Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Course 1 – Identifying and Solving Performance Issues in Power BI
Module 1 - Performance Tuning Strategy (Free!)
What is the problem? (5:46)
Principles of troubleshooting (13:12)
Why is it slow? (9:12)
Where is it slow? (5:27)
Tools of the Trade (7:21)
Module 1 slides
Module 2 - Improving refresh - Power Query
PowerQuery is unituitive (6:35)
Keep it small (4:49)
Do less work (4:13)
Query folding (4:37)
Demo - Query Folding (1:41)
Summary (0:22)
Module 3 - Improving Refresh - Measuring Refresh performance
Understanding Refresh Metrics (6:51)
Demo - Query diagnostics (6:08)
Demo - SQL Server Profiler (2:34)
Demo - Refresh visualizer (2:10)
Reading Execution Plans (5:56)
Demo - Viewing SQL Query Plans (3:11)
Module 4 – Improving rendering - modeling
Keep it small (3:45)
Understanding columnar storage (4:32)
Keep it simple (6:19)
Demo - Dax Studio (2:05)
Demo - Vertipaq Analyzer (1:47)
Demo - Tabular Editor (2:06)
Module 5 – Improving rendering – DAX code
Keep it simple (4:20)
Storage Engine versus Formula engine (5:47)
Demo - Performance Analyzer and DAX Studio (4:03)
Minimize Work (3:48)
Module 6 - Improving rendering - visuals
Reduce objects on screen (2:57)
Demo - Consolidating Visuals (2:20)
Measuring Visual Performance (2:18)
Demo - Report Analyzer (2:42)
Module 7 - Improving DirectQuery
Understanding DirectQuery (7:55)
Demo - Limit Querying (3:32)
Demo - Tracing SQL (7:37)
Teach online with
Reduce objects on screen
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock