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.

lessons and examples are very clear discussion sections are very useful

Again a perfect course. Very useful are the patters provided. So all you have to do is to identify the right pattern and apply ;-)

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.

Excellent and astonishing course.

Thank you! Excellent!

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!

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.

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)

Great course, I really enjoyed it! I'll continue with the DAX advanced course! Regards!

Thanks Marko & Alberto for organizing the course. Best practices and scenarios solved during the course are often daily on tables of the data analysts. I enjoyed the course a lot and still need to go back tor review some more complex scenarios :)

Outstanding materials. The contents are "meaty" and of high-quality.

congratulazioni, il corso è molto ben fatto ed efficace! Se posso, vorrei aggiungere 2 suggerimenti: - sarebbe utile pensare ad un nuovo modulo orientato alla gestione e controllo dei modelli e del flusso dei dati in un'organizzazione complessa in relazione ai vari modelli di deployment - sarebbe molto interessante apprendere quali soluzioni si possano sviluppare mediante il data modeling per facilitare l'applicazione di tutti i requisiti di privacy by design e di compliance control nella creazione di una piattaforma di BI aziendale (sempre in relazione ai modelli di deployment di cui sopra ed all'utilizzo o meno dei filtri di confidenzialità di Power BI)

It gave me the confirmation of thoughts and also gave me new ideas. I thank you for publishing this good course.

after using Power Pivot for some years, I could with this course improve my data modeling skills to the next level. The core principles explained in the sections are good understable. Some topics have some (DAX) magic in it. I appreciated the ways proposed in many examples to simplify the data model. Doing it right, it's much more easier and performant. Thanks a lot! With this video course, I'm just only missing eating a pizza with Alberto or Marco.

• – Thanks!!
  Reply by SQLBI (Jul 13, 2018)