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

In data modeling, star and snowflake are two popular ways of modeling your data. In this video, I will explain you following concepts in a very simple manner,
What is star schema?
What is snowflake schema?
Difference between star and snowflake schema
What is fact table?
What is dimension table?
Fact vs Dimension table
Power BI course that covers all above concepts in depth: codebasics.io/...
Do you want to learn technology from me? Check codebasics.io/... for my affordable video courses.
Need help building software or data analytics/AI solutions? My company www.atliq.com/ can help. Click on the Contact button on that website.
🎥 Codebasics Hindi channel: / @codebasicshindi
#️⃣ Social Media #️⃣
🔗 Discord: / discord
📸 Dhaval's Personal Instagram: / dhavalsays
📸 Codebasics Instagram: / codebasicshub
🔊 Facebook: / codebasicshub
📱 Twitter: / codebasicshub
📝 Linkedin (Personal): / dhavalsays
📝 Linkedin (Codebasics): / codebasics
🔗 Patreon: www.patreon.co...

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

Yup true you said

[@mohammedabdeen9841]

I totally agree

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

This guy explained my 14w of lectures crystal clear in just under 7m damn

[@shathusjansivaneswaran9758]

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 KZbinr explains it in a way that even a 5-year-old can grasp the ideas of Star and Snowflake schemas.

[@AjayPrashar]

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]

Excellent 💯

[@akshaydushyanth9720]

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]

Bhai kya bola tune, sahi hai bhai!

[@just_be_abhinav]

dude this is in your engineering? i am in bba and i am also having same topics in business analytics

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

[@abhijitdas8617]

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.

[@kstar_kz]

I find this video a great explanation of the STAR and the SNOWFLAKE schemas! Thanks for creating a valuable content!

[@GiGi-dd5cr]

You have no idea how helpful this was! You explained that so well, thank you!

[@bijayphoto1447]

I had understood crisp clear about these concepts. Thanks to you man❤

[@user-xi1kr2it9v]

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+++++

[@killersongs7906]

sir i had just read this same topic a few days ago but now you have cleared all my doubts completely, thanks

[@RiyaKakar]

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.

[@drtrewenstein]

Fantastic, I tried to learn from text book but couldn't quite grasp it. You made it very simple thank you

[@PostFrontier]

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.

[@erigelavani4162]

Thanks sir for explaining in better way and with better example

[@saiuppuluri1063]

Very thoughtfully explained, making it easy to grasp even for data engineering newbies

[@thenuchellappen4688]

Nobody can match the way how you are teaching/clarifying a new topic to the beginners. ❤️ Please do more such videos 👍

[@omarcruz6326]

Hello ! This is probably the best video I have seen in my life about this topic. Excellent ! 👌

[@hb3393]

Excellent video, very succinct and no nonsense thank you sir

[@jupitervibe3825]

Thank you so much Sir. I am glad I found this first before seeing any other confusing videos unlike others here. Very nice explanation 👌

[@abhijithvm3166]

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.

[@iiN1GH7M4R3ii]

Thank you Dhaval for another very informtive video, you are unmatched in the world of data analytics!

[@007hariharan]

Well explained. I got goosebumps when Dhaval said "Folks it is as simple as that ..." 4:05. Great job . Loved your content.

[@VEGASNARSI]

Same here. … awesome explanation.. a big thumbs Up sir 👍🏻

[@hobbymoman95]

This is the best explanation. I finally got it. Thank you Sir

[@safkaify7875]

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.

[@andrewt3593]

Thank you for the overview! I learned a lot from this video.

[@swanandkulkarni1095]

You art of breaking complex things into simple is awesome. Superb explained. Thanks.

[@lamo2real]

thank you very much for explaining it on such a fundamental level, very easy to grasp

[@KrishnaConcious9888]

Can't be any simpler explanation than this, Thank You

[@adedoyinkudehinbu5039]

This was beautifully I explained. I subscribed in an instant!

[@_RajRanjanOjha]

This was one of the best method to explain. The diagram and visualization was perfect. Thank you sir..

[@SivaV-v2y]

Short and Crisp explanation.

[@limjuroy7078]

Thank you for your SUPER CLEAR explanation ❤

[@learn_ai_with_us]

waaao...amazing..very simple explanation..hatts off

[@zerobars3]

Great Explanations simple and easy to understand. Thanks

[@anakapallisuneetha]

What an explanation bro mind blowing... Now how simple is this

[@joseluiscabrera1417]

Thank you so much, my friend. Great explanation!

[@minato.namekaze.47]

Explained better than ChatGPT! Excellent 😁👍🏼

[@elmirahadidian5051]

it was the best best best ever describing the models , thankkkkkkkkkkkkks alot.

[@aelianmvarghese4460]

