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/uploads/2024/10/sample-chocolate-sales-data-all.xlsx
Completed Data Model Power BI workbook and other resources - https://chandoo.org/wp/free-data-analyst-course/
Free 14-week Data Analyst Course - https://chandoo.org/wp/free-data-analyst-course/
💻 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-program/
~
#powerbi #datamodeling #chandoo #freedataanalystcourse #fdac
53.320 Lượt nghe
Video
