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.
Fantastic course! I feel like I levelled up a lot in my journey to learn DAX with this course. I really appreciated how complex concepts were presented in an easy to understand way. Thank you Alberto and Marco for delivering such great content.
Muhammad Bilal Azim(Jul 15, 2019)
I will describe this course by by using a line from first Avengers movie
"The DAX video course has shown me so much. It's more than knowledge. It's truth"
The content and flow of topics from start to finish is so elegantly structured, its perfect. I am from accounting background without any background in coding or programming and still able to understand the concepts taught in the course as they have been delivered in such an elegant manner
Thank you Marco and Alberto
Thomas Kwakman(Jul 10, 2019)
Hard to find better. Very hard.
Marcelo Salata(Jul 8, 2019)
Great!!!
Iva Vucak(Jul 5, 2019)
This course is excellent. I have never seen complex functions explained in such easy to understand way. 2nd edition is even better, context transition is better explained, I think. You helped me so much, thank you for amazing course!
Nghia Tran Trong(Jun 27, 2019)
good
Gary Friend(Jun 19, 2019)
Great course, brilliantly presented. Certain I will go through from the beginning again to make sure I pick up all of the insights it delivers.
Luca Priano(Jun 17, 2019)
Fully satisfied ;-)
Paul Talbot(Jun 16, 2019)
You can't take this course, do all the exercises, and not come away with a much higher understanding of DAX. The last 'Relationships at different granularities' module is an excellent capstone to all the learning. I personally benefited from a much better understanding of TREATAS, CROSSFILTER, ALLSELECTED, and DAX Studio / querying using the SUMMARIZE-type functions. The only thing I would say is that I would probably still not recommend this material to someone who hasn't touched DAX before (e.g. to a person completely new to Power BI who has to learn DAX as well), but that doesn't reduce the overall 5-star rating for me.
Fernando Luís(Jun 7, 2019)
Congratulations Alberto and Marco. This course is very well structure, very complete and effective. It help me a lot. With this course I could understand things that were not totally clear, after the read of your book “The Definitive Guide to DAX” .
Kenneth Barber(Jun 7, 2019)
Mastering DAX is nearly perfect and absolutely essential to understanding DAX. I have not found this level of detail presented so clearly and concisely elsewhere. The 2nd Edition is a great improvement over an already great course. There are many examples of mistakes that you might make. Approaches to each problem are compared and contrasted. This course uses lots of guided critical thinking, which helps you understand the material, not just know it.
Every Excel and Power BI developer must take this course to be able to handle large or complex data sets, otherwise you will waste lots of time coming up with poor solutions.
I recommend that you watch the videos at double speed to get more ideas in your head faster and make more connections between ideas, otherwise each individual idea might come and go.
Matt Ballinger(Jun 5, 2019)
Marco and Alberto have provided tremendous insight into the internal workings of the DAX language in a consumable and powerful course. After taking this course I feel fully equipped to face situations with a stronger understanding of the underlying concepts related to the DAX functions and capabilities. Thanks SQL BI!
youssef zaki(Jun 1, 2019)
Perfect course. can't wait for the next ssas training ! thanks guys for your efforts
Roman Emelyanov(May 12, 2019)
Thank you very much for the Course! It's Great! Labs was interesting and difficult for me. Now I need more practice after it. I think that at this moment I understand more about filter and row context, propagation, date lineage, filtering, querying, relationships. Waiting your new book "The Definitive Guide to DAX" second edition. Thank you again!
Donald Wiesmann(Apr 21, 2019)
thank you very much! very detailed and helpful!
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!