Master Data Modeling in Power BI - Beginner to Pro Full Course

[@PragmaticWorks]

🔗 Student Files - prag.works/data-modeling-files 📃 Certificate of Completion - prag.works/data-modeling-certificate 📚 Power BI Cheat Sheet - pragmaticworks.com/resources/cheat-sheet/power-bi 📺 On-Demand Free Plan - prag.works/data-modeling-free-plan ✅ Survey - prag.works/10/24/survey

[@bradj229]

A video on the different Slowly Changing Dimension Types (0, 2, maybe 3) with examples in Power BI would be AWESOME!

[@jay_wright_thats_right]

That's simple as hell. Just read what SCD is. It's not rocket science.

[@RLawK12]

You explain everything so well. I felt like I was in class. This was extremely helpful

[@atulverma_]

Video is awesome, Great Explaination, Easy to Understand. I do believe that one more thing needs to added to these tutorial videos, that is, If while mentioning the table name and particular attribute, a simple hovering of cursor or any highlight can be done then that would be great. what happens is that it becomes difficult for the listener to catch up with the concepts while looking out for which table and column the tutor is talking about. Very subtle thing but i believe it will improve the attentiveness of the listener. Thanks for the awesome video.

[@ogra247]

Thanks for the opportunity. I've set my calendar waiting for the time.

[@markkendal5490]

Thank you, a superb session. I'm just starting on my Power BI journey but have over the years worked in SQL Server so this has been so very helpful. Thank you again.

[@terrylee2094]

Great channel: I have managed to persuade a UK government department to pay a subscription for 4 of us to trial for 12 months

[@yunteng7245]

Thank you for a great tutorial. Finally had time to finish it:) I would certainly want to have another session on slowly changing dimension. I am sure many organizations will find it helpful as we would have use case of Business Units changing due to reorg, pay rate changing due to CPI, etc.

[@mouctechy]

Wow I made it to the end! I needed to hear this! Thank you so much for this amazing course. Multiple facts will no longer confuse me!! I highly recommend this course!

[@shoboyjr]

I just watched this video after bookmarking it for some time. It's really well delivered and covers different realistic scenarios, which I found particularly helpful. So thanks a lot to the team. Much appreciated. My only question is regarding the methodology that you recommended for DAX (USERELATIONSHIP) to override the inactive relationship, while using this method, how can you create a slicer/filter based on the inactive relationship (e.g. Ship Date in this example). Is this a scenario where perhaps the multiple Date Tables trumps your recommended approach (DAX approach) or is there a way for this?

[@kasperselmar7747]

Thank you for this awesome course. I would definitely like to see how to build SD2. I feel like everybody talks about them, but no one shows how to implement them

[@emmanuelajoma1528]

Seconded. Slowly changing dimensions 2 is something I’d like to you as well!

[@adrianmoldovanbm]

Awesome course! Really want to know more, on how to implement those slowly changing dimensions in Power BI.

[@CuriousJo1122]

I just really wanted Mitchell to say "I was building data models before you were born!" hehe.. fun session and thank you so much for this great session!

[@CaraFang]

Thank you guys for pulling out this amazing training. I was pretty much following from the beginning until the Multi fact table. I found the Multi fact table part confusing. I really enjoyed Mitchell's teaching style. Really hope there'll be more tutorials from Mitchell regarding Mult fact table as well as the slowly changing dimensions!!

[@enochbishop8298]

Really liked the variety of examples that one could immediately apply in their own work to make better Data Models! Interested in exploring the Fabric side of this work going forward. Thanks for sharing the multiple resources and links!

[@carolinavisnadi]

I learnt a lot with the video, thank you. One question I have on creating relationships and not merging is: if I have an attribute that I want to see as it was in the point in time when I added the rows to the facts table, would the attribute keep updating for all entries, or just for the new ones? e.g. Client was a Small Business back in March 23, now it has grown and it is a Large business. Would I see the transactions from 2023 as a Small Business, and now transactions will be under Large Business bucket for the same client? I noticed that merging, it only applies again to the new facts added each month, but the downside is that the query gets very slow and heavy really quick.

[@carolinavisnadi]

I think what I am asking is what the guy below asked :) after googling 'Slowly Changing Dimension Types'

[@user-is6wi6iv9e]

Mitch can we get a data modeling course with the data in a microsoft sql server database ?

[@samdanu]

Wow!! I am enjoying watching this video tutorial! Thank you @Pragmaticworks for recording this video and uploading it to KZbin. This is the most detailed and well explained tutorial video on Data Modeling I have watched so far on KZbin. The video quality and sound output is top-notch. One question though... what is the brand name of that microphone you used for this video? I mean that microphone on your left hand-side in this video... I want to go buy the same mic. The sound output is just so good! 😀

