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

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:
=============

💻 Paid courses to help you:
=======================

~

#powerbi #datamodeling #chandoo #freedataanalystcourse #fdac

[deepikaanjali]

00:06 Data modeling and Star Schema setup in Power BI
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

[jetwheels]

Chandoo I am your student from Pakistan Loved your content, because of you I got the job thank you so much.

[masabwajid]

Explanation of many to one was so crisp. I have completed the paid series of power BI from a different coach but the way you explained is just awesome .. salute to you Sir
I am your subscriber after watching just one of your video.

[nematullorahmatov]

I found you one of the best expert in Data Analytics field!

[teryn]

Oh my goly. you are a powerBi guru! im new and this is so easy to digest, finding how obscure functions really works is a great help, especially for a new guy, , , thank you!

[Rostaman]

Chandoo. You are God Tier level when it comes to explaining complex concepts. I am a novice/semi-pro level and still learned so much from every one of your videos. Thank you for taking the time to help your community. Cheers.

[catherinengina]

You have made data modeling easy to understand....Thank you so much.

[thinkanalyst]

Chandoo makes the data analyst role easy to understand by delivering simple, actionable insights. From Ethiopia

[rupalimurthy]

Explained in a very simple way, thank you !

[SaadKhan-ydss]

This is such a great video as it explains why star schema is so important to know the attribute behind each number when making charts

[charishmayerramsetti]

Try to take complexity data..then show the data modelling.. normal channels are showing with simple and easy data.. what is difference in your video..??

[Poultry_patrol]

You just saved from 3 hour tutorial. Thank you 🎉

[shilparani]

You explained it in very easy way to understand! Thank you!

[sumitkoshti]

Chandoo always come up with simple and spot on content. Thank you for making data analyst role easy to understand

[CuriousJo]

Thank you again!!! Truly love your teaching style!

[rakeshverma]

Crisp and beautifully explained. I love the way Chando has explained the concept.

[Chrisdb]

Thank you for your crisp and simple explanation of modelling.

[AnandhAdhithan]

Clear explanation with good examples thanks for the wonderful video ❤

[zakymbalire]

Thank you for this! Really easy to understand and follow along.

[shambavivusirikala]

Thanku chandoo...u are my guru for power bi