Power BI Exercises

Build the whole star

Data Modeling · Advanced · 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.: "We moved everything to a fresh file and lost every relationship. Can you wire it back up?" A matrix of revenue by city and style, on a complete star schema.

A star schema has one fact table in the middle (Orders) and a lookup table on each side. Every lookup table needs one relationship to the fact table, from the fact table’s key to the lookup’s key.

Task: Create the four relationships: Orders to Pizza, Store, Driver (on their IDs) and Calendar (on Order Date → Date).

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