Platform Access

Optimizing DAX

Take this course to master key data modeling and DAX concepts and techniques to optimize performance in Power BI. Developing data models to support optimal performance of your Power BI reports. Understand the techniques to optimize your data model Implement methods to improve DAX code to increase performance

Enroll Now
 Optimizing Dax, Course on DAX concepts and techniques

Here's What You'll Get

With The Course

Over 3 hours of

video training

1x demo data sets to practice DAX formula development

Optimizing Dax

Master key data modeling and dax techniques to optimize your performance

  • Teaches you best practices for developing data models. You will also learn how to diagnose and resolve performance bottlenecks in your DAX measures.
  • Explains in plain language how the DAX calculation engines work.

Details Of What You Will Learn

During This Course

  • Learn - best practice techniques when using the query editor
  • Learn - how to diagnose the root cause of a slow measure
  • Understand - the techniques to optimize your data model
  • Implement - methods to improve DAX code to increase performance
 Optimizing Dax

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

This course is for those who have little to no knowledge about Optimizing DAX and want to improve their report performance.

LEARN HOW TO

Utilize the key features within Optimizing Dax

 Optimizing Dax
  • Best practices in developing DAX expressions
  • Use correct method for developing data model
  • Solve bottle neck issues that cause slow performance
  • Develop optimizations of DAX patterns
  • Visualize the outcome of DAX formulas

Course Curriculum

1. Course Resource Pack

  • Course Resource Pack

2. Introduction to the Course

  • How to get certified for this course?
  • Resource Pack
  • Topics We Will Cover
  • Download Files and Change Parameter

3. What is VertiPaq

  • Resource Pack
  • DAX Query Structure
  • What is VertiPaq
  • Columnar Storage
  • Types of Compression Overview
  • Value Encoding
  • Dictionary (Hash) Encoding
  • Run Length Encoding (RLE)
  • RLE on Dictionary Encoded Columns
  • Segmentation
  • Data Model and Relationships
  • General Best Practices

4. Intro to DAX Studio

  • Resource Pack
  • What is DAX Studio
  • Tour of DAX Studio

5. VertiPaq Analyzer in DAX Studio

  • VertiPaq Analyzer- Table Metrics
  • VertiPaq Analyzer- Table-Column Metrics
  • VertiPaq Analyzer- All Columns Metrics
  • VertiPaq Analyzier-Relationships and Referential Integrity

6. What's Under the Hood

  • Resource Pack
  • DAX Query Structure Part 2
  • Two Engines Comparison
  • DAX Studio and the Two Engines

7. Logical and Physical Query Plans

  • Resource Pack
  • DAX Query Plan Steps 1.a
  • DAX Query Plan Steps 1.b
  • Logical Query Plans
  • Physical Query Plans
  • VertiPaq Operators
  • Intro to Storage Engine Queries

8. Deeper Dive into Storage Engine Queries

  • Resource Pack
  • Implied GroupBy
  • What is this RowNumber?
  • xmSQL Aggregations
  • xmSQL Mathematical Operations
  • xmSQL and Filter
  • xmSQL and Filter on Ranges
  • xmSQL and Join
  • Identifying Context Transition

9. Measuring Query Performance

  • Resource Pack
  • Setting up DAX Studio
  • What are Data Caches?
  • Materilization, the Later the Better
  • CallBackDataID: What is it?

10. Time to Start Optimizing

  • Resource Pack
  • VertiPaq Cache
  • Sub-expression Detection
  • Where's the bottle neck
  • Mitigating CallBackDataID
  • FILTER or CALCULATE?
  • Variables
  • Watch out for Context Transition

What our Students Say

Your Instructor

Nick Moné

  • Skilled in creating complex data models, such as a Sales table and a Budget table.
  • Expertise in utilizing Power Query to take data in any form and transform it into tabular format.
  • Capabilities to take seemingly unyielding complex scenarios and break them down into easier digestible smaller parts.
  • Ability to see how all the Power BI products (Power Query, DAX, Power BI) function together ecosystem.

Frequently Asked Questions

  • How long do I have access to the course? You have access to this course as long as you have Enterprise DNA Membership Subscription.

  • Can I purchase a single course instead of the full Enterprise DNA membership? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full membership here.
  • Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA Membership or CoE access to receive support.

  • What if I need to train my team? We recommend exploring Enterprise DNA Center of Excellence platform. To learn more, see here.

Get full access to unparalleled training

& skill-building resourcess

For Individuals

Enterprise DNA

Membership

Empowering the most valuable Power BI users to expand their analytical thinking and insight generation possibilities

membership enterprise dna

For Teams

Enterprise DNA

Center of Excellence

Training, tools, and guidance to unify and upskill the Power BI analysts in your workplace