Тёмный

Data Modeling for Power BI [Full Course] 📊 

Pragmatic Works
Подписаться 217 тыс.
Просмотров 3,2 млн
50% 1

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

Опубликовано:

 

10 авг 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 388   
@summaoruvideo7300
@summaoruvideo7300 7 месяцев назад
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
@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
@kuldeeppatil9680 24 дня назад
Thanks for suggestion i am looking for only that
@tumblingartist
@tumblingartist 20 дней назад
Thanks!!
@AbdallahMohammedem
@AbdallahMohammedem Год назад
Excellent work, Mitchel. I appreciate what you and the team at Pragmatic are doing. The three hours were very useful.
@brianligat9493
@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.
@victor_peral
@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
@stevenhampson8657
@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
@PragmaticWorks Год назад
Thanks for watching!
@KephaMurage
@KephaMurage Год назад
Just discovered this channel and it is such a blessing!
@GeraldHilbers
@GeraldHilbers 10 месяцев назад
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!!
@onkar7651
@onkar7651 Год назад
just half way through and its already amazing, thanks for creating this excellent tutorial
@mathewrtaylor
@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
@PragmaticWorks Год назад
Glad it was helpful!
@ahmedroberts4883
@ahmedroberts4883 Год назад
You have done it again Mitchell. This is exactly what I was looking for. Thank you so much!
@PragmaticWorks
@PragmaticWorks Год назад
You're very welcome!
@robinpremgulapala8850
@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.
@veronicafox7950
@veronicafox7950 9 месяцев назад
I come back again and again to go through this process. Thank you. I subscribed and gave a thumbs up.
@MaHa63b
@MaHa63b Год назад
Excellent course. Now I know a lot of more about Power BI related data modelling. A lot of thanks for instructor.
@karunanagre4949
@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
@PragmaticWorks Год назад
You're very welcome!
@khurrammazhar9351
@khurrammazhar9351 4 месяца назад
Thank you immensely! Every moment in this video is worth watching and contributes to enhancing one's understanding of data modeling.
@kishangzp
@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
@youjohnny16 Год назад
I took exactly the same time stamps for my notes !
@GROWINGBUSINESSESBETTER
@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
@PragmaticWorks Год назад
Glad it was helpful!
@carlosazp1386
@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
@PragmaticWorks Год назад
Thanks for watching!
@U2EdgeFan
@U2EdgeFan Год назад
You guys are awesome. Many thanks for sharing your valuable knowledge for free! 👍😎
@PragmaticWorks
@PragmaticWorks Год назад
Glad we could help!
@mikekarls529
@mikekarls529 7 месяцев назад
This was great. Presenter was phenomenal, great energy. Thank you!
@sonjaboes3138
@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!
@florina-vq1db
@florina-vq1db 4 месяца назад
Very complex, interesting, and useful video tutorial. Thank you very much! Congratulations for all you do!
@yutianwanggg
@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
@ahmadpvp Год назад
How'd it go?
@johnefokwu6342
@johnefokwu6342 10 месяцев назад
How did it go?
@AdelitaWilliam-dl7ci
@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.
@RicardoFlores_Senior
@RicardoFlores_Senior Год назад
Thanks, Mitchel for investing your valuable time in us!
@PragmaticWorks
@PragmaticWorks Год назад
My pleasure!
@manjunathmnm
@manjunathmnm Год назад
@@PragmaticWorks Greetings from Bangalore India 👍
@j.malave445
@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
@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.
@juja2819
@juja2819 Год назад
Awesome presentation! Thanks to you Mitchell and Pragmatic Works! :)
@haregewoingebre6538
@haregewoingebre6538 Год назад
Loved this video, it is simple and to the point. Thank you!!! Mitchel
@swatisinha3230
@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
@PragmaticWorks Год назад
Glad you enjoyed it!
@Captain_MoRNGan
@Captain_MoRNGan Год назад
Amazing , thank you a lot !!! Have 4 layouts in my system, now with your help only 2 !!!
@junshi9857
@junshi9857 2 месяца назад
Great content on Power BI data modeling, very clearly articulated, learned a lot, thanks!
@vandanpandya9587
@vandanpandya9587 4 месяца назад
Thank you for the wonderful tutorial on Data Modelling in Power BI.
@premjitchowdhury262
@premjitchowdhury262 Год назад
You are a true professional in your field. Respect from India
@PragmaticWorks
@PragmaticWorks Год назад
Happy to help! Glad you enjoyed.
@internationalsteppa
@internationalsteppa Месяц назад
Learning more from this RU-vid channel than the Microsoft Power BI Self Paced learning modules.
@manodeugado2175
@manodeugado2175 Год назад
Thank you saved me a lot of time trying to browse videos for an actual working one
@PragmaticWorks
@PragmaticWorks Год назад
No problem 👍
@mttwss
@mttwss 11 месяцев назад
Mitchell...you are the BEST! Love your bi videos!!
@ahsanali50
@ahsanali50 Год назад
Thank you for the value provided. you are beyond amazing Sir !
@PragmaticWorks
@PragmaticWorks Год назад
I appreciate that!
@RayaFlora
@RayaFlora 11 месяцев назад
Thank you for the video!!! We learn a lot with you! Thank you!
@power-reconcile
@power-reconcile 18 дней назад
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!
@otakusong66
@otakusong66 Год назад
IT WORKED, THANKS I'VE BEEN LOOKING FOR THIS FOREVER, BUT NO TUTORIAL COULD EXPLAIN IT AS YOU DID
@PragmaticWorks
@PragmaticWorks Год назад
Glad I could help! Thanks for watching!
@xyclos
@xyclos 3 месяца назад
Thanks a lot Mitchel. Great training!!
@KhanhNguyen-ef2vg
@KhanhNguyen-ef2vg Год назад
thank you for sharing the knowledge. One of the best lessons on youtube
@PragmaticWorks
@PragmaticWorks Год назад
Wow, thanks!
@user-rp1ub1qw6m
@user-rp1ub1qw6m День назад
Great video , Mitchell. I appreciate the way you explained. Thanks
@MEETMEKANNAN
@MEETMEKANNAN Год назад
Really awesome! Enjoyed every moment of this video, you made Power BI looks very interesting and simple Thanks Man🙂🙂🙂😊
@PragmaticWorks
@PragmaticWorks Год назад
Glad you liked it!
@olinazhu9014
@olinazhu9014 Месяц назад
This is honestly an amazing course and I can't believe it is free
@garmacan3185
@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.
@sophiahoult2952
@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
@PragmaticWorks Год назад
Glad it was helpful!
@samuelnwakolam5158
@samuelnwakolam5158 Год назад
@@PragmaticWorks hello can this tutorial be considered as a data modelling project ?
@HugoFurth
@HugoFurth Год назад
Super informative and beautifully and clearly presented
@user-qx5xg8bc2x
@user-qx5xg8bc2x 5 месяцев назад
Thank you for this amazing class!
@mrgogate
@mrgogate Год назад
Thank you, Mitch! much appreciated !
@PragmaticWorks
@PragmaticWorks Год назад
Thank you for watching!
@amitmend
@amitmend Год назад
Amazing class! Thank you
@chitreshrahamatkar
@chitreshrahamatkar 5 дней назад
i am doing same thing from many years, thanks for approving that i am doing correct.
@henryalferink1941
@henryalferink1941 15 дней назад
Excellent stuff. Love the density of content.
@ahmedamerica
@ahmedamerica 8 месяцев назад
Really appreciate this, thank you!
@utubeAgape
@utubeAgape Год назад
Really helpful teaching - thank you!
@PragmaticWorks
@PragmaticWorks Год назад
You're very welcome!
@giogonzalez499
@giogonzalez499 8 месяцев назад
This course was Brillant!!! thanks a lot!
@aminkarimi6861
@aminkarimi6861 Год назад
Thank you Mitchell/Pragmatic Works.
@SantiagoZuluaga
@SantiagoZuluaga Год назад
Again, Thanks Mitchell & Pragmatic Works!
@blessingclaudio4777
@blessingclaudio4777 Год назад
I have benefited a lot from this class new perspective as well!
@PragmaticWorks
@PragmaticWorks Год назад
Thanks for watching!
@dazyneupane8944
@dazyneupane8944 Год назад
Thank You Pragmatic Works for such good videos..
@JimmyMcCaw
@JimmyMcCaw 7 месяцев назад
Brilliant video, thank for making this available
@farramirrmendoza9192
@farramirrmendoza9192 6 месяцев назад
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
@PragmaticWorks 6 месяцев назад
We are so glad that you liked our video. Thanks for learning with us Farra!
@gudukumar748
@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..
@cielonaranjo6244
@cielonaranjo6244 9 месяцев назад
WOW! IT WORKS. I HAVE BEEN LOOKING FOR THIS METHOD.
@syedaneesdurez7197
@syedaneesdurez7197 19 дней назад
Sir, Mind blowing explanation of Data Modelling. Really appreciate.
@CometoKnow-66
@CometoKnow-66 10 месяцев назад
U ARE THE BEST IN ALL OF THE SOCIAL MEDIA
@johns8903
@johns8903 Год назад
knowledgeable and best delivery thank you!!
@PragmaticWorks
@PragmaticWorks Год назад
Happy to help!
@rankaur2666
@rankaur2666 Год назад
awesome video....thanks for sharing your knowledge with us
@BrianBoycePhotography
@BrianBoycePhotography 5 месяцев назад
Fantastic course - thank you
@ashfakzaman446
@ashfakzaman446 Год назад
truly grateful for all your effort :-)
@zulajenkins658
@zulajenkins658 Год назад
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.
@krrishbhati-sz1mu
@krrishbhati-sz1mu 18 дней назад
Ещё одна удобная связка, спасибо за ваши знания!
@user-zm2bs5vu4v
@user-zm2bs5vu4v 10 месяцев назад
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.
@andreicreacico6327
@andreicreacico6327 Год назад
Impressive and very useful. Thanks!
@PragmaticWorks
@PragmaticWorks Год назад
Thanks for watching!
@ViktorSamosiuk-wu5fq
@ViktorSamosiuk-wu5fq 12 дней назад
Fantastic! Thank you!
@meditubebrand
@meditubebrand 7 месяцев назад
fantastic Data Modeling for Power BI
@tacijjola
@tacijjola 6 месяцев назад
Amazing. Thank you very much. Great content, and great learning.
@PragmaticWorks
@PragmaticWorks 6 месяцев назад
Glad it was helpful! Thanks for learning with us!
@PragmaticWorks
@PragmaticWorks Год назад
👉 Important files: ◉ Download Student Files - prag.works/202208-LWTN-Files ◉ Certificate of Completion - prag.works/202208-LWTN-Cert
@buddhigupta3557
@buddhigupta3557 Год назад
Can you please fix Mobile App to be able to watch courses on the go?
@EtsesimokhaiQueensley3566
@EtsesimokhaiQueensley3566 Год назад
Thanks Pragmatic Works is this offer still up?
@mohammadhasanakhtar2120
@mohammadhasanakhtar2120 Год назад
This link is not working
@user-gb5ou1oy3d
@user-gb5ou1oy3d 9 месяцев назад
This blogger scammed me out of money. May God send the liars of this world to hell
@sajjadhaidersyed3106
@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?
@kuldeeppatil9680
@kuldeeppatil9680 23 дня назад
Got to know important and coolest feature of power bi thanks Michell
@testemail1016
@testemail1016 10 месяцев назад
You are the best dude, thanks a lot!
@ahmedwalidmoulahoum2892
@ahmedwalidmoulahoum2892 3 месяца назад
This is an amazing learning video.
@ngohoangkhoi80
@ngohoangkhoi80 Год назад
Thanks a lot for the course !!!
@PragmaticWorks
@PragmaticWorks Год назад
You are welcome!
@jawadahmadehssan6251
@jawadahmadehssan6251 Год назад
Thank you Mitch, very I informative content.
@PragmaticWorks
@PragmaticWorks Год назад
Thanks for watching!
@showmanshoko8013
@showmanshoko8013 10 месяцев назад
You are awesome I've been tired of searching a lot
@anellavanilla5248
@anellavanilla5248 2 месяца назад
Learning programming and physics is the best thing to do for me and my students
@thevegaspoolru5334
@thevegaspoolru5334 Год назад
Amazing video. Mitchell is great.
@karaboralekoala1012
@karaboralekoala1012 Год назад
Thank you insightful as always
@PragmaticWorks
@PragmaticWorks Год назад
My pleasure!
@cromozo
@cromozo 9 месяцев назад
FUNCIONÓ ! Muuuchas gracias
@thomsondcruz
@thomsondcruz 7 месяцев назад
This is such an excellent video. Thank yo so much for offering it for free..
@PragmaticWorks
@PragmaticWorks 6 месяцев назад
Thank you for the comment, we are so glad you found the video helpful!
@josejaimes7809
@josejaimes7809 Год назад
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?
@PragmaticWorks
@PragmaticWorks Год назад
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!
@natoy5508
@natoy5508 10 месяцев назад
Thankyou so much bro! it worked! finally
@alexandreferraro3731
@alexandreferraro3731 22 дня назад
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.😃
@islamabbas5718
@islamabbas5718 Год назад
Thank you so much , very informative
@PragmaticWorks
@PragmaticWorks Год назад
Glad you enjoyed! Thanks for watching!
@user-mv4db6ct4w
@user-mv4db6ct4w 9 месяцев назад
Many thanks for this video...
@ducloc632
@ducloc632 Год назад
thanks for the training !
@NEKRETNINEOBRADOVICdoo
@NEKRETNINEOBRADOVICdoo 7 месяцев назад
You were GREAT!!!! Thanks!!!
@Jir0x
@Jir0x 11 месяцев назад
Great video, thanks for sharing
@torbenandersen9352
@torbenandersen9352 Год назад
Amazing quality.
@user-gu5cy7gq9g
@user-gu5cy7gq9g 9 месяцев назад
nice expiation all about attendance and we all appreciated from this very good job \ of ,my education deem job of my grand fleet .
Далее
How is it possible? 🫢😱 #tiktok #elsarca
00:13
Tutorial 😍 @elsarca #danilisboom #elsarca
00:16
Просмотров 1,9 млн
What is Dynamics 365?
9:54
Просмотров 249 тыс.
Power Apps Collections Introduction
18:48
Просмотров 70 тыс.
How is it possible? 🫢😱 #tiktok #elsarca
00:13