Data Modeling for Power BI [Full Course] 📊

Prerequisites: (to follow along or review later)

After you finish this course:

✔ 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:


Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]

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

[summaoruvideo]

Anyone scrolling through comments to check if this video is meaningful enough to understand data modelling ( particularly in power bi ), its a 200 % yes

[kishangzp]

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

[victor_peral]

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

[GROWINGBUSINESSESBETTER]

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.

[dr]

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 :) .

[brianligat]

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.

[yutianwanggg]

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 :)

[akshaykapoor]

This is one of the best and straightforward video on Data Modeling in Power BI.

[farramirrmendoza]

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.

[GeraldHilbers]

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

[AbdallahMohammedem]

Excellent work, Mitchel. I appreciate what you and the team at Pragmatic are doing. The three hours were very useful.

[premjitchowdhury]

You are a true professional in your field. Respect from India

[power-reconcile]

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!

[swatisinha]

Thankyou Mitchel, this is my first video for data modelling & i am glad i accidentally landed to this page. Amazing video & detailed explanation 😊

[carlosazp]

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 !

[veronicafox]

I come back again and again to go through this process. Thank you. I subscribed and gave a thumbs up.

[manodeugado]

Thank you saved me a lot of time trying to browse videos for an actual working one

[otakusong]

IT WORKED, THANKS I'VE BEEN LOOKING FOR THIS FOREVER, BUT NO TUTORIAL COULD EXPLAIN IT AS YOU DID

[florina-vqdb]

Very complex, interesting, and useful video tutorial. Thank you very much! Congratulations for all you do!

[MaHab]

Excellent course. Now I know a lot of more about Power BI related data modelling. A lot of thanks for instructor.