Course Objective & Scope
As report counts and data volumes grow, slow models, uncontrolled workspaces and duplicated measures become typical Power BI problems. This advanced programme covers advanced DAX and context transition, calculation groups, field parameters, RLS/OLS, incremental refresh, composite models and DirectQuery scenarios.
Using Performance Analyzer, DAX Studio and Tabular Editor, participants find bottlenecks in a realistic model and discuss deployment pipelines and workspace governance. The work concludes with an optimisation report and checklist on a case resembling the organisation's own model.
Who Should Attend?
- Analysts who regularly build Power BI reports and models
- BI developers and BI team leads
- Data platform teams administering the Power BI environment
- Prerequisite: experience with Power Query, relational models and basic DAX
Key Takeaways
- Write DAX measures that use context transition and iterators correctly
- Reduce measure sprawl with calculation groups and field parameters
- Design and test role-based RLS and OLS
- Configure incremental refresh for large tables
- Improve slow visuals with DAX Studio and Performance Analyzer
- Set up a dev-test-prod release flow with deployment pipelines
Curriculum
Advanced DAX and Context Transition
- CALCULATE, filter context and row context
- Iterators, virtual tables and variables
Calculation Groups and Field Parameters
- Time intelligence calculation groups with Tabular Editor
- Dynamic measure and dimension selection
Security: RLS and OLS
- Static and dynamic row-level security
- Object-level security and role testing
Large Data: Incremental Refresh and Composite Models
- Incremental refresh policies
- DirectQuery, Import and aggregation tables
Performance Analysis and Optimisation
- Query analysis with Performance Analyzer and DAX Studio
- Reducing model size with VertiPaq Analyzer
Release Management and Workspace Governance
- Deployment pipelines and release flow
- Certified semantic models and access policies
Other Courses in This Category
-
Star schema design, fact and dimension tables, relationships and filter direction, date tables and core-to-intermediate DAX measures, so analysts build Power BI models that return correct, maintainable results.
- Live Course
- 6 modules
-
Importing from multiple sources, cleaning, merging, unpivoting, parameters, custom functions and M language basics in Power Query, so Excel and Power BI users automate manual data preparation.
- Live Course
- 6 modules
-
OneLake, Lakehouse, Data Warehouse, Data Factory pipelines, Dataflow Gen2, notebooks and Direct Lake Power BI, giving data and BI teams an end-to-end introduction to Microsoft Fabric components.
- Live Course
- 6 modules
-
Moving Power BI Premium/Pro environments to Fabric capacity, converting dataflows to Gen2 and sources to Lakehouse and Direct Lake, so BI teams produce a risk-controlled migration roadmap.
- Live Course
- 6 modules
-
PivotTables, XLOOKUP, dynamic array functions (FILTER, UNIQUE, SORT), conditional aggregation, What-If analysis and Power Pivot, so business users perform fast and reliable analysis in Excel.
- Live Course
- 6 modules
-
Python in Excel (=PY), pandas for cleaning and transforming data, openpyxl report automation and matplotlib charts, helping Excel users scale repetitive analysis with Python.
- Live Course
- 6 modules
Get in touch
