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
- Sanjeev Kumar (Dec 24, 2020)
I could have given six stars if possible. Amazing content and very well explained. Thank you very much for making this available as a free course. Your contribution to the data community is incredible. Merry Christmas and Happy new year to the SQLBI team. Best Regards, Sanj
- Daniel Alejandro Gil Perafita (Dec 24, 2020)
The couse was amazing, I can't wait to start the next one. However, I know that I don't have all the knowledge yet so I have to take it step by step in order to take the max benefit from it. Thanks to all the SQLBI!!
- Debasree Tripathy (Dec 24, 2020)
Great Course. I liked the simple explanation of Vertipaq Analyzer and the example of real time data.
- Luis Castellanos (Dec 23, 2020)
interesting, thanks for the info
- Anil Yadav (Dec 23, 2020)
That's awesome. Please more training like that.
- Mauricio Chacon (Dec 22, 2020)
Very usefull
- Ron van der Laan (Dec 22, 2020)
It is a nice shkrt training that gives me a lot of good tools
- Scott Moody (Dec 22, 2020)
This was exactly what I was after and needed. Thank you so much. This laid the foundation for many doors to be opened and explored around evolving my craft and improving my product to my customers!
- Curtis Gregson (Dec 22, 2020)
Fantastic!, The course design is simple but highly effective. The bit size chunks of information in each short session is perfect for getting acquainted with these tools. Now I (finally) feel prepared to use these tools vs stumbling through things via trial and error. Thank you!!
- emiliano vuoto (Dec 21, 2020)
only the best
- Jose Almeida (Dec 21, 2020)
Top-notch content as always ! Thanks for sharing .
- Raja kumar (Dec 21, 2020)
This is excellent, I have been learning these tools in bits and pieces, now i see all shaped in one Video explaining in detail.
- M Jain (Dec 20, 2020)
Excellent course. I have been fan and follower of your teaching, such a smooth flow and you go with such a systematic manner. I have been working in PowerBI since last 3 years and want to pursue your other courses mainly DAX and data modelling, but truly speaking very expensive, it would be nice if you can reduce the cost a little lower or give option of smaller monthly amounts or so.
- lixia zhang (Dec 19, 2020)
very useful tools and I will start to use them from today and let them become my best friend!
- Sujan Bhattarai (Dec 19, 2020)
The video tutorials provided are easy to grasp the different aspects of DAX studio, Vertipaq Analyzer and Analyze in Excel tools. This made to start the journey in Power Bi with more professional approach. Thankyou SQLBI.