DAX Tools Video Course
The DAX Tools video course teaches how to use three popular tools to write and optimize DAX: DAX Studio, VertiPaq Analyzer, and Analyze in Excel for Power BI Desktop. All these tools are free and open-source.
DAX Studio allows you to write DAX queries and test your DAX measures in an environment where you can check the results and measure performance. You can also use DAX Studio to export data in different formats. VertiPaq Analyzer requires DAX Studio to export statistics and metadata about a data model that you can investigate in more detail using the dedicated tool. You can investigate in compression and get documentation about all the DAX expressions used in a model using VertiPaq Analyzer.
Analyze in Excel for Power BI Desktop makes it very handy to test your Power BI model using an Excel PivotTable without having to publish the model to the Power BI service. During the development of new DAX formulas, this tool shortens the waiting time and increases your productivity.
The course is made of 129 minutes of lectures. You can watch the videos at any time and the system will keep track of your progress. Within the course, you can download the files used in the demos.
Collapse allCurriculum
- Nick Brown (Jan 7, 2026)
Difficult to understand presenter due to thick accent. Far too much time spent on VertiPaq Analyzer, far too little explaining what the various terms mean and what their uses are. No examples of actual optimization provided because it's "far too indepth for this course".
- – Thank you Nick for this feedback. Although the course is free, we still made the effort of hand-writing subtitles in English, precisely to make it easier to follow. These subtitles were then translated automatically into many different languages. I recommend using them for other courses you may be wanting to study.
Re: Optimization, that is indeed off topic for a course about DAX Tools. What you can do is start with the free, trial version of Optimizing DAX to get a better idea of what you can expect - but it would be best to lay the foundation with the Mastering DAX, and the Data Modeling video courses first. The DAX Tools course is very much at the beginner level, and Optimization is at the other end of the spectrum for advanced students.
Reply by Claire Costa (Jan 8, 2026)
- – Thank you Nick for this feedback. Although the course is free, we still made the effort of hand-writing subtitles in English, precisely to make it easier to follow. These subtitles were then translated automatically into many different languages. I recommend using them for other courses you may be wanting to study.
Re: Optimization, that is indeed off topic for a course about DAX Tools. What you can do is start with the free, trial version of Optimizing DAX to get a better idea of what you can expect - but it would be best to lay the foundation with the Mastering DAX, and the Data Modeling video courses first. The DAX Tools course is very much at the beginner level, and Optimization is at the other end of the spectrum for advanced students.
- Balaji Komma (May 15, 2024)
It is already there in the youtube, so what is the purpose you provide it free in the form of course
- – Thank you Balaji for your time, although your comment does not have much to do with the course itself. We published the free courses on YouTube to reach a larger audience, but viewing the videos on our platform allows you to keep track of you progress, search in the transcript, use the highlighter, and apply bookmarks. We hope you do not find it confusing; we apologize if you do.
Reply by Claire Costa (May 16, 2024)
- – Thank you Balaji for your time, although your comment does not have much to do with the course itself. We published the free courses on YouTube to reach a larger audience, but viewing the videos on our platform allows you to keep track of you progress, search in the transcript, use the highlighter, and apply bookmarks. We hope you do not find it confusing; we apologize if you do.
- Aadil Sharma (Jul 6, 2023)
good but need more explanation