Accept cookies to show this video. Cookies Policy
Allow all cookies

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

  • Introduction

    • Introduction

  • DAX Studio

    • DAX Studio
    • Introduction to DAX Studio
    • Connections
    • The metadata panel
    • The ribbon
    • Running a query
    • Output of a query
    • Query builder
    • Format DAX
    • Editing tools
    • Load Performance Analyzer data
    • Capturing queries executed on a server
    • Query plan and server timings
    • Run benchmark
    • View, import, export metrics
    • Export data
    • SQL Profiler and Analyze in Excel
    • Options

  • VertiPaq Analyzer

    • VertiPaq Analyzer
    • Introduction to VertiPaq Analyzer
    • Load VPAX files
    • The Tables page
    • The Columns page
    • The Partitions page
    • The User Hierarchies page
    • The Relationships page
    • The Compression page
    • The Columns Data Types page
    • The Encoding page
    • The DAX Expressions page
    • A real data demo
    • VertiPaq Analyzer vs. DAX Studio

  • Analyze in Excel for Power BI Desktop

    • Analyze in Excel for Power BI Desktop
    • Introduction to Analyze in Excel for Power BI Desktop
    • Trace MDX queries
    • Limitations
Student Rating
4.9
439 ratings
90%
8%
1%
0%
1%
Student Reviews (208)
  • 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.

  • Franz Scheller (Dec 19, 2020)

    Buenisimo!

  • Sue Bayes (Dec 18, 2020)

    Really enjoyed this course, it gave a useful insight into how to maximise the external tools to increase efficiency and performance. I do use all 3 tools but now can really utilise the features to improve my work. Lovely short and sharp course that was easily digestible and will make a big difference to me. Thank you.

  • Nkululeko Nzimande (Dec 18, 2020)

    Amazing course to get you going with these amazing Dax Tools. Thank you for offering this for free.

  • Nicola Jelmorini (Dec 17, 2020)

    As always, the presentation is very clear, simple and understandable.

  • JOSE R AZCANO (Dec 17, 2020)

    Excelente! Me ayudó mucho a comprender mejor estas herramientas. Muchas gracias

  • Kenneth Barber (Dec 17, 2020)

    Admittedly, I never bothered to try to learn these tools, so I didn't use them very much. This course does a good job of showing off most of the features of each tool. At the beginning of the course, they say that this course is a prerequisite for all of their DAX courses. To add to this, I find that this course is especially important to take if you took or will take Optimizing DAX.

  • Frank Kiss (Dec 16, 2020)

    Excellent introduction into the new frontier myriad of Data Analysis/Modelling!!!

  • Erica M Dyson (Dec 16, 2020)

    Hi. Thanks so much for this training. It's excellent and I've already picked up functionality that I didn't know was there. Also a small(ish) point, I found out that the Query Builder is not visible by default. It needs to be activated via Options - so now I have it. Thanks once again. I shall definitely be using Dax Studio more and the Excel connector now that I know it exists! Erica Dyson

  • Andrea Venturini (Dec 15, 2020)

    Very useful

  • Mauricio Jimenez Ortiz (Dec 15, 2020)

    very good training , thanks a lot!

  • Ed Elliott (Dec 15, 2020)

    great