Data Modeling for Power BI [Full Course] 📊
Вставка
- Опубліковано 11 тра 2024
- Prerequisites: (to follow along or review later)
✔️ Download student files - prag.works/202208-LWTN-Files
After you finish this course:
📄 If you have completed this class and would like a certificate, fill out this form - prag.works/202208-LWTN-Cert
✔ Event Overview:
Everything in Power BI is more complicated if you don’t build a good data model. Business Intelligence consultants spend an entire career learning how to build data models, but NOT you! Understanding the fundamentals of dimensional modeling (Star Schema) can get you very far in Power BI.
✔ What You’ll Learn:
• What is a Star Schema?
• Building Facts and Dimensions
• Understanding Relationships
• Role-Playing tables
• Calculation Groups
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan:prag.works/lwtn-trial
🔗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
✔️UA-cam: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
**Any sale mentioned in the video are no longer valid. Offers are subject to change with/without notice and are for a limited time only.
![Hands-On Power BI Tutorial 📊 Beginner to Pro 2023 Edition [Full Course] ⚡](http://i.ytimg.com/vi/77jIzgvCIYY/mqdefault.jpg)
![Hands-On Power BI Tutorial 📊 Beginner to Pro 2023 Edition [Full Course] ⚡](/img/tr.png)
![DAX Filter Context Basics [Full Course]](http://i.ytimg.com/vi/Rpa8mDH7mes/mqdefault.jpg)
![Visual Calculations in Power BI - DAX Made Easy! [Full Course]](/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
Excellent work, Mitchel. I appreciate what you and the team at Pragmatic are doing. The three hours were very useful.
Excellent Work Mitchel, I enjoyed the entire 3 hours session. In fact, I never sat down for the entire 3 hours at a stretch before. Amazing content and the way you have explained and organized the content was beyond our expectation.
Now, I have a quick question. When we create data model from the live table (which has around 20 columns), we have to remove duplicates in the fact or dim tables (as you did in this training). The question is, how does it work when we have created data model from the live data (esp. removing duplicates in the fact & dim tables). Hope I am able to explain about the question.
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.
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!
I come back again and again to go through this process. Thank you. I subscribed and gave a thumbs up.
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!!
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
just half way through and its already amazing, thanks for creating this excellent tutorial
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!
Just discovered this channel and it is such a blessing!
You have done it again Mitchell. This is exactly what I was looking for. Thank you so much!
You're very welcome!
Thank you immensely! Every moment in this video is worth watching and contributes to enhancing one's understanding of data modeling.
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!
Excellent course. Now I know a lot of more about Power BI related data modelling. A lot of thanks for instructor.
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!
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?
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!
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 !
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!
Very complex, interesting, and useful video tutorial. Thank you very much! Congratulations for all you do!
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.
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 was great. Presenter was phenomenal, great energy. Thank you!
Really appreciate this, thank you!
Great content on Power BI data modeling, very clearly articulated, learned a lot, thanks!
Loved this video, it is simple and to the point. Thank you!!! Mitchel
This course was Brillant!!! thanks a lot!
Awesome presentation! Thanks to you Mitchell and Pragmatic Works! :)
Amazing , thank you a lot !!! Have 4 layouts in my system, now with your help only 2 !!!
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!
Thanks, Mitchel for investing your valuable time in us!
My pleasure!
@@PragmaticWorks Greetings from Bangalore India 👍
Thank you for the wonderful tutorial on Data Modelling in Power BI.
Thanks a lot Mitchel. Great training!!
Really awesome!
Enjoyed every moment of this video, you made Power BI looks very interesting and simple
Thanks Man🙂🙂🙂😊
Glad you liked it!
Thank you for the video!!! We learn a lot with you! Thank you!
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 👍
In Synapse Dedicated Pool, we have to be very cautious on how we distribute the data evenly between nodes - does this concept still apply with Fabric SQL Warehouse or does the product help on re-distributing the data based on usage for better performance. A video on what we need to do as a developer from the old world Vs. the new Fabric world to achieve maximum perfoamce with an example would be a great one for us. Thanks always for your videos and all the education.
Hi Mitchel. Thanks for sharing this great training. Since I'm leaving in Quebec, Canada, I'm having a problem replacing the unit Cost & Price value to the US origin file value, they appear in text value not in the decimal value. When I look at the origin of the file ite indicates 1251: West of Europe. I've tried to change it to 437: OEM US so that I can use your data in power querry but each time when I wan't to remove duplicates I've a error message. Is there a way that I can use the data and not have to change my cumputer settings. Thanks for posting, very instructive.
Thank you for the value provided. you are beyond amazing Sir !
I appreciate that!
You are the best dude, thanks a lot!
FUNCIONÓ ! Muuuchas gracias
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 ?
Mitchell...you are the BEST! Love your bi videos!!
awesome quick and precise training to gain knowledge on Modelling in short period. Thanks so much Mitchell. It would be great if you cover how to apply filter for SCD-Type-2 in PBI..
So Should I watch data modelling video first or the DAX video?
Data Modeling!
thank you for sharing the knowledge. One of the best lessons on youtube
Wow, thanks!
Thank you for this amazing class!
WOW! IT WORKS. I HAVE BEEN LOOKING FOR THIS METHOD.
An excellent presentation. It was mentioned in the earlier part of the presentation in response to a question that the powerpoin slides will be added to student files after the session. Where can I find those?
U ARE THE BEST IN ALL OF THE SOCIAL MEDIA
Fantastic work, Learn Electronics India! Your IoT Weather Station project using NodeMCU has sparked my interest in the world of IoT. I'm eager to dive into more of your content and learn even more. Thanks for the inspiration.
Thank you, Mitch! much appreciated !
Thank you for watching!
You are a true professional in your field. Respect from India
Happy to help! Glad you enjoyed.
Super informative and beautifully and clearly presented
Learning more from this UA-cam channel than the Microsoft Power BI Self Paced learning modules.
Brilliant video, thank for making this available
Amazing class! Thank you
Very good content of. Vedio. Informative. Thank u for sharing it.
Such a great tutorial and information. Thanks for that!
I maybe will have a project which I have to use this schema, Power BI tool and another IT tool. i was wondering if you have a bunch of hours to do mentoring?
Hi! We are so glad that you enjoyed our tutorial. We do offer mentoring hours and would love to help you with your project! Please send an email to training@pragmaticworks.com and one of our team members will reach out to you. Thank you!
I have benefited a lot from this class new perspective as well!
Thanks for watching!
Hi Mitchel. Thanks fir sharing the training. You created ship date column in the factsale table. If my ship date is 3 working days, how do i create it.
truly grateful for all your effort :-)
awesome video....thanks for sharing your knowledge with us
Again, Thanks Mitchell & Pragmatic Works!
Many thanks for this video...
Really helpful teaching - thank you!
You're very welcome!
Thankyou so much bro! it worked! finally
knowledgeable and best delivery
thank you!!
Happy to help!
This is honestly an amazing course and I can't believe it is free
Thank You Pragmatic Works for such good videos..
Fantastic course - thank you
Helped, thanks.
You are awesome I've been tired of searching a lot
This is an amazing learning video.
nice expiation all about attendance and we all appreciated from this very good job \
of ,my education deem job of my grand fleet .
Thank you Mitchell/Pragmatic Works.
Thanks a lot for the course !!!
You are welcome!
thanks for the training !
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!
Thank you insightful as always
My pleasure!
Thank you Mitch, very I informative content.
Thanks for watching!
Amazing. Thank you very much. Great content, and great learning.
Glad it was helpful! Thanks for learning with us!
yoooo thank u sooo much man
fantastic Data Modeling for Power BI
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.
Great video, thanks for sharing
Great job
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
Impressive and very useful. Thanks!
Thanks for watching!
Thank you very much bro :)
This is a good tutorial to watch before watching the 3-hour tutorial on Power BI.
Glad you enjoyed! Thank you for watching!
hello
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.
Amazing quality.
Love from Germany. Great video
Its Work. Thanks
well done bro thank you ❤
You were GREAT!!!! Thanks!!!