Coming from a coding background and just getting into data you do an amazing job of making all the content so easily understandable and relatable. Seriously good.
I have not used Data Vault but from what I have read it seems unnecessarily complex. See this great video that explains this really well. ua-cam.com/video/RNMoWnSWcTo/v-deo.html
Thanks for the information.. this was very helpful in building dim and facts for my projects.. still I'm confused on certain fields like delinquent days, next payment date and some date related fields.. where these fits?
@@shanaebrown1563 Good idea. I was thinking of using the OLTP AdventureWorks database and creating the Dimensional Model and DW from that. There is a DW version of the AW database already but I don't think it is very good so this would be a walk through as if the DW did not exist. Make sense?
@@BryanCafferky I think the main thing for me is that I know the concepts but after building the dimensional tables I am a bit loss on how to integrate them in the fact table using queries, so this would be really great.
Coming from a coding background and just getting into data you do an amazing job of making all the content so easily understandable and relatable. Seriously good.
i appriciate your work alot. keep the series going
Thanks!
Thank you so much for this. I am already looking forward to the next video on this series. I love the series.
Hello, I like that series. Please keep going.
Loving this information its so great as someone who is in a small business breaking through to BI work. Look forward to more
Looking forward to the next video! Please continue it :)
Great Video Bryan! First class tutorial
Thank You!
Kudos! God bless. Salam from Kazakhstan
I hope this playlist is completed.
love this series. please make a video about Data Vault modeling techniques. Much appreciate it.🥰
I have not used Data Vault but from what I have read it seems unnecessarily complex. See this great video that explains this really well. ua-cam.com/video/RNMoWnSWcTo/v-deo.html
very informative! Keep up good work please!
Thanks
Thanks for the information.. this was very helpful in building dim and facts for my projects.. still I'm confused on certain fields like delinquent days, next payment date and some date related fields.. where these fits?
Quantitative fields like delinquent days are probably facts. Dates are almost always dimensions. Hope that helps. Thanks for watching.
Can you do a more practical example
What are you thinking of?
@@BryanCafferky like getting a dataset then start creating the facts and dimensions from it using microsoft sql server.
@@shanaebrown1563 Good idea. I was thinking of using the OLTP AdventureWorks database and creating the Dimensional Model and DW from that. There is a DW version of the AW database already but I don't think it is very good so this would be a walk through as if the DW did not exist. Make sense?
@@BryanCafferky I think the main thing for me is that I know the concepts but after building the dimensional tables I am a bit loss on how to integrate them in the fact table using queries, so this would be really great.