Implementing Slowly Changing Dimensions Type 2 (SCD2) with Power Query
Вставка
- Опубліковано 11 вер 2024
- Session Name:
Tracking changes over time using Slowly Changing Dimensions in Power Query
Session Details:
Tracking changes over time is often a specific request by the Business for historical analysis, therefore the Data Model (built either in PowerPivot in Excel, SSAS Tabular or PowerBI) needs to be designed in a very specific way in order to facilitate that.
One of the most critical ETL tasks in tracking the history of dimension records are Slowly Changing Dimensions (SCD) which basically are dimensions that stores and manages both current AND historical data over time, containing relatively static data which can change slowly but unpredictably, rather than according to a regular schedule.
There are several types of SCDs and they are considered depending on the analytical needs, some examples of typical slowly changing dimensions being entities as names of geographical locations, customers or products.
This session aims to show how to implement a SCD Type 2 using Power Query allowing full history analysis of a specific dimension.
Speaker:
Cristian Angyal, MCSE, MCT
Cristian is a “Project Management Professional turned into a Data Guy” as he self-describes himself, working as a link between two worlds: Business and IT.
Having worked for the last 15+ years with data in different roles he was fascinated when he discovered Power Query and Power Pivot back in 2014 and then, Power BI in 2015.
Ever since he learned about the POWER tools he realized that these tools, with the ability to “learn them once and used them in multiple places”, could make a huge difference in the way Data is managed inside organizations.
He’s holding several Microsoft Certifications (MCSE Data Management and Analytics, MCSA BI Reporting, MOS Master, Excel Expert, Trainer (MCT), Power BI Certified Data Analyst, etc) and he loves getting insights from data and then, using these insight solving real business problems.
Social Media / Website Links
LinkedIn: / cristian-angyal
UA-cam: / ssbicentral
Twitter: / cristian_angyal
Meetup: www.meetup.com...
Cristian, do you have the sample worksheets available to reproduce while watching this webinar? It would be very helpful to see the work "right in front of me" while learning the processes you are teaching in the webinar. Thank you. Mark P. Minnesota, USA
Thanks! A good example for full refresh. Incremental Refresh might be more difficult? Say, if the Product keys change for Products in past. But now that I watch to the end, the keys with meaning might fix that.