DAX Optimization Masterclass Using DAX Studio

Improve the overall performance of your DAX measures using the DAX Studio

schedule6 hours
play_circle39 videos
unfold_more43 exercises
trending_up700 xp

Let’s create your free account

OR

By continuing, you accept our Enterprise DNA Terms & Conditions , our Privacy & Cookie Policy and that your data is stored.

If you have an account Login here

Trusted by 220,000+ people worldwide.

coca-cola-logouniliver-logonhs-logonestle-logoatt-logoanglo-logomackinsey-logoalbemarle-logojonson-logopanasonic-logo

An outline of this training course

A great general principle to follow with DAX is “make it work, then make it fast”. If you are at the point in your journey where you can regularly make complex measures DAX “work”, you are doing great and are far ahead of the vast majority of Power BI users. However, you are probably at the point where some of your more complex measures are not running efficiently, and you need to “make them fast” in order for your report to be effective. So how can we make sure that we make the best use of this language and write code that doesn’t slow down the performance of our reports? For that we need to first understand the internals of the DAX Engine and understand that Tabular is a different technology than a SQL database. Once you build that mindset you need to understand the flow of a DAX code and will need to learn how to read query plans. Once you’ve got all these tools in your toolbox, you’ll be ready to begin fine-tuning your code for peak performance.

To help guide you down the road to becoming an advanced user of DAX, we are proud to present a course on DAX Studio and Optimization, where we begin with the types of engines in DAX, 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. Then we transition into developing an understanding of the Logical and Physical Query Plans, xmSQL, and finally we read query plans of DAX functions so that you can also understand how your code is getting executed. At that point, we will go through a number of examples of how to integrate and apply all of this knowledge to optimize your DAX measures.

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.


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

What you get with the course

  • Over 5 hours of comprehensive training
  • Resource pack

Here are the specifics for the course

Learn how to:

  • 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

What our

Students Say
Curriculum
1

Course Introduction


2

SE, FE, Cache and Query Execution


3

Vertipaq Compression Techniques


4

Vertipaq Analyzer


5

Query Plans, Server Timings & more


6

Advanced Ribbon


7

Reading Query Plans of DAX Functions


8

Optimizing DAX Code & Data Model


9

Conclusion and Final Words


10

Feedback


11

Certification


Your

Instructor
Empty image or helper icon

We are always looking for the best solution for you

Frequently Asked

Questions

Recommended

Courses
Course Cover: Excel to Python for Data Analysis
beginner
Total points: 206 XP clock-blue 1 hours

Excel to Python for Data Analysis

Join us on this journey from cells to scripts, and unlock a new realm of possibilities for your data projects.
Tools
Python
Excel
Skills
Data Transformation
Data Analysis
Data Visualization
Advanced Analytics
Gaelim Holland
Gaelim Holland
See details
Course Cover: Machine Learning Models in Power BI
intermediate
Total points: 194 XP clock-blue 1 hours

Machine Learning Models in Power BI

From Data Preprocessing to Advanced AutoML: Mastering Predictive Analytics in Power BI
Tools
Power BI
Python
R
Skills
Data Transformation
Data Analysis
Advanced Analytics
Data Visualization
Data Modeling
Report Design
Business Analytics
Gaelim Holland
Gaelim Holland
See details
Course Cover: LangChain Deeper Dive: Prompts
intermediate
Total points: 174 XP clock-blue 1 hours

LangChain Deeper Dive: Prompts

Unlock the power of Large Language Models: Dive deep into LangChain and transform your AI interactions.
Tools
ChatGPT
Python
Other Tools
Skills
Data Analysis
App Development
Data Strategy
Gaelim Holland
Gaelim Holland
See details

Get full access to unparalleled

training & skill-building resources
power-bi-custom-visuals

FOR INDIVIDUALS

Enterprise DNA

For Individuals

Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.

Learn More chevron_right

FOR BUSINESS

Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace.

Learn More chevron_right
power-bi-custom-visuals