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.

[@raunaqkoppikar1986]

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

[@vamsikrish7406]

It is very much informational ! Thank You !

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

[@ericka.montanez6821]

Very insightful. Thank you!

[@paddywhack]

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

[@zxcase0]

Great explanation! Thank you!

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

[@gabrielevangelista2199]

What an awesome video, Very clear and concise

[@kevinliu9668]

Well explain video with easy understanding examples. Thanks!

[@hydtechietalks3607]

Thanks for the refresh!

[@tobyroy336]

this was really informative. Thank you so much

[@antoninachernyshova4666]

Thank you for the great video!

[@Agx21111]

Very nice dude, ty for y our help

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

[@antonkostov1691]

Good job! You are good.

[@QueenaJami]

Thank you!!!

[@divyne_]

Great tutorial

[@Alexmontoyaangel]

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

[@vasudevareddysudireddy8860]

Super bro 👍👍👍

[@filetiktok9794]

Do fact table need primary key?

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

[@rabanchikwanha5612]

thanks for the information, its good

[@lanreade3562]

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

[@TheBansalvikas]

Are you Walter White Jr. ?

[@ramielkady938]

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