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
5-star Reviews (653 of 754)
Julianna Weldon (Jun 11, 2021) I LOVE the auto-scrolling highlighted captions, it makes it so easy to follow along!
Lucas Leal (Jun 7, 2021) Great explanation about data modeling!
Mohit Anshuman (Jun 6, 2021) A very good introductory course, thank you.
Domingos Liao (Jun 4, 2021) Great intro, easy to follow, engaging presenter.
Jane Hobden (May 30, 2021) Thanks for a great introductory course!
mohammad murtuza (May 28, 2021) Such a great teaching like we are learning face to face and mind blowing explanation.
petros kefalas (May 24, 2021) Excellent tutorial. Thanks for the opportunity
ivan khoo (May 23, 2021) Very good course on covering the concept of data modelling scenarios
Lucas Augusto Guterres Garais (May 18, 2021) Nice course that teaches some basic concepts about data modelling and analysis.
FABIAN PEREZ LOPEZ (May 12, 2021) Excellent
Alexander Mililis (May 12, 2021) Excellent presentation, well done!
Irina Sviridova (May 8, 2021) Great introduction course with clear examples. Thank you.
Sridhar (May 8, 2021) Great Course...
Roope Rantanen (May 7, 2021) Excellent course! Easy to grasp but still has a lot of good information.
Thomas Schmidt (May 6, 2021) Amazingly great!!!
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
A team management dashboard is available if you choose to assign this course after the purchase or you get a transferable license.
Learn more