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.
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
Student Rating
4-star Reviews (54 of 672)
Robin Neven (Oct 17, 2019) Well explained summary of some of the data modeling issues you might run into with Power BI or Analysis Services!
Michael Nishimura (Oct 5, 2019) Overall, very good. I learned a lot. Star Schema makes sense and examples how to manage around multiple fact tables is helpful.
Thanks!
Benjamin Kormos (Oct 5, 2019) It was great and clear, though the layout of the tables in presentation slides should be the same as in the PBI files for more clarity.
André Pinheiro (Jul 8, 2019) Pretty good for beginners.
Helmar Träger (Jul 8, 2019) Very interesting and presented in an easy to understand why though the subjects are a bit difficult
Heike Holubek (May 14, 2019) good introduction, mostly easy to follow
fatima Essahibi (Apr 23, 2019) thank you for this great introduction
harm bons (Apr 15, 2019) Nice introduction in relation to data modeling!
Lucas Silva (Mar 28, 2019) Very Good!
What is included
This video course contains 108 minutes of training, for a total of 27 lectures.
Our training platform tracks your progress and resumes the course from where you left off.
The videos are hosted by SQLBI on vimeo.com – if you are in a country that blocks access to this platform, you will need a VPN to watch the videos.
You can download all the exclusive content produced by our trainers for this video course, including all the examples and the exercises. Take a look at the curriculum for more details.
In this video course both our senior trainers are in front of the camera. The conversational style allows for more entertaining lectures, and it answers the most common questions on the topics covered.
After completing all the lectures in this video course,
you will be able to download a certificate of completion in PDF format from your student dashboard.
Training Platform
Along with subtitles, you can view a transcript of the content of each lecture in different languages.
The transcripts are synchronized with the video and you can easily jump from one segment to another.
Learn more
Save the most interesting lectures for future use and easy access with bookmarks.
Press the marker button in every lecture and check the Bookmarks tab.
Learn more
You can highlight segments of the video transcripts, like you would with a printed book. Highlights are automatically saved and quickly accessible from your Bookmarks tab.
Learn more
In every section of this course, you will find an easy way to start a discussion about a topic relevant to the course.
Our team usually replies within a few hours!
Learn more