/Power BI - Advanced

Course Curriculum

Section 1 · Module 1: Advanced DAX Functions & Calculations

○ Time Intelligence Functions (YEAR, MONTH, SAMEPERIODLASTYEAR, YTD, MTD) ○ Ranking & Sorting (RANKX, TOPN) ○ Conditional Calculations (IF, SWITCH, LOOKUPVALUE)

Section 2 · Module 2: Power BI Report Optimization & Performance Tuning

○ Improving data model efficiency ▶ Reducing report load times ○ Using Aggregations and Optimized Queries

Section 3 · Module 3: Power BI Service & Sharing Reports

○ Publishing reports to Power BI Service ○ Creating dashboards and sharing insights ○ Setting up automatic data refresh

Section 4 · Module 4: Advanced Visualizations & Custom Charts

○ Using AI visuals (Decomposition Tree, Key Influencer Chart) ○ Building interactive reports with Drill-through & Bookmarks ○ Custom visuals and third-party Power BI visuals

Section 5 · Module 5: Power BI Automation & Integration

○ Power Automate for report automation ○ Real-time data analysis with Power BI Streaming

Module 2: Power BI Report Optimization & Performance Tuning

Reducing report load times

← Previous Continue →