No video

What is STAR schema | Star vs Snowflake Schema | Fact vs Dimension Table

  Рет қаралды 141,856

codebasics

codebasics

Күн бұрын

Пікірлер: 185
@montycardman2535
@montycardman2535 Жыл бұрын
i sometimes wonder how much universities would be better off if they employed the best youtube teachers as professors instead of the professors they currently employ. just had a 2 hour confusing lecture on this topic. this video explained it in 6 minutes
@riaswamy4778
@riaswamy4778 Жыл бұрын
Yup true you said
@mohammedabdeen9841
@mohammedabdeen9841 Жыл бұрын
I totally agree
@temptedtrevor8498
@temptedtrevor8498 Жыл бұрын
Some universities do have good professors but again there are more universities than the number of good teacher available. And these youtubers teach online cause they like their own schedule and environment. You can't expect every Online Educator to sign up for an university job.
@randall.o8995
@randall.o8995 11 ай бұрын
This guy explained my 14w of lectures crystal clear in just under 7m damn
@shathusjansivaneswaran9758
@shathusjansivaneswaran9758 9 ай бұрын
Certainly, with "Aliens" included: I couldn't agree more. My lecture explained it in a way that only stereotypical aliens can understand this concept. But this KZfaqr explains it in a way that even a 5-year-old can grasp the ideas of Star and Snowflake schemas.
@AjayPrashar
@AjayPrashar 9 ай бұрын
I have heard of these star and snowflake schema concepts before as well as implemented them for many years without really grasping key foundational concepts. This explanation really cleared up the key concepts for me. As an added bonus I finally grasped concepts behind Normalized and Denormalized. I finally get it. Thank you.
@codebasics
@codebasics 9 ай бұрын
Excellent 💯
@GiGi-dd5cr
@GiGi-dd5cr 4 күн бұрын
You have no idea how helpful this was! You explained that so well, thank you!
@equiwave80
@equiwave80 Жыл бұрын
This is the best video I have seen for difference between the Star and Snowflake Schema. The easiest and clearest way to explain this topic. Thanks for all your efforts!!!👍🙏
@akshaydushyanth9720
@akshaydushyanth9720 10 ай бұрын
To be frank many of our college professors who were Phd holders and getting paid 20lpa just for taking 2 hours of class per day never made an attempt to reach their concepts to last benchers also, they had a superiority complex of having Phd certificate so if any student didnt understand their way of explaining things they made us to feel that we arent fit for engineering. Glad that youtubers are becoming our best teachers now.
@0777deep
@0777deep 4 ай бұрын
Bhai kya bola tune, sahi hai bhai!
@just_be_abhinav
@just_be_abhinav 4 ай бұрын
dude this is in your engineering? i am in bba and i am also having same topics in business analytics
@abhijitdas8617
@abhijitdas8617 9 ай бұрын
People complicate data modelling so much that many get scared of this term. You have explained in such a clear way in short time which is commendable. Unfortunately many university professors waste ample time without achieving anything.
@bijayphoto1447
@bijayphoto1447 4 күн бұрын
I had understood crisp clear about these concepts. Thanks to you man❤
@omarcruz6326
@omarcruz6326 15 күн бұрын
Hello ! This is probably the best video I have seen in my life about this topic. Excellent ! 👌
@killersongs7906
@killersongs7906 Жыл бұрын
sir i had just read this same topic a few days ago but now you have cleared all my doubts completely, thanks
@kstar_kz
@kstar_kz 5 ай бұрын
I find this video a great explanation of the STAR and the SNOWFLAKE schemas! Thanks for creating a valuable content!
@user-xi1kr2it9v
@user-xi1kr2it9v 10 ай бұрын
Good job on this video. I'm a senior data engineer and found this easier to explain than what was in my head Lol. I think how you described how the snowflake schema can evolve from a star schema was spot on. One suggestion would be to compliment the ease of how these tables are refreshed and maintained over time (you did this a bit with your product table) and how modeling these up front impacts everything around it such as ETL, API calls in a web form, how a search might be conducted, etc. Nice work!! A+++++
@drtrewenstein
@drtrewenstein 5 ай бұрын
Fantastic, I tried to learn from text book but couldn't quite grasp it. You made it very simple thank you
@RiyaKakar
@RiyaKakar 2 ай бұрын
I really could not understand the snowflake schema but this video did its job. I am clear now. Thankyou, appreciate it. We need more of these videos.
@thenuchellappen4688
@thenuchellappen4688 11 ай бұрын
Nobody can match the way how you are teaching/clarifying a new topic to the beginners. ❤️ Please do more such videos 👍
@PostFrontier
@PostFrontier 2 ай бұрын
This video is incredible. Completely simplified the concept for my understanding. And being able to see the concepts you're explaining helps greatly as well. Thank you for making this.
@jupitervibe3825
@jupitervibe3825 7 ай бұрын
Thank you so much Sir. I am glad I found this first before seeing any other confusing videos unlike others here. Very nice explanation 👌
@erigelavani4162
@erigelavani4162 4 ай бұрын
Thanks sir for explaining in better way and with better example
@lamo2real
@lamo2real Ай бұрын
thank you very much for explaining it on such a fundamental level, very easy to grasp
@hobbymoman95
@hobbymoman95 Ай бұрын
This is the best explanation. I finally got it. Thank you Sir
@limjuroy7078
@limjuroy7078 22 күн бұрын
Thank you for your SUPER CLEAR explanation ❤
@saiuppuluri1063
@saiuppuluri1063 4 ай бұрын
Very thoughtfully explained, making it easy to grasp even for data engineering newbies
@andrewt3593
@andrewt3593 23 күн бұрын
Thank you for the overview! I learned a lot from this video.
@swanandkulkarni1095
@swanandkulkarni1095 10 ай бұрын
You art of breaking complex things into simple is awesome. Superb explained. Thanks.
@iiN1GH7M4R3ii
@iiN1GH7M4R3ii 11 ай бұрын
Thank you Dhaval for another very informtive video, you are unmatched in the world of data analytics!
@SivaV-v2y
@SivaV-v2y Ай бұрын
Short and Crisp explanation.
@abhijithvm3166
@abhijithvm3166 7 ай бұрын
I really enjoyed this video because the content in this video is very amaze. I am aspiring data analyst so every day i spent some time for learning new skills depends upon the analytics and talking about this video its very good because with in 6 minute teaching me whole thing related to star and snow schema and data modeling also. I really enjoyed this video and i recommending this video if you really want to know more about the schema, Database, Data modeling and normalization.
@_RajRanjanOjha
@_RajRanjanOjha Ай бұрын
This was one of the best method to explain. The diagram and visualization was perfect. Thank you sir..
@KrishnaConcious9888
@KrishnaConcious9888 Жыл бұрын
Can't be any simpler explanation than this, Thank You
@zerobars3
@zerobars3 Ай бұрын
Great Explanations simple and easy to understand. Thanks
@007hariharan
@007hariharan Жыл бұрын
Well explained. I got goosebumps when Dhaval said "Folks it is as simple as that ..." 4:05. Great job . Loved your content.
@VEGASNARSI
@VEGASNARSI Жыл бұрын
Same here. … awesome explanation.. a big thumbs Up sir 👍🏻
@ChristianeRhelyJoselleA.Bacani
@ChristianeRhelyJoselleA.Bacani 9 күн бұрын
Excellent, I thought the last example is an example of Galaxy Schema (Constellations of facts used to connect different or same dimensions) but good visualization!
@safkaify7875
@safkaify7875 3 ай бұрын
Best video I have seen on this topic. PLEASE keep up the good work so others (like me) can benefit from your simple way of explaining concepts.
@minato.namekaze.47
@minato.namekaze.47 3 ай бұрын
Explained better than ChatGPT! Excellent 😁👍🏼
@joseluiscabrera1417
@joseluiscabrera1417 2 ай бұрын
Thank you so much, my friend. Great explanation!
@adedoyinkudehinbu5039
@adedoyinkudehinbu5039 2 ай бұрын
This was beautifully I explained. I subscribed in an instant!
@MeetShah-pr7mm
@MeetShah-pr7mm 2 ай бұрын
Such an insightful explanation that too in simple terms
@learn_ai_with_us
@learn_ai_with_us 2 ай бұрын
waaao...amazing..very simple explanation..hatts off
@elmirahadidian5051
@elmirahadidian5051 4 ай бұрын
it was the best best best ever describing the models , thankkkkkkkkkkkkks alot.
@jace743
@jace743 2 ай бұрын
Succinct and extremely informative. Thank you for this!
@user-vp9er1kn1r
@user-vp9er1kn1r 11 ай бұрын
Awesome, very clear and simple explanation. Up until know, Data Modeling concept is ambiguity for me, now I understood full. it's data conversion process from raw data to normalized one!
@Yuvans22
@Yuvans22 Жыл бұрын
Very great explanation, I was in confusion all these days , but you have clarified it for good. Thanks heaps
@vishalchauhan9832
@vishalchauhan9832 Жыл бұрын
wow amazing , so simple to understand. crystal clear explanation ! Thank you so much Subscribed !
@sripree
@sripree Ай бұрын
Amazing video. Very simple and easy. I am 5 years old and I understood the concept completely.😅
@balive053
@balive053 Жыл бұрын
Love the explanation. Very clear and good example. Thanks very much!
@munyinting487
@munyinting487 7 ай бұрын
Omg, that makes it so so so much clearer that chatgpt also can't explain well. Thanks!
@fernandoroque2374
@fernandoroque2374 4 ай бұрын
Excelent explanation professor! Thank you for the great work! A huge hug from Brazil
@aelianmvarghese4460
@aelianmvarghese4460 8 ай бұрын
The best easiest explanation till date. Thankyou Sir !!
@OkayestOfDads
@OkayestOfDads 3 ай бұрын
Great explanation and visuals.
@venkichinni7893
@venkichinni7893 9 ай бұрын
Really short and sweet way of teaching 😀
@vial2811
@vial2811 Ай бұрын
Jeez, you really explained it like to a 5 years-old. Thanks so much
@SantoshRokaya-wb9or
@SantoshRokaya-wb9or 3 ай бұрын
Such an excellent way to explain the things..Thank you sir!!
@mmmwatching
@mmmwatching 4 ай бұрын
Very helpful, thank you!
@akeemadedigba8279
@akeemadedigba8279 Ай бұрын
Great explanation.
@kaveghasemzade8751
@kaveghasemzade8751 5 ай бұрын
I really enjoyed the way you explaiend those :)
@lien-chinwei4815
@lien-chinwei4815 Жыл бұрын
Thank you. This explanation is so clear and highlights the difference between two schemes.
@MAXMEN-fl6yv
@MAXMEN-fl6yv Жыл бұрын
Awesome sir, ur way of explanation with practical example is jusssst awwwwesssome !!!!
@GAURAVSHEKHAWAT
@GAURAVSHEKHAWAT 16 күн бұрын
Excellent an dsimple!
@husseinalshaiban9288
@husseinalshaiban9288 7 ай бұрын
Excellent job, the Idea is clear and straightforward
@venkatrr8267
@venkatrr8267 Жыл бұрын
way of explaining is extra ordinary.
@akapurvis1173
@akapurvis1173 Ай бұрын
Totally awesome.👍🏾
@edjosephalejandro2696
@edjosephalejandro2696 3 ай бұрын
Thank you this was very helpful
@The_Bold_Statement
@The_Bold_Statement 4 ай бұрын
fantastic explaination
@vannessawilliams3131
@vannessawilliams3131 7 ай бұрын
I wish you were teaching my SQL course because this is so so clear! Thank you
@codebasics
@codebasics 7 ай бұрын
I am. Check codebasics.io
@ghostrider-hk5jm
@ghostrider-hk5jm 6 ай бұрын
Thank you sir. Very good explanation with simple examples
@crazytravels
@crazytravels 5 ай бұрын
what a gem of a person you are!
@0777deep
@0777deep 4 ай бұрын
Superb man! Superb .
@MrPrince
@MrPrince Жыл бұрын
You are a life saver ! Thanks alot for the simplification of the concept
@abhishekgpa7948
@abhishekgpa7948 6 ай бұрын
superb explanation
@armghan2312
@armghan2312 9 ай бұрын
Man you are just amazing!
@rakeshverma6867
@rakeshverma6867 Жыл бұрын
Its very simple that you had explained ..Even though a layman can easily grab this concept. Thank you very much making this video.
@petrmudra1413
@petrmudra1413 Жыл бұрын
Simple topic, but explained very well.
@stephenwood4814
@stephenwood4814 Жыл бұрын
This is a superb, very clarifying presentation. Thank you for putting this together.
@timoteoalvescollege
@timoteoalvescollege 8 ай бұрын
That was really a great video!
@NickSinghTech
@NickSinghTech 3 ай бұрын
Great video Dhaval!
@JustScrollup
@JustScrollup Жыл бұрын
Seriously Got to know the exact point in a few seconds ✍👏
@Dhruv4work
@Dhruv4work 2 ай бұрын
thankyou so much sir .
@jupallipraveenkumar-nn9ef
@jupallipraveenkumar-nn9ef 3 ай бұрын
thank you so much for information
@leethedev49
@leethedev49 9 ай бұрын
Very clear explanation, many thanks.
@petebell271
@petebell271 2 ай бұрын
MASTER DATA MANGEMENT (customer , Vendors), sometimes after 20 years of experience we forget the THEORY , although we have the practical knowledge ( good to brush)
@krishna-mx1dx
@krishna-mx1dx 7 ай бұрын
Superb & clear explanation ...Thanks
@tim-duncan2137
@tim-duncan2137 6 ай бұрын
nice explanation sir!
@zohaibjamal
@zohaibjamal 11 ай бұрын
Excellent. Tough concept simplified
@viciwo3396
@viciwo3396 5 ай бұрын
Easy to understand! Thanks!
@darkmatter4701
@darkmatter4701 5 ай бұрын
Thank You Sir
@nethravathi2845
@nethravathi2845 Жыл бұрын
This video helped me a lot, thank you so much for wonderful explanation , it means a lot 🙏🙏🙏🙏🙏
@Travel_and_music_shorts
@Travel_and_music_shorts 7 ай бұрын
Thanks for visualizing and explaining
@devanshpandey7750
@devanshpandey7750 5 ай бұрын
All doubts cleared!
@veerkumargouraj3060
@veerkumargouraj3060 Жыл бұрын
Great learning cleared all my doubts tq
@sarwarcseju
@sarwarcseju 10 ай бұрын
very nicely explained. Thank you for sharing.
@andrefigalmeida
@andrefigalmeida 2 ай бұрын
thank you 🙏🙏
@tyroncloete8113
@tyroncloete8113 Жыл бұрын
Beautifully explained. Thank you!
@saiaravindm.2459
@saiaravindm.2459 Ай бұрын
Done, thanks
@greg_thomson
@greg_thomson 5 ай бұрын
Fantastic help
@Wolves2314
@Wolves2314 10 ай бұрын
Fantastic video, great explanations. Thank you, sir.
@Captureindeed
@Captureindeed 5 ай бұрын
Really helpful
@dipti2075
@dipti2075 Жыл бұрын
Hi sir , your videos are really good. Please make a playlist for data engineering concepts . Love from Odisha ❤️❤️
@tahirhanif9669
@tahirhanif9669 11 ай бұрын
Excellent presentation, thank you
@tushararora6665
@tushararora6665 8 ай бұрын
amazing amazing amazing!!
@muhammetmuslu4429
@muhammetmuslu4429 9 ай бұрын
very good explanation.thank you.
@codebasics
@codebasics 9 ай бұрын
I am happy this was helpful to you.
@kyledukes9788
@kyledukes9788 6 ай бұрын
so clear, thank you!
What is ETL | What is Data Warehouse | OLTP vs OLAP
8:07
codebasics
Рет қаралды 412 М.
Can This Bubble Save My Life? 😱
00:55
Topper Guild
Рет қаралды 41 МЛН
Why Is He Unhappy…?
00:26
Alan Chikin Chow
Рет қаралды 100 МЛН
👨‍🔧📐
00:43
Kan Andrey
Рет қаралды 9 МЛН
Tutorial: Monitoring Button Statuses with LoRa and Modbus TCP
8:04
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 58 М.
7 Different Types of Dimensions in a Data Warehouse!
8:56
Abhilash Marichi
Рет қаралды 34 М.
Data Modeling Tutorial: Star Schema (aka Kimball Approach)
16:34
Kahan Data Solutions
Рет қаралды 105 М.
I Studied Data Job Trends for 24 Hours to Save Your Career! (ft Datalore)
13:07
Thu Vu data analytics
Рет қаралды 180 М.
Database vs Data Warehouse vs Data Lake | What is the Difference?
5:22
Alex The Analyst
Рет қаралды 764 М.