Module 1 slides | 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)
Remaining modules are in production!

Module 3 - Improving Refresh - Measuring Refresh performance

Understanding Refresh Metrics
Demo - Query diagnostics
Demo - SQL Server Profiler
Demo - Refresh visualizer
Optimizing SQL Server
Demo - Viewing SQL Query Plans

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

Module 1 slides

Module 1.pdf

Complete and Continue

Discussion

0 comments