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.
DAX is not easy - it is built on concepts that do not exist in other query languages. While some of them, like filter context, is something you intuitively start understanding after a while of using Power BI, others are not what you would discover on your own. Not only that, they do not exist in official Microsoft documentation either.
This course is absolutely brilliant in teaching you all such core concepts and really allows you be ready to **master** DAX. There is a lot of content on the Internet on DAX, but I have yet to see anything of such high quality as SQLBI courses, and this is one is definitely essential for anyone who wants to be serious in this space. Marco and Alberto are great educators, the exercises (that I highly recommend to go through) are highly relevant, and the discussion pages are another treasure trove to scan through.
I can't say this enough: it's a brilliant course.
Fermin bartolome(Jun 26, 2021)
Fantastic
MATIAS STERZER(Jun 18, 2021)
Every time I played one of these videos, I learned something new. And I'm pretty sure I'll keep doing it. Excellent material!!
MATIAS STERZER(Jun 18, 2021)
Every time I played one of these videos, I learned something new. And I'm pretty sure I'll keep doing it...Excellent material!!
Oded Dror(Jun 1, 2021)
Very informative
One suggestion for the Filter Context, Row Context and transition it will be helpful to return one VAR at the time to show the students what VAR actually contain by visualizing the VAR data it will help to better understand this complex subject enjoy DAX
Thomas Schmidt(May 25, 2021)
Excellent Course from the Grandmasters of DAX-Fu!
Thanks Alberto & Marco
Khristian Hernandez(May 19, 2021)
Was a good course, thank you.
Manuel Pedrozo(May 18, 2021)
Excellent course, well done all the way around. Highly recommend.
Kun Wang(May 11, 2021)
Awesome Courses
Stefaan Louette(May 9, 2021)
By far the best course I ever had - masterpiece and for me a mandatory one for anybody who is working with PowerBI and DAX
Abhijith DSouza(May 3, 2021)
Fantastic course covering all aspects of DAX. A must for any Power BI professional
Gaston Clynhens(May 2, 2021)
Dear SQLBI Team,
What a fantastic course!
The global setup and the way this is organized is excellent.
Some pro's: studying at your own pace, when you have personal timeslots available, based on high-level video courses explaining the concepts in a structured & clear way, dedicated (real-life) exercises and last but not least the interaction in the "Discussion".
( There are no con's )
This was "chapter 1" in my DAX adventure; the next ones will be related to "consolidation of the knowledge" and diving deeper into (other) details. Every chapter in this course is very relevant; the different options explained in the "Working at different granularity" part is simply great!
I'll see you soon!
Thank you
Mark Bennett(Apr 23, 2021)
Excellent!
Vladimir Rakascan(Apr 15, 2021)
The course is great, I learned a lot!
I will definitely watch the course again after some time spent practicing DAX.
I would like to thank Marco and Alberto for making a huge effort to realize such good content.
Maria Katsanevas(Apr 13, 2021)
great course
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!