Data Mart Design - Populate Dimensions and Fact Tables

This demonstrates the ETL process involved in populating the Crime Data Mart Dimensions and Fact Tables.

[poptrt]

Thank you so much, I looked for just this kind of walkthrough, tutorial on this subject; you spoke so clearly and directly and stayed on topic that it was easy to follow. Thanks again, great job, I like the usage of staging tables I use that alot as well!!

[philippr.]

Great Job on this video I am trained at SSMS, SSIS and SSAS seperately but putting it all together to get a DW from a source was a missing link for me. Keep up the great work :-)

[arturobrunocm]

Thank you for all the information shared, I’ve just finished the course project. Thanks!!

[jesflo]

Very clear and straightfoward, thank you for sharing your knowledge!

[ronaldmudenyo]

Best video ever. You just helped me complete my project. Thanks for the video

[Jackie.]

Best tutorial of data marts in youtube

[pedrobarrocas]

You are the man, thank you so much! You are saving Panda Jardins

[jahangirkabir]

Great video! thank you. Please continue uploading.

[abrammakgalemele]

Tx Clinton.
You are super!
Spot on like Clint Eastwood's shooting!

[JanUnitra]

is it a good way of doing warehousing ? I always hear that the staging should be raw, no calculation, no changing etc. but you added surrogate keys ?

[godfreynyirenda]

Thanks Clint, very well explained. Do you have follow up videos on multi dimensional analysis?

[sandipbaidya]

I really enjoyed watching this video ::)

[chamathhasthuka]

Thank you Sir. Could you please update more videos. And one suggestion please create playlists

[ericsos]

Such a wonderful project approach on data mart.Can you please share the dataset because i would love to follow through on hand on ...it will be much appreciated./.Thx again in advance

[sandeeppai]

Hi, thanks for the tutorials. Can we include business logic or calculation in ETL while loading data from staging to fact ?

[datafreak]

Thanks for this nice video, would you do another one for how to do this project from beginning

[quinnhogan]

Hello, great video. I know it's been a while, but can you perhaps speak on how you would take your data from a staging db and insert it into your fact table after all your dimensions are built, but this time you do not have any IDs for the dimensions in your staging table?

[learnenglishwithcumaali]

Why would you keep all the values in a single FactTable? Is not a FactTable suppose to keep only agg values in order to limit the storage and the cots of DWH?

[jitenderreddy]

Hey Daniel !! Its a nice video can you please share the Database and queries to practice.

[timovskyt]

Thank you, helped a lot, very grateful, any videos on updating the fact table through querying in siss. Eg example if you were to add to the datawarehouse a new dataset and had to insert new fields into the fact table and then update that in visual studio. Is this difficult?