Course · Power BI
Advanced DAX & Performance
For people who already write DAX: advanced patterns, calculation groups and finding out why a report is slow.
- Level
- Advanced
- Format
- Live online, small group
- Length
- 12 hours, 4 sessions
- Price
- $199
Price and enrolment
$199 per learner
- 4 sessions × 3 hours (12 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 Professional path: $599 for the full path.
See Learning PathsWho it is for
This course is for
- Experienced Power BI developers
- Corporate BI teams maintaining large models
Syllabus
What each session covers
Session 1 · Advanced filter patterns
- Context transition
- Expanded tables and relationships in DAX
- Many-to-many and bridge tables
Session 2 · Advanced calculations
- Calculation groups
- Window functions
- Semi-additive measures and snapshots
Session 3 · Performance analysis
- Performance Analyzer and DAX Studio
- Storage engine vs formula engine
- Model size and column cardinality
Session 4 · Optimisation
- Rewriting slow measures
- Import, DirectQuery and composite models
- Aggregations and incremental refresh
Hands-on labs
What you will build
- Diagnose a slow report page
- Reduce model size
- Replace repetitive measures with a calculation group
- Rewrite a slow measure and measure the gain
Before you join
Prerequisites and setup
- Level
- Advanced
- Prerequisite
- Data Modelling & DAX or solid DAX experience
- You need
- Power BI Desktop and DAX Studio (free) installed
Outcomes
After the course you should be able to
- Use advanced DAX patterns where they help
- Find the real cause of slow reports
- Make models smaller and faster
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
Data Modelling & DAX
The skills behind trustworthy numbers: star-schema models, relationships, filter context and DAX measures that give the same answer everywhere.
$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 Advanced DAX & Performance
Send the short form; we confirm the next cohort dates and send an invoice.