Data warehouse schema design - dimensional modeling and star schema

[@stacyread8711]

This is lecture I wish my professor would have given! Thank you, Snir!

[@chenvili]

We had a course on DW last semester (in BGU) , I'm preparing for a Data Engeneering interview and I think I've learned more from this video than I did during the whole semester.

[@snirdavid-dev8982]

Wow. Thank you. It is worth everything to me.

[@chenvili]

@@snirdavid-dev8982 Just so you know, I got the job!
I own most of it to you!

[@yehuda4904]

very nice and more practical then what they show in class, Amazing !!!!

[@jacksonmay153]

i crammed this right before my data engineer interview thanks!!!! Everything you covered here was asked in some ways.

[@yasithudawatte8924]

Thanks you. Well explained with appropriate examples. Keep up the good work.

[@paddywhack]

Thanks, Snir. You covered a lot of ground in 30 minutes....but everything was clearly explained.

[@nomad7317]

Great Video! Thank you so much! Taught me so much more than my university

[@baroktollossa4218]

This was an amazing video. Thank you for the content!

[@conradblume4274]

Excellent, thank you for taking the time to make this video!!

[@kevinliu9668]

Well explain video with easy understanding examples. Thanks!

[@Alexmontoyaangel]

Thank you for the lecture.
I am so confused; Dimensional modelling, Kimball modelling and Star scheme are the same or they have differences ?

[@chayanshrangraj4718]

Hi, Thank you for the amazing video! Really insightful! I was wondering about one thing you mentioned in OLTP section about data being inconsistent. Aren't ACID properties used for that purpose so that data is always consistent in OLTP? Let me know what do you think.

[@vochau9806]

Could you make a demonstration in SSIS? Thank you a lot

[@tobyroy336]

this was really informative. Thank you so much

[@0x1f8b]

Thanks for the excellent video!
With the advent of columnar database, power BI, tableau, are there any changes required in modelling techniques?

[@antoninachernyshova4666]

Thank you for the great video!

[@hydtechietalks3607]

Thanks for the refresh!

[@chaosinorderrr]

Great video. One question: can you go the OLAP route and use that to design the schema for your primary data store for your application?

[@lanreade3562]

OLTP is a relational system for day to day transaction.. I will say Bill Inmon normalization is the best method.

[@blerdijankoliqi3994]

Such a great video! Helped me with my exam so much!

[@filetiktok9794]

Do fact table need primary key?

[@ericka.montanez6821]

Very insightful. Thank you!

[@raunaqkoppikar1986]

Awesome video... you covered many useful concepts in a clear and concise manner... Thank you 👍

[@divyne_]

Great tutorial

[@vamsikrish7406]

It is very much informational ! Thank You !

[@zxcase0]

Great explanation! Thank you!

[@antonkostov1691]

Good job! You are good.

[@Agx21111]

Very nice dude, ty for y our help

[@vasudevareddysudireddy8860]

Super bro 👍👍👍

[@QueenaJami]

Thank you!!!

[@rabanchikwanha5612]

thanks for the information, its good

[@TheBansalvikas]

Are you Walter White Jr. ?

[@Rami_Elkady]

Spin up an IDE and actually do something man ...