In the previous section, we learned that part of the process of executing a DAX query results in the calculation engine producing a logical query plan and a physical query plan. In addition, when attempting to optimize a slow DAX query it helps to understand which elements are carried out by the formula engine and which are carried out by the storage engine. To help us with both processes, we're going to look at using DAX Studio, a third-party tool that we've looked at briefly in previous chapters.
To follow along with this section, you will need to download and install DAX Studio, which is available from:
https://daxstudio.org
https://daxstudio.org
Once you have installed DAX studio, you will be able to create links to tabular data models in the following products:
- Power BI
- Excel Power Pivot
- SQL Server Analysis Services (SSAS) Tabular
If you are working...
