I have watched so many videos about the star schema concept, but this is the very first video I've seen to actually walk me through how to actually normalize a denormalized table of data. THANK YOU, Manuel. I feel like I finally get it now!
Agreed, this was a great video to share with my new Power BI expert-in-training. It's always been the one concept that I feel like is criminally underexplained, either ignoring it entirely, talking too high-level, or assuming you already know how to do it. And other guides use DAX which... is not what you're supposed to do when you're building the starting model. Useful to visualizing the idea, but not for practically doing it. This Power Query-based video is perfect.
Thank you very much for this great explanation. Almost all the other videos only lightly touch this area without going into the depth of it. This video has the right balance of simplicity and depth. thanks again.
Hey Manuel, thanks for making a mystery into something that I can use today! If only all tutorials were this straight forward to understand. Nice work!
Such a great video and instructor. I've always struggled with modeling with star schemas but this makes so much sense and I'm sure I'll come back for when I need a reference. Thank you!
Fantastic video. Thanks! I understand modelling, but am new to PowerBi and have been pulling my hair out on how to normalise data. This was everything I needed. ❤
Man that was a very good video, very visual and nicely explained not too much info so I could relate and think about my own problematics and how it ties at the same time.. you have a new subscriber!!
Hi thanks for the video! Great summary! At 12:09 for Denormalized Tables it lists "Best for increasing the spee of data search and analysis" on the slide but I interepret from what you are saying, the opposite. Can you exlplain the statement on slide a bit more please? Thank you!
Thanks for sharing the video. I was able to create a star schema with my data by following along. Do you have a video where you show how to use the star schema tables and create visuals with them? I am trying to recreate visuals I had made before star schema vs with star schema and my visuals are coming out very differently. Bar charts with data in x and y axis along with the legend. Thanks!
Great video, however this aligns more with a traditional multidimensional model (snowflake). PowerBi is optimized to work with a tabular model which is more denormalized in nature. I think our response to introduce snowflake stems more from our bias towards DB design than dimensional modeling. Both will work though and you provided a great lecture
You have mentioned that star schema is about getting things normalized but Data Bricks suggests this: Star schemas denormalize the data, which means adding redundant columns to some dimension tables to make querying and working with the data faster and easier. The purpose is to trade some redundancy (duplication of data) in the data model for increased query speed, by avoiding computationally expensive join operations. Bit confused.
I wish Power BI could integrate with a GraphQL spec or something like it. Where the query is the model and no need to manage relationships. However love your video and thank you!
Thank you! Very helpful video when beginning my Power BI adventure and want to apply good Power BI data models. However, one thing keeps me awake at night - - but I hope there is no reason for that other than my lack of knowledge - - well, the thing is, now that I have done all the normalisation in Power BI, data is organised very different from my starting point - - so will Power BI still be able to recognize the original data set from Excel that I will continue to use as a datasource, and what if I did make changes in my Excel datasourse - how should I apply these changes in Power BI If I eg added an extra column in my Excel model???
Thanks for explaining! have a question, if a new category segment is added in the productdim table at the database level then how that will be reflected in the categorydim table which is created in power bi ?
In this video, dimensions are created dynamically in each refresh based on the original sales table of sales. So, if the new category shows up in any sale, the new category will be picked up by the query that creates the dimension of categories.
I have watched so many videos about the star schema concept, but this is the very first video I've seen to actually walk me through how to actually normalize a denormalized table of data. THANK YOU, Manuel. I feel like I finally get it now!
Awesome, thank you!
Agreed, this was a great video to share with my new Power BI expert-in-training. It's always been the one concept that I feel like is criminally underexplained, either ignoring it entirely, talking too high-level, or assuming you already know how to do it. And other guides use DAX which... is not what you're supposed to do when you're building the starting model. Useful to visualizing the idea, but not for practically doing it. This Power Query-based video is perfect.
Thank you very much for this great explanation. Almost all the other videos only lightly touch this area without going into the depth of it. This video has the right balance of simplicity and depth. thanks again.
Short, Clear, Precise.
You are awesome! Keep it up
I was confused because the basic star schema tutorials weren't giving me what I want but this video just solved my problem. Thank you
OMG, this is the topic I am searching from 10 days. very well expalained
This is extremely helpful! Thank you so much for making such a good interpretation of how data schema works in PowerBI!
this is I love. Actual example and not just slide show of pictures and theory.
Thank you so much for this. I got it the moment you explained with the demo.
Hey Manuel, thanks for making a mystery into something that I can use today! If only all tutorials were this straight forward to understand. Nice work!
Thank you!
You're really good at explaining! Thank you for being so awesome!
We appreciate that. Thanks for watching!
Thanks so much for making this topic easy to understand.
Glad it was helpful!
You are a lifesaver. This is essential for building DWH from scratch. Thank you.
Such a great video and instructor. I've always struggled with modeling with star schemas but this makes so much sense and I'm sure I'll come back for when I need a reference. Thank you!
one of the best one I seen so far
First time I've seen query merging. It's really efficient. Thanks!
You are a great teacher. Taking the complex and making it simple is a great trait to have.
Glad you enjoyed!
One of the best PowerBi videos on TH-cam. Thanks Sir.
Nice work explaining this, thank you.
thank you, I finally got it. It was very clear explanation!
That's amazing video that getting me thru the basic of the data schema, short but very precise.
This is amazing, was able to apply immediately and get a better more efficient product. Thanks!
Glad it was helpful!
Fantastic job teaching this. Super helpful for me trying to figure out this tool.
Glad you enjoyed!
great video, well explained and straight to the point.
Great job! This was so easy to understand, appreciate the video!
Fantastic video. Thanks! I understand modelling, but am new to PowerBi and have been pulling my hair out on how to normalise data. This was everything I needed. ❤
i love you , have you onlyfans?
perfectly explained. Finally understood the concept
Excellent information!! Thank you!!!
Glad you enjoyed :)
Excellent video! Thank you so much for this Manuel, just subscribed because of this video. Thanks a lot!
Glad it was helpful!
very clear and informative. thanks
Glad you found this helpful!
brilliant demonstration Thank you so much
Glad you enjoyed it!
Really nicely explained, this is going to help me clean up my messy models for sure.
Great to hear!
Very good explanation
Great video Manual. This information is going to help me tremendously! 😀
Glad it was helpful!
This is really good! Thank you very much!
Amazing job Manuel, really appreciate it
Great tutotial, very instructive.
Glad it was helpful!
Great Video Manuel, and logic really well explained. :)
Glad you liked it!
Amazing explanation! Thank you!
Excellent presentation, thank you
Powerful explanation.💯
Thanks for watching!
Awesome video, Manuel. Thank you very much for sharing your knowledge!
Glad you enjoyed!
Great video, I've definitely learned something today. Thank you for this tutorial, I'll be looking to implement this going forward
Glad you enjoyed!
Manuel, this was so useful. Thank you! I like how you present.
Thank you for this video!
Liked and subscribed. Excellent tutorial.
Excellent video!
Glad you enjoyed!
Good job, great explanation.
Thank you so much for this Dim in PowerBI
Good explanation.
Glad it was helpful!
Man that was a very good video, very visual and nicely explained not too much info so I could relate and think about my own problematics and how it ties at the same time.. you have a new subscriber!!
Glad to hear it!
Absolutely excellent talk ... truly well delivered. I love the passion
Much appreciated!
Very helpful! Thanks a lot.
Glad it was helpful!
Simple effective, thank you so much.
Awesome Work Sir !! Thank you for the value provided . Subscribed !! ☺️
Thank you!
no comment only appreciated 100% for great JOB
Great video
Thank you! Glad you liked it.
Thank you so much this is helpful
You're so welcome!
this video is a masterpiece!! thank you very much 🤓
Thank you so much!, truly helpful!
Really helpful awesome! Thank you very much.
You're very welcome!
I love Manuel!
Perfect!! Thanks
Glad it helped!
Amazing video
Good stuff, bro! 🤌🏽
Appreciate it!!
Great video, thanks!
Glad you liked it!
This guy is amazing.
We think so!
Excellent - thanks!
That was great. Thank you.
Glad you enjoyed it!
Is there an excel file corresponding to the one used in the video that I can follow along with?
well explained thx
Glad you found it helpful :)
Awesome 🎉 thanks
You’re welcome 😊
Thank you very much sir!!!
Most welcome!
Awesome!
Glad you enjoyed!
AMAZING tutorial
Thanks!
You're welcome!
This was extremely helpful! Is this how I would tie in a date table, as well? Merge with the date table then delete the original columns? Thanks!
Hi thanks for the video! Great summary! At 12:09 for Denormalized Tables it lists "Best for increasing the spee of data search and analysis" on the slide but I interepret from what you are saying, the opposite. Can you exlplain the statement on slide a bit more please? Thank you!
Thank You
You're welcome!
Thanks for sharing the video. I was able to create a star schema with my data by following along. Do you have a video where you show how to use the star schema tables and create visuals with them? I am trying to recreate visuals I had made before star schema vs with star schema and my visuals are coming out very differently. Bar charts with data in x and y axis along with the legend. Thanks!
Great! Thanks.
It's awesome
Thank you!!
Great video, however this aligns more with a traditional multidimensional model (snowflake). PowerBi is optimized to work with a tabular model which is more denormalized in nature. I think our response to introduce snowflake stems more from our bias towards DB design than dimensional modeling. Both will work though and you provided a great lecture
Learned so much
perfect!!
Thanks a lot
Keep going Please
We will!
You have mentioned that star schema is about getting things normalized but Data Bricks suggests this:
Star schemas denormalize the data, which means adding redundant columns to some dimension tables to make querying and working with the data faster and easier. The purpose is to trade some redundancy (duplication of data) in the data model for increased query speed, by avoiding computationally expensive join operations.
Bit confused.
Awesome! Great job explaining the value of normalized data.
Glad you enjoyed it!
if you want to understand what is star schema and how to use id in pbi, this video is for your you.
I wish Power BI could integrate with a GraphQL spec or something like it. Where the query is the model and no need to manage relationships. However love your video and thank you!
perfect. thanks
Thank you so much
Thank you! Very helpful video when beginning my Power BI adventure and want to apply good Power BI data models. However, one thing keeps me awake at night - - but I hope there is no reason for that other than my lack of knowledge - - well, the thing is, now that I have done all the normalisation in Power BI, data is organised very different from my starting point - - so will Power BI still be able to recognize the original data set from Excel that I will continue to use as a datasource, and what if I did make changes in my Excel datasourse - how should I apply these changes in Power BI If I eg added an extra column in my Excel model???
superb
Thanks for explaining! have a question, if a new category segment is added in the productdim table at the database level then how that will be reflected in the categorydim table which is created in power bi ?
In this video, dimensions are created dynamically in each refresh based on the original sales table of sales.
So, if the new category shows up in any sale, the new category will be picked up by the query that creates the dimension of categories.
Fantastic video. Thank you. Would be very interested in knowing what you were going to do with the Geo Dim.
@Future Me : 16:17 is the timecode you'll look for for actually creating DimTables from Facts
Thanks dear
DIM tables. MOST Important part of data in model.
Thank you!!!!
You're welcome!
@@PragmaticWorks I have a challenge of identifying the grain of a dataset, please where can I find your video on this?
Thank u❤
Excelent
Glad you enjoyed :)