Busy days of the week
Data Modeling · Intermediate · Chapter 5 of 10. Create and fix relationships in the Model view, and see why they matter.
The request, from Giulia Moretti, Owner, Slice & Co.: "I want to plan staff by weekday. Which days actually bring in the money?" A column chart of revenue by day of the week.
Dates need their own table. Relate Orders[Order Date] to Calendar[Date] and every column of the calendar (Month, Day of Week) can slice the orders.
Task: Connect Orders[Order Date] to Calendar[Date].
Task: The column chart then shows revenue per day of the week.
Practice data: Slice & Co., a fictional pizza restaurant chain. The model has the Orders, Pizza, Store, Driver and Calendar tables.
How it works: the exercise opens a practice copy of the Power BI report editor in your browser. Do the task, press Check, and your result is compared with the expected answer in seconds. Hints are there if you get stuck.