The film
From the dashboard to the build beneath it, and back.
Under a minute through the build of a Power BI report: the dashboard on its glass slab, the portal into what sits underneath it, the raw data, Power Query, the model, the measures and the tie-out, then back to the dashboard. NEX leads the way.
Drawn entirely in code, live in your browser. Report data and verification shown in the film are illustrative.
Chapters
Nine chapters, one camera
- 0:00Opening
- 0:06The world
- 0:14The portal
- 0:19Raw data
- 0:26Power Query
- 0:33Model
- 0:41Measures
- 0:45Verify
- 0:49Decision
The titles
What the film says
The eight titles set in the film, in order, as text.
- 0:01
00 / Opening
You see a dashboard.
We see what comes next.
- 0:08
01 / Beneath the surface
A dashboard is only the surface.
Every number has a journey. Let’s follow it back to its source.
- 0:21
02 / Raw data
It starts as noise.
Fourteen sources. Nulls, duplicates and three spellings of one region.
- 0:26
03 / Power Query
Shape it once, properly.
Every step is recorded, so each refresh repeats the same work.
- 0:34
04 / Semantic model
Make the connections count.
Clear grain. Deliberate relationships. A model built around the question.
- 0:41
05 / Measures
One name. One definition.
The same label can conceal different logic. Make every calculation explainable.
- 0:45
06 / xVerify
Tie it back to the source.
Every total checked against where it came from, before anyone decides on it.
- 0:50
07 / The decision product
Clarity. With evidence.
Start with the question
Request a review.
Name the report, and name the decision it is supposed to support. The rest follows from those two answers.