DAX Studio Essentials | Training.tips

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Mastering Power BI Performance Tuning

Introduction and Setting the Expectations

Welcome to Mastering Power BI Performance Tuning Course! (2:12)
Whats in for you? (2:17)
Setting the Right Expectations - When To Start Tuning Your Power BI Reports? (5:52)
Resources

Data Modeling for Power BI Performance

The Importance of Data Modeling and Star Schema (8:47)
Demo: The Importance of Star Schema (2:36)
Understanding Bi-Directional Relationships (5:09)
Demo: Avoiding Bi-Directional Relationships (5:51)

Optimizing Data Model Size

Demo: Reduce the Data Model Size by 90% (10:11)
Understanding VertiPaq Engine (12:53)
How to Destroy Data Model with Auto Date/Time (8:45)
Demo: How to Destroy Power BI Data Model with Auto Date/Time (2:55)
3 Solutions to Avoid Auto Date/Time (2:24)
Best Practices for Data Model Size Optimization (3:00)

Optimizing Data Refresh Process

Understanding Data Shaping Process (5:03)
Understanding Query Folding (8:22)
Demo: Changing Data Type and Query Folding (3:16)
Demo: Query folding - When View Native Query Lies (2:36)
Demo: Native SQL Query and Query Folding (4:35)
Demo: Query Folding - Why Should You Care? (3:30)
Demo: Identifying Bottlenecks in the Data Refresh Process (3:04)
Best Practices for Optimizing the Data Refresh Process (2:39)

Improving the Visuals Rendering Time

Identifying Performance Improvements in Report Visuals (0:41)
Demo: Improving Performance by Designing the Report Page Background (3:20)
Best Practices for Improving the Visuals Rendering Time (1:42)

Understanding Aggregations in Power BI

Demo: Implementing Aggregations (9:00)
Understanding Aggregations in Power BI (4:03)

Implementing Incremental Refresh and Hybrid Tables

Understanding Incremental Refresh (5:57)
Demo: Implementing Incremental Refresh (3:49)
Going Beyond With Hybrid Tables (5:01)

Optimizing DAX

Understanding DAX Query Plans (4:22)
Step-By-Step Process For Optimizing DAX (3:43)
Demo: Optimizing Filtering Conditions (6:45)
Demo: Optimizing IF Statements (3:27)
Demo: Being Mindful With Data Types in DAX (3:55)
Demo: Why You Should (NOT) Replace Blanks With 0? (5:55)

Performance Tuner Toolbox

Understanding Performance Analyzer (2:42)
DAX Studio Essentials (1:34)
Tabular Editor Essentials (4:02)
Demo: Optimizing Data Model with Tabular Editor (2:55)
VertiPaq Analyzer Essentials (1:48)
Demo: Analyzing Data Structures With VertiPaq Analyzer (2:43)
Bravo for Power BI Essentials (2:27)
Demo: Creating a Date Dimension With Bravo for Power BI (4:04)

Optimizing Direct Query Scenarios

Direct Query in Power BI (6:04)
Demo: Optimizing Direct Query Scenarios in Power BI (5:31)

Real-Life Use Cases: Lessons Learned From Optimizing Real-Life Data Models

Case Study #1: Reducing the Cardinality (5:08)
Case Study #2: Hidden Little Gem That Can Save Your Power BI Life (9:03)
Case Study #3: Power BI Hybrid Tables For "Poor" People (10:01)

Course Summary and Next Steps

Monday To-Do List (2:37)
Where To Go From Here?

Grande Quiz

Grande Quiz

Teach online with

DAX Studio Essentials

Lesson content locked

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

Enroll in Course to Unlock