What is SCD / Slowly Changing Dimension | Data Warehouse Tutorial | Data Warehouse Concepts (14/30)
HTML-код
- Опубликовано: 18 окт 2024
- 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 ✉ : analyticswithnags@gmail.com
💬 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
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
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.
Mostly its the ask from the business to maintain the history.
Thanks Nags for This playlist, Please upload implementation part also
Watch the End to End DW implementation video. Which is in End to End playlist
Thanks eagerly waiting for implementation part ...
Very soon, Noted, Thanks.
Please make video on ssis ,so we will undersatnd scd model better,thanks sir making a video and clear concept.
Noted, will try to bring in future.
@@AnalyticswithNags thanks sir
great video.. are there any videos in the playlist there is only 16...
Will upload soon
@@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?
pls upload the full playlist@@AnalyticswithNags
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
Made an not of it , Keep watching this channel, will do it in future.
finished watching
thanks , keep learning
plz provide us video for surrogate key. thanks in advance
Its already uploaded , you can check the channel's uploaded videos.
pls share the implementation part soon :)
yeah sure i will
Need to watch it again hahhaah . Not clear
Stop watching from the channel
Little bit of confusion in datekey part