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.
I’m interested in data analysis, but I haven’t studied Power BI yet. I often feel unmotivated when studying data analysis with the power bi, but after watching your video, I’m excited to start with Power BI. Thank you for explaining things in detail . Thank you so much
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 UA-cam videos and also your videos. Thank you very much!
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 :)
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.
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
I have some new projects in the form of the Ultimate Excel Projects that I'm launching very soon. They will contain finance case studies. Keep an eye out for the projects.
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.
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.
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?
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?
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.
I do have a mentorship program but it is only for the people who are inside the Mo Chen data analysis community. You can join the community through my website at mochen.info. I believe you've already done this.
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.
Glad it was helpful!
I’m interested in data analysis, but I haven’t studied Power BI yet. I often feel unmotivated when studying data analysis with the power bi, but after watching your video, I’m excited to start with Power BI. Thank you for explaining things in detail . Thank you so much
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 UA-cam videos and also your videos. Thank you very much!
I just started a new job and requires alot of data modelling, which this video came in handy. Thank you Mo!
Ivan
Glad it was helpful!
This is great. Behind the fancy words are really simple concepts! Thanks for making it easy to understand
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 :)
Glad it was helpful!
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.
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
I have some new projects in the form of the Ultimate Excel Projects that I'm launching very soon. They will contain finance case studies. Keep an eye out for the projects.
Thank you for this 🙌🏻 this is what I struggled with most in my last module on my Masters course
Glad it was helpful!
Love these kinds of videos ty 🥰
You and I both haha
Heading home now so I once I get home. I’d jump on this. Thanks Mo.
I will always be happy to be among the first set of persons to see your videos
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.
Thanks so much for your kind words and your support!
Nicely done Mo!!!
Glad you liked it!
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.
This is so informative. Thank you, Mo.
Glad it was helpful!
Great Video Mo!
Glad you enjoyed it
You got a new subscriber!
Welcome to the channel!
Would have killed for this vid when I went for my PL300 :D
At least now you know. Better late than never!
Please make a video on customer churn analysis in tableau
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?
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?
In the snowflake schema can the order of relationship in the products table not be, products->categories->subcategories?
Also can we get the dataset so we can try on our end?
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.
I do have a mentorship program but it is only for the people who are inside the Mo Chen data analysis community. You can join the community through my website at mochen.info. I believe you've already done this.
thanks.