How to model data in Power BI (Star vs Snowflake schema)

┋Professional Certificates┋

┋Timestamps┋

Project Overview 00:00
Star Schema 03:58
Snowflake Schema 11:25

Thanks so much for taking a little time out of your day to watch this!

[teachtime]

Mo Chen You are goot at teaching Data Analytics. I respect your job!
I have been working as Data Analyst since March 2024.
I learned a lot from YouTube videos and also your videos. Thank you very much!

[bbhee]

I just started a new job and requires alot of data modelling, which this video came in handy. Thank you Mo!

Ivan

[Bossman]

This is great. Behind the fancy words are really simple concepts! Thanks for making it easy to understand

[karenaWarner]

I’ve done many power Bi courses, but this is the first time somebody’s explained the process of changing one-to-one to many to one and the rationale behind it. Thank you so very much, Mo.

[aryandwivedi]

This is one of the best videos to understand modelling. I would also love to understand types of relationships ( one to one, one to many, many to one & many to many) from one of your future videos in such a simpler way if possible :)

[chasingdogs]

First off, I am self taught and haphazardly so.

This video helped me understand some basics of working with dates. I was finding it hard to wrap around the one to many relationships. your latter half of the video actually helped me understand it.

I am not very good at enunciating what I meant... please understand that your video helped me a LOT!

Thanks, Mo.

[SANDATA]

Absolutely amazing and incredible, We’re gaining so much from this, and we truly appreciate you sharing these concepts for free. Since you mentioned that you work in the finance industry, could you start an end-to-end project series that covers the key aspects of working in finance? What are the most essential domain knowledge areas in the finance sector?

We’re excited to see more of your videos. Kudos to you, man

[cassidyhalpin]

Thank you for this 🙌🏻 this is what I struggled with most in my last module on my Masters course

[prashantbalodi]

Thank you Mo, you are a gem. I have learned so much through your videos. Thank you for all the efforts you put in making these videos i really appreciate you.

[BuildwithMark]

This is so informative. Thank you, Mo.

[rumeeburu]

Heading home now so I once I get home. I’d jump on this. Thanks Mo.

[rumeeburu]

I will always be happy to be among the first set of persons to see your videos

[omotoshotemitope]

Hello Mo Chen, thank you for simplifying this concept. I always look forward to your next video.

I have a couple of questions;
1. What is the disadvantage of the one to one relationship which you corrected? Also in an event something like that happens in a real project, is it better to leave it as a single table instead of breaking it down?

2. You said something that snowflake schema is a data model where some dimension tables have other dimension tables. How do we handle the data model a case where we have to actual fact tables capturing different events but they cannot be linked, and they are related?
For example, a purchase fact table and sales fact table that cannot be linked together but they are both needed to calculate the net profit.


Thank you.

[pillslifestylereviews]

Would have killed for this vid when I went for my PL300 :D

[preetshah]

Please make a video on customer churn analysis in tableau

[seanetho]

Great video, thanks for the information. Is anyone able to explain the key differences between a Star Schema and Snowflake Schema and their pros and cons related to the example provided in the video?

[RobertKillalea]

Hey Mo, really love the video. Hope this isn’t a dumb question (as I may not be understanding it correctly) but why split the gym’s original product data set into separate tables (dimension tables) to then model? If you’re just going to be doing it for visualizations can’t you just input the one original dataset as is (one document where you haven’t yet removed any columns) and just add the fields to the visualization you’d like? Or have I got it wrong and you were just creating dimension tables for the sake of the exercise? As normally dimension tables would have fields the fact table doesn’t have?

[MarjanR]

Hi Mo, first of all, thank you for your great advice, I was wondering if you have any mentorship program ? I would like to have a mentor as a guide for improving my skills that you teach them in your channel.

[rumeeburu]

Also can we get the dataset so we can try on our end?