Skip to content

Data Modelling: Slowly Changing Dimensions in Power BI - Chris Barber

Photo of Mark Wilcock
Hosted By
Mark W. and Christopher B.
Data Modelling: Slowly Changing Dimensions in Power BI - Chris Barber

Details

In Power BI we frequently "slice and dice" data using dimensions. For instance, the date dimension allows us to view data by "month", "quarter" or "year". However, dimensions are often fluid; they change over time. This includes products which are slightly refined or employees who move in and out of our business and across the organisational spectrum.

During this session we will use Power BI to explore how to handle these slowly changing dimensions; a key element of the Kimball methodology.

Files downloaded to folder. Added link in meetup description. Resources (worked examples, datasets etc) are at https://bit.ly/33zWQtp in the 'Slowly Changing Dimensions' folder.

Photo of London Business Analytics Group group
London Business Analytics Group
See more events