Efficient and optimized DAX code is a big part of your organization’s success: it is faster, makes users happier, and represents significant savings in Fabric capacity.

If you are working with DAX at a level where performance and capacity usage are starting to be key, this workshop is for you. You will learn what is needed to optimize DAX and which tools to use.

Starting from the semantic model architecture, you will understand the internals of the VertiPaq engine used for Import and DirectLake. You will learn how to isolate performance issues by using Performance Analyzer and how to interpret Query plans and Server Timings information provided by DAX Studio.

After an introduction to the DAX query fundamentals, you will also learn several DAX optimization patterns that you can easily apply to your models.