Star Schema vs Snowflake Schema I Data Modelling I Data Warehousing I Schema I SQL I Power BI

[@KSRDatavizon]

Hi Viewers, if you have any queries on this topic or you want any topic to learn from us, drop them in our comments section. Please make sure you subscribe to our KZbin channel 👉Please ping on WhatsApp wa.me/9916961234

[@karanmalkhede6689]

Number is not working sir🙏

[@mohammadsi678]

Highly appreciate your video, easily understood regarding fact and dimension tables as well as star and snowflake schemas. You are one of the highest performing teacher. Many thanks.

[@KSRDatavizon]

Glad it was helpful!

[@snehagoud9452]

You explaination is on the another level... All your videos are very helpful... Thank you so much KSR...

[@KSRDatavizon]

You are most welcome

[@anmolmadaan6644]

This is the best explanation of the topic I've seen so far. Highly appreciated.

[@KSRDatavizon]

Glad it was helpful! , Please subscribe our channel for regular updates , all the best

[@dadasahebkoulageofficial]

Highly appreciated,,,, thank you... 😊

[@KSRDatavizon]

Thank you for your kind words, they truly mean a lot to me.

[@esireddysrinuvasareddy7119]

It is helpful for new SQL learners thank you

[@KSRDatavizon]

Thank you so much, Please subscribe our channel, it motivates us a lot

[@scottgaines2677]

Thank you for the breakdown between the different schemas, it was very helpful. Great job!

[@KSRDatavizon]

Glad it was helpful!

[@blogtonight1698]

Thanks, I never considered different data models untilI got into Microsoft Power BI!

[@sujaa1000]

Thanks for a clear explanation!

[@KSRDatavizon]

You're welcome! we are glad that we could provide a clear explanation. If you have any more questions or need further assistance, feel free to ask!

[@hasaanwahid1675]

Very informative vedio. Thanks for an amazing content.

[@KSRDatavizon]

Glad you liked it!

[@lalithanandhesh]

Teaching is very easy to understand concepts sir tq

[@KSRDatavizon]

Keep watching, Thank you, Please subscribe our channel for regular updates , all the best

[@chandrakamal7655]

very nice explanation sir jii

[@KSRDatavizon]

Thanks and welcome, Please subscribe our channel, it will motives to do more videos

[@karanmalkhede6689]

Another useful video🥳

[@KSRDatavizon]

Glad you think so!

[@princemurali5509]

Your team cleared my long doubt

[@KSRDatavizon]

Thats great, Please subscribe our channel, it motivates us.

[@rajeshraj-sk8nn]

Watched all ur videos . All are very useful .. And the explanation is too good.. ..

[@KSRDatavizon]

Thanks a lot 😊

[@ashokreddy3366]

Your explanation is next level sir

[@KSRDatavizon]

Glad to hear that. Thanks

[@gradeaaguy]

Thanks!

[@KSRDatavizon]

you are Welcome!, please subscribe our channel for regular updates.

[@eswarkumar8458]

Thank you so much for wonderful explanation

[@KSRDatavizon]

Glad it was helpful!

[@santroramki]

Hi.. Sir, In above case the fact table should have unique values or dimension tables ? How do we create many to many relationships with the schema?

[@balamuruganpandiyan5435]

I have attended power bi interview this morning and interviewer asked the below question. We need to calculate the average attrition% .. Based on the user selection ... Example : 1. fiscal year - Apr - Mar.. 2. We need to calculate the average attrition % .... 3. If you click / Select December month then attrition count and average should dynamically calculate from sum( April - November ) ...and we need to add those value in numerator and by denominator should be December month values

[@KSRDatavizon]

We have solved similar usecase in session. we will upload same video shortly

[@blogtonight1698]

Yes, but did you get the job?

[@Nana-on8vv]

Please upload full videos on this two schemas.. Many videos are there in this shemas but no one is explaining like you sir.

[@KSRDatavizon]

Thanks. We will upload more videos

[@sai3321]

Somewhere I have seen that star,snowflake can have multi fact tables If star has multi fact tables then what's the difference between galaxy and star schemas

[@sanjeeth9996]

Hi sir your videos are very Helpful ,I had watched your End To End Project Webinar, Can you Please Conduct a Webinar Specially On DAX

[@KSRDatavizon]

Sure we will have it asap

[@sai3321]

Can we have more than 1 fact tables in a snowflake schema in realtime?

[@vrmotovlog4333]

Are you providing complete training on Multi-Dim Data Modelling in Snowflake?

[@KSRDatavizon]

Yes sir

[@anuradhadepuri7962]

In real time which schema more used

[@KSRDatavizon]

Star Schema mostly used

[@dinesha9152]

I have a question sir... If we created a report with default color coding and client didn't like report colouring ... What would be our next approach..... Note : client didn't provide their own colour Please help me regarding this???

[@KSRDatavizon]

if clients don't give colors.. we can choose the best combinations of colors. Default colors is usually avoided. Also please check our end to end project playlist. we have explained this

[@dinesha9152]

@@KSRDatavizon thank u sir

[@kamalhema6911]

Hi sir thanku you very much sir. I want SCD types class. Can you please provide link.

[@KSRDatavizon]

will try to explain in different video

[@vinny_daali]

I am 2020 passed out I had learn power bi with SQL but now I struggle to get the place in field. Cannot receive the call from requirements

[@crazy_MoviesBy007]

Learn python

[@KSRDatavizon]

For 2 years exp . SQL+ Power BI should be enough.. Seems like you are not applying correctly. Please follow this video. This will be very useful kzbin.info/www/bejne/in7PfIaMnc9ko5o

[@karanmalkhede6689]

Make a video on many to many relationship

[@KSRDatavizon]

Sure Karan, in pipeline.

[@karanmalkhede6689]

Cardinality

[@sivakumar-wb4pr]

star schema always have only one fact table?

[@KSRDatavizon]

It can have more than 1.. But it should be connected to all dimension tables

[@sivakumar-wb4pr]

@@KSRDatavizon Thank you 👍

[@ashamatiepper1096]

P

[@KSRDatavizon]

Thank you