Learn Data Modelling & Star Schema for Power BI in 20 minutes
Chandoo
326,654 views
Data modeling, semantic modeling, star schema and how to make one in Power BI - all explained neatly and clearly in this video.
In this video learn about data modeling in Power BI, using a fictional chocolate company as an example. It explains the importance of setting up a star schema, which involves organizing data into fact and dimension tables. I also cover the process of importing data into Power BI, establishing relationships between tables, and creating visualizations to analyze the data.
💡 What you will learn:
==================
◉ What is Data Modelling:
◉ Data modelling with a real-world example
◉ Fact vs. Dimension table
◉ How to set up relationships in Power BI?
◉ Types of relationships
◉ What does the "arrow" mean in the semantic model? (filter propagation)
◉ Importance of "correct" data modelling
⏱ Video timestamps:
==================
0:00 - Introduction to Data Modeling (or Semantic Modeling)
0:43 - Sample dataset and the tables
2:18 - Data model for Awesome Chocolates business 🍫 (fact vs. dimension, star schema)
9:40 - Loading data into Power BI
11:50 - Creating the semantic (data) model in Power BI
15:35 - What is filter direction & filter propagation in Power BI?
18:08 - Evaluation context explained with data model
20:19 - The importance of "proper" data modeling
21:32 - In conclusion
📁 Sample files:
=============
Awesome chocolates dataset (Excel file) - https://chandoo.org/wp/wp-content/upl...
Completed Data Model Power BI workbook and other resources - https://chandoo.org/wp/free-data-anal...
Free 14-week Data Analyst Course - https://chandoo.org/wp/free-data-anal...
💻 Paid courses to help you:
=======================
Modern Data Analyst Course - https://chandoo.org/mdac (Power BI, SQL, Excel, Python & AI)
Power BI course - https://chandoo.org/wp/power-bi-course/
Excel course - https://chandoo.org/wp/excel-school-p...
~
#powerbi #datamodeling #chandoo #freedataanalystcourse #fdac
20 Comments
I am your subscriber after watching just one of your video.
02:34 Understanding fact and dimension tables in data modeling.
05:11 Understanding many-to-one relationships in data modeling
07:34 Understanding Fact Tables and Dimension Tables in Data Modeling
09:56 Data may not always be neatly available in one file, might have to connect to different systems for different parts.
12:08 Connecting tables and setting up a star schema in Power BI
14:19 Managing relationships in Power BI for data modeling.
16:41 Data Modeling involves semantic modeling for creating measures and role-based access.
18:50 Slicers in Power BI limit data displayed based on selections
20:55 Importance of correct data modeling for accurate calculations
Really want you to be successful and grow. Hopefully will see the 1M subscribers on your channel soon. Stay blessed Chandoo ❤
Learn Data Modelling & Star Schema for Power BI in 20 minutes
Chandoo
326,654 views
Data modeling, semantic modeling, star schema and how to make one in Power BI - all explained neatly and clearly in this video.
In this video learn about data modeling in Power BI, using a fictional chocolate company as an example. It explains the importance of setting up a star schema, which involves organizing data into fact and dimension tables. I also cover the process of importing data into Power BI, establishing relationships between tables, and creating visualizations to analyze the data.
💡 What you will learn:
==================
◉ What is Data Modelling:
◉ Data modelling with a real-world example
◉ Fact vs. Dimension table
◉ How to set up relationships in Power BI?
◉ Types of relationships
◉ What does the "arrow" mean in the semantic model? (filter propagation)
◉ Importance of "correct" data modelling
⏱ Video timestamps:
==================
0:00 - Introduction to Data Modeling (or Semantic Modeling)
0:43 - Sample dataset and the tables
2:18 - Data model for Awesome Chocolates business 🍫 (fact vs. dimension, star schema)
9:40 - Loading data into Power BI
11:50 - Creating the semantic (data) model in Power BI
15:35 - What is filter direction & filter propagation in Power BI?
18:08 - Evaluation context explained with data model
20:19 - The importance of "proper" data modeling
21:32 - In conclusion
📁 Sample files:
=============
Awesome chocolates dataset (Excel file) - https://chandoo.org/wp/wp-content/upl...
Completed Data Model Power BI workbook and other resources - https://chandoo.org/wp/free-data-anal...
Free 14-week Data Analyst Course - https://chandoo.org/wp/free-data-anal...
💻 Paid courses to help you:
=======================
Modern Data Analyst Course - https://chandoo.org/mdac (Power BI, SQL, Excel, Python & AI)
Power BI course - https://chandoo.org/wp/power-bi-course/
Excel course - https://chandoo.org/wp/excel-school-p...
~
#powerbi #datamodeling #chandoo #freedataanalystcourse #fdac