Autoplay
Autocomplete
Previous Lesson
Complete and Continue
DAX Optimization Masterclass Using DAX Studio
Course Introduction
Let's get started
Resource Pack
Introduction (2:54)
SE, FE, Cache and Query Execution
Formula Engine (11:08)
Storage Engine (10:16)
Row Store vs Column Store (7:32)
Data Cache (5:45)
How DAX Query is Executed (3:48)
Segments (4:24)
Vertipaq Compression Techniques
Value Encoding (4:45)
Run Length Encoding (2:46)
Dictionary Encoding (4:00)
Sort Order (3:23)
Vertipaq Analyzer
Introduction (17:20)
Optimizing with Vertipaq Analyzer (11:50)
Reducing Numbers After Decimal (7:26)
Hidden Date Table (6:45)
Dictionary Size (4:52)
Encoding Hint (5:01)
Number vs String vs Datetime (3:43)
Query Plans, Server Timings & more
Introduction to Query Plan and Server Timings (7:06)
Logical & Physical Query Plan (16:53)
Complex Physical Query Plan (4:16)
Native SE functions (18:26)
SE Subclass Types (3:50)
Query Plans Do Not Change (8:11)
With and Without Cache Execution (6:35)
CALLBACKDATAID (21:02)
Comparing Query Plans (3:41)
Advanced Ribbon
Import and Export Metrics (3:18)
Benchmarking DAX Code Timings (5:37)
SQL Profiler - Power Query Processing Time (11:57)
Reading Query Plans of DAX Functions
SUM vs SUMX (16:19)
FILTER (11:50)
CROSSJOIN (11:15)
CALCULATETABLE (9:29)
Optimizing DAX Code & Data Model
Adding 0 to the Measures (29:38)
DISTINCT vs SUMX (26:55)
UNION in Power Query vs DAX (9:21)
Circular Dependency (18:10)
Conclusion and Final Words
What's Next and Final Words (2:29)
Feedback
Course Survey
Certification
Certificate & Badge
Import and Export Metrics
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock