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
Understanding columnar storage
Keep it simple
Tools of the trade
Demo - Dax Studio
Demo - Vertipaq Analyzer
Demo - Tabular Editor
Module 5 – Improving rendering – DAX code
Keep it simple
Storage Engine versus Formula engine
When to pre-calculate?
Demo - Performance Analyzer
Module 6 - Improving rendering - visuals
Reduce objects on screen
Demo - Creating a background image
Reduce interaction
Demo - reducing interactions
Embrace just-in-time information
Demo - Simplifying a report
Module 7 - Improving DirectQuery
How Does DirectQuery work?
Limiting querying
Improving SQL
Demo - Adding SQL Indexes
Advanced features
Demo - Composite modeling
Demo - Hybrid tables
Course Summary
Teach online with
Do less work
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock