Data Modeling for Power BI [Full Course] 📊

Рет қаралды 3,147,288

Жыл бұрын

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
✔️KZfaq: / 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.

Пікірлер: 384

@summaoruvideo7300 6 ай бұрын

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

@spp2000 2 ай бұрын

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!

@kuldeeppatil9680 12 күн бұрын

Thanks for suggestion i am looking for only that

@tumblingartist 8 күн бұрын

Thanks!!

@AbdallahMohammedem Жыл бұрын

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

@power-reconcile 6 күн бұрын

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!

@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

@youjohnny16 Жыл бұрын

I took exactly the same time stamps for my notes !

@onkar7651 Жыл бұрын

just half way through and its already amazing, thanks for creating this excellent tutorial

@robinpremgulapala8850 Жыл бұрын

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.

@stevenhampson8657 Жыл бұрын

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.

@PragmaticWorks Жыл бұрын

Thanks for watching!

@veronicafox7950 8 ай бұрын

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

@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

@mathewrtaylor Жыл бұрын

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!

@PragmaticWorks Жыл бұрын

Glad it was helpful!

@ahmedroberts4883 Жыл бұрын

You have done it again Mitchell. This is exactly what I was looking for. Thank you so much!

@PragmaticWorks Жыл бұрын

You're very welcome!

@KephaMurage Жыл бұрын

Just discovered this channel and it is such a blessing!

@brianligat9493 5 ай бұрын

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.

@MaHa63b Жыл бұрын

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

@khurrammazhar9351 4 ай бұрын

Thank you immensely! Every moment in this video is worth watching and contributes to enhancing one's understanding of data modeling.

@GeraldHilbers 9 ай бұрын

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

@internationalsteppa Ай бұрын

Learning more from this KZfaq channel than the Microsoft Power BI Self Paced learning modules.

@karunanagre4949 Жыл бұрын

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

@PragmaticWorks Жыл бұрын

You're very welcome!

@syedaneesdurez7197 7 күн бұрын

Sir, Mind blowing explanation of Data Modelling. Really appreciate.

@farramirrmendoza9192 5 ай бұрын

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.

@PragmaticWorks 5 ай бұрын

We are so glad that you liked our video. Thanks for learning with us Farra!

@U2EdgeFan Жыл бұрын

You guys are awesome. Many thanks for sharing your valuable knowledge for free! 👍😎

@PragmaticWorks Жыл бұрын

Glad we could help!

@florina-vq1db 4 ай бұрын

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

@mikekarls529 7 ай бұрын

This was great. Presenter was phenomenal, great energy. Thank you!

@sonjaboes3138 11 ай бұрын

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!

@Captain_MoRNGan Жыл бұрын

Amazing , thank you a lot !!! Have 4 layouts in my system, now with your help only 2 !!!

@AdelitaWilliam-dl7ci Жыл бұрын

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.

@olinazhu9014 29 күн бұрын

This is honestly an amazing course and I can't believe it is free

@haregewoingebre6538 Жыл бұрын

Loved this video, it is simple and to the point. Thank you!!! Mitchel

@j.malave445 Жыл бұрын

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.

@j.malave445 Жыл бұрын

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.

@carlosazp1386 Жыл бұрын

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 !

@PragmaticWorks Жыл бұрын

Thanks for watching!

@junshi9857 2 ай бұрын

Great content on Power BI data modeling, very clearly articulated, learned a lot, thanks!

@RicardoFlores_Senior Жыл бұрын

Thanks, Mitchel for investing your valuable time in us!

@PragmaticWorks Жыл бұрын

My pleasure!

@manjunathmnm Жыл бұрын

@@PragmaticWorks Greetings from Bangalore India 👍

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

@PragmaticWorks Жыл бұрын

Glad it was helpful!

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

@ahmadpvp Жыл бұрын

How'd it go?

@johnefokwu6342 10 ай бұрын

How did it go?

@vandanpandya9587 4 ай бұрын

Thank you for the wonderful tutorial on Data Modelling in Power BI.

