Тёмный

Data Modeling (Star Schema 🌟) in Power BI - Creating Dimension Tables 

Pragmatic Works
Подписаться 221 тыс.
Просмотров 174 тыс.
50% 1

In this video we discuss the definition of a data model and focus our exploration around the Star Schema. We break down the specifics of what makes a Star Schema model and take a closer look at Fact tables and Dimension tables. At the end we walk through an example of creating a dimension table to help model efficiency!
If you enjoy this video or any of my other videos and are interested in formal training on DAX, Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Manuel30" to get an extra of 30% off at check out when purchasing our On-Demand Learning classes from pragmaticworks.com/pricing/ #ManuelQuintana
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/

Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️RU-vid: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
~-~~-~~~-~~-~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
• Free Power Apps Compon...
~-~~-~~~-~~-~

Опубликовано:

 

27 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 178   
@rokaskrisciunas6015
@rokaskrisciunas6015 8 дней назад
perfectly explained. Finally understood the concept
@ifyluv7402
@ifyluv7402 Год назад
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
@awarrentfa
@awarrentfa Год назад
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!
@PragmaticWorks
@PragmaticWorks Год назад
Awesome, thank you!
@glengarner4566
@glengarner4566 Год назад
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.
@akshaykalamkar304
@akshaykalamkar304 2 года назад
OMG, this is the topic I am searching from 10 days. very well expalained
@yutianwanggg
@yutianwanggg Год назад
This is extremely helpful! Thank you so much for making such a good interpretation of how data schema works in PowerBI!
@nazirkulovbotir6491
@nazirkulovbotir6491 Год назад
You are a lifesaver. This is essential for building DWH from scratch. Thank you.
@Ryiah87
@Ryiah87 2 года назад
First time I've seen query merging. It's really efficient. Thanks!
@ethanlecuona5557
@ethanlecuona5557 2 года назад
You're really good at explaining! Thank you for being so awesome!
@PragmaticWorks
@PragmaticWorks 2 года назад
We appreciate that. Thanks for watching!
@devun1248
@devun1248 2 года назад
Short, Clear, Precise. You are awesome! Keep it up
@mauriceprice4211
@mauriceprice4211 Год назад
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!
@PragmaticWorks
@PragmaticWorks Год назад
Thank you!
@kkpw12
@kkpw12 5 месяцев назад
this is I love. Actual example and not just slide show of pictures and theory.
@yolanizitumane4993
@yolanizitumane4993 2 года назад
One of the best PowerBi videos on RU-vid. Thanks Sir.
@nolann2763
@nolann2763 2 года назад
You are a great teacher. Taking the complex and making it simple is a great trait to have.
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad you enjoyed!
@carltonpatterson5539
@carltonpatterson5539 2 года назад
Absolutely excellent talk ... truly well delivered. I love the passion
@PragmaticWorks
@PragmaticWorks 2 года назад
Much appreciated!
@TraceyOsbornHR
@TraceyOsbornHR 2 года назад
Excellent information!! Thank you!!!
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad you enjoyed :)
@baneledludlu7983
@baneledludlu7983 Год назад
Thank you so much this is helpful
@PragmaticWorks
@PragmaticWorks Год назад
You're so welcome!
@shoboyjr
@shoboyjr 2 месяца назад
This is really good! Thank you very much!
@Avenger24601
@Avenger24601 2 года назад
Manuel, this was so useful. Thank you! I like how you present.
@mosesakwagiobe4438
@mosesakwagiobe4438 Год назад
great video, well explained and straight to the point.
@davidmanoraj6274
@davidmanoraj6274 Год назад
Awesome 🎉 thanks
@PragmaticWorks
@PragmaticWorks Год назад
You’re welcome 😊
@joseluisbeltramone599
@joseluisbeltramone599 2 года назад
Awesome video, Manuel. Thank you very much for sharing your knowledge!
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad you enjoyed!
@olusolaokuboyejo7291
@olusolaokuboyejo7291 Год назад
Thanks so much for making this topic easy to understand.
@PragmaticWorks
@PragmaticWorks Год назад
Glad it was helpful!
@iamtrapped1
@iamtrapped1 2 года назад
Great video
@PragmaticWorks
@PragmaticWorks 2 года назад
Thank you! Glad you liked it.
@naojamg
@naojamg 2 года назад
this video is a masterpiece!! thank you very much 🤓
@muftau7
@muftau7 2 года назад
Very good explanation
@robertomarra2431
@robertomarra2431 9 месяцев назад
Amazing job Manuel, really appreciate it
@rahulrd2713
@rahulrd2713 2 года назад
very clear and informative. thanks
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad you found this helpful!
@eligorniak9699
@eligorniak9699 11 месяцев назад
Amazing explanation! Thank you!
@jessicaperez3746
@jessicaperez3746 Год назад
This is amazing, was able to apply immediately and get a better more efficient product. Thanks!
@PragmaticWorks
@PragmaticWorks Год назад
Glad it was helpful!
@jerrychen8715
@jerrychen8715 Год назад
That's amazing video that getting me thru the basic of the data schema, short but very precise.
@tahirhanif9669
@tahirhanif9669 9 месяцев назад
Excellent presentation, thank you
@BrettGroneman
@BrettGroneman 2 года назад
Fantastic job teaching this. Super helpful for me trying to figure out this tool.
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad you enjoyed!
@BikerDad40
@BikerDad40 2 года назад
Excellent video, explained very well Start schema and normalizing table, very knowledgeable video. Great job!
@PragmaticWorks
@PragmaticWorks 2 года назад
Than kyou for your kind words! Glad you enjoyed it.
@stevieboyProductions
@stevieboyProductions 2 года назад
Great video, I've definitely learned something today. Thank you for this tutorial, I'll be looking to implement this going forward
@PragmaticWorks
@PragmaticWorks Год назад
Glad you enjoyed!
@mantasgustas1352
@mantasgustas1352 Год назад
one of the best one I seen so far
@ItsWithinYou
@ItsWithinYou 2 года назад
Awesome!
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad you enjoyed!
@fennecfennec5234
@fennecfennec5234 2 года назад
brilliant demonstration Thank you so much
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad you enjoyed it!
@4nyone
@4nyone Год назад
Really nicely explained, this is going to help me clean up my messy models for sure.
@PragmaticWorks
@PragmaticWorks Год назад
Great to hear!
@bensix6496
@bensix6496 2 года назад
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!!
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad to hear it!
@kidssongs6542
@kidssongs6542 2 года назад
Thank you so much!, truly helpful!
@marceljohnson5783
@marceljohnson5783 Месяц назад
Simple effective, thank you so much.
@ahsanali50
@ahsanali50 Год назад
Awesome Work Sir !! Thank you for the value provided . Subscribed !! ☺️
@PragmaticWorks
@PragmaticWorks Год назад
Thank you!
@mirelatamaokigiraldini9989
@mirelatamaokigiraldini9989 Год назад
Excellent video! Thank you so much for this Manuel, just subscribed because of this video. Thanks a lot!
@PragmaticWorks
@PragmaticWorks Год назад
Glad it was helpful!
@EllaXu-ge7hf
@EllaXu-ge7hf 2 месяца назад
Thank you so much for this Dim in PowerBI
@phenposothea4892
@phenposothea4892 2 года назад
Thanks!
@PragmaticWorks
@PragmaticWorks 2 года назад
You're welcome!
@advent7324
@advent7324 2 года назад
Great Video Manuel, and logic really well explained. :)
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad you liked it!
@wuajaz91
@wuajaz91 Год назад
if you want to understand what is star schema and how to use id in pbi, this video is for your you.
@shivappas8432
@shivappas8432 Год назад
Thank You
@PragmaticWorks
@PragmaticWorks Год назад
You're welcome!
@paulobuenobruno3423
@paulobuenobruno3423 7 месяцев назад
Great video, thanks!
@PragmaticWorks
@PragmaticWorks 7 месяцев назад
Glad you liked it!
@RenataOliveira-dw1vl
@RenataOliveira-dw1vl 2 года назад
Very helpful! Thanks a lot.
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad it was helpful!
@ae7786
@ae7786 Год назад
Great video Manual. This information is going to help me tremendously! 😀
@PragmaticWorks
@PragmaticWorks Год назад
Glad it was helpful!
@aziiserak8863
@aziiserak8863 2 года назад
well explained thx
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad you found it helpful :)
@chandrasekhar1883
@chandrasekhar1883 2 года назад
Powerful explanation.💯
@PragmaticWorks
@PragmaticWorks Год назад
Thanks for watching!
@Cebuanoontwowheels
@Cebuanoontwowheels 2 года назад
Thank you very much sir!!!
@PragmaticWorks
@PragmaticWorks 2 года назад
Most welcome!
@GiaiPhapXP
@GiaiPhapXP 2 года назад
Great! Thanks.
@Adin7785
@Adin7785 2 года назад
Awesome! Great job explaining the value of normalized data.
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad you enjoyed it!
@lilpandacub
@lilpandacub 2 года назад
Learned so much
@adrianfuhrer5832
@adrianfuhrer5832 7 месяцев назад
Perfect! Thanks!
@oscarrosalescorzo
@oscarrosalescorzo 2 года назад
Excelent
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad you enjoyed :)
@richardgavatin2592
@richardgavatin2592 Год назад
Excellent - thanks!
@simonnalleey7547
@simonnalleey7547 2 года назад
Love your videos, informative and entertaining. Question though: if a new category were added to the data, wouldn't that potentially break the indexing that appears to be tied to the ascending sort step? And potentially shift all the index keys and royally mess up the data model? I guess I am unsure how the incremental index step works.
@rachelrdh5671
@rachelrdh5671 7 месяцев назад
AMAZING tutorial
@RedCloudServices
@RedCloudServices 4 месяца назад
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!
@iamthemoss
@iamthemoss 11 месяцев назад
Good job, great explanation.
@barryjorden1145
@barryjorden1145 2 года назад
Excellent video!
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad you enjoyed!
@shawnebrown
@shawnebrown 2 года назад
Fantastic video. Thank you. Would be very interested in knowing what you were going to do with the Geo Dim.
@AbadllahDeBourgogne
@AbadllahDeBourgogne Год назад
Great tutotial, very instructive.
@PragmaticWorks
@PragmaticWorks Год назад
Glad it was helpful!
@lpdowdell
@lpdowdell 4 месяца назад
I love Manuel!
@Manojprapagar
@Manojprapagar Год назад
Amazing video
@waltherziemerink
@waltherziemerink 2 месяца назад
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
@parastoomousavi8847
@parastoomousavi8847 Год назад
perfect. thanks
@francisjohn6638
@francisjohn6638 2 года назад
It's awesome
@PragmaticWorks
@PragmaticWorks 2 года назад
Thank you!!
@mirdhapuneet
@mirdhapuneet 2 года назад
superb
@jilalumustefa2276
@jilalumustefa2276 Год назад
no comment only appreciated 100% for great JOB
@ramielhag2284
@ramielhag2284 Год назад
Perfect!! Thanks
@PragmaticWorks
@PragmaticWorks Год назад
Glad it helped!
@fadwa2413
@fadwa2413 2 года назад
perfect!! Thanks a lot Keep going Please
@PragmaticWorks
@PragmaticWorks 2 года назад
We will!
@jayong2370
@jayong2370 Год назад
That was great. Thank you.
@PragmaticWorks
@PragmaticWorks Год назад
Glad you enjoyed it!
@juantray
@juantray Год назад
Good stuff, bro! 🤌🏽
@PragmaticWorks
@PragmaticWorks Год назад
Appreciate it!!
@stevanmomcilovic4469
@stevanmomcilovic4469 Год назад
Good explanation.
@PragmaticWorks
@PragmaticWorks Год назад
Glad it was helpful!
@kevdo6333
@kevdo6333 9 месяцев назад
Thanks dear
@anitachacko8006
@anitachacko8006 9 месяцев назад
Thank u❤
@mercydabbs3330
@mercydabbs3330 2 года назад
Thank you!!!!
@PragmaticWorks
@PragmaticWorks 2 года назад
You're welcome!
@mercydabbs3330
@mercydabbs3330 2 года назад
@@PragmaticWorks I have a challenge of identifying the grain of a dataset, please where can I find your video on this?
@gerryboie
@gerryboie Год назад
Hey Manuel, thank you for making this video. One thing I would like to ask, if the star schema had been modelled in the database but the surrogate keys are not numeric as you would normally expect, can this be utilised directly in PowerBI or do we need to create unique IDs within PowerBI? Are there any performance issues using non-numeric surrogate keys?
@xMastJedi
@xMastJedi 2 года назад
DIM tables. MOST Important part of data in model.
@vsone9565
@vsone9565 2 года назад
Great video!! Incredibly insightful and very practical explanation on how to create dimension tables. I'm trying to replicate the same but in this case it's requesting me to change from directquery to Import - is it expected to work from this mode?
@manuelquintana2225
@manuelquintana2225 2 года назад
Yes, as working with a Direct Query connection does have limitations on what you can do within the power query editor. As soon as you go past those limitation you get the message that if you would like to continue you must switch to import. This same conversation we have in this video is what IT would have with the upstream data source and quite often this should be implemented at the source system when possible. Here we are just showing that it is possible
@tMub365
@tMub365 2 года назад
So easy on the ears
@PragmaticWorks
@PragmaticWorks 2 года назад
Glad to hear it!
@babulthegreat4834
@babulthegreat4834 Год назад
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!
@deniseortiz8567
@deniseortiz8567 2 года назад
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!
@user-kr9wv4ex3g
@user-kr9wv4ex3g 7 месяцев назад
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!
@janwillemvanholst
@janwillemvanholst 2 года назад
In my view the most important argument for modelling (quoting Ferrari/Russo): 'if you fix the model, the formula becomes easy to author and understand'
@ankitacs7
@ankitacs7 2 года назад
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 ?
@excelrati
@excelrati 2 года назад
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.
@norpriest521
@norpriest521 2 года назад
Thank you. Do you have video tutorial for a little more complex dimensional modeling where there are more than multiple fact tables and multiple dim tables?
@mubarbianalytics
@mubarbianalytics Год назад
This is what I'm facing through now, please can you help with this tutorial?
@patrickbcox
@patrickbcox 2 года назад
Thanks for sharing. I enjoyed your video. I do have a question. Is normalization really that important for a dimension table that will generally have relatively fewer record than your fact tables? And then I thought that adding the filter layers in a snowflake vs star schema can have a negative impact on model performance. What are your thoughts on this? Thanks again.
@dawidgrzeskow987
@dawidgrzeskow987 2 года назад
Have in mind that you are on reporting side of the process, your goal is to provide easy to use and access report, do this changes affect the performence? Yes, they are, so if you see that your transformation is to costly you have to change your approach or push these changes on lower level (Data Warehouse). On the other hand what is the cost of looking just for performence? Well, have you ever had task to change huge report with not clear data model? If you didn't I'll tell you it's hell.
@dizzyharris2658
@dizzyharris2658 2 года назад
Scenario Question: I'm pulling in data from a ITSM solution in which they use a 20 character alpha-numeric key for each validated attribute across all their tables. In most cases the Key has more characters than the text attribute. After watching this video, is it safe to say that I should just create my own keys, even though the fact and dim tables exist?
@sunenielsen2686
@sunenielsen2686 6 месяцев назад
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???
@ashutoshgadgil8407
@ashutoshgadgil8407 11 месяцев назад
Hello, for anyone who has worked on data modelling; Can we apply similar steps when the scheduled update is switched on and all of Dimension tables needs to be created in in Business Client Project scenario, or Should we inform data engineering team to create these tables in backend?
@user-ip3fr3lp4r
@user-ip3fr3lp4r Год назад
Just to clarify: the redundancy in denormalized tables is not a problem in columnar storages (most of modern DWs)
@mattmatt245
@mattmatt245 2 года назад
Could you give some examples of sql queries, which would be difficult to write against transnational (relational) database but are fairly easy with star schema ?
@manuelquintana2225
@manuelquintana2225 2 года назад
Hello Matt, In this video we took the approach and idea of starting with a de-normalized flattened out table and seeing the benefits of moving to a star schema by normalizing the data into facts and dimensions. When talking about pulling data from OLTP DB you generally need to go the other direction and go through a process of de-normalization because generally you have multiple tables that contain attributes for a table that would ultimately be your dimension (e.g. various different tables that hold different attributes for customers that are important). Because you have various table that need to be brought together the common item which can degrade performance is having more and more join statements needed, this is how the SQL can become more complicated. Yours is a rather large question but hopefully my short answer helps
@mattmatt245
@mattmatt245 2 года назад
@@manuelquintana2225 Do you know where I can find some examples of how it's done ?
@cavemanworld5019
@cavemanworld5019 2 года назад
if you keep the product category inside the product table, the model is a perfect star schema. Is there any reason to normalise the product table in a kind of data warehouse?
@mcnater
@mcnater 2 года назад
no there really isn't...no real need to snowflake in most cases.
@tkjlochmandy7112
@tkjlochmandy7112 Год назад
great video, but I have a question... The steps to the solution make sense, but how do you aggregate the facts by category segment when your relationship generalizes at the product level? Am I missing a step? Is the catsegment just used as a relational component vs a true dimension?
@manuelquintana2225
@manuelquintana2225 Год назад
The nature of the relationship between the newly created CatSegDim and ProductDim allows filters to pass from CatSegDim through ProductDim all the way to the Fact table easily allowing us to slice up our metrics in the Fact table by those category segments. As well be branching out that ProductDim the way we did we now have a more efficient column for storage in the CatSegID column within the ProductDim table.
@tkjlochmandy7112
@tkjlochmandy7112 Год назад
@@manuelquintana2225 so we need to move the cat segment Id to the fact level, I think I missed that. Thank you for replying, very helpful 😄
Далее
Return Working Days in Power BI using DAX
16:28
Просмотров 5 тыс.
Fact & Dimension tables in Power BI | Data Modelling
15:07
Игровой Комп с Авито за 4500р
01:00
Recycled Car Tyres Get a Second Life! ♻️
00:58
Просмотров 3,5 млн
LISA - ROCKSTAR (MV Teaser)
00:10
Просмотров 10 млн
Nick's Power BI Tricks - Data Modeling Edition
17:54
Просмотров 4,8 тыс.
Advanced Power BI: Solving the Hard Problems
1:00:26
Просмотров 125 тыс.
Power BI Masterclass: Data Modeling 101
56:54
Просмотров 53 тыс.
Why Power BI loves a Star Schema
8:10
Просмотров 122 тыс.
Designing Your Data Warehouse from the Ground Up
1:01:21
Просмотров 150 тыс.
Advanced Power BI Takeover!
2:56:16
Просмотров 176 тыс.
Игровой Комп с Авито за 4500р
01:00