Why we need a date dimension Power BI

Опубликовано: 31 Август 2021
на канале: Learn 2 Excel
1,632
12

Published on Aug 31, 2021:
In this video, we will discuss why we need a date dimension in Power BI.
1. Improved model performance
2. Minimise data model size
3. DAX code maintanability

In the previous video, we learnt to join two fact tables using a common dimension table in Power BI.

Previous Video:   • Join Two Fact Tables using a common d...  

SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!
   / @learnexcelrelentless  


Download M Query code:
http://bit.ly/3kJwUUq


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


ABOUT DAGDOO:
Website:
Home Page: http://www.dagdoo.org/
Power BI Tutorials: http://www.dagdoo.org/excel-learning/...


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

Twitter: @dagdooe

Category: Science & Technology
License: Standard YouTube License