Published on Jul 29, 2021:
In this video, we will discuss the highly denormalised fact tables in Power BI. The impact of highly denromalised fact tables can be that the data does not filter correctly between the two facct tables as there is no common dimension joining the two fact tables.
In the previous video, we discussed how bidirectional relationships may change the values on display in visuals and cause confusion with the consumer of the report.
Previous Video: youtu.be/YC9OYdGlpP4
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
Data Modelling with Power BI: tinyurl.com/8b4srjrm
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
- Highly Denormalised Fact Tables Power BI ( Download)
- Handling MULTIPLE fact tables in Power BI ( Download)
- Number of Fact tables in a data model Power BI ( Download)
- What is STAR schema | Star vs Snowflake Schema | Fact vs Dimension Table ( Download)
- The Dimensional Dilemma and Power BI ( Download)
- CREATE FACT & DIMENSION TABLES FROM A SINGLE DE-NORMALIZED TABLE ( Download)
- DP 900 — Normalized vs Denormalized Data ( Download)
- Propogating Filters between unrelated tables using TREATAS DAX Power BI ( Download)
- Star schema or single table in Power BI ( Download)
- Normalisation vs Denormalisation Power BI ( Download)
- Header-detail vs star schema models in Tabular and Power BI ( Download)
- Data Modeling (Star Schema 🌟) in Power BI – Creating Dimension Tables ( Download)
- Data Modeling with The Star Schema in Power BI⭐ ( Download)
- Star Schema vs Snowflake Schema I Data Modelling I Data Warehousing I Schema I SQL I Power BI ( Download)
- Data Modeling Tutorial: Star Schema (aka Kimball Approach) ( Download)
