No video

Data warehouse schema design - dimensional modeling and star schema

  Рет қаралды 59,805

Snir David - dev

Snir David - dev

Күн бұрын

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

Пікірлер: 35
@stacyread8711
@stacyread8711 Жыл бұрын
This is lecture I wish my professor would have given! Thank you, Snir!
@chenvili
@chenvili 2 жыл бұрын
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
@snirdavid-dev8982 Жыл бұрын
Wow. Thank you. It is worth everything to me.
@chenvili
@chenvili Жыл бұрын
@@snirdavid-dev8982 Just so you know, I got the job! I own most of it to you!
@yehuda4904
@yehuda4904 2 жыл бұрын
very nice and more practical then what they show in class, Amazing !!!!
@paddywhack
@paddywhack 3 жыл бұрын
Thanks, Snir. You covered a lot of ground in 30 minutes....but everything was clearly explained.
@jacksonmay153
@jacksonmay153 2 жыл бұрын
i crammed this right before my data engineer interview thanks!!!! Everything you covered here was asked in some ways.
@yasithudawatte8924
@yasithudawatte8924 Жыл бұрын
Thanks you. Well explained with appropriate examples. Keep up the good work.
@nomad7317
@nomad7317 2 жыл бұрын
Great Video! Thank you so much! Taught me so much more than my university
@kevinliu9668
@kevinliu9668 2 жыл бұрын
Well explain video with easy understanding examples. Thanks!
@conradblume4274
@conradblume4274 3 жыл бұрын
Excellent, thank you for taking the time to make this video!!
@baroktollossa4218
@baroktollossa4218 Жыл бұрын
This was an amazing video. Thank you for the content!
@tobyroy336
@tobyroy336 2 жыл бұрын
this was really informative. Thank you so much
@hydtechietalks3607
@hydtechietalks3607 2 жыл бұрын
Thanks for the refresh!
@raunaqkoppikar1986
@raunaqkoppikar1986 2 жыл бұрын
Awesome video... you covered many useful concepts in a clear and concise manner... Thank you 👍
@antoninachernyshova4666
@antoninachernyshova4666 Жыл бұрын
Thank you for the great video!
@Alexmontoyaangel
@Alexmontoyaangel 2 жыл бұрын
Thank you for the lecture. I am so confused; Dimensional modelling, Kimball modelling and Star scheme are the same or they have differences ?
@ericka.montanez6821
@ericka.montanez6821 2 жыл бұрын
Very insightful. Thank you!
@blerdijankoliqi3994
@blerdijankoliqi3994 3 жыл бұрын
Such a great video! Helped me with my exam so much!
@chayanshrangraj4718
@chayanshrangraj4718 9 ай бұрын
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.
@divyne_
@divyne_ Жыл бұрын
Great tutorial
@vamsikrish7406
@vamsikrish7406 4 жыл бұрын
It is very much informational ! Thank You !
@chaosinorderrr
@chaosinorderrr 3 жыл бұрын
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?
@antonkostov1691
@antonkostov1691 2 жыл бұрын
Good job! You are good.
@lanreade3562
@lanreade3562 2 жыл бұрын
OLTP is a relational system for day to day transaction.. I will say Bill Inmon normalization is the best method.
@0x1f8b
@0x1f8b 3 жыл бұрын
Thanks for the excellent video! With the advent of columnar database, power BI, tableau, are there any changes required in modelling techniques?
@zxcase0
@zxcase0 3 жыл бұрын
Great explanation! Thank you!
@Agx21111
@Agx21111 3 жыл бұрын
Very nice dude, ty for y our help
@vochau9806
@vochau9806 Жыл бұрын
Could you make a demonstration in SSIS? Thank you a lot
@vasudevareddysudireddy8860
@vasudevareddysudireddy8860 2 жыл бұрын
Super bro 👍👍👍
@QueenaJami
@QueenaJami 2 жыл бұрын
Thank you!!!
@filetiktok9794
@filetiktok9794 2 жыл бұрын
Do fact table need primary key?
@rabanchikwanha5612
@rabanchikwanha5612 3 жыл бұрын
thanks for the information, its good
@TheBansalvikas
@TheBansalvikas 3 жыл бұрын
Are you Walter White Jr. ?
@ramielkady938
@ramielkady938 Жыл бұрын
Spin up an IDE and actually do something man ...
Dimensional Modeling
53:54
Bryan Cafferky
Рет қаралды 166 М.
Data Modeling Tutorial: Star Schema (aka Kimball Approach)
16:34
Kahan Data Solutions
Рет қаралды 105 М.
Logo Matching Challenge with Alfredo Larin Family! 👍
00:36
BigSchool
Рет қаралды 7 МЛН
Design a Data Warehouse | System Design
14:08
Interview Pen
Рет қаралды 20 М.
Dimensional Modeling - Declaring Dimensions
55:32
Pragmatic Works
Рет қаралды 24 М.
Building an Enterprise Data Warehouse
21:20
James Oliver
Рет қаралды 28 М.
Which Database Model to Choose?
24:38
High-Performance Programming
Рет қаралды 50 М.
Building a Data Warehouse from the Ground Up
1:20:45
South Florida Data Geeks
Рет қаралды 8 М.