@juja2819 Жыл бұрын

Awesome presentation! Thanks to you Mitchell and Pragmatic Works! :)

@krrishbhati-sz1mu 7 күн бұрын

Ещё одна удобная связка, спасибо за ваши знания!

@xyclos 2 ай бұрын

Thanks a lot Mitchel. Great training!!

@henryalferink1941 3 күн бұрын

Excellent stuff. Love the density of content.

@RayaFlora 11 ай бұрын

Thank you for the video!!! We learn a lot with you! Thank you!

@mttwss 10 ай бұрын

Mitchell...you are the BEST! Love your bi videos!!

@swatisinha3230 Жыл бұрын

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

@PragmaticWorks Жыл бұрын

Glad you enjoyed it!

@ahsanali50 Жыл бұрын

Thank you for the value provided. you are beyond amazing Sir !

@PragmaticWorks Жыл бұрын

I appreciate that!

@sophiahoult2952 Жыл бұрын

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

@PragmaticWorks Жыл бұрын

Glad it was helpful!

@samuelnwakolam5158 Жыл бұрын

@@PragmaticWorks hello can this tutorial be considered as a data modelling project ?

@manodeugado2175 Жыл бұрын

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

@PragmaticWorks Жыл бұрын

No problem 👍

@KhanhNguyen-ef2vg Жыл бұрын

thank you for sharing the knowledge. One of the best lessons on youtube

@PragmaticWorks Жыл бұрын

Wow, thanks!

@MEETMEKANNAN Жыл бұрын

Really awesome! Enjoyed every moment of this video, you made Power BI looks very interesting and simple Thanks Man🙂🙂🙂😊

@PragmaticWorks Жыл бұрын

Glad you liked it!

@otakusong66 Жыл бұрын

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

@PragmaticWorks Жыл бұрын

Glad I could help! Thanks for watching!

@HugoFurth Жыл бұрын

Super informative and beautifully and clearly presented

@mrgogate Жыл бұрын

Thank you, Mitch! much appreciated !

@PragmaticWorks Жыл бұрын

Thank you for watching!

@anellavanilla5248 2 ай бұрын

Learning programming and physics is the best thing to do for me and my students

@premjitchowdhury262 Жыл бұрын

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

@PragmaticWorks Жыл бұрын

Happy to help! Glad you enjoyed.

@blessingclaudio4777 Жыл бұрын

I have benefited a lot from this class new perspective as well!

@PragmaticWorks Жыл бұрын

Thanks for watching!

@amitmend Жыл бұрын

Amazing class! Thank you

@utubeAgape Жыл бұрын

Really helpful teaching - thank you!

@PragmaticWorks Жыл бұрын

You're very welcome!

@ahmedamerica 8 ай бұрын

Really appreciate this, thank you!

@user-qx5xg8bc2x 5 ай бұрын

Thank you for this amazing class!

@giogonzalez499 8 ай бұрын

This course was Brillant!!! thanks a lot!

@cielonaranjo6244 9 ай бұрын

WOW! IT WORKS. I HAVE BEEN LOOKING FOR THIS METHOD.

@SantiagoZuluaga Жыл бұрын

Again, Thanks Mitchell & Pragmatic Works!

@user-zm2bs5vu4v 9 ай бұрын

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.

@JimmyMcCaw 6 ай бұрын

Brilliant video, thank for making this available

@rankaur2666 Жыл бұрын

awesome video....thanks for sharing your knowledge with us

@CometoKnow-66 9 ай бұрын

U ARE THE BEST IN ALL OF THE SOCIAL MEDIA

@BrianBoycePhotography 5 ай бұрын

Fantastic course - thank you

@johns8903 Жыл бұрын

knowledgeable and best delivery thank you!!

@PragmaticWorks Жыл бұрын

Happy to help!

@andreicreacico6327 Жыл бұрын

Impressive and very useful. Thanks!

@PragmaticWorks Жыл бұрын

Thanks for watching!

@ashfakzaman446 Жыл бұрын

truly grateful for all your effort :-)

