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
Student Reviews (714)
marco minervino (Jul 16, 2020) fantastic and extremely useful course!
clear explanations and with many points of reflection
EDUARD JOEL PRADO ROJAS (Jul 15, 2020) EXCELENTE
Claudia Borges Fernandes (Jul 13, 2020) The Making of a New Tribe and the Remaking of the World
Mustafa Omer Al Omery (Jul 10, 2020) Great
Michael Jones (Jul 8, 2020) Amazing!
Ran Li (Jul 8, 2020) Muy buenos cursos chicos, los felicito.
Santeri Virtanen (Jul 7, 2020) This is best what happened my business intelligence career!
Federico Sierra (Jul 4, 2020) It was excellent! Thanks for sharing this course. Very clear and well explained.
Yue Li (Jul 3, 2020) Excellent!
Yue Li (Jul 2, 2020) Excellent! Hope has a glossary for terms like filter, measure, metric, relationships etc.
Abhishek Prasad (Jul 2, 2020) Awesome course for beginners and Managers who do not have idea about data modeling.
Kehinde Olugbenga Omisile (Jul 1, 2020) Super awesome
Lucas Dias (Jun 28, 2020) Amazing course!
Incredible content!
Roque Salde (Jun 23, 2020) Excellent video course, very clear examples and explanation.
Paul Brown (Jun 19, 2020) Great introduction to Data Modeling.
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