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)
  • RUPALI NARVEKAR (Dec 16, 2024)

    Very Informative

  • Lucas Alves Leal (Dec 1, 2024)

    Great content Great content

  • Rigoberto Garcia (Nov 9, 2024)

    Excellent readings, accompanied by a very detailed descriptive video, which gives us an overview, the benefits of each of these tools and the best way to integrate them into our work, depending on what we want to achieve.

  • Lilian Lima (Nov 4, 2024)

    It was awesome.

  • Lillian Wen (Oct 28, 2024)

    Very helpful. I am working in a semantic model in power bi and the DAX studio and Vertipaq analyzer help a lot to improve the performance of the model.

  • krishna chaitanya (Oct 14, 2024)

    Great course and It is a well-structured and comprehensive guide to using DAX Studio and VertiPaq Analyzer, essential tools for DAX query optimization and analysis in Power BI. It covers practical topics, from basic connections and queries to advanced techniques.The inclusion of SQL Profiler and Analyze in Excel adds valuable breadth to the learning

  • ilay damari (Sep 30, 2024)

    excellent! Enriching course, comprehensive and clear and well recorded!

  • Quique Torrón (Sep 15, 2024)

    Excellent!!!! Thank you so much!

  • Gul Abbas (Aug 21, 2024)

    I learn a lot from this course

  • Aldo Zapata Vargas (Aug 16, 2024)

    excelent..!!!!

  • Alina Loginova (May 31, 2024)

    Thanks a lot for these amazing courses!

  • Oded Dror (May 30, 2024)

    Great

  • 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)
  • Kumari Ankita (Apr 22, 2024)

    Great Learning

  • Mijalis Alexandros Méndiz Pazos (Apr 14, 2024)

    Great course to have a first glance at the most common usage of DAX Studio, Vertipaq Analyzer and Analyze in excel.