Power BI: Data Modelling and DAX in Practice
Go beyond drag-and-drop reporting. Declare the grain of every table, build a star schema with a marked date table, and write DAX measures for margin, share of total, year-to-date, prior-year growth, ship-date analysis and targets at a coarser grain. Every worked example has exact expected numbers, and you finish with a tested, documented portfolio model built on fictional data. Text-based course with downloadable CSV practice files and an answer guide; Power BI Desktop is a free Windows download, while publishing and sharing need an appropriate licence.
Unlock this course and 50+ others
One membership at £4 a month opens every lesson, quiz and certificate on Skillora. Cancel anytime.
- Every paid course in the library unlocked
- Quizzes and verifiable completion certificates
- Career pathways matched to the courses
- Cancel any time — access runs to the end of your billing period
Course content
Module 1: Model foundations: grain, star schema and dates
Load a fictional trading dataset, declare the grain of every table and build a star schema with a proper date table.
- Set up the practice model and confirm what you can use30 min
- Declare the grain and design a star schema30 min
- Build relationships and a proper date table35 min
Module 2: Measures and filter context
Write base measures correctly, then learn to predict how filter context and CALCULATE change their results.
- Measures, calculated columns and base measures30 min
- Read filter context in visuals and totals30 min
- CALCULATE, REMOVEFILTERS and KEEPFILTERS40 min
Module 3: Time intelligence, role-playing dates and mixed grain
Compare periods correctly, switch between order and ship dates, and report targets that live at a coarser grain.
- Year-to-date and prior-year comparisons35 min
- Role-playing dates with USERELATIONSHIP30 min
- Report targets that live at a coarser grain35 min
Module 4: Validate, optimise and deliver
Test measures with queries, write efficient DAX and complete a documented portfolio model.
- Test measures with DAX query view35 min
- Iterators, variables and performance basics30 min
- Capstone: deliver a tested trading review model60 min