[@JuanMarcico]

Im on for the changing dimensions video! have this problem on my work now, dont know if im doing it right. Product price tables are a thing itself

[@yuhooh]

Great Learning by example and provide usecase. I can use exercise file and follow along, recommend if you need to be better understand create Data Model handling multiple fact tables and deal with multiple date role calculation.

[@bernardoalves5849]

well done friends, thank you a lot!

[@ManojKhatua-w2o]

Our data model incorporates multiple date dimension tables, each mapped to fact tables based on specific date keys, such as Order Date, Delivery Date, and Processing Date. The primary and most frequently used date dimension is the HistoryDate table.

[@CuriousJo1122]

I recently went looking for videos on Slowly Changing Dimensions. I would consume one if you put it out!

[@yadlapalliramesh]

Thank you very much for the session. Its informative and I learned Star and Snowflake schemas

[@nanaamanyarko526]

Great video by all standards. Been looking for data modelling videos and this best explains into detail. However, I have a question. So just wondering if I update the Sales or fact table with new entries every month, will the other dimension tables automatically update on its own or I need to make the change individually in each table? Thank you.

[@PragmaticWorks]

Hello, when you refresh your data model the dimensions will also be updated automatically. In the demo, we built the dimension tables and fact table from the single excel worksheet, when we refresh the power bi model, it will update all tables that are pulling from that worksheet.

[@nanaamanyarko526]

@@PragmaticWorks Thank you very much!

[@ETEXCEL]

Catchy, well done Pragmatic. Thank you!

[@wandylim9598]

hey bro, can you download the student files?

[@bernardappiagyei9767]

Very, very useful. Thank you so much guys

[@danielmagantopizarro2262]

Very instructive, really well explained. I enjoyed it very very much. Watch out for the links and the many resources. Amazing! Thank you!! One more thing. May I ask for the instructors name? 🙌🏻

[@PragmaticWorks]

Mitchell Pearson

[@anoopashware9539]

This is great video about data modeling. I missed only one thing. If you used AI for languages (here my native language is hindi)then it will be a great next steps to connect more views to your video.

[@xyclos]

Fantastic team. Thanks a lot Michael!!!

[@Abubakar91718]

Really helpful cleared all my doubts

[@juliekim6892]

Which is recommended, building semantic models using Dataflow Gen2 (the current Power BI feature) or using dim and fact tables in a data warehouse within MS Fabric? Which is better for scaling out? Also how to import tables stored in the semantic model LTWN-Modeling Example and delete the Power BI based model in MS fabric?

[@yannkitson116]

Another excellent course, thank you for sharing.

[@henriette769]

Really exciting stuff. Looking forward to learn from the Pro's

[@stopspinslots]

Great Channel! So thankful I came accross.. i was able to slowly build our dashboard. however I got problem with the auto refresh from my BI desktop and BI web. I think it's because my data was stored in my local drive. Tried to save it it sharepoint however I cannot figure out how to configure. Also, tried to configure bi gateway also, still dont know how to configure it properly. Sirs, im wondering if you can give me tips how to manage this. Thank you from Philippines!

[@lindalagstad625]

Fantastic video, so useful :) Thank you

[@nurzhansa9300]

Hallo. Thanks for the course. Question: In your case Power BI created relationships automatically except for Dim Date. However in My case relationship was created automatically only between Customer and Sales tables. And when I tried to connect manually Geography - Customer and Sales - Product it refused saying it had duplicate zipcode and productID. Shall I remove duplicates?

[@CaraFang]

The slow changing dimension is what I would like to know more about. For a NGO, you'll need to update the service hourly/unit charge for each service delivered on a regular basis, e.g., annually or 6 monthly.

[@sachin-b8c4m]

thanks for this video very helpful

[@zahou9]

Thanks for the clarity of explanation

[@shaibeezz]

Do we have any limitations on number records to read from large csv or txt file??

[@carmenmoncada3331]

Excited for this.

[@mohsinsiddiqui8757]

Hi I have one question, the price of the product tend to change over time. How would I ensure that my table has all relevant prices in it.? eg 2022, 2023, 2024 and the price of the product fluctuates i.e. gold or any other commodity. So please advice on it

[@samimkakakhil6891]

Thank you so much for the informative session

[@msetia20]

If you build a report on top of this model, wont the report be slow?usuually i create dim tables in sql and import. How to create a model n make sure its not slow

[@msetia20]

Does having a powerbi model in desktop power bi make it slow than if we bring in processed data?

[@rahul_singh7]

Really want to know more, on how to implement those slowly changing dimensions in Power BI.

[@Wisdiq]

i got a little problem when i opened cvs Sales file all columns where in the same column it just didn't separate them into different columns but in power bi it separated it perfectly

