What is SCD / Slowly Changing Dimension | Data Warehouse Tutorial | Data Warehouse Concepts (14/30)

What is Slowly Changing Dimension
What is SCD
Different Types of SCD
What is SCD 1 , SCD 2, SCD 3
Advantages of Using SCD
Why we need to implement Slowly changing Dimension (SCD)
#DWBI #DatawarehouseTutorials
✉ Business Queries / Analytics Consulting ✉ : [e-mail]
💬 For Learners Post queries and Interact 💬 : t.me/analyticsw...
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Data Warehouse Tutorials 📚📖 • Introduction | Data Wa...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
SSIS Tutorials - SQL Server Integration Services 📚📖 • Introduction to SQL Se...
Power BI Interview Topics 📚📖 • What to Expect in Powe...
MSBI (SSIS,SSAS,SSRS) Interview Topics 📚📖 • What to Expect in MSBI...
Excel for Data Analysis 📚📖 • Analytics with Nags Yo...
Power BI + R 📚📖 • Analytics with Nags Yo...
Catch with Nags 📚📖 • Catch Up With Nags - I...
Nags Checklist 📚📖 • 5 Things to Consider w...
Visuals with Nags 📚📖 • Visuals With Nags - Intro

[@moeeljawad5361]

Hello Nag, do you have a practical example on how to deal with SCD Type 2 in power BI? if not do you have any recommendations about this topic.
Thanks

[@vivekpuurkayastha1580]

Thanks eagerly waiting for implementation part ...

[@AnalyticswithNags]

Very soon, Noted, Thanks.

[@kishanbhise4733]

Thanks Nags for This playlist, Please upload implementation part also

[@AnalyticswithNags]

Watch the End to End DW implementation video. Which is in End to End playlist

[@rajapeter6076]

Thanks Nag for this explanation...will the SCD a basic principle in Dimension modelling, or a ask from the business to preserve the historical attribute change like the one you have shown.

[@AnalyticswithNags]

Mostly its the ask from the business to maintain the history.

[@sandipansarkar9211]

finished watching

[@AnalyticswithNags]

thanks , keep learning

[@priyar1165]

Hi sir pls make a video on how daily data will be processed and archived in real time. Staging tables concept archiving files and also tables pls

[@AnalyticswithNags]

Made an not of it , Keep watching this channel, will do it in future.

[@raviranjansingh5527]

Please make video on ssis ,so we will undersatnd scd model better,thanks sir making a video and clear concept.

[@AnalyticswithNags]

Noted, will try to bring in future.

[@raviranjansingh5527]

@@AnalyticswithNags thanks sir

[@rajapeter6076]

pls share the implementation part soon :)

[@AnalyticswithNags]

yeah sure i will

[@ashokatechtalk6307]

plz provide us video for surrogate key. thanks in advance

[@AnalyticswithNags]

Its already uploaded , you can check the channel's uploaded videos.

[@javedabdool1187]

great video.. are there any videos in the playlist there is only 16...

[@AnalyticswithNags]

Will upload soon

[@javedabdool1187]

@@AnalyticswithNags hello nags do you have a specific tutorial where you have tables in oltp and like you design the datawarehouse according to the oltp? or have i missed something?

[@sivadamisetti4994]

pls upload the full playlist@@AnalyticswithNags

[@shafa7668]

Need to watch it again hahhaah . Not clear

[@AnalyticswithNags]

Stop watching from the channel

[@sasidharreddykomatla3006]

Little bit of confusion in datekey part