What is STAR schema | Star vs Snowflake Schema | Fact vs Dimension Table
HTML-код
- Опубликовано: 30 сен 2024
- 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...
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
Yup true you said
I totally agree
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.
This guy explained my 14w of lectures crystal clear in just under 7m damn
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 RUclipsr explains it in a way that even a 5-year-old can grasp the ideas of Star and Snowflake schemas.
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.
Excellent 💯
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.
Bhai kya bola tune, sahi hai bhai!
dude this is in your engineering?
i am in bba and i am also having same topics in business analytics
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!!!👍🙏
I find this video a great explanation of the STAR and the SNOWFLAKE schemas! Thanks for creating a valuable content!
MASTER DATA MANGEMENT (customer , Vendors), sometimes after 20 years of experience we forget the THEORY , although we have the practical knowledge ( good to brush)
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!
Excellently explained! Thank you very much!
Beautiful explanation brother.. I missed a Job opportunity because I dint know the answer for this 😢
sir i had just read this same topic a few days ago but now you have cleared all my doubts completely, thanks
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.
Very brief question, is the definition of the type of a data model between star or snowflake simply defined by at least one dimension table having a "secondary" dimension table? For example, if you delete that dim_market table it makes the data model to use a star schema now, instead of snowflake. Is that right?
Thank you for your SUPER CLEAR explanation ❤
thank you , avery useful and enjoyable video to watch, thanks again from a 5(0) year old child ....
Succinct and extremely informative. Thank you for this!
Good Explanation Sir! Just a quick question, are you gujarati ?
very very useful and clear, thanks very much for sharing!
Fantastic, I tried to learn from text book but couldn't quite grasp it. You made it very simple thank you
thank you very much for explaining it on such a fundamental level, very easy to grasp
Thank you so much, my friend. Great explanation!
Man seriously.. Never thought it is that simple. I read some articles but didnt understand anything.
Lots of people saying this is best video and lab lab honestly this is not best video you can find better video than this people are just come to seek attention for their comments lol yrr
Jeez, you really explained it like to a 5 years-old. Thanks so much
Does that mean extended star schema is nothing but snowflake schema?
Thank you for the tutorial could you please share the csv file example
What an explanation bro mind blowing... Now how simple is this
Simple and concise! Thank you so much!
Great Explanations simple and easy to understand. Thanks
Thank you Dhaval for another very informtive video, you are unmatched in the world of data analytics!
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.
Indians are just superior, I went from hating the accent to loving it kekw
This is the clear explanation i came across till now in RUclips
wow amazing , so simple to understand. crystal clear explanation ! Thank you so much Subscribed !
Thanks sir for explaining in better way and with better example
Explained better than ChatGPT! Excellent 😁👍🏼
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+++++
Thank you so much Sir. I am glad I found this first before seeing any other confusing videos unlike others here. Very nice explanation 👌
@codebasics
Does my Fact table must have Foreign keys to access each dimension tables?
yes it will have FK from the dimension table
Thank you for the overview! I learned a lot from this video.
Excellent video, very succinct and no nonsense thank you sir
it was the best best best ever describing the models , thankkkkkkkkkkkkks alot.
I dont know if its reall that simple😅
Well explained. I got goosebumps when Dhaval said "Folks it is as simple as that ..." 4:05. Great job . Loved your content.
Same here. … awesome explanation.. a big thumbs Up sir 👍🏻
could you send that powerbi file then we can understand very easily
Such an insightful explanation that too in simple terms
Months of classes at university in 6 minutes. My teacher sucks so hard
thank u soooooooooooooooooooooooooooooooooooooooooooooo much for explaining
Thank you this was very helpful
frankly it's not rocket science 😂😂😂😂😂😂😂😂
Came here from the "SQL for data science" course
Not quite what I was looking for. But thanks
I really enjoyed the way you explaiend those :)
Hi sir , your videos are really good. Please make a playlist for data engineering concepts . Love from Odisha ❤️❤️
You art of breaking complex things into simple is awesome.
Superb explained. Thanks.
Love the explanation. Very clear and good example. Thanks very much!
Which tool are using to design. Data model
Short and Crisp explanation.
I had understood crisp clear about these concepts. Thanks to you man❤
Nobody can match the way how you are teaching/clarifying a new topic to the beginners. ❤️ Please do more such videos 👍
can also explain ACID transactions?
Great explanation and visuals.
Very helpful, thank you!
FANTASTIC VIDEO! I've been trying to find a simple explanation of what Fact / Dimension tables are for a week now and I just kept finding super long and overly complicated descriptions of database architecture. This is so well done. I now understand what Fact / Dimension tables and Star Schemas are! thank you
Can't be any simpler explanation than this, Thank You
thank you so much for information
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.
Very thoughtfully explained, making it easy to grasp even for data engineering newbies
Very great explanation, I was in confusion all these days , but you have clarified it for good. Thanks heaps
best explanation sir
Not only you explained star schema, you also did it with normalization. Thankyou very much. It was very clear and easy to understand.
Amazing video. Very simple and easy. I am 5 years old and I understood the concept completely.😅
You explained so good.
Excelent explanation professor! Thank you for the great work! A huge hug from Brazil
Awsome content Dhaval....Thanks brother...Hope you are keeping well Now..............Respect from Bangalore...
thankyou so much sir
.
This was one of the best method to explain. The diagram and visualization was perfect. Thank you sir..
Excellent an dsimple!
Fantastic explanation!
thank you 50 year old
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.
You have no idea how helpful this was! You explained that so well, thank you!
This is not wholesome , transaction systems have Normalised tables and datawarehouses may have denomalized (start/snowflake etc schema), there might be multiple transaction table we join it and create few fact tables, to avoid join on the fly while reporting in warehouse or may aggregate as well..(source: i am db engineer for last 12 years)
Hello !
This is probably the best video I have seen in my life about this topic.
Excellent ! 👌
very good explanation.thank you.
I am happy this was helpful to you.
superb explanation
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.
Totally awesome.👍🏾
Thank you sir. Very good explanation with simple examples
Great explanation.
nice explanation sir!
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!
fantastic explaination
Such an excellent way to explain the things..Thank you sir!!
waaao...amazing..very simple explanation..hatts off
This was beautifully I explained. I subscribed in an instant!
Superb man! Superb .
Omg, that makes it so so so much clearer that chatgpt also can't explain well. Thanks!
amazing amazing amazing!!
very nicely explained. Thank you for sharing.
This video helped me a lot, thank you so much for wonderful explanation , it means a lot 🙏🙏🙏🙏🙏