The best easiest explanation till date. Thankyou Sir !!

[@MeetShah-pr7mm]

Such an insightful explanation that too in simple terms

[@fernandoroque2374]

Excelent explanation professor! Thank you for the great work! A huge hug from Brazil

[@vishalchauhan9832]

wow amazing , so simple to understand. crystal clear explanation ! Thank you so much Subscribed !

[@user-vp9er1kn1r]

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!

[@jace743]

Succinct and extremely informative. Thank you for this!

[@venkichinni7893]

Really short and sweet way of teaching 😀

[@crazytravels]

what a gem of a person you are!

[@ChristianeRhelyJoselleA.Bacani]

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!

[@balive053]

Love the explanation. Very clear and good example. Thanks very much!

[@MAXMEN-fl6yv]

Awesome sir, ur way of explanation with practical example is jusssst awwwwesssome !!!!

[@sripree]

Amazing video. Very simple and easy. I am 5 years old and I understood the concept completely.😅

[@husseinalshaiban9288]

Excellent job, the Idea is clear and straightforward

[@kaveghasemzade8751]

I really enjoyed the way you explaiend those :)

[@Yuvans22]

Very great explanation, I was in confusion all these days , but you have clarified it for good. Thanks heaps

[@SantoshRokaya-wb9or]

Such an excellent way to explain the things..Thank you sir!!

[@munyinting487]

Omg, that makes it so so so much clearer that chatgpt also can't explain well. Thanks!

[@vial2811]

Jeez, you really explained it like to a 5 years-old. Thanks so much

[@venkatrr8267]

way of explaining is extra ordinary.

[@OkayestOfDads]

Great explanation and visuals.

[@lien-chinwei4815]

Thank you. This explanation is so clear and highlights the difference between two schemes.

[@0777deep]

Superb man! Superb .

[@mmmwatching]

Very helpful, thank you!

[@timoteoalvescollege]

That was really a great video!

[@armghan2312]

Man you are just amazing!

[@ghostrider-hk5jm]

Thank you sir. Very good explanation with simple examples

[@vannessawilliams3131]

I wish you were teaching my SQL course because this is so so clear! Thank you

[@codebasics]

I am. Check codebasics.io

[@edjosephalejandro2696]

Thank you this was very helpful

[@MrPrince]

You are a life saver ! Thanks alot for the simplification of the concept

[@JustScrollup]

Seriously Got to know the exact point in a few seconds ✍👏

[@GAURAVSHEKHAWAT]

Excellent an dsimple!

[@akapurvis1173]

Totally awesome.👍🏾

[@akeemadedigba8279]

Great explanation.

[@The_Bold_Statement]

fantastic explaination

[@stephenwood4814]

This is a superb, very clarifying presentation. Thank you for putting this together.

[@devanshpandey7750]

All doubts cleared!

[@abhishekgpa7948]

superb explanation

[@leethedev49]

Very clear explanation, many thanks.

[@krishna-mx1dx]

Superb & clear explanation ...Thanks

[@petrmudra1413]

Simple topic, but explained very well.

[@zohaibjamal]

Excellent. Tough concept simplified

[@rakeshverma6867]

Its very simple that you had explained ..Even though a layman can easily grab this concept. Thank you very much making this video.

[@NickSinghTech]

Great video Dhaval!

[@dipti2075]

Hi sir , your videos are really good. Please make a playlist for data engineering concepts . Love from Odisha ❤️❤️

[@tim-duncan2137]

nice explanation sir!

[@shaikusman536]

Awsome content Dhaval....Thanks brother...Hope you are keeping well Now..............Respect from Bangalore...

[@tushararora6665]

amazing amazing amazing!!

[@nethravathi2845]

This video helped me a lot, thank you so much for wonderful explanation , it means a lot 🙏🙏🙏🙏🙏

[@viciwo3396]

Easy to understand! Thanks!

[@Dhruv4work]

thankyou so much sir .

[@jupallipraveenkumar-nn9ef]

thank you so much for information

[@shashankjoshi8250]

Good Explanation Sir! Just a quick question, are you gujarati ?

[@kaltoumrachdi2086]

thank u soooooooooooooooooooooooooooooooooooooooooooooo much for explaining

[@darkmatter4701]

Thank You Sir

[@veerkumargouraj3060]

Great learning cleared all my doubts tq

[@Wolves2314]

Fantastic video, great explanations. Thank you, sir.

[@allanfernandes245]

Crystal clear explanation !!

[@Travel_and_music_shorts]

Thanks for visualizing and explaining

[@krishram8599]

Best one ❤

[@sarwarcseju]

very nicely explained. Thank you for sharing.

[@muhammetmuslu4429]

very good explanation.thank you.

[@codebasics]

I am happy this was helpful to you.

[@Captureindeed]

Really helpful