Course · Power BI
Data Modelling & DAX
The skills behind trustworthy numbers: star-schema models, relationships, filter context and DAX measures that give the same answer everywhere.
- Level
- Intermediate
- Format
- Live online, small group
- Length
- 15 hours, 5 sessions
- Price
- $199
Price and enrolment
$199 per learner
- 5 sessions × 3 hours (15 hours)
- Live online, groups of up to 12
- Hands-on labs and course materials
- Q&A with the instructor
We confirm the next cohort dates and send an invoice. Your seat is held once payment is received. Prices in US dollars, excluding any local taxes.
Save with a path
This course is part of the Power BI Analyst path: $449 for the full path.
See Learning PathsWho it is for
This course is for
- Existing Power BI users who need stronger modelling and DAX
- Analysts whose totals do not reconcile
- BI developers building shared models
Syllabus
What each session covers
Session 1 · Model design
- Star schema: facts, dimensions and grain
- Relationships, cardinality and filter direction
- Date tables done properly
Session 2 · How DAX evaluates
- Measures vs calculated columns
- Row context and filter context
- Iterators: SUMX, AVERAGEX
Session 3 · CALCULATE
- Changing filter context
- ALL, REMOVEFILTERS and KEEPFILTERS
- Common mistakes and how to test measures
Session 4 · Time intelligence
- Year to date, prior year and rolling periods
- Custom fiscal calendars
- Comparing periods correctly
Session 5 · Reusable KPI layer
- Building a measure library
- Variables and readable DAX
- Validating totals against the source
Hands-on labs
What you will build
- Remodel a flat table into a star schema
- Fix totals that do not add up
- Build a time-intelligence measure set
- Create a governed KPI measure library
Before you join
Prerequisites and setup
- Level
- Intermediate
- Prerequisite
- Power BI Fundamentals or equivalent experience
- Prerequisite
- Has built at least one report
- You need
- Power BI Desktop installed
Outcomes
After the course you should be able to
- Design cleaner models
- Understand why a measure returns what it returns
- Write reusable, testable measures
Courses build practical skills. They do not promise certification passes, job placement, salary increases or expert-level mastery.
Related courses
Continue learning
Power BI Fundamentals
The full Power BI workflow for new users: connect data, clean it, model it, write first measures and publish a useful report.
$149 per learner
Power Query & Data Preparation
Turn messy files and system extracts into clean, repeatable data with Power Query, so the report never needs manual fixing.
$119 per learner
Advanced DAX & Performance
For people who already write DAX: advanced patterns, calculation groups and finding out why a report is slow.
$199 per learner
Dashboard Design & Storytelling
Design reports people actually read: layout, visual choice, navigation and how to lead a reader to a decision.
$89 per learner
Power BI Service, Security & Governance
Run Power BI as a reliable team environment: workspaces, apps, refresh, gateways, row-level security and ownership.
$119 per learner
Need it built? · Datazeb Consulting
Want Datazeb to build or fix your Power BI?
The trainers deliver Power BI projects for clients. If you need a model, dashboard or a governed environment built for you, the consulting team can help.
datazeb.com
Reserve your seat on Data Modelling & DAX
Send the short form; we confirm the next cohort dates and send an invoice.