Mastering DAX Studio

We show how to download DAX Studio and install it.

In August of 2022, DAX Studio v3 was released. We talk about that here.

We do a brief tour of the product highlighting the major features of DAX Studio

You will be able to connect to various data sources, such as an instance of Power BI, Analysis Services or Excel Power Pivot

In this lecture we demonstrate how to connect to datasets sitting in a Power BI Premium or PPU workspace

You will learn about the power of Dynamic Management Views and their usefulness in understanding and documenting your data models

There are four DAX statement you must be familiar with when writing queries in DAX Studio. We show what these are and how to use them

DAX Studio will apply default formatting to your query output. However, you can help it do a better job if you know how.

We demonstrate how to mimic a Power BI filter context in your DAX Studio queries.

We demonstrate how to create a measure in your DAX Studio queries

With the release of v2.11.0 a new query builder was added to DAX Studio. We talk about how to use it.

We demonstrate how to export your data to CSV files. And, we show how to send one, several, or all of the tables in your data model to CSV files or SQL Server.

You will learn about the basic debugging features built into DAX Studio

You will learn how to capture all queries generated by your Power BI reports and display them in DAX Studio

You will learn how to monitor the performance of your queries, how to take advantage of the new Performance Analyzer in Power BI and the two engines used in Analysis Services to execute queries.

For those of you who do not come from a development background, this lecture shows how to find and download SQL Server and SQL Server Management Studio

A discussion of the new set of INFO functions added to Power BI

A wrap up of the course and a few DAX Studio features missed

Version 2.16.0 was released on 21-June 2021. We cover the new release in this lecture.

In this exercise you need to connect to a Power BI file using DAX Studio and display all rows in a particular table

In this exercise you are asked to fix a common coding error when executing queries in DAX Studio

In this exercise you are asked to show two different ways to export the contents of a table to a CSV file and explain why one approach has an advantage over the other

In this exercise you are asked to look at a slow query and determine what options you have in DAX Studio that might help you determine why the query is running slowly

In this exercise you are asked to generate some performance metrics in Power BI and then import them into DAX Studio for evaluation