Optimizing DAX Video Course
This video course teaches you how to optimize queries and measures in DAX.
DAX is the native language of Power Pivot for Excel, Power BI Desktop and SSAS Tabular models in Microsoft SQL Server Analysis Services. This video course is aimed at users of Power BI and Analysis Services developers who already know the DAX language and want to learn how to optimize DAX formulas and models for improving performance.
The goal of the video course is to enable you to find bottlenecks in DAX calculations using Performance Analyzer and DAX Studio, providing the knowledge to improve the performance by using different DAX formulas or by changing the data model, when required. The video course is made up of over 29 hours of lectures covering the formula engine and the VertiPaq storage engine – other hours of lectures will be added by the end of 2023 with the additional sections for DirectQuery and composite models. You can watch the videos at any time and the system will keep track of your progress.
The companion content available to the students includes:
The PDF version of Optimizing DAX The book includes a detailed description of all the modules of the video course. You have access to draft versions before the book is published by the end of 2023.
- PBIX files for all the demos
- DAX code for all the demos
- Backup of SQL Server databases to refresh the PBIX files
- BIM file to create Analysis Services databases used for demos with large models
Students have access to a private discussion area where they can interact with the instructors, asking questions related to the lectures and the exercises.
Prerequisites: Students need a good knowledge of the DAX Language, and a previous experience using Power BI Desktop or Analysis Services Tabular. You may acquire this knowledge by following the Mastering DAX Workshop, or by having equivalent real-world experience.
Collapse allCurriculum
- KANG YOUGEN (May 20, 2023)
i
- Kenneth Barber (May 19, 2023)
This review is for the 2nd edition of this course before the content about DirectQuery and composite models was released. Anybody that works regularly with DAX should take this course. It succeeds in "teaching a man to fish" and gets you comfortable with looking at xmSQL code and query plans. There is great emphasis on analytical thinking, methodology, adaptability, and trial and error, and this approach prepares you for any Data Model in any version of Tabular, whether now or in the future. Because of this, you will leave the course feeling empowered rather than feeling powerful. Lastly, the delivery of this course's content is overall the best so far out of SQLBI's courses. I look forward to the rest of this course and any future courses by SQLBI!
- Deron Huskey (May 3, 2023)
Great course! Thanks for the time and effort you put into it.
- Alexander Feygin (Dec 20, 2022)
I guess I'll continue buying your courses even I'll stop using Power BI.
- Alexander Feygin (Dec 20, 2022)
I guess I'll continue buying your couses even when i'll stop using Power BI.
- Paweł Zieliński (Nov 28, 2022)
Hi Alberto, Hi Marco That was very interesting course. I learned a lot. Thanks to that I have now completely different view on DAX and opimization process. Thanks!
- Alexey Zidymakov (Nov 13, 2022)
This is a great course. Thanks!
- Ezequiel Matos (Jan 6, 2022)
Excellent course.
- Mark Levy (Jun 7, 2021)
Not related to Review: I like to use the yellow color pen when reading along with your commentary: Is it possible to have other color options as well? e.g orange, and green?? Also I notice that when I print off the commentary - even though I am using color setting - I am unable to print the color highlights that I make . It would be useful to allow color printing to the allow that highlighted sections to print. Related to REVIEW: Very detailed and has complex information that needs time to be digested. I will go through this course many more times in order to be comfortable with it.
- Mark Levy (Jun 6, 2021)
Very detailed and has complex information that needs time to be digested. I will go through this course many more times in order to be comfortable with it.
- Igor Poleshchuk (Jan 25, 2021)
For a long time, I doubted whether I needed this course or not. In the end, I decided to go through it and did not regret it for a single second! I feel that after completing the course, I have moved to a new level in my understanding of DAX.
- Ross Waterston (Nov 18, 2020)
That was great, really enjoyed the challenges set in the labs. This has been a fantastic rebalance of my DAX. Correcting some of the "lazy" that have no doubt crept in while also firming up the reasoning behind some of the things I do "just because" now.
- Leo Godin (Oct 26, 2020)
Great course. I'd read a lot of articles on optimization, but this course walks you through a process for optimizing and shows great solutions. The important part is it teaches you how to think about optimizing DAX code.
- David Williams (Jun 3, 2020)
A fabulous training course that I will start using immediately and that I will have to review a few times to be able to use all of the value provided! I absolutely recommend it.
- Kenneth Barber (Apr 23, 2020)
SQLBI has done it again! Very thorough and very well explained. This is a great supplement to Mastering DAX and is essential for writing fast DAX code. DAX (or at least Power Pivot in Excel) is a bit sensitive; it doesn't take much for DAX code to run slowly and have you wondering how to make it faster.