All lessons
Power BI and DAX: from raw data to a dashboard managers use
Learn Power BI the way BI teams use it: clean data in Power Query, model it as a star schema, write DAX measures and time intelligence, and design a report people act on. Type and run DAX in every lesson, and watch step by step what each formula does to the data.
What you will be able to do
- Turn messy files into a clean model with Power Query, then shape it into a star schema with a proper date table.
- Write the DAX that interviews ask for: measures, SUMX and row context, CALCULATE and filter context, ALL and percent of total, ranking, year to date, last year and rolling averages.
- See what every formula does: press "Show me what happened" under any result to watch the filters flow through the relationships, rows get kept or dropped, and values add up, one step at a time.
- Build a dashboard you can show employers: the capstone is a Northbay sales report you build yourself in Power BI Desktop, with a write-up for your portfolio.
Every lesson has a short explanation, a picture of the idea, DAX you can type and run with instant checks, practice questions and a 3-question quiz. Pair it with Data storytelling for the design side, and with From a straight line to an LLM if you want the maths of prediction.
0 of 45 lessons done
Without the tick, your progress lasts until you close this tab. Either way it stays in this browser: there is no sign-up and nothing is sent to us.