Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Optimizing DAX
Course Resource Pack
Course Resource Pack
Introduction
How to get certified for this course?
Resource Pack
Topics We Will Cover (3:13)
Download Files and Change Parameter (2:10)
What is VertiPaq
Resource Pack
DAX Query Structure (3:36)
What is VertiPaq (4:04)
Columnar Storage (3:54)
Types of Compression Overview (3:21)
Value Encoding (2:24)
Dictionary (Hash) Encoding (2:38)
Run Length Encoding (RLE) (2:14)
RLE on Dictionary Encoded Columns (2:58)
Segmentation (6:33)
Data Model and Relationships (4:52)
General Best Practices (5:34)
Intro to DAX Studio
Resource Pack
What is DAX Studio (3:27)
Tour of DAX Studio (8:49)
VertiPaq Analyzer in DAX Studio
VertiPaq Analyzer- Table Metrics (11:12)
VertiPaq Analyzer- Table-Column Metrics (10:03)
VertiPaq Analyzer- All Columns Metrics (7:59)
VertiPaq Analyzier-Relationships and Referential Integrity (9:28)
What's Under the Hood
Resource Pack
DAX Query Structure Part 2 (5:54)
Two Engines Comparison (5:45)
DAX Studio and the Two Engines (3:27)
Logical and Physical Query Plans
Resource Pack
DAX Query Plan Steps 1.a (3:22)
DAX Query Plan Steps 1.b (1:10)
Logical Query Plans (7:14)
Physical Query Plans (4:45)
VertiPaq Operators (3:34)
Intro to Storage Engine Queries (9:03)
Deeper Dive into Storage Engine Queries
Resource Pack
Implied GroupBy (7:09)
What is this RowNumber? (5:23)
xmSQL Aggregations (8:17)
xmSQL Mathematical Operations (6:33)
xmSQL and Filter (8:04)
xmSQL and Filter on Ranges (7:28)
xmSQL and Join (8:32)
Identifying Context Transition (8:16)
Measuring Query Performance
Resource Pack
Setting up DAX Studio (6:38)
What are Data Caches? (10:51)
Materilization, the Later the Better (12:15)
CallBackDataID: What is it? (11:14)
Time to Start Optimizing
Resource Pack
VertiPaq Cache (4:43)
Sub-expression Detection (2:53)
Where's the bottle neck (6:41)
Mitigating CallBackDataID (8:53)
FILTER or CALCULATE? (14:53)
Variables (5:01)
Watch out for Context Transition (11:01)
Your Feedback
Course Survey
Certification
Certificate & Badge
xmSQL and Filter on Ranges
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock