Summary
Keywords
Full Transcript
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
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
