Introduction to Data Modeling for Power BI Video Course

Introduction to Data Modeling for Power BI is an introductory video course about data modeling, which is a required skill to get the best out of Power BI, Power Pivot for Excel, and Analysis Services. The training is aimed at users that do not have a background knowledge in data modeling for analytical systems and reporting.

The goal of the course is introduce the primary concepts of dimensional modeling, using practical examples and demos to illustrate how to obtain the desired result without having to write complex DAX expressions. Creating a proper data model simplifies the code to write and improves the performance. The course is made of 100 minutes of lectures. You can watch the videos at any time and the system will keep track of your advances. Within the course you can download the slides and the Power BI files used in the demos.

Collapse allCurriculum

  • Presentation of Introduction to Data Modeling for Power BI

    • Presentation of Introduction to Data Modeling for Power BI
  • Slides and demos

    • How to download and use demo files
    • Demos download
    • Slides of the video course
  • Introduction to data modeling

    • Introduction to data modeling
    • Introduction
    • Scattered information
    • Business entities
  • Normalization and denormalization

    • Normalization and denormalization
    • Introducing normalization and denormalization
  • Star schemas

    • Star schemas
    • Introducing star schemas
    • Placing tables in a diagram
    • If you don't have a star schema
  • Why data modeling is useful

    • Why data modeling is useful
    • What is the role of a data model
  • Data modeling scenarios

    • Data modeling scenarios
    • Common scenarios
    • Header / detail tables
    • Back to a star schema
    • Multiple fact tables
    • Building a star schema
    • Handling multiple dates
    • Multiple relationships with date
    • Events with different durations
    • Precompute the values
  • Conclusion

    • Conclusion
Student Rating
4.9
1448 ratings
87%
11%
1%
1%
0%
Student Reviews (674)
  • carry Zhou (Jun 23, 2019)

    good,especially for star schemas

  • hemchand chowdary (Jun 12, 2019)

    this course dives through the data modeling with great granularity.

  • Dave Mason (Jun 12, 2019)

    Very interesting and useful introduction to data modelling. Suggests good ways to think about transforming your data to allow straight-forward analysis, whether in Power BI or other analysis tools.

  • Saurabh Pandit (Jun 12, 2019)

    A Must Do! Its a great course even for someone doing data modelling for years. The fundamental concepts have been so clearly explained. Just set the video playback speed to 2x and finish it in your lunch break! AMAZING! Thank you so much guys!

  • Beng Hwa Chan (Jun 9, 2019)

    An excellent introduction to Data Modeling with Power BI covering fundamental concepts and methodologies !

  • Eduardo Rocha Clemente (Jun 9, 2019)

    Good Initiative, but I´ve expected in this course an example for normalization from a denormalized table in excel. It´s a very common situation that we face... Many thanks for this free video. Your classes are becoming even better like Italian wine!!!!

  • Ketil Lidahl (Jun 5, 2019)

    These courses that Marco and Alberto makes has high value, and I can definitely see the value of paying for the complete course after having watched this. Very good tutoring skills and good use of practical examples to ease the understanding.

  • Daniel Pantie (May 28, 2019)

    I am a beginner and this is what I needed to kick off my data modelling journey. Great explanation supported by good examples in a very pleasant narrative. Simply 5 stars!

  • Richard Svensson (May 25, 2019)

    I have followed SQLBI since 2015 and got a lot of good experience from Alberto and Marco. For me it solved a lot of how to think when it comes to what should be done in SQL, Power Query and/or DAX, and especially, what are the pros and cons in different situations. The course is a very good introduction to data modeling using Power BI.

  • JOSE VICENTE DOÑATE (May 24, 2019)

    Sois muy grandes !!!!!!!!!ª

  • Paulo Rocha (May 21, 2019)

    I read "The Definitive Guide to DAX", "Analyzing Data with Power BI and Power Pivot for Excel", attended "Mastering DAX Workshop" with Alberto, "Mastering DAX Videocourse", and the full "Data Modeling for Power BI". All content produced by SQLBI is excellent. I did this intro course as a recap and still learned new insights! Keep up the good work Maestros!

  • Norman Ocampo (May 20, 2019)

    Very great intro course to those starting to Data Modeling.

  • Evelin Yasmyn Padilla Sulca (May 20, 2019)

    Very interesting

  • Rasitha Chathuranga (May 15, 2019)

    This introduction course was really giving fundamental but very important to know those who are working with report creation through power query , data modelling and Power BI. Thank you for providing such a introductory video course on free . We are really looking into learn more on this as we are moving with out report creations and Analytics.

  • Guilherme Maciel (May 15, 2019)

    Marco Russo is the God of Power BI. This is a perfect Data Modeling Intro Course! Going to recommend it to all my colleagues.