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
- Paulo Rocha (Feb 6, 2021)
Thanks again Maestros Marcos and Alberto for providing such an excellent course, for free. SQLBI is the most important contributor for the Power BI and DAX Community.
- Miguel Angel Medina (Feb 3, 2021)
Very good course, and the explanation is very easy to understand
- Kataka Arnold (Jan 18, 2021)
Thank you very much for the course, I've gained a lot of insights on all the tools used with DAX and I'll be practicing with the skills I've learned.
- Mr A Lockett (Jan 17, 2021)
A very useful review of these three handy tools. Many thanks for making this available!
- Abdelkader Gharbi (Jan 16, 2021)
the best quality for learning !
- Abdelkader Gharbi (Jan 12, 2021)
as usual great learning series from great experts thanks a lot
- R Bi (Jan 10, 2021)
Супер вводный курс для старта! Спасибо!
- Franz Scheller (Jan 8, 2021)
Thank You Guys!
- Rigoberto Garcia (Jan 6, 2021)
Excellent video course. There is a perfect and wonderful integration of the instructor between the theory and the practical part. These tools open up a world of possibilities and make it easy to use Power BI Desktop and create better models. Thank you very much for this video course and for sharing your knowledge and experience.
- Enmanuel López (Jan 6, 2021)
¡Excellent this course. I've learned a lot about it. Thanks so much!
- steven foster (Jan 4, 2021)
Good course. I wish Tabular editor was covered though.
- Alejandro Ruano (Jan 4, 2021)
A simple way to learn new tools for Power BI
- Deepak Rajan (Jan 3, 2021)
Found this course really helpful as it covers Dax Studio, Vertipaq and Analyze in Excel in a very clear manner.
- Igor Poleshchuk (Jan 3, 2021)
Thank you so much! A really useful course for every DAX developer!
- MOHAMMED SALEM MAROUF (Jan 2, 2021)
Very cool