Data Modeling for Power BI Video Course
Data modeling is a required skill to get the most out of Power BI, Power Pivot for Excel, and Analysis Services. This video course is aimed at users of Power BI Desktop or Power Pivot for Excel, and at Analysis Services developers who want to learn how to build the optimal data model for their reporting needs.
The goal of the video course is to teach through examples of increasing complexity how to solve business scenarios by adapting the data model, so that the required DAX code becomes easier, faster and more robust. All the demos and the exercises are based on Power BI examples. However, the very same concepts can be applied to Power Pivot and Analysis Services Tabular.
The video course is made up of over 10 hours of lectures, plus another estimated 8 hours of individual exercises. You can watch the videos at any time and the system will keep track of your progress. Within the video 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.
Collapse allCurriculum
- Robin Neven (Oct 25, 2019)
Very good: clear explanations and examples, though harder than I had expected. But that's good because it means there was a lot to learn! Minor point of improvement: sometimes the assignments weren't totally clear to me. In those cases it started with a description, but never really asked a question/gave an assignment.
- Lucas Minikoski (Oct 24, 2019)
Thank's, this course leveled me to another way of "DAXing". Now I feel better when I open the PBI and start measuring. Thank's a lot!!!!
- Abhijith DSouza (Oct 16, 2019)
Thank you Marco and Alberto for a wonderful course. A lot of real world applications were covered in the course and also different techniques to solve them. I particularly enjoyed the techniques which we shouldn't use and the reasons for not using them. Highly recommended for anyone interested in an in depth analysis for Power BI data modeling.
- Claudio Trombini (Oct 14, 2019)
Best course of Data Modeling!!!
- Thomas Allan (Oct 7, 2019)
A thorough review of model scenarios (simple to complex) covering date and time, historical attributes, snapshots, intervals, many-to-many relationships, differing granularities, segmentation, and multiple currencies.
- Luigi Bissolotti (Oct 2, 2019)
lessons and examples are very clear discussion sections are very useful
- Andreas Ratz (Aug 22, 2019)
Again a perfect course. Very useful are the patters provided. So all you have to do is to identify the right pattern and apply ;-)
- Sergio Murru (Aug 15, 2019)
This course covers different scenarios, from the simplest to the most complex ones, using them as examples to give a clear explanation of the different techniques that can be used when building the data models for our reports.
- Ciro Gómez Parssian (Jul 13, 2019)
Excellent and astonishing course.
- harm bons (Jun 25, 2019)
Course was good.
- Marcelle Georgiev (Apr 30, 2019)
Thank you! Excellent!
- John Mathews (Apr 4, 2019)
Excellent course and presentation, especially with the (deliberate) mistakes and interactions. The row explosion implications of (S/F)CD-Type2 were eye opening. Would like to see some of the scalability modelling issues discussed such amount splitting by order of magnitude, albeit you did mention date/time splitting, and how patterns change to deal with it. Now it's time to rip up my model and do it properly!
- Donald Wiesmann (Apr 4, 2019)
Thank you very much, very good in depth explanations, shows in a detailed way philosophy and specialities for data modeling with DAX in Power BI with still following the Kimball method.
- Steven Fortier (Mar 17, 2019)
Wow, this course was so amazing. Marco and Alberto are really good teachers and I recommand taking this course together with the other other one Mastering Dax. The only complain I might have is there's no chapter on handeling different langage in reports. Like if I want to show a reports to my customer in Europe and he talk spanish and the othe one wants it in French. I know there isn't a proper way to do it in Power BI but maybe talk about different possibilities and what are the possible solutions. Except that, everything is well covered. Thank you!
- – That is not a limitation of Power BI and the Tabular modeling where we do not have a good solution yet. The Tabular model supports translations of metadata only, but there are not good solutions for translating entity names (e.g. product names) or report labels. You can figure out workarounds, but any solution has implementation and execution costs - so a feature in Power BI to manage those scenario is really required.
Reply by SQLBI (Mar 18, 2019)
- – That is not a limitation of Power BI and the Tabular modeling where we do not have a good solution yet. The Tabular model supports translations of metadata only, but there are not good solutions for translating entity names (e.g. product names) or report labels. You can figure out workarounds, but any solution has implementation and execution costs - so a feature in Power BI to manage those scenario is really required.
- Jordi Andres Aguiñaga Gonzalez (Feb 21, 2019)
Great course, I really enjoyed it! I'll continue with the DAX advanced course! Regards!
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!Amsterdam, NL | Apr 14-16, 2025 Amsterdam |