Intermediate Track¶
Take your Power BI skills to the next level with advanced DAX, optimized data models, and professional report design.
Learning Objectives
Time intelligence • Incremental refresh • Aggregations • Calculation groups • Advanced DAX patterns (visual calculations, non-additive measures) • Optimize model relationships & performance • Security (RLS introduction) • External tools
| Resource | Type | Theme | Cost | Focus |
|---|---|---|---|---|
| Work with semantic models in Microsoft Fabric | Official | Modeling | Manage & use semantic models across Fabric | |
| Model data with Power BI | Official | Modeling | Data modeling design & relationships | |
| Use DAX in semantic models | Official | DAX | Core & intermediate DAX functions | |
| Design effective reports in Power BI | Official | Visuals | UX, accessibility & storytelling | |
| Manage and secure Power BI | Official | Security Admin | Governance, security, admin tasks | |
| DAX Guide | Community | DAX | Function catalog & syntax reference | |
| DAX 101 Playlist | Video | DAX | Progressive DAX learning curve | |
| Measures vs Calculated Columns | Video | DAX | Logic placement best practices | |
| Non-additive measures | Blog | DAX | Totals & non-additive measure handling | |
| Tabular Editor Docs | Community | Tools | Calculation groups & scripting automation | |
| TMDL View: A practical introduction | Video | Tools | Make direct changes to model metadata in TMDL (Tabular Model Definition Language) format | |
| Understanding visual calculations | Video | DAX | Visual calculations engine & context | |
| Power BI Architecture & Performance Playlist | Video | Performance | Performance & architecture | |
| DAX Tools Course | Course | Tools | Tooling: DAX Studio, Vertipaq Analyzer | |
| VertiPaq Analyzer crash course | Video | Performance Tools | Learn how to read the information provided by VertiPaq Analyzer 2.0 and optimize data models in Power BI, Analysis Services, and Power Pivot | |
| Calculation Groups Playlist | Video | DAX | Time intelligence & formatting reuse | |
| Mastering DAX | Course | DAX | $$ | Comprehensive DAX patterns, context transition, and advanced calculations |
| Data Modeling for Power BI | Course | Modeling | $$ | Star schema design, relationships, and modeling best practices |
| Master RLS in Power BI | Course | Security | $ | Complete guide to implementing and testing row-level security |
Next Steps¶
Ready for enterprise-level Power BI? Continue to the Advanced Track for deployment pipelines, architecture, and governance!