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

Free

3

Vertipaq Compression Techniques

Free

4

Vertipaq Analyzer

Free

5

Query Plans, Server Timings & more

Free

6

Advanced Ribbon

Free

7

Reading Query Plans of DAX Functions

Free

8

Optimizing DAX Code & Data Model

Free

9

Conclusion and Final Words

Free

10

Feedback

Free

11

Certification

Free

Your

Instructor

Antriksh Sharma

null

Frequently Asked

Questions

add

What’s the difference between a free account and a paid plan?

add

Do I need to know anything about data science or data analytics to get started with Enterprise DNA?

add

How will I be charged?

add

Can I get an invoice for my company?

add

Are refunds available?

add

Will AI take over the world and make data skills worthless?

Recommended

Courses

Course Cover: ChatGPT to Improve Productivity in Excel
beginner
Total points: 178 XP clock-blue 1 hours

ChatGPT to Improve Productivity in Excel

Boost your Excel productivity with our ChatGPT course designed to enhance your skills!
Tools
ChatGPT
Excel
Skills
Data Analysis
Process Automation
Henry Habib
Henry Habib
See details
Course Cover: Beginners Guide to ChatGPT
beginner
Total points: 167 XP clock-blue 1 hours

Beginners Guide to ChatGPT

Unlock the full potential of ChatGPT and take your language processing skills to the next level.
Tools
ChatGPT
Skills
Process Automation
Sam McKay
Sam McKay
See details
Course Cover: Beginners Guide to Power BI
beginner
Total points: 330 XP clock-blue 2 hours

Beginners Guide to Power BI

Build a solid foundation in using Power BI.
Tools
Power BI
Skills
Data Analysis
Data Modeling
Data Visualization
Sam McKay
Sam McKay
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