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

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024

Комментарии • 187

  • @Jad-m5f
    @Jad-m5f 10 дней назад

    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!

  • @awarrentfa
    @awarrentfa 2 года назад +33

    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  2 года назад +1

      Awesome, thank you!

    • @glengarner4566
      @glengarner4566 Год назад +1

      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.

  • @ifyluv7402
    @ifyluv7402 Год назад +1

    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

  • @devun1248
    @devun1248 2 года назад +4

    Short, Clear, Precise.
    You are awesome! Keep it up

  • @akshaykalamkar304
    @akshaykalamkar304 2 года назад +1

    OMG, this is the topic I am searching from 10 days. very well expalained

  • @yutianwanggg
    @yutianwanggg Год назад +12

    This is extremely helpful! Thank you so much for making such a good interpretation of how data schema works in PowerBI!

  • @kkpw12
    @kkpw12 7 месяцев назад

    this is I love. Actual example and not just slide show of pictures and theory.

  • @ethanlecuona5557
    @ethanlecuona5557 2 года назад +21

    You're really good at explaining! Thank you for being so awesome!

    • @PragmaticWorks
      @PragmaticWorks  2 года назад

      We appreciate that. Thanks for watching!

  • @johnorourke7693
    @johnorourke7693 11 дней назад

    Great job! This was so easy to understand, appreciate the video!

  • @Ryiah87
    @Ryiah87 2 года назад +5

    First time I've seen query merging. It's really efficient. Thanks!

  • @nazirkulovbotir6491
    @nazirkulovbotir6491 Год назад +1

    You are a lifesaver. This is essential for building DWH from scratch. Thank you.

  • @GPZ_Biker
    @GPZ_Biker Месяц назад

    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. ❤

  • @mauriceprice4211
    @mauriceprice4211 2 года назад +6

    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!

  • @yolanizitumane4993
    @yolanizitumane4993 2 года назад

    One of the best PowerBi videos on RUclips. Thanks Sir.

  • @nolann2763
    @nolann2763 2 года назад +1

    You are a great teacher. Taking the complex and making it simple is a great trait to have.

  • @wuajaz91
    @wuajaz91 Год назад +1

    if you want to understand what is star schema and how to use id in pbi, this video is for your you.

  • @rokaskrisciunas6015
    @rokaskrisciunas6015 2 месяца назад

    perfectly explained. Finally understood the concept

  • @olusolaokuboyejo7291
    @olusolaokuboyejo7291 2 года назад +1

    Thanks so much for making this topic easy to understand.

  • @jessicaperez3746
    @jessicaperez3746 Год назад +1

    This is amazing, was able to apply immediately and get a better more efficient product. Thanks!

  • @BrettGroneman
    @BrettGroneman 2 года назад +1

    Fantastic job teaching this. Super helpful for me trying to figure out this tool.

  • @TraceyOsbornHR
    @TraceyOsbornHR 2 года назад +1

    Excellent information!! Thank you!!!

  • @mantasgustas1352
    @mantasgustas1352 Год назад

    one of the best one I seen so far

  • @mosesakwagiobe4438
    @mosesakwagiobe4438 Год назад +1

    great video, well explained and straight to the point.

  • @jaitoddja
    @jaitoddja Месяц назад +1

    Great video

  • @muftau7
    @muftau7 2 года назад +1

    Very good explanation

  • @fennecfennec5234
    @fennecfennec5234 2 года назад +1

    brilliant demonstration Thank you so much

  • @rahulrd2713
    @rahulrd2713 2 года назад +1

    very clear and informative. thanks

  • @shoboyjr
    @shoboyjr 4 месяца назад +1

    This is really good! Thank you very much!

  • @4nyone
    @4nyone Год назад +1

    Really nicely explained, this is going to help me clean up my messy models for sure.

  • @jerrychen8715
    @jerrychen8715 Год назад

    That's amazing video that getting me thru the basic of the data schema, short but very precise.

  • @michaelosadebe6418
    @michaelosadebe6418 Месяц назад

    This guy is amazing.

  • @xMastJedi
    @xMastJedi 2 года назад

    DIM tables. MOST Important part of data in model.

  • @ae7786
    @ae7786 2 года назад +1

    Great video Manual. This information is going to help me tremendously! 😀

  • @EllaXu-ge7hf
    @EllaXu-ge7hf 3 месяца назад

    Thank you so much for this Dim in PowerBI

  • @waltherziemerink
    @waltherziemerink 4 месяца назад

    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

  • @chandrasekhar1883
    @chandrasekhar1883 2 года назад +1

    Powerful explanation.💯

  • @ItsWithinYou
    @ItsWithinYou 2 года назад +1

    Awesome!

  • @joseluisbeltramone599
    @joseluisbeltramone599 2 года назад +1

    Awesome video, Manuel. Thank you very much for sharing your knowledge!

  • @phenposothea4892
    @phenposothea4892 2 года назад +1

    Thanks!

  • @mirelatamaokigiraldini9989
    @mirelatamaokigiraldini9989 2 года назад +1

    Excellent video! Thank you so much for this Manuel, just subscribed because of this video. Thanks a lot!

  • @Cebuanoontwowheels
    @Cebuanoontwowheels 2 года назад +1

    Thank you very much sir!!!

  • @RenataOliveira-dw1vl
    @RenataOliveira-dw1vl 2 года назад +1

    Very helpful! Thanks a lot.

  • @carltonpatterson5539
    @carltonpatterson5539 2 года назад +2

    Absolutely excellent talk ... truly well delivered. I love the passion

  • @advent7324
    @advent7324 2 года назад +1

    Great Video Manuel, and logic really well explained. :)

  • @stevieboyProductions
    @stevieboyProductions 2 года назад +1

    Great video, I've definitely learned something today. Thank you for this tutorial, I'll be looking to implement this going forward

  • @shivappas8432
    @shivappas8432 Год назад +1

    Thank You

  • @aziiserak8863
    @aziiserak8863 2 года назад +1

    well explained thx

  • @jilalumustefa2276
    @jilalumustefa2276 Год назад

    no comment only appreciated 100% for great JOB

  • @naojamg
    @naojamg 2 года назад +1

    this video is a masterpiece!! thank you very much 🤓

  • @RedCloudServices
    @RedCloudServices 6 месяцев назад

    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!

  • @davidmanoraj6274
    @davidmanoraj6274 Год назад +1

    Awesome 🎉 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'

  • @robertomarra2431
    @robertomarra2431 11 месяцев назад

    Amazing job Manuel, really appreciate it

  • @Avenger24601
    @Avenger24601 2 года назад

    Manuel, this was so useful. Thank you! I like how you present.

  • @paulobuenobruno3423
    @paulobuenobruno3423 9 месяцев назад

    Great video, thanks!

  • @barryjorden1145
    @barryjorden1145 2 года назад +1

    Excellent video!

  • @eligorniak9699
    @eligorniak9699 Год назад

    Amazing explanation! Thank you!

  • @marceljohnson5783
    @marceljohnson5783 3 месяца назад

    Simple effective, thank you so much.

  • @AbdallahProgrammer
    @AbdallahProgrammer 28 дней назад

    Thank you so much

  • @tahirhanif9669
    @tahirhanif9669 11 месяцев назад

    Excellent presentation, thank you

  • @bensix6496
    @bensix6496 2 года назад +1

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

  • @GiaiPhapXP
    @GiaiPhapXP 2 года назад +1

    Great! Thanks.

  • @Manojprapagar
    @Manojprapagar Год назад +1

    Amazing video

  • @mirdhapuneet
    @mirdhapuneet 2 года назад +1

    superb

  • @lpdowdell
    @lpdowdell 6 месяцев назад

    I love Manuel!

  • @ramielhag2284
    @ramielhag2284 2 года назад +1

    Perfect!! Thanks

  • @AbadllahDeBourgogne
    @AbadllahDeBourgogne 2 года назад

    Great tutotial, very instructive.

  • @ahsanali50
    @ahsanali50 2 года назад +1

    Awesome Work Sir !! Thank you for the value provided . Subscribed !! ☺️

  • @parastoomousavi8847
    @parastoomousavi8847 Год назад

    perfect. thanks

  • @rachelrdh5671
    @rachelrdh5671 9 месяцев назад

    AMAZING tutorial

  • @juantray
    @juantray Год назад +1

    Good stuff, bro! 🤌🏽

  • @kevdo6333
    @kevdo6333 11 месяцев назад

    Thanks dear

  • @stevanmomcilovic4469
    @stevanmomcilovic4469 Год назад +1

    Good explanation.

  • @richardgavatin2592
    @richardgavatin2592 Год назад

    Excellent - thanks!

  • @adrianfuhrer5832
    @adrianfuhrer5832 9 месяцев назад

    Perfect! Thanks!

  • @iamthemoss
    @iamthemoss Год назад

    Good job, great explanation.

  • @baneledludlu7983
    @baneledludlu7983 Год назад +1

    Thank you so much this is helpful

  • @francisjohn6638
    @francisjohn6638 2 года назад +1

    It's awesome

  • @kidssongs6542
    @kidssongs6542 2 года назад

    Thank you so much!, truly helpful!

  • @fadwa2413
    @fadwa2413 2 года назад +1

    perfect!!
    Thanks a lot
    Keep going Please

  • @lilpandacub
    @lilpandacub 3 года назад +1

    Learned so much

  • @Adin7785
    @Adin7785 3 года назад +1

    Awesome! Great job explaining the value of normalized data.

  • @simonnalleey7547
    @simonnalleey7547 2 года назад +5

    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.

  • @mercydabbs3330
    @mercydabbs3330 2 года назад +1

    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?

  • @anitachacko8006
    @anitachacko8006 11 месяцев назад

    Thank u❤

  • @oscarrosalescorzo
    @oscarrosalescorzo 2 года назад +1

    Excelent

  • @jayong2370
    @jayong2370 2 года назад

    That was great. Thank you.

  • @user-ip3fr3lp4r
    @user-ip3fr3lp4r Год назад

    Just to clarify: the redundancy in denormalized tables is not a problem in columnar storages (most of modern DWs)

  • @shawnebrown
    @shawnebrown 2 года назад

    Fantastic video. Thank you. Would be very interested in knowing what you were going to do with the Geo Dim.

  • @tMub365
    @tMub365 3 года назад +1

    So easy on the ears

  • @ArnavMangla-m3b
    @ArnavMangla-m3b 4 дня назад +1

    Is there an excel file corresponding to the one used in the video that I can follow along with?

  • @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?

  • @ashutoshgadgil8407
    @ashutoshgadgil8407 Год назад

    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?

  • @sunenielsen2686
    @sunenielsen2686 7 месяцев назад

    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???

  • @user-kr9wv4ex3g
    @user-kr9wv4ex3g 9 месяцев назад

    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!

  • @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?

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

  • @heobingo
    @heobingo Год назад

    What if more data need to be added into fact tables after creating index column in dimension table, merging and cleaning the fact table, how can some one remember all of those index key for each combination?

  • @ankitacs7
    @ankitacs7 2 года назад +1

    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 года назад +1

      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.

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