Introduction and Setting the Expectations
Data Modeling for Power BI Performance
Optimizing Data Model Size
-
Demo: Reduce the Data Model Size by 90% (10:11)
-
Understanding VertiPaq Engine (12:53)
-
How to Destroy Data Model with Auto Date/Time (8:45)
-
Demo: How to Destroy Power BI Data Model with Auto Date/Time (2:55)
-
3 Solutions to Avoid Auto Date/Time (2:24)
-
Best Practices for Data Model Size Optimization (3:00)
Optimizing Data Refresh Process
-
Understanding Data Shaping Process (5:03)
-
Understanding Query Folding (8:22)
-
Demo: Changing Data Type and Query Folding (3:16)
-
Demo: Query folding - When View Native Query Lies (2:36)
-
Demo: Native SQL Query and Query Folding (4:35)
-
Demo: Query Folding - Why Should You Care? (3:30)
-
Demo: Identifying Bottlenecks in the Data Refresh Process (3:04)
-
Best Practices for Optimizing the Data Refresh Process (2:39)
Improving the Visuals Rendering Time
Understanding Aggregations in Power BI
Implementing Incremental Refresh and Hybrid Tables
Optimizing DAX
Performance Tuner Toolbox
-
Understanding Performance Analyzer (2:42)
-
DAX Studio Essentials (1:34)
-
Tabular Editor Essentials (4:02)
-
Demo: Optimizing Data Model with Tabular Editor (2:55)
-
VertiPaq Analyzer Essentials (1:48)
-
Demo: Analyzing Data Structures With VertiPaq Analyzer (2:43)
-
Bravo for Power BI Essentials (2:27)
-
Demo: Creating a Date Dimension With Bravo for Power BI (4:04)
Optimizing Direct Query Scenarios
Real-Life Use Cases: Lessons Learned From Optimizing Real-Life Data Models
Course Summary and Next Steps
Grande Quiz
