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
426 ratings
90%
8%
1%
0%
1%
Student Reviews (202)
  • Vyacheslav Ilnytskyy (Dec 29, 2020)

    As always great. I've learned a lot from this short and very effective course.

  • Leandro Rocha (Dec 29, 2020)

    In my opinion this course is very good, clarified many questions and help me to understand many things. Now, i will put into practice in my job everything I learned here. Thanks!

  • v slivinski (Dec 28, 2020)

    Awesome overview. Keep up the quality work!

  • john keegan (Dec 28, 2020)

    Once again, an outstanding presentation by Alberto Ferrari and Marco Russo. A must see for all Power BI developers. You cannot get this content anywhere else. Thank you Alberto and Marco for your remarkable contributions to the World.

  • Rogerio da Silva Matos (Dec 28, 2020)

    Ferramentas fantásticas, e uma explicação extraordinária.

  • Yamin KERKOUB (Dec 28, 2020)

    Very nice course, short but efficient and relevant. Thanks a lot. I would suggest a course on PAGINATED REPORT because the SQLBI style and pedagoy is unique ! Warm regards ! Yamin

  • Kevin Dmonte (Dec 27, 2020)

    Very good to have access to this course. It outlines what tools are available to us to make Power BI reports better (via DAX formatting via Studio and the performance functions available , Vertipaq Analyzer etc) . Thanks.

  • Ignacio Cabrero (Dec 27, 2020)

    A little sample gfor How optimize a PowerBI model was fantastic. Thx

  • Cosmin Ioan (Dec 27, 2020)

    top notch course, as the rest of the training courses, by the leaders in the industry! many thanks for all your contributions, Marco, Alberto!

  • arnaldo tanaka (Dec 26, 2020)

    Excellent.

  • Robert Wolf (Dec 26, 2020)

    I had just finished Mastering Dax course and went on to this free course. This also was a very good short course and it gave me insights from one source on how to use these three Power BI tools. Though some of the items were beyond my level it was still very helpful. And was one more addition on my Power BI DAX journey.

  • 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