Anyone scrolling through comments to check if this video is meaningful enough to understand data modelling ( particularly in power bi ) , its a 200 % yes
Great practical use of merge query... 1:35:35... excellent Create measure to use an inactive relation in the model 1:52:58... WOW...! Using parameters to filter query 2:03:50 Aggregate Table using Group By very useful to handle large data 2:08:20
There are lots of amazing contents on powerbi data modeling. But this Is the best I’ve seen. The kind of effort being put into this video all for free is just amazing. Thank you for your contributions to humanity
Thank you for this video, you are demonstrating how to take a regular table and make a fact and dimension tables. Really starting from scratch. Super important.
The reason why the rows duplicated at 2:24, its bacause scenario column on FactBudget Table has two categories. You cab use DAX to get Total Budget and Total Forecast. Formular : Total Forecast = CALCULATE(SUM('FactBudget'[Value]),'FactBudget'[Scenario] = "forecast")
Oh man, what a lecture... First time in my life I understand what is modeling on a basic level. Even if there are some more advanced things for me, and I am a Data Analyst, now I understand many things about modeling the data in Power BI, and I am ready for more, ready for DAX :) .
Started this course today. The teaching is nice and goes with a flow. Will update this comment after I fully complete this course. Edited: I have completed 40 percent in this and this gives good learning, can definitely see this if you are a beginner.
I am currently preparing for a BI developer interview and accidently found this. Thank you Mitchell this is solid explanation and good demonstration of data modelling knowledge using understandable case study! Thanks for posting this live for us :)
Your advice has been a game-changer for me. I followed your strategy and got 10 out of 12 - a personal best! Your guidance has given me the confidence to keep pushing forward. Thank you
Sometines the thought of sitting for 2-3 hours for your tutorials seems a bit long, but you (and Devon) impart so much good stuff that it's well worth the time. Awesome content as always.
This video taught me way more than the expensive 1 year post graduate program i took at Southern Alberta Inst of Tech. God I wasted so much money in that crap school.
Great explanation. I think every PowerBI developer needs to view this course at least twice. Once to see and understand the possibilities of data modeling and PowerQuery. And then after working a while with the possibilities to see even more and better ways to find solutions. E.g. the calculation groups for the measures with the inactive relationships are great!!
1:02:20 - Multiple Fact Tables 1:05:15 - When one fact table uses a different time frame/granularity than another fact table. 1:07:25 - which classes??!
Is anyone able to explain why at 39:01, the date on the excel file appears to be "00:00:0000" but when it gets loaded into Power BI seconds later, the dates appeared to be filled in?
1:30 Type 2 Historical Dimensions - I ran into this challenge instead of using a SK I created new products in the CRM with the respective dates they were in effect then added adjustment columns to allocate manual adjustments. The root problem was incorrect capturing of product changes.
at 2:15:56 when you opened the relationship tab why wasnt the measures by ship date table shown there. it is being shown in my file and also in your completed file but asking for a relation in your file
Fantastic job, Mitchel! I really appreciate the incredible work you and the team at Pragmatic are doing. This video is immensely valuable and packed with useful insights. Keep up the great work!
At 1:27:11, I didn't understand, Why you removed all other columns from the main Factsales table. It is the table that has the record of sales right. Kindly clarify anyone in the comment section or from the pragmatic works team.
Once you move all your descriptive attributes into dimension tables, you will want to remove those descriptive columns from the fact table. If you want to know your sales my Customer or Product Name, you will now filter from those dimensions. -Mitchell
@@PragmaticWorks Thank you for reverting back. Thinking for a moment after posting this question, I came to understand that, Only one common pair is enough in the facts table right, Rest all has to be in the dimensions table and you have cleared out by replying the same. Thank you Mitchell
At 1:09:48, There you got an error in parsing the date. After getting back from the break, You didn't explain, how you got rid of the error. I am still getting the error while converting the data type of date time into date. Kindly help me out with this.
@@PK-iu9nc Good catch, I just looked at it. If the value is already a date time, you can change it to a Date and make sure to add as a NEW Step. If it's a text data type, then you will need to perform two steps. First, change the data type to date/time, then change the data type to date and make sure to "Add as New Step".
Thank you, Mitchell Sir, for this amazing Data Modeling for Power BI course! 🙌 Clear, practical, and insightful-I've learned so much and feel confident applying it. Highly recommended! 💡📊
Hello, thanks for the video. Questions: If I open this data model/FM to my end of users, how can I prevent my user to select column from 2 fact table for the cross join? Can I create a naming space/folders for these diff data models?
Thanks Mitchell and all the team at Pragmatic Works. Insightful, considered information that I can definitely use. And great interactions from the people also watching live with good feedback from others who also are walking the same path.
If the value is already a date time, you can change it to a Date and make sure to add as a NEW Step. If it's a text data type, then you will need to perform two steps. First, change the data type to date/time, then change the data type to date and make sure to "Add as New Step".
thanks for this wonderfull course. but i need a help. i am following each step for creating report. but i see the sales tables does not have a proper date value in the date column. and then how do we be able to connect the sales fact to the date dimension. valuable reply would be much appreciated.
Hello Mitchel! I uploaded the sales CSV file to power BI, but the date column is still in text format. i tried to change it to date format but its giving me an error. How do i fix this? Someone help! btw loved your session! this is the error - DataFormat.Error: We couldn't parse the input provided as a Date value. Details: 00:00.0
Hello, I have another question please. When you calculated the total budget you did the sum of value but there 2 scenarios in the fact budget: budget and forecast. I think we should put a condition when we do the sum that the scenario must be budget isn't it ? Thanks in advance
Hi Mitchel Excellent and Informative video, thoroughly enjoyed it. Just one quick question, when you build the FactAggSales table at 2:16:31 timeframe and replace the Total Sales generated from the FactSales table with the ones from the FactAggSales table the values are different, can you please explain this and I am not sure if someone else has already pointed this out. Many Thanks
What a fantastic class!! I really thank you and your team for giving these full courses on youtube. I learned a lot and I need to watch it again 😂. Great job!! I do have a question in which I did not see in this course.
I import to my Power Bi report from a data model I created in excel. But when I refresh my Power Bi to extract new data from my data model in excel, the new added information is not refreshing and I can’t figure out why.
Huge respect and Thnq pragmatic works from india u did grt work provided by advance data modelling, power query, dax query and advance power bi developer course it is going to be really work for us in real time once agin thank you so much ❤❤❤🎉🎉
Thank you So much Mitchell for wonderful course. This is my first video that i have completed and learnt and understood the data modeling in a better way. I'm looking forward to look out all your videos and gain extensive knowledge on Power BI. Great Job Mitchell. 🙂
Hello Mitchell thanks for this. However, I want to ask when you changed the relationship between the factsales and the DimDate using the shipDate instead of the order date. Why is the total figure of the unit price different since we are using the same figure from the fact sales? Why is there a reduction from 10,595,490.03 to 10,474,999.87?
You can find the class files in the description. Better yet, check out the 2024 version of this course here: th-cam.com/video/air7T8wCYkU/w-d-xo.htmlsi=7bc7acncJr8kLEV9
Hey, following along I noticed that you were selecting all columns and then removing the duplicates. Why not remove the duplicates from the unique id column only? Does that make any diffrence? Thanks for this course!
Thanks for the training: you've explained complex new information (to me) in an way a starter is able top understand. It was a lot you've covered. Yhank you!
Thumbs up for Calculation Groups. Will save me time from creating lots of DAX formulas. Also great refresher for Data Modelling in PBI. Thank you for this tutorial :)
Hi, I'm not sure what I did wrong, I was doing my best to follow step by step but after the power query editor, some of my relationships did not seme to build. Specifically, what should the relationship be between DimCustomer and FactSales? Thanks!
I didn't sign up for this, but glad to watch through. Great explanations, easy to follow, and loved the Calculated Groups! Thanks for posting this for us!
hi pragmatic team, at 1:25:45 what will happen if we will NOT DELETE the attribute columns from the original facts table even if we have made a duplication of that columns into separate tables? will it affect the results? looking forward with your confirmation thanks.
It won't affect results, it will just needlessly increase the size of your model / pbix file and perhaps impact performance. With small models and small datasets, not an issue and can keep if you have a reason (not sure what that would be).
![Beginner Power BI DAX Functions Tutorial [Full Course]](http://i.ytimg.com/vi/QJw4HkagVWc/mqdefault.jpg)
![Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] 2023 Edition⚡](/img/n.gif)
Anyone scrolling through comments to check if this video is meaningful enough to understand data modelling ( particularly in power bi ) , its a 200 % yes
Absolutely fantastic course! I was intimidated by the duration but broke it down and watched it over two days. I learnt so much. Thank you Mitchell!
Thanks for suggestion i am looking for only that
Thanks!!
Thank you for this review :) -Mitchell
Thank you ! Was about to do that rn😂
Great practical use of merge query... 1:35:35... excellent
Create measure to use an inactive relation in the model 1:52:58... WOW...!
Using parameters to filter query 2:03:50
Aggregate Table using Group By very useful to handle large data 2:08:20
I took exactly the same time stamps for my notes !
There are lots of amazing contents on powerbi data modeling. But this Is the best I’ve seen. The kind of effort being put into this video all for free is just amazing. Thank you for your contributions to humanity
Where is lot of content in data modeling side in power bi?
You are a true professional in your field. Respect from India
Happy to help! Glad you enjoyed.
Learning more from this TH-cam channel than the Microsoft Power BI Self Paced learning modules.
Thank you for this video, you are demonstrating how to take a regular table and make a fact and dimension tables. Really starting from scratch. Super important.
Glad it was helpful!
The reason why the rows duplicated at 2:24, its bacause scenario column on FactBudget Table has two categories. You cab use DAX to get Total Budget and Total Forecast.
Formular : Total Forecast = CALCULATE(SUM('FactBudget'[Value]),'FactBudget'[Scenario] = "forecast")
Oh man, what a lecture... First time in my life I understand what is modeling on a basic level. Even if there are some more advanced things for me, and I am a Data Analyst, now I understand many things about modeling the data in Power BI, and I am ready for more, ready for DAX :) .
Started this course today. The teaching is nice and goes with a flow. Will update this comment after I fully complete this course.
Edited: I have completed 40 percent in this and this gives good learning, can definitely see this if you are a beginner.
Glad you're enjoying the class, thank you for learning with us! - Mitchell
I am currently preparing for a BI developer interview and accidently found this. Thank you Mitchell this is solid explanation and good demonstration of data modelling knowledge using understandable case study! Thanks for posting this live for us :)
How'd it go?
How did it go?
Are you bi now?
Your advice has been a game-changer for me. I followed your strategy and got 10 out of 12 - a personal best! Your guidance has given me the confidence to keep pushing forward. Thank you
Thank you for your feedback, keep climbing! - Mitchell
This is a good tutorial to watch before watching the 3-hour tutorial on Power BI.
Glad you enjoyed! Thank you for watching!
hello
I come back again and again to go through this process. Thank you. I subscribed and gave a thumbs up.
Sometines the thought of sitting for 2-3 hours for your tutorials seems a bit long, but you (and Devon) impart so much good stuff that it's well worth the time. Awesome content as always.
Just discovered this channel and it is such a blessing!
Your speech clarity is on another level!
Excellent course. Now I know a lot of more about Power BI related data modelling. A lot of thanks for instructor.
Excellent work, Mitchel. I appreciate what you and the team at Pragmatic are doing. The three hours were very useful.
This video taught me way more than the expensive 1 year post graduate program i took at Southern Alberta Inst of Tech. God I wasted so much money in that crap school.
We are so glad that you liked our video. Thanks for learning with us Farra!
Thankyou Mitchel, this is my first video for data modelling & i am glad i accidentally landed to this page. Amazing video & detailed explanation 😊
Glad you enjoyed it!
Great explanation. I think every PowerBI developer needs to view this course at least twice. Once to see and understand the possibilities of data modeling and PowerQuery. And then after working a while with the possibilities to see even more and better ways to find solutions. E.g. the calculation groups for the measures with the inactive relationships are great!!
1:02:20 - Multiple Fact Tables
1:05:15 - When one fact table uses a different time frame/granularity than another fact table.
1:07:25 - which classes??!
This is one of the best and straightforward video on Data Modeling in Power BI.
Thank you! - Mitchell Pearson
Is anyone able to explain why at 39:01, the date on the excel file appears to be "00:00:0000" but when it gets loaded into Power BI seconds later, the dates appeared to be filled in?
He is joking with us😂, I followed him step by step and got to dat part and i got lost immediately
Great Job to the presenter, excellent video, and great hands-on demo actually showing the application of surrogate keys using power query
So much important information based on your experiences. You know how to teach, love from Turkey.
Thanks a lot Mitchel for this amazing course on data modelling. Your suggestion to appoint a Q&A sesion is much appreciated. I'll keep my ears open !
Thanks for watching!
IT WORKED, THANKS I'VE BEEN LOOKING FOR THIS FOREVER, BUT NO TUTORIAL COULD EXPLAIN IT AS YOU DID
Glad I could help! Thanks for watching!
Thank you saved me a lot of time trying to browse videos for an actual working one
No problem 👍
1:30 Type 2 Historical Dimensions - I ran into this challenge instead of using a SK I created new products in the CRM with the respective dates they were in effect then added adjustment columns to allocate manual adjustments. The root problem was incorrect capturing of product changes.
at 2:15:56 when you opened the relationship tab why wasnt the measures by ship date table shown there. it is being shown in my file and also in your completed file but asking for a relation in your file
This was great. Presenter was phenomenal, great energy. Thank you!
👉NEW UPDATED 2024 VERSION AVAILABLE HERE: th-cam.com/video/air7T8wCYkU/w-d-xo.html
◉ Download Student Files - prag.works/202208-LWTN-Files
◉ Certificate of Completion - prag.works/202208-LWTN-Cert
Can you please fix Mobile App to be able to watch courses on the go?
Thanks Pragmatic Works is this offer still up?
This link is not working
This blogger scammed me out of money. May God send the liars of this world to hell
Very complex, interesting, and useful video tutorial. Thank you very much! Congratulations for all you do!
Thanks, Mitchel for investing your valuable time in us!
My pleasure!
@@PragmaticWorks Greetings from Bangalore India 👍
Thank you immensely! Every moment in this video is worth watching and contributes to enhancing one's understanding of data modeling.
Great content on Power BI data modeling, very clearly articulated, learned a lot, thanks!
Fantastic job, Mitchel! I really appreciate the incredible work you and the team at Pragmatic are doing. This video is immensely valuable and packed with useful insights. Keep up the great work!
At 1:27:11, I didn't understand, Why you removed all other columns from the main Factsales table. It is the table that has the record of sales right. Kindly clarify anyone in the comment section or from the pragmatic works team.
Once you move all your descriptive attributes into dimension tables, you will want to remove those descriptive columns from the fact table. If you want to know your sales my Customer or Product Name, you will now filter from those dimensions. -Mitchell
@@PragmaticWorks Thank you for reverting back. Thinking for a moment after posting this question, I came to understand that, Only one common pair is enough in the facts table right, Rest all has to be in the dimensions table and you have cleared out by replying the same.
Thank you Mitchell
At 1:09:48, There you got an error in parsing the date. After getting back from the break, You didn't explain, how you got rid of the error. I am still getting the error while converting the data type of date time into date. Kindly help me out with this.
@@PK-iu9nc Good catch, I just looked at it. If the value is already a date time, you can change it to a Date and make sure to add as a NEW Step. If it's a text data type, then you will need to perform two steps. First, change the data type to date/time, then change the data type to date and make sure to "Add as New Step".
This is honestly an amazing course and I can't believe it is free
Thank you, Mitchell Sir, for this amazing Data Modeling for Power BI course! 🙌 Clear, practical, and insightful-I've learned so much and feel confident applying it. Highly recommended! 💡📊
Thank you for the wonderful tutorial on Data Modelling in Power BI.
WOW! IT WORKS. I HAVE BEEN LOOKING FOR THIS METHOD.
Sir, Mind blowing explanation of Data Modelling. Really appreciate.
i am doing same thing from many years, thanks for approving that i am doing correct.
U ARE THE BEST IN ALL OF THE SOCIAL MEDIA
This session is really informative, thanks for your valuable insights. Really appreciate !!!
thank you for sharing the knowledge. One of the best lessons on youtube
Wow, thanks!
Thanks a lot Mitchel. Great training!!
Mitchell...you are the BEST! Love your bi videos!!
@ 1:09:40 Date Column conversion was throwing an error, how can we fix that?
agree
Try converting the date in the original csv file to date using excel before importing to powerbi .
I did that it worked
Hi, from Togo. Great Job. I really enjoyed it!! thank you very much
Where can I get the link to copy the code for the date?
I have benefited a lot from this class new perspective as well!
Thanks for watching!
This is such an excellent video. Thank yo so much for offering it for free..
Thank you for the comment, we are so glad you found the video helpful!
Hello, thanks for the video. Questions: If I open this data model/FM to my end of users, how can I prevent my user to select column from 2 fact table for the cross join? Can I create a naming space/folders for these diff data models?
Thanks Mitchell and all the team at Pragmatic Works. Insightful, considered information that I can definitely use. And great interactions from the people also watching live with good feedback from others who also are walking the same path.
Thanks for watching!
Now am stuff...how did you rectify the date issue before the break
Think I found it.....
From Change type, move down to using locale, then select date
If the value is already a date time, you can change it to a Date and make sure to add as a NEW Step. If it's a text data type, then you will need to perform two steps. First, change the data type to date/time, then change the data type to date and make sure to "Add as New Step".
thanks for this wonderfull course. but i need a help. i am following each step for creating report. but i see the sales tables does not have a proper date value in the date column. and then how do we be able to connect the sales fact to the date dimension. valuable reply would be much appreciated.
Excellent demonstration of Data modelling compare to other trainers who shows / briefs / demonstrates only general way..🙂🙂🙂🙂🙂🙂
Hello Mitchel! I uploaded the sales CSV file to power BI, but the date column is still in text format. i tried to change it to date format but its giving me an error. How do i fix this? Someone help!
btw loved your session!
this is the error -
DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
00:00.0
please link to the previoud youtube video ("you spoke more about this") and old class to data modeling. Thanks
You are awesome I've been tired of searching a lot
Excellent Mitchel.
Already create a post on my LinkedIn promoting your presentation.
Thanks
Awesome, thank you so much!
I am learning so much from watching your videos. Thank you so much for sharing this amazing source of information. This one is quite helpful.
Hello, I have another question please. When you calculated the total budget you did the sum of value but there 2 scenarios in the fact budget: budget and forecast. I think we should put a condition when we do the sum that the scenario must be budget isn't it ?
Thanks in advance
Hi Mitchel Excellent and Informative video, thoroughly enjoyed it. Just one quick question, when you build the FactAggSales table at 2:16:31 timeframe and replace the Total Sales generated from the FactSales table with the ones from the FactAggSales table the values are different, can you please explain this and I am not sure if someone else has already pointed this out. Many Thanks
fantastic Data Modeling for Power BI
You guys are awesome. Many thanks for sharing your valuable knowledge for free! 👍😎
Glad we could help!
What a fantastic class!! I really thank you and your team for giving these full courses on youtube. I learned a lot and I need to watch it again 😂. Great job!! I do have a question in which I did not see in this course.
I import to my Power Bi report from a data model I created in excel. But when I refresh my Power Bi to extract new data from my data model in excel, the new added information is not refreshing and I can’t figure out why.
This course was Brillant!!! thanks a lot!
Thank You Pragmatic Works for such good videos..
Huge respect and Thnq pragmatic works from india u did grt work provided by advance data modelling, power query, dax query and advance power bi developer course it is going to be really work for us in real time once agin thank you so much ❤❤❤🎉🎉
Awesome presentation! Thanks to you Mitchell and Pragmatic Works! :)
Hi Mitchell. I am kind of lost as to how I should download the Tabular Editor into PBI (External Tools). Can you help me out please? Thanks Mitchell.
Finally, what I was looking for.
Thank you for amazing presentation!
Thank you So much Mitchell for wonderful course. This is my first video that i have completed and learnt and understood the data modeling in a better way. I'm looking forward to look out all your videos and gain extensive knowledge on Power BI. Great Job Mitchell. 🙂
You're very welcome!
Thank you for explaining Type 2 Dim models. Most of my Dim's are slowing changing TYpe 2 tables.
Learning programming and physics is the best thing to do for me and my students
Hello Mitchell thanks for this. However, I want to ask when you changed the relationship between the factsales and the DimDate using the shipDate instead of the order date. Why is the total figure of the unit price different since we are using the same figure from the fact sales? Why is there a reduction from 10,595,490.03 to 10,474,999.87?
Brilliant video, thank for making this available
is it not possible to track the sales price of each order in fact sales, so if you change the price it is always mentioned?
Very good content of. Vedio. Informative. Thank u for sharing it.
Excellent stuff. Love the density of content.
Amazing , thank you a lot !!! Have 4 layouts in my system, now with your help only 2 !!!
Hi @pragmaticworks, can you please share the link to the 3 hours Dax video that Mitchel refers to?
Tx
Here you go! th-cam.com/users/liveQJw4HkagVWc?si=s0dK-BlQCjc5tyqw
where we will get data set used in video for data modeling?
You can find the class files in the description. Better yet, check out the 2024 version of this course here: th-cam.com/video/air7T8wCYkU/w-d-xo.htmlsi=7bc7acncJr8kLEV9
So Should I watch data modelling video first or the DAX video?
Data Modeling!
Hey, following along I noticed that you were selecting all columns and then removing the duplicates. Why not remove the duplicates from the unique id column only?
Does that make any diffrence?
Thanks for this course!
You have done it again Mitchell. This is exactly what I was looking for. Thank you so much!
You're very welcome!
Thanks for the training: you've explained complex new information (to me) in an way a starter is able top understand. It was a lot you've covered. Yhank you!
Thumbs up for Calculation Groups. Will save me time from creating lots of DAX formulas. Also great refresher for Data Modelling in PBI. Thank you for this tutorial :)
Glad it was helpful!
@@PragmaticWorks hello can this tutorial be considered as a data modelling project ?
Hi, I'm not sure what I did wrong, I was doing my best to follow step by step but after the power query editor, some of my relationships did not seme to build. Specifically, what should the relationship be between DimCustomer and FactSales? Thanks!
The relationship will be on CustomerKey!
Again, Thanks Mitchell & Pragmatic Works!
I didn't sign up for this, but glad to watch through. Great explanations, easy to follow, and loved the Calculated Groups! Thanks for posting this for us!
Glad it was helpful!
nice expiation all about attendance and we all appreciated from this very good job \
of ,my education deem job of my grand fleet .
Got to know important and coolest feature of power bi thanks Michell
Thank you Mitchell/Pragmatic Works.
hi pragmatic team, at 1:25:45 what will happen if we will NOT DELETE the attribute columns from the original facts table even if we have made a duplication of that columns into separate tables? will it affect the results? looking forward with your confirmation thanks.
It won't affect results, it will just needlessly increase the size of your model / pbix file and perhaps impact performance. With small models and small datasets, not an issue and can keep if you have a reason (not sure what that would be).
Great presentation ... Thanks... 🙂