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

No video

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

Рет қаралды 48,181

Күн бұрын

#IndiaBestITtrainingCenter #KSRDatavizon #Schema
What is Schemas? Star vs. Snowflake
In this video we will understand and learn about Schemas, the difference between fact table and dimension table. Also we will compare between Star and Snowflake schema. This is very important step we do at initial phase of project.
So in this video we are going to see -
1. Detailed Explanation of fact and dimension table
2. Star schema and dimension Schema
3. Galaxy schema
#PowerBI #Demand #BestSalary #HighDemand #BusinessIntelligence #Schemas #Star#Snowflake #StarSchemas ##BestBITool #Highest #HighestSalary #BestNegotiation #Package #HighPackage #Visualizations #Reports #Dashboard #HighSalary #BI #HotSkill #MarketDemand
*************************
Live Powerbi Interview with Capgemini : • Capgemini Interview 20...
Live Powerbi Interview with EY -Round 1: • First Round Live Inter...
Live Powerbi Interview with EY -Round 1: • Live Recorded Intervie...
Interview tips and Tricks: • Power BI Tips and Tric...
***************************
How are we different from others
1. 24*7 Life time Access & Support
2. Flexible Class Schedule
3. 100 % Job Guarantee
4. Mentors with +14 yrs
5. Industry Oriented Course ware
6. Life time free Course Upgrade
------------------------------
Call us on IND: 9916961234/8527506810 to talk to our Course Advisors.

Пікірлер: 65

@KSRDatavizon 2 жыл бұрын

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 KZfaq channel 👉Please ping on WhatsApp wa.me/9916961234

@karanmalkhede6689 2 жыл бұрын

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 2 жыл бұрын

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

@KSRDatavizon 2 жыл бұрын

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 7 ай бұрын

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

@KSRDatavizon 5 ай бұрын

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

@esireddysrinuvasareddy7119 5 ай бұрын

It is helpful for new SQL learners thank you

@KSRDatavizon 5 ай бұрын

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

@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

@sujaa1000 2 ай бұрын

Thanks for a clear explanation!

@KSRDatavizon 2 ай бұрын

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!

@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!

@chandrakamal7655 Жыл бұрын

very nice explanation sir jii

@KSRDatavizon Жыл бұрын

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

@balamuruganpandiyan5435 2 жыл бұрын

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 2 жыл бұрын

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

@blogtonight1698 Жыл бұрын

Yes, but did you get the job?

@princemurali5509 Жыл бұрын

Your team cleared my long doubt

@KSRDatavizon Жыл бұрын

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

@gradeaaguy 6 ай бұрын

Thanks!

@KSRDatavizon 5 ай бұрын

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

@karanmalkhede6689 2 жыл бұрын

Another useful video🥳

@KSRDatavizon 2 жыл бұрын

Glad you think so!

@santroramki 8 ай бұрын

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?

@eswarkumar8458 2 жыл бұрын

Thank you so much for wonderful explanation

@KSRDatavizon 2 жыл бұрын

Glad it was helpful!

@rajeshraj-sk8nn 2 жыл бұрын

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

@KSRDatavizon 2 жыл бұрын

Thanks a lot 😊

@ashokreddy3366 2 жыл бұрын

Your explanation is next level sir

@KSRDatavizon 2 жыл бұрын

Glad to hear that. Thanks

@Nana-on8vv 2 жыл бұрын

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

@KSRDatavizon 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

Sure we will have it asap

@sai3321 Жыл бұрын

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

@vrmotovlog4333 11 ай бұрын

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

@KSRDatavizon 11 ай бұрын

Yes sir

@kamalhema6911 Жыл бұрын

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

@KSRDatavizon 11 ай бұрын

will try to explain in different video

@vinny_daali 2 жыл бұрын

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 2 жыл бұрын

Learn python

@KSRDatavizon 2 жыл бұрын

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 kzfaq.info/get/bejne/irOcfraHzdCVnWw.html

@dinesha9152 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

@@KSRDatavizon thank u sir