⭐ STAR SCHEMA and Data Modeling in Power BI
In this video, learn what star schema is, what are fact & dimension tables and about many to one relationships. You will also learn the difference between star and snow-flake schemas and know how to set up a star schema in Power BI using the data modeling feature.
Please use the practice data file here - https://chandoo.org/wp/wp-content/uploads/2022/04/pb-sales-data-blank-clean.xlsx to set up your own star schema data model in Power BI.
Video topics ⏱👇
===============
0:00 - What is Star Schema?
2:07 - Table relationships in Star Schema
3:25 - Snow flake vs. Star Schema
4:08 - Fact vs. Dimension Tables
4:36 - Many to One Relationship
5:46 - Setting up Star Schema in Power BI
7:01 - Understanding the relationship line in Power BI Data Model
7:42 - Connecting or making a new relationship in Power BI
💥Watch Next
============
Now that you understood Star Schema & Data Modeling, why not take your Power BI skills to next level with below videos:
Data Analysis with Power BI (40 minutes) - https://youtu.be/uwe8C7K8fXY
Power BI vs. Excel - which one should you learn (15 minutes) - https://youtu.be/nOWzpJ4gUKo
Data base vs. Data warehouse vs. Data lake (8 minutes) - https://youtu.be/WgIbvkyY4mI
Power BI getting started (40 minutes) - https://youtu.be/uwe8C7K8fXY
My full Power BI videos playlist - https://www.youtube.com/watch?v=uwe8C7K8fXY&list=PLmejDGrsgFyClheDmsfikqOt0no-TKArs
#Starschema #powerbi