Data warehouse schema design - dimensional modeling and star schema

A tech talk introducing the concepts of dimensional modeling for data warehouse design.
Covering:
- OLTP vs OLAP
- Star schema
- Dimensions
- Facts
- Surrogate keys
- Dimension grain
- Slowly changing dimensions
Visit my site:
snir.dev
Snir David

[@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!

[@conradblume4274]

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

[@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.

[@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

[@yasithudawatte8924]

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

[@blerdijankoliqi3994]

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

[@raunaqkoppikar1986]

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

[@ericka.montanez6821]

Very insightful. Thank you!

[@vamsikrish7406]

It is very much informational ! Thank You !

[@zxcase0]

Great explanation! Thank you!

[@baroktollossa4218]

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

[@gabrielevangelista2199]

What an awesome video, Very clear and concise

[@hydtechietalks3607]

Thanks for the refresh!

[@kevinliu9668]

Well explain video with easy understanding examples. Thanks!

[@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?

[@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!

[@tobyroy336]

this was really informative. Thank you so much

[@Agx21111]

Very nice dude, ty for y our help

[@QueenaJami]

Thank you!!!

[@Alexmontoyaangel]

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

[@antonkostov1691]

Good job! You are good.

[@divyne_]

Great tutorial

[@vasudevareddysudireddy8860]

Super bro 👍👍👍

[@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.

[@filetiktok9794]

Do fact table need primary key?

[@lanreade3562]

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

[@vochau9806]

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

[@rabanchikwanha5612]

thanks for the information, its good

[@TheBansalvikas]

Are you Walter White Jr. ?

[@ramielkady938]

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