Demo - Tracing SQL | Eugene Meidinger's School

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

Demo - Tracing SQL

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock