?? Work at Pickup Points � Flexible schedule

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

codebasics 198 views

Download

Download Video

Comments

Very good! Thank you!
Comment from : @DianaCoffman-ln5qk

Wow that's a great explanation !
Comment from : @poojasoneja7011

Amazing brother
Comment from : @sailensvidegraphy

Perfection Thank you
Comment from : @williammcintire359

Great explanation
Comment from : @vikasvicky5674

goated Inder
Comment from : @frkz2259

Very well explained, thank you :) I am doing an Udemy course in which this topic was explained 11min but I did not really understand Your approach is very structured, I liked it Thanks!
Comment from : @Bockplumpi

Thanks for explaining I'm taking an Azure course and the explanation the instructor gave was not very good Your explanation is much better
Comment from : @SHAOLINCOWBOY-ip9hw

❤
Comment from : @MIKEBENISB

bro, the way you head to explain this concept is perfect keep it up!
Comment from : @backsidemil6230

I'm working on a DA Bachelor's degree, and the course material on fact tables/dimension tables really does a terrible job of explaining the difference This video finally gave me an explanation that made sense
Comment from : @lolvidar1964

Straight to the point Ver well explained :)
Comment from : @RizwanS12261a1455

concise! thanks for that
Comment from : @karangadgil9847

Great Explanation of data modelling in simplest way ,👍
Comment from : @rahulgoel4115

Very good video!
Comment from : @luanmalushaj3616

Great Visual Explanation Sir!!! No more confusions Thanks a TON
Comment from : @venkatasreeram7933

You rocked man Wonderful Hats off 😊
Comment from : @SudhakarR-n7m

good explanation
Comment from : @mohammed_Ansar

I missed that course and was looking like a fool when they did an exercise about it You just save a life in less than 10mins
Comment from : @DjonarTags

Great and concise video! Thanks
Comment from : @rjvzz

love the explanation! thanks
Comment from : @Matias-eh2pn

“I will explain TO you” ,not ; “I will explain you …”
Comment from : @Charango123quena

thank u so much
Comment from : @dev4128

sir can you pease answer thisbrbrwhich dimension table from the star schema did you use to build the new extended tables in the snowflake schema?
Comment from : @KARTHIKEYANMARLA

Thanks coach
Comment from : @desivideshi8372

Customer names are so funny 😅brbrWell explained, thanks
Comment from : @alitailor6509

I dont know if its reall that simple😅
Comment from : @Nopalxha

Excellently explained! Thank you very much!
Comment from : @MarcoBarretoBittner

Simple and concise! Thank you so much!
Comment from : @bennguyen4409

best explanation sir
Comment from : @ayushshukla5945

This is the clear explanation i came across till now in YouTube
Comment from : @akhildharimisetty2767

Not only you explained star schema, you also did it with normalization Thankyou very much It was very clear and easy to understand
Comment from : @corsim5997

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
Comment from : @turnerkirk5265

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
Comment from : @rohansingh1584

very very useful and clear, thanks very much for sharing!
Comment from : @Ragada7877

You explained so good
Comment from : @Sudha-n8c

Fantastic explanation!
Comment from : @timohubsch4281

super
Comment from : @spoortikulkarni7034

Can someone please tell me what is the program name that's used at 5:35
Comment from : @SuperNovaxFF

thank you 50 year old
Comment from : @rizwanfarooq2739

Excellent video, very succinct and no nonsense thank you sir
Comment from : @hb3393

What an explanation bro mind blowing Now how simple is this
Comment from : @anakapallisuneetha

I had understood crisp clear about these concepts Thanks to you man❤
Comment from : @bijayphoto1447

You have no idea how helpful this was! You explained that so well, thank you!
Comment from : @GiGi-dd5cr

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!
Comment from : @ChristianeRhelyJoselleABacani

Hello !brThis is probably the best video I have seen in my life about this topicbrExcellent ! 👌
Comment from : @omarcruz6326

Excellent an dsimple!
Comment from : @GAURAVSHEKHAWAT

wow thanks
Comment from : @malebeauty

Thank you for your SUPER CLEAR explanation ❤
Comment from : @limjuroy7078

Thank you for the overview! I learned a lot from this video
Comment from : @andrewt3593

Beautiful explanation brother I missed a Job opportunity because I dint know the answer for this 😢
Comment from : @liveyourlife998

Done, thanks
Comment from : @saiaravindm2459

Totally awesome👍🏾
Comment from : @akapurvis1173

Short and Crisp explanation
Comment from : @SivaV-v2y

thank you very much for explaining it on such a fundamental level, very easy to grasp
Comment from : @lamo2real

Great explanation
Comment from : @akeemadedigba8279

Jeez, you really explained it like to a 5 years-old Thanks so much
Comment from : @vial2811

Does that mean extended star schema is nothing but snowflake schema?
Comment from : @saurabhruikar1131

Great Explanations simple and easy to understand Thanks
Comment from : @zerobars3

This is the best explanation I finally got it Thank you Sir
Comment from : @hobbymoman95

Amazing video Very simple and easy I am 5 years old and I understood the concept completely😅
Comment from : @sripree

This was one of the best method to explain The diagram and visualization was perfect Thank you sir
Comment from : @_RajRanjanOjha

top G THX!
Comment from : @KM-ho7oy

Best one ❤
Comment from : @krishram8599

Awsome!!
Comment from : @chaithanyav6646

waaaoamazingvery simple explanationhatts off
Comment from : @learn_ai_with_us

Succinct and extremely informative Thank you for this!
Comment from : @jace743

This was beautifully I explained I subscribed in an instant!
Comment from : @adedoyinkudehinbu5039

thankyou so much sirbr
Comment from : @Dhruv4work

Wow 👍
Comment from : @venkatpartha

thank you 🙏🙏
Comment from : @andre_guitar

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
Comment from : @RiyaKakar

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
Comment from : @PostFrontier

Thank you so much, my friend Great explanation!
Comment from : @joseluiscabrera1417

Came here from the "SQL for data science" course
Comment from : @alemayehudesta2744

MASTER DATA MANGEMENT (customer , Vendors), sometimes after 20 years of experience we forget the THEORY , although we have the practical knowledge ( good to brush)
Comment from : @petebell271

Such an insightful explanation that too in simple terms
Comment from : @MeetShah-pr7mm

thank you so much for information
Comment from : @jupallipraveenkumar-nn9ef

Thank you this was very helpful
Comment from : @edjosephalejandro2696

Such an excellent way to explain the thingsThank you sir!!
Comment from : @SantoshRokaya-wb9or

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
Comment from : @safkaify7875

Great explanation and visuals
Comment from : @OkayestOfDads

Bro thank you so much!!! I've been searching online, teacher's documentation, even ChatGPT did not explain it well But this is literally the simplest explanation I've seen Thanks!!!
Comment from : @ugochukwunwachukwu7246