Slowly Changing Dimensions in Power BI
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.
Resources (worked examples, datasets etc) are at https://bit.ly/33zWQtp in the 'Slowly Changing Dimensions' folder.
We run a full range of data analysis and generative AI courses in London and online. See our courses at zomalex.co.uk