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 course is very dense, as I expect but the many growing concepts and the hard exercises are in a level that not correspond to the video classes. Video classes are easy and in a lower level presented. Perhaps , as a suggestion you could send us videos about the exercises resolution. The forum in that case is not enough. I realized that was a "jump" between the classes and exercises. Intermediate exercises between them could be another strategy to consolidate the concepts before going direct to the complex exercises.
– Eduardo, thanks for the feedback. Any example of intermediate exercises would be useful - we know that we have several exercises that we consider basic or intermediate, and we can imagine what you consider advanced, but a more detailed explanation would be very useful for our evaluation. Thanks! Reply by SQLBI (Oct 10, 2018)
Shivakumar Konar(Sep 23, 2018)
This course is absolutely brilliant and covers all the topics of DAX in depth. The lectures very quickly go into advanced mode right from the word go, so this is not something you can just watch on the go. You truly have to get your hands dirty and watch all the videos multiple times(I am on 4th iteration :D).
What makes this course more valuable is ablility to get in touch with Marco & Alberto. Marco has helped me solve so many problems, not just the ones mentioned in the course, any real life problem you encounter, Marco was able to solve it and give the approach of solving the problem.
Moreover, I was able to clear the Micro 70-778 exam. Although this course does not cover all the sections required to clear the 70-778 exam, but it definitely covers the largest section relating to DAX.
Thanks Marco & Alberto for putting this course together
Steven Fortier(Sep 11, 2018)
Thank you so much for this course. Alberto and Marco are really the best teacher you can get to teach you DAX. I had already 1 year of experience with Power Pivot but this course helped me a lot to understand all the works under the hood. I will definitely buy their book in the next months.
Joe Chamberlain(Jun 15, 2018)
Excellently explained and delivered, will find this very useful. If I'm honest I found the exercises very difficult, but I probably didn't allow myself enough time. Keep up the good work. :)
Ihthisham Hazard(Mar 28, 2018)
Thanks Alberto and Marco for this. I bought the Book (Definitive Guide to DAX) in 2016 and started reading until advance filter context and then thought I want to learn from Video. The Video was a great boost for my dax knowledge.
Andres Taroco(Mar 19, 2018)
Muy buen curso.
Raheel Rana(Mar 18, 2018)
Learned a lot ...Thanks, Alberto and Marco ... you guys have made many lifes easy :)
Izacc Moreira(Feb 26, 2018)
Thats a great course!!!!
Sony Thomas(Dec 22, 2017)
Very good presentation. It satisfied my requirements. I have gone through all the topics by one week and will refresh it from beginning again . From last few months I was doing projects for my company on Power BI with few DAX equations like SUM , SUMX and few equations with Filters, now I will be able to use the power of DAX to provide powerful reports.
Once I refresh the course and able to practise it , I prefer to take the DAX Optimization course. Once again thanks for the good presentation.
Bhavesh Patel(Dec 21, 2017)
The Best DAX Course in the World!
Feiwei Yang(Dec 11, 2017)
Awesome!
Flora Fangfang Zhao(Dec 8, 2017)
This course is definitely the must-learn if anyone wants to use Power BI in a proficient way. From my own experience, it would be more efficient to follow the course and at the same time read the book . I appreciate that Marco and Alberto answer to all questions I posted on the web with as many details as possible. Thanks a lot and keep up the terrific work!
Larry Casey(Oct 31, 2017)
Not enough real world examples. None of the examples will ever be used in the real world so it is very difficult to learn something when it is not taught correctly.
My suggestion, don't give us some stupid unrealistic examples to work with, give us real examples that relate to real business needs.
Not once do you provide examples of using dates to filter multiple tables or how to create relationships that calculate balances etc....
Everything is just a real water downed single table.
– The examples included in the course are intentionally focused on explaining how the DAX language works.
For this reason, they isolate specific issues that can help to understand each behavior of the language and of specific functions.
If you want to get more real-world examples, we suggest you to take a look at www.daxpatterns.com where you can find a number of templates (completely free) that can be applied to real world issues. On that site, the focus is to apply the language to the business, so you will not find there an explanation of how the language work, which is probably needed when you have to adapt a pattern to your specific scenario.
Thanks for your feedback, it will help us in clarifying the goals of the course in our marketing content. Reply by SQLBI (Nov 3, 2017)
Andrew Mackay(Oct 21, 2017)
What can I say, you guys are great at what you do and in short this course is what is says on the can.I feel like I can Master DAX with more time and practice and the material covered allows me to know I can do it by understanding these areas as a foundation.
Very cool thanks
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!