filmov
tv
Implementing Slowly Changing Dimensions Type 2 (SCD2) with Power Query
Показать описание
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
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
0:08:15
Slowly Changing Dimensions For Data Engineers
0:25:43
SCD: Slowly changing dimensions explained with real examples
0:13:31
Working with Slowly Changing Dimensions in Power BI
0:28:55
SCD Type 1 and Type 2 using SQL | Implementation of Slowly Changing Dimensions
0:45:12
Implementing Slowly Changing Dimensions Type 2 (SCD2) with Power Query
0:00:47
Understanding Slowly Changing Dimensions - SCD Type 2 in Apache Spark #interview #question
0:25:53
Informatica Slowly Changing Dimensions --SCD2
0:23:00
Slowly Changing Dimensions made Easy with Durable Keys
5:16:43
23rd Prof K.V Thomas Endowment National Seminar On Frontiers In Materials Science | Day 2
0:21:34
Dimensional modelling: Slowly changing dimensions in depth
0:26:51
Slowly Changing Dimensions – The Ultimate Guide
0:00:59
Understanding Slowly Changing Dimension SCD in ETL under 60 Seconds #interview #question
0:11:23
Slowly Changing Dimension (SCD) : Type 2 in SQL Server | Data Engineer #sql #sql #dataengineers
0:00:12
SCD - Slowly Changing Dimensions | SQL interview questions | Data Katral
0:13:05
SCD Slowly Changing Dimension An Ultimate Guide
0:12:17
Implement SCD type 2 in data build tool (dbt) in 10 mins | Tutorial for beginners
0:04:24
SLOWLY CHANGING DIMENSION IN POWER BI | DATA MODELING WITH SLOWLY CHANGING DIMENSIONS
0:05:32
Implement SCD Type 2 (Slowly Changing Dimensions)
0:00:59
SCD Type 1 ( Slowly Changing Dimension ) #sql #sqlserver #dataengineers #azure #scdtype1
0:08:15
Slowly Changing Dimensions (SCD) Type 2 in Action
0:09:27
Implementing SCD Type 1 in SQL - The EASY Way #sql
0:36:02
17. Slowly Changing Dimension(SCD) Type 2 Using Mapping Data Flow in Azure Data Factory
0:12:35
Slowly Changing Dimensions In Data warehousing with iPhone 11 Example | SCD 1/2/3
0:48:42
SCD Type 2 implementation in Fabric Data Warehouse (Slowly Changing Dimension SCD Type 2) by taik18
Комментарии