Published on Jun 16, 2021:

In this video, we will talk about how moving away from the star schema can create confusion in the data model. This can lead to active and inactive relationships in power bi.

In the previous video, we discussed the star schema:
Star schema separates business processes into:
FACT - What happened e.g. Sales
DIMENSION - Labels, Filters or Groups for what happened
Looks like a star. With Fact table in the middle and dimension tables on the side

Previous Video: youtu.be/UjlgM8Ql2To
SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!
youtube.com/channel/UCYYHFZpm5GbaOmQKDNSTGLw

Download M Query code:
bit.ly/3kJwUUq

Our Playists:
Extract Load and Transform data using Power Query: bit.ly/3orLRf4
Enhance Power BI Data model using DAX: bit.ly/2GbTENc
Python and Power BI: bit.ly/2EajdNc
Getting Started with AWS: bit.ly/2PgSCQX
SQL Playlist : goo.gl/PS5Ep6
DAX PlayList : goo.gl/S4W41D
Power BI PlayList: goo.gl/dXxvnB
Power Query Playlist: goo.gl/5QS7P4
Getting Started with Power BI: goo.gl/GHakLZ
Getting Started with Python: goo.gl/n24P3w
Data Science With Python: goo.gl/PeYCR5
Power BI service: tiny.cc/sjekmz

ABOUT DAGDOO:
Website:
Home Page: dagdoo.org/
Power BI Tutorials: dagdoo.org/excel-learning/tutorial-power-bi-desktop/

Questions? Comments and SUGESTIONS? You will find me here:

Twitter: @dagdooe

Category: Science & Technology
License: Standard YouTube License

• Active relationship and star schema Power BI ( Download)
• Understanding Relationships in Power BI // Beginners Guide to Power BI in 2021 ( Download)
• Learn Data Modelling & Star Schema for Power BI in 20 minutes ( Download)
• Active and Inactive Relationship in Power BI ( Download)
• How to solve Inactive Relationship Problem with Role Playing Dimensions in Power BI ( Download)
• 4.8 Managing Active vs Inactive Relationships | Relationships & Data Models | Learn Power BI 2022 ( Download)
• Power BI star schemas and best practice data modelling ( Download)
• Data Modeling for Power BI [Full Course] 📊 ( Download)
• 9.2 Data Modeling Part 1 (Active Vs Inactive Relationship) ( Download)
• Power BI Modelling- Part 4 | Active Inactive Relationship| Factless Fact Table| PBI Tutorial (46/50) ( Download)
• Complete Guide to Create Data Models & Table Relationships | Power BI ( Download)
• How to create model relationships in Power BI | DP-600 Ep16 #dp600 #microsoftfabric #powerbi #data ( Download)
• How to model data in Power BI (Star vs Snowflake schema) ( Download)
• How to Create and Manage Relationships in Power BI | Microsoft Power BI for Beginners ( Download)
• Star Schema Power BI ( Download)