Data Modeling for Power BI [Full Course] 📊
ฝัง
- เผยแพร่เมื่อ 10 ส.ค. 2022
- 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
✔️TH-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.
![Azure Synapse Analytics: Provisioning ASA [Introduction to Azure Synapse Analytics Series - Ep. 2]](http://i.ytimg.com/vi/Q2cAVSzI12o/mqdefault.jpg)
![Azure Synapse Analytics: Provisioning ASA [Introduction to Azure Synapse Analytics Series - Ep. 2]](/img/tr.png)
![DAX Filter Context Basics [Full Course]](http://i.ytimg.com/vi/Rpa8mDH7mes/mqdefault.jpg)
![[Watch Party] RoV APL 2024 Bacon VS TDT ( AlmonP Wanoiz )](http://i.ytimg.com/vi/LvZvKzu3VSk/mqdefault.jpg)
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
Excellent work, Mitchel. I appreciate what you and the team at Pragmatic are doing. The three hours were very useful.
Just discovered this channel and it is such a blessing!
👉 Important files:
◉ 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
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!
You have done it again Mitchell. This is exactly what I was looking for. Thank you so much!
You're very welcome!
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.
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!
Thank you immensely! Every moment in this video is worth watching and contributes to enhancing one's understanding of data modeling.
You guys are awesome. Many thanks for sharing your valuable knowledge for free! 👍😎
Glad we could help!
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?
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
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!!
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!
This was great. Presenter was phenomenal, great energy. Thank you!
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!
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 !
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.
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 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!
Amazing , thank you a lot !!! Have 4 layouts in my system, now with your help only 2 !!!
Awesome presentation! Thanks to you Mitchell and Pragmatic Works! :)
just half way through and its already amazing, thanks for creating this excellent tutorial
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!
Loved this video, it is simple and to the point. Thank you!!! Mitchel
Thanks, Mitchel for investing your valuable time in us!
My pleasure!
@@PragmaticWorks Greetings from Bangalore India 👍
Great content on Power BI data modeling, very clearly articulated, learned a lot, 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.
Mitchell...you are the BEST! Love your bi videos!!
Thank you for the video!!! We learn a lot with you! Thank you!
Thank you for the wonderful tutorial on Data Modelling in Power BI.
Thank you for the value provided. you are beyond amazing Sir !
I appreciate that!
Thank you saved me a lot of time trying to browse videos for an actual working one
No problem 👍
You are a true professional in your field. Respect from India
Happy to help! Glad you enjoyed.
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!
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!
Super informative and beautifully and clearly presented
Amazing class! Thank you
thank you for sharing the knowledge. One of the best lessons on youtube
Wow, thanks!
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.
This course was Brillant!!! thanks a lot!
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 ?
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!
Thank you for this amazing class!
Again, Thanks Mitchell & Pragmatic Works!
Really appreciate this, thank you!
Thank you, Mitch! much appreciated !
Thank you for watching!
awesome video....thanks for sharing your knowledge with us
Brilliant video, thank for making this available
Excellent presentation. Thank you so much.
Really helpful teaching - thank you!
You're very welcome!
truly grateful for all your effort :-)
I have benefited a lot from this class new perspective as well!
Thanks for watching!
Thank You Pragmatic Works for such good videos..
Fantastic course - thank you
this video was awesome! thanks a lot!
WOW! IT WORKS. I HAVE BEEN LOOKING FOR THIS METHOD.
Excellent stuff. Love the density of content.
knowledgeable and best delivery
thank you!!
Happy to help!
Ещё одна удобная связка, спасибо за ваши знания!
Thank you Mitchell/Pragmatic Works.
Impressive and very useful. Thanks!
Thanks for watching!
FUNCIONÓ ! Muuuchas gracias
Amazing. Thank you very much. Great content, and great learning.
Glad it was helpful! Thanks for learning with us!
Fantastic! Thank you!
This is an amazing learning video.
U ARE THE BEST IN ALL OF THE SOCIAL MEDIA
Amazing video. Mitchell is great.
You are the best dude, thanks a lot!
Thankyou so much bro! it worked! finally
Thanks a lot for the course !!!
You are welcome!
thanks for the training !
Thank you Mitch, very I informative content.
Thanks for watching!
You are awesome I've been tired of searching a lot
Great video, thanks for sharing
This is honestly an amazing course and I can't believe it is free
i am doing same thing from many years, thanks for approving that i am doing correct.
You were GREAT!!!! Thanks!!!
Sir, Mind blowing explanation of Data Modelling. Really appreciate.
Great video , Mitchell. I appreciate the way you explained. Thanks
Thank you! - Mitchell
fantastic Data Modeling for Power BI
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 insightful as always
My pleasure!
Learning more from this TH-cam channel than the Microsoft Power BI Self Paced learning modules.
Got to know important and coolest feature of power bi thanks Michell
Many thanks for this video...
Amazing quality.
Thank you so much , very informative
Glad you enjoyed! 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!
Very good content of. Vedio. Informative. Thank u for sharing it.
Omg Mitchell, ya the best of the best.💪 I love you. ❤️ I was looking for this concepts for só long. I have made many courses, but only you give the concepts.👃. TKS,, TKS a Lot.😃
Helped, thanks.
very helpful, thanks
Indices are great Good job!
Thanks for watching!
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!
nice expiation all about attendance and we all appreciated from this very good job \
of ,my education deem job of my grand fleet .