Power BI Exercises

Which pizzas pay the bills?

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.: "Our report says every pizza style made exactly the same money. That can't be right, can it?" A table of revenue by pizza style, with the model fixed.

New dataset! Slice & Co. is a four-store pizza chain: Orders has one row per order line, and Pizza, Store, Driver and Calendar describe it. One relationship is missing, so the table on the page shows the same revenue for every pizza style.

Task: In the Model view, connect Orders[PizzaID] to Pizza[PizzaID].

Task: Check that the table now shows a different revenue per style.

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.

Keep practicing