12
Dealing with More Advanced Data Warehousing Concepts in Power BI
In the previous 11 chapters, we learned about various aspects of data modeling to model many different scenarios. This chapter focuses on implementing more advanced data warehousing concepts in Power BI, which become handy in more complex real-world scenarios. This chapter covers the following areas:
- Dealing with slowly changing dimensions (SCDs)
- Dealing with degenerate dimensions
Dealing with SCDs
The term slowly changing dimensions, or in short, SCD, is a data warehousing concept introduced by the amazing Ralph Kimball. You can learn more about Ralph Kimball here: https://www.kimballgroup.com/about-kimball-group/.
The SCD concept deals with moving a specific dataset from ...
Get Expert Data Modeling with Power BI - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
