Platform Access

DAX Optimization Masterclass Using DAX Studio

Improve the overall performance of your DAX measures using the DAX Studio. Mastering the art and science of Optimizing DAX will place you in the top-tier of Power BI practitioners, substantially improving your reports and increasing the value of your overall skillset.

Enroll Now
Dax Optimization Masterclass Usin Dax Studio, DAX Studio training course

Here's What You'll Get

With The Course

Over 5 hours of comprehensive training

R For Power BI Users

 Resource pack

 Dax Optimization Masterclass Usin Dax Studio

Mastering the art and science of Optimizing DAX will place you in the top-tier of Power BI practitioners

  • Understand the internals of the DAX Engine and understand that Tabular is a different technology than a SQL database
  • Understand the flow of a DAX code and will need to learn how to read query plans

Details Of What You Will Learn

During This Course

  • Determine - how data is stored in Power BI
  • Describe - how a DAX code is executed
  • Read - query plans
  • Optimize - data models using VertiPaq analyzer
  • Identify - issues that cause wrong calculations in query plans
  • Optimize - slow calculations and identify the issues causing it
 Dax Optimization Masterclass Usin Dax Studio

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

LEARN HOW TO

Utilize the key features within the DAX Optimization Masterclass Using DAX Studio

 Dax Optimization Masterclass Usin Dax Studio
  • How the data is stored and compressed in Tabular
  • How to use VertiPaq analyzer to identify and optimize the effects of the data model characteristics on memory usage
  • Developing an understanding of the Logical and Physical Query Plans
  • Read query plans of DAX functions so that you can also understand how your code is getting executed

Course Curriculum

1. Course Introduction

  • Let's get started
  • Resource Pack
  • Introduction

2. SE, FE, Cache and Query Execution

  • Formula Engine
  • Storage Engine
  • Row Store vs Column Store
  • Data Cache
  • How DAX Query is Executed
  • Segments

3. Vertipaq Compression Techniques

  • Value Encoding
  • Run Length Encoding
  • Dictionary Encoding
  • Sort Order

4. Vertipaq Analyzer

  • Introduction
  • Optimizing with Vertipaq Analyzer
  • Reducing Numbers After Decimal
  • Hidden Date Table
  • Dictionary Size
  • Encoding Hint
  • Number vs String vs Datetime

5. Query Plans, Server Timings & more

  • Introduction to Query Plan and Server Timings
  • Logical & Physical Query Plan
  • Complex Physical Query Plan
  • Native SE functions
  • SE Subclass Types
  • Query Plans Do Not Change
  • With and Without Cache Execution
  • CALLBACKDATAID
  • Comparing Query Plans

6. Advanced Ribbon

  • Import and Export Metrics
  • Benchmarking DAX Code Timings
  • SQL Profiler - Power Query Processing Time

7. Reading Query Plans of DAX Functions

  • SUM vs SUMX
  • FILTER
  • CROSSJOIN
  • CALCULATETABLE

8. Optimizing DAX Code & Data Model

  • Adding 0 to the Measures
  • DISTINCT vs SUMX
  • UNION in Power Query vs DAX
  • Circular Dependency

What our Students Say

Your Instructor

Antriksh Sharma - Power BI

Antriksh Sharma

  • 2+ years of experience in Power BI, Power Pivot, Power Query and SSAS
  • 2+ years of experience in DAX, optimizing DAX, and SQL language. Likes to read DAX blogs, articles, and books in free time.
  • Keen interest in Data Modelling, Data preparation, and Data clean-up using various tools.
  • 1+ years of experience in Core Python and approx. 6 months of experience in Pandas/NumPy/Matplotlib/Seaborn etc. Python libraries for Data Analytics.
  • Super User at Microsoft’s Power BI community platform with over 80 solutions, 50 PBI solutions at Enterprise DNA’s community, and approx. 30 PBI solutions on other platforms. Passionately believes in sharing everything he knows.
  • 4+ years of experience in excel automation through VBA, likes to read VBA blogs in free time.

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