[@ExcelWithChris]

Hi. Came upon an issue today. In one of my dimensional tables I have a number in a column (let's say the price of the unique item). In the fact table I have many of the same items with a quantity sold column. I then wanted to create a pivot table per item with from the Fact Table the quantity field and from the dimensional table price field. I then wanted to put both these numbers in the Values field of the pivot, but when I wanted to drag the dimensional price value in the value field, it said I had no relationship (although I do have a one to many in the model from dimensional table to Fact table.. I could drag the price column from the dimensional table into the rows, so they will show next to each other, but then you can do no calculation on the price data. Hope this makes sense. The bigger problem would then be what if the price is in the dim table and the quantity in the fact table and then you want to work out the price x quantity?

[@ExcelWithChris]

Solved myself. I will use normal Merge into the Fact Table to get price from Dim Table into the Fact Table so I can do calcs in fact table and not get a one to many relationship to drag the field in.

[@SirEdges_Adejo]

Is this live? Effects and sound are perfect

[@PragmaticWorks]

This is pre-recorded and delivered as a premiere in KZbin so we can have higher quality!

[@ExcelWithChris]

Would really like to learn about slowly changing dimension. I would like to have my price in a dim, but it will change over time and I do not want the person capturing the price to capture it every time in the fact sheet as it would be extra admin and they might get it wrong???!!!! Yes PLEASE tell me how to do this. Thanks.

[@myladouglas3249]

I would love to see Voice of the Customer survey data as one of your products you review.

[@ANNIESMURF]

Is this going to be available on the KZbin channel, my service providers are acting up, can I come back later to watch and follow along again?

[@PragmaticWorks]

Yes this is recorded.

[@mfanwar67]

Great session

[@bananageorge2133]

Thanks so much, appreciate it.

[@MiguelFlores-dw4uj]

are there any breaks on this presentation?

[@TimothyOmlor]

I couldn't find Fabric Analyst In a Day course... is it named something else now?

[@PragmaticWorks]

It's coming very soon but will free forever.

[@CandiceSteinke-b6o]

Anyone else have issues selecting multiple columns in Power Query? I have tried Cntrl and Shift and it simply won't work. Stuck on trying to remove duplicates at the very beginning because I can't select more than one column at a time!

[@encusnnp3646]

The class files show 4 files, but you showed here were 6 (the pdf and one other is missing)

[@EVeritasUnum]

Didn't include the Devin Knight link in notes. please post.

[@PragmaticWorks]

devinknightsql.com/2015/06/16/creating-a-date-dimension-with-power-query/

[@IBRAsTV]

Thank you bros

[@Wisdiq]

and also i don't have the american date type how to change it to american? i mean i dont have am/pm...

[@venkataneelapala5640]

Thanks

[@aliciazigay4510]

Will you please post a recording of this? I won't be able to stay for the whole event.

[@PragmaticWorks]

This Session is being recorded and will be available on KZbin.

[@SirEdges_Adejo]

Can you increase the view ​@@PragmaticWorks

[@RioDrew]

Thank you

[@DataQuestLive]

The only thing I dont understand is this. Lets say I recieve my data as a CSV everyday a flat CSV like we have. How do I reload the powerBI with the new data?

[@amaka1480]

I want to know if the session is still going to take place

[@PragmaticWorks]

Yes, this session is at 11:00 AM EST today

[@silaspaul144]

​@@PragmaticWorksGood day. Please will there be course materials so we can follow along as we watch? Thanks.

[@PragmaticWorks]

Download the student files for today: prag.works/data-modeling-files

[@MiguelFlores-dw4uj]

why the date relationship was not created automatically?

[@SkullMercenary-rz6lb]

I noticed mine didnt create automatically too. I had to manually create it. Hope you were able to figure that out too.

[@akinsinasegun2379]

Please I will need a video in slowly changing dimensions

[@parthsharma3354]

Why isn’t this live? Looks like recorded session.

[@SirEdges_Adejo]

I'm wondering if it's live as well, the effects and sound quality is topnotch.

[@popoolaio]

Interesting

[@christophermueller3373]

This is great, but how does this perform with big data?? say 500 million rows +

[@ogra247]

6 Hours to go

[@EducationYard-rm6rf]

Ensure you turn off the annoying Ads before publishing your next long-running video.

[@cmlibin]

Why write Dax when you can chatgpt

[@shaibeezz]

🎉

[@michaelfarin6580]

Hello

[@mrbartuss1]

FYI, in real life you will almost never get such clean data and it won't be so easy

[@vishalmane3139]

use mutiple big wide files,, nt just a single one lol

[@abhi9029]

I am convinced that Indian tech youtubers teaches far better than this.