Learn Data Modelling & Star Schema for Power BI in 20 minutes @chandoo_
Learn Data Modelling & Star Schema for Power BI in 20 minutes  @chandoo_
Uploaded October 2024 | Updated November 2026, 3 hours ago
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) - chandoo.org/wp/wp-content/uploads/2024/10/sample-chocolate-sales-data-all.xlsx

Completed Data Model Power BI workbook and other resources - chandoo.org/wp/free-data-analyst-course

Free 14-week Data Analyst Course - chandoo.org/wp/free-data-analyst-course

πŸ’» Paid courses to help you:
=======================

Modern Data Analyst Course - chandoo.org/mdac (Power BI, SQL, Excel, Python & AI)
Power BI course - chandoo.org/wp/power-bi-course
Excel course - chandoo.org/wp/excel-school-program


~


#powerbi #datamodeling #chandoo #freedataanalystcourse #fdac
Learn Data Modelling & Star Schema for Power BI in 20 minutesHR Data Analytics & Awesome Dashboard with Power BI πŸ’‘: End-to-End ProjectPower BI got a MAJOR upgrade - This changes everything!How to pick the perfect chart for your situation in Power BI?WRAPROWS in Excel - a must have functionPower BI Jargon Buster - 25 More Buzzwords explained in 15 minutesThis Excel Formula Shows Stock Prices Instantly!Complete Excel Tutorial for Data Analysis in 4 Hours (with FREE Files)COUNTIFS with Date Between - This is a must have formulaExcel VBA Macros - Beginner to PRO Masterclass with Code SamplesMake an AWESOME Employee Dashboard with Power BI (Adv. DAX)Second Week Sales Only with SUMIFS (Excel formula)
Chandoo |

Learn Data Modelling & Star Schema for Power BI in 20 minutes

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER