This is the video course version of the Mastering DAX workshop. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power BI, Power Pivot for Excel, and at Analysis Services developers that want to learn and master the DAX language.
The goal of the course is to teach all the features of DAX, providing the knowledge to write formulas for common and advanced business scenarios. The video course is made up of over 15 hours of lectures, plus another 15-20 hours of individual exercises. You can watch the videos at anytime and the system will keep track of your progress. Within the course you can download the material for all the exercises.
Students have access to a private discussion area where they can interact with the instructors asking questions related to the lectures and the exercises.
The knowledge and enthusiasm of Marco and Alberto around DAX is really impressive :)
Due to the complexity and difference of DAX compared to other ways of coding and syntaxes, I found some of the lectures quite hard to follow.
Maybe it could be good in some looooong chapters to have exercises spread out inside a chapter instead of only in the end.
I don't feel as a Master of DAX, but at least I know a lot more know about what is possible (and not possible) to do :)
Alastair McIntosh(Oct 7, 2024)
Thank you ever so much, Alberto and Marco, I aspire to be like you gentlemen.
Bruna Fernandes da Fonseca(Oct 5, 2024)
Loved it!
Organized, resourceful, detailed, well articulated, with good exercises!
Francis Larin(Sep 27, 2024)
Superbe formation pour son contenu et l'interface utilisateur.
Je recommande fortement !
Alastair McIntosh(Sep 25, 2024)
Brilliant course! Thank you so much Alberto and Marco, for sharing your intimate knowledge so effectively. You guys are my inspiration!
Matthias Giger(Sep 24, 2024)
This course goes very deep, and I might have to do it again, but it also serves as a library. It does a great job of showing some of the more and some of the less common obstacles one could face working full speed with DAX.
Thomas Grieb(Aug 12, 2024)
The course covered all important aspects of DAX. However, I am a bit disappointed about the teaching qualities of the lecturers. Many concepts are described only verbally instead of using adequate graphs and sketches to help understand what is being explained. For example in section "Example of an arbitrarily shaped filter", there is a difficult concept mostly verbally explained from time stamp 3:45 onward. The lecturer then goes on to explain while there are two rows in the left hand table, there should actually be four. The months columns are filtered by the other filter but, at the end, there are still iterations going over four months. All of this is quite confusing and it would have helped to use a concrecte example with simple numbers in outlining what the lecturer has explained. There are many more of these example which I find unfortunate.
Nicolas Demers(Aug 4, 2024)
Very good, well organized and complete coverage of DAX formula expression language.
I loved the way information and material was disseminated. I enjoyed greatly the addition of exercise videos. I also appreciated when you shared new tools like the DAXstudio.org. Finnally, Alberto & Marco, despite your great level of mastery (DAX Jedi) you were able to transfer your knowlege and experience in an easy and accessible manner for your little DAX Padawan!
KUDO for this great video course.
Jen Zelmanski(Jul 29, 2024)
If you want to learn it right, the SQLBI guys are your source. Hands down. I'm not sure anyone in the world knows the ins and outs of DAX as deeply and thoroughly as they do, and they understand what confuses students and they know how to 1st - teach the concepts needed to understand DAX and 2nd - explain tricky subjects and aspects of DAX.
Priyanka K(Jul 17, 2024)
Wonderful!
Would you prefer a classroom course?
This video course is based on a classroom course we teach all around the world. If you prefer a classroom learning experience, take a look at the dates below for a list of our upcoming classroom courses!