@dazyneupane8944 Жыл бұрын

Thank You Pragmatic Works for such good videos..

@ViktorSamosiuk-wu5fq 19 сағат бұрын

Fantastic! Thank you!

@meditubebrand 6 ай бұрын

fantastic Data Modeling for Power BI

@tacijjola 6 ай бұрын

Amazing. Thank you very much. Great content, and great learning.

@PragmaticWorks 5 ай бұрын

Glad it was helpful! Thanks for learning with us!

@kuldeeppatil9680 11 күн бұрын

Got to know important and coolest feature of power bi thanks Michell

@ngohoangkhoi80 Жыл бұрын

Thanks a lot for the course !!!

@PragmaticWorks Жыл бұрын

You are welcome!

@aminkarimi6861 Жыл бұрын

Thank you Mitchell/Pragmatic Works.

@StopWhining491 Жыл бұрын

This is a good tutorial to watch before watching the 3-hour tutorial on Power BI.

@PragmaticWorks Жыл бұрын

Glad you enjoyed! Thank you for watching!

@Jamaludeen44 Жыл бұрын

hello

@garmacan3185 Жыл бұрын

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.

@ahmedwalidmoulahoum2892 3 ай бұрын

This is an amazing learning video.

@dmatrader Жыл бұрын

Indices are great Good job!

@PragmaticWorks Жыл бұрын

Thanks for watching!

@karaboralekoala1012 Жыл бұрын

Thank you insightful as always

@PragmaticWorks Жыл бұрын

My pleasure!

@thevegaspoolru5334 Жыл бұрын

Amazing video. Mitchell is great.

@jawadahmadehssan6251 Жыл бұрын

Thank you Mitch, very I informative content.

@PragmaticWorks Жыл бұрын

Thanks for watching!

@monn3t440 Ай бұрын

I scoured the Internet in search for the answers I got in this video. It totally worth the commercials

@ducloc632 Жыл бұрын

thanks for the training !

@thomsondcruz 6 ай бұрын

This is such an excellent video. Thank yo so much for offering it for free..

@PragmaticWorks 6 ай бұрын

Thank you for the comment, we are so glad you found the video helpful!

@testemail1016 9 ай бұрын

You are the best dude, thanks a lot!

@showmanshoko8013 9 ай бұрын

You are awesome I've been tired of searching a lot

@cromozo 9 ай бұрын

FUNCIONÓ ! Muuuchas gracias

@joaorataoo 6 ай бұрын

Excellent Mitchel. Already create a post on my LinkedIn promoting your presentation. Thanks

@PragmaticWorks 6 ай бұрын

Awesome, thank you so much!

@PragmaticWorks Жыл бұрын

👉 Important files: ◉ Download Student Files - prag.works/202208-LWTN-Files ◉ Certificate of Completion - prag.works/202208-LWTN-Cert

@buddhigupta3557 Жыл бұрын

Can you please fix Mobile App to be able to watch courses on the go?

@EtsesimokhaiQueensley3566 Жыл бұрын

Thanks Pragmatic Works is this offer still up?

@mohammadhasanakhtar2120 Жыл бұрын

This link is not working

@user-gb5ou1oy3d 9 ай бұрын

This blogger scammed me out of money. May God send the liars of this world to hell

@alexandreferraro3731 11 күн бұрын

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

@sajjadhaidersyed3106 Жыл бұрын

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?

@NEKRETNINEOBRADOVICdoo 6 ай бұрын

You were GREAT!!!! Thanks!!!

@gudukumar748 9 ай бұрын

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

@chalu919 9 ай бұрын

Very good content of. Vedio. Informative. Thank u for sharing it.

@Jir0x 11 ай бұрын

Great video, thanks for sharing

@islamabbas5718 Жыл бұрын

Thank you so much , very informative

@PragmaticWorks Жыл бұрын

Glad you enjoyed! Thanks for watching!

@Travel_and_music_shorts 5 ай бұрын

Love from Germany. Great video

@arvindperiyasamy8904 9 ай бұрын

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.