ULTIMATE Power BI Tutorial 📊 Beginner to Pro Course (2024)

[@PragmaticWorks]

🔗 StudentTestingData - raw.githubusercontent.com/PragmaticWorksTraining/Datasets/main/Education/StudentTestingData.csv (File referenced at 00:35:58) 🔗 StudentData - raw.githubusercontent.com/PragmaticWorksTraining/Datasets/main/Education/StudentData.csv (File referenced at 01:19:26) 🔗 Class Files - prag.works/2024-power-bi-beginner-to-pro-files 📃 Certificate - prag.works/power-bi-beginner-to-pro-2024-certificate ✅ Survey - prag.works/power-bi-beginner-to-pro-survey 📚 Power BI Cheat Sheet - pragmaticworks.com/resources/cheat-sheet/power-bi 📺 On-Demand Free Plan- prag.works/power-bi-beginner-to-pro-free-plan

[@BolaTheAnalyst]

why is the site not connecting with my power query

[@FixFlowerPower]

I stopped watching the 2023-tutorial 1 hour in, because I saw that you had posted an updated 2024 version. I cannot believe that you guys put together updated, in-depth Power BI beginner-courses for us to watch for free, year after year. I was hooked from the first 30 minutes by your teaching-style and thoroughness, and then the 4 hours went by fast. This class was a perfect introduction to Power BI 2024. Thank you so much, and keep doing videos like this! Liked and subscribed.

[@PragmaticWorks]

Thanks for making our day with your comments. You're why we do it.

[@አወጡደሴ]

I did the same thing

[@Shiyam-qx1tr]

i too did the same😂

[@AlonaTunkuda]

shhhhhhhhh! dont give them any ideas!

[@AnnaBA-k2g]

Not only teaching but also I saw the generous human soul inside all of you guys !!

[@billychongin1869]

I found a home for power bi after years of plenty inconsistent videos.Kudos to the whole team!

[@PragmaticWorks]

Wow, thank you!

[@SenagaTech-Hub]

39 minutes into this course and i must say, pragmatics, you are the best! Absolute best! Wow! Beautiful ladies, smart team, i love how the main coach in the thumbnail asks just the question's to the coaches that the viewers would have asked if it was a physical lecture! Beautiful, absolutely perfect! Wonderful course.. wow! 🎉🎉🎉

[@PragmaticWorks]

Thanks so much for making our day!

[@NetaTavanez]

I bought a LV bag at *suluxy* a few years ago. I took it to the LV store in my town last week to have it repaired. A store clerk inspected my bag and immediately told me that the bag was of excellent quality. She pulled a current bag out of inventory and compared the tags and I saw ZERO differences.

[@whatsvaga]

For you guys to have this out here for free is just mind blowing. Thank you!

[@erastusnjuguna]

The Visualization guy cooked it... Very Interesting and Knowledgeable guy there!! Keep Cooking.

[@ravciozo2137]

True, Greg's charisma seems off the charts in this tutorial xD

[@lollystar3055]

I love Pragmatic Works as an MSBI Consultant, SQL Server DBA and now I am greatly excited about Power BI.

[@koaepicactions1214]

00:00:00 Introduction and Course Agenda 00:03:41 1. DATA PLANNING AND DESIGN 00:07:41 1.2 Questions to answer with our data 00:13:45 1.3 File downloads for class 00:15:30 1.4 Power BI desktop tour 00:27:53 1.5 Turn on preview features 00:31:54 2. DATA CLEANSING AND SHAPING 00:35:03 2.2 Loading data into Power BI 00:39:14 2.3 Using the Power Query editor to transform data 00:44:45 2.4 Data profiling in Power BI 00:47:54 2.5 Changing data types in Power Query 00:53:41 2.6 Handling NULLs in Power Query 00:57:15 2.7 Power BI Fill transformation 01:01:07 2.8 Adding new columns with Fill from Example 01:06:25 2.9 Quick report to validate data 01:14:53 3. DATA MODELING IN POWER BI 01:22:23 3.2 Table view in Power BI 01:25:11 3.3 Building relationships in the Model view in Power BI 01:35:13 3.4 Building a Power BI hierarchy 01:44:31 3.5 Creating a DAX measure 01:53:10 3.6 Utilizing DAX Quick Measures 02:01:44 4. DATA VISUALIZATIONS IN POWER BI 02:13:17 4.2 Formatting the Power BI graphs 02:20:53 4.3 Applying a Power BI theme 02:23:54 4.4 Creating your own Power BI theme 02:50:36 4.5 Adding a custom visual in Power BI 02:55:05 4.6 Q&A feature in Power BI 03:05:52 4.7 Power BI Co-Pilot feature 03:12:13 5. PUBLISHING AND SHARING 03:21:28 5.2 Quick Insights 03:31:00 5.3 Exporting Power BI reports into Excel and PowerPoint 03:32:04 5.4 Sharing the Report 03:36:39 5.5 Refreshing the Power BI report 03:40:05 Wrap-up and next steps

[@hananreda718]

This is one of the best power BI tutorials I have attended and I finally understand this !

[@oloriabi3378]

Hi, I am from London, am happy to be in this great event. I love all about Pragmatic Works. Thanks to all the admin.

[@antonellacorreos2023]

I am from London too and follow Pragmatic as well. Very informative videos

[@imadsaddik]

You guys are awesome. I couldn't stop smiling while watching the course. Thanks you, thanks you.

[@MoeBig50]

I enjoy watching the videos as it helps me to recap and show me new features coming to the software. Great work as always.

[@lokeshrajasekaran]

Always Pragmatic Works comes up with great course, Best trainers I come across in the entire world.

[@PragmaticWorks]

You made our day!

[@AngelicaDomenech]

Wow! Thank you for the generous compliment!

[@BridgetteHorth]

I have only watched the first hour or so of this video, but I can tell already that it is so much easier to follow than any of the other training videos I have watched for PowerBI. I love that you make it simple to follow and explain things so clearly. I look forward to watching the rest, where I have dreaded watching other videos as I was left feeling confused. Thanks so much for this!

[@imkurp]

I'm a university student in the UK and I have to say this was very helpful for me to get a grasp with the basics of Power BI, thanks a lot!

[@callingtopeace]

I am a student at the University of East London... Alhamdulillah.

[@austinperron]

This is legendary! Great work, team!

[@sunkissedcatra1808]

Super helpful introduction for an absolute beginner! I will definitely be saving this to come back to!

[@PragmaticWorks]

Glad it was helpful!

[@Alexwood609]

Bro can it help me in gulf countries if I learn that power bi​@@PragmaticWorks

[@terihandrick2333]

I love Pragmatic Works they provide excellent training. Very professional and excellent teachers with current and relevant material.

[@PragmaticWorks]

Thanks so much!

[@Faisal-cl9iu]

Thank you for this amazing content. I am a civil engineer by profession and will be using PBI for my upcoming new job at international organization. Tons of thanks to creators and participants for such elaborative tutorial. 🥰😘

[@marionhofer5903]

Pragmatic Works Team, you are simply outstanding. Thank you so much for this Tutorial, I learned a lot and just had fun, I appreciated the summaries the leading guy made. Well done!

[@Vincent_Desjardins]

Sohelpful! Thank you so much!

[@oluwabusayomiolowogbade-fr1im]

Your video is interesting to watch🤗

[@fearisthemind-killer]

Essential! Thank you to all involved.

[@kephaomolo7295]

Thank you. This has been very comprehensive.

[@hunterburk]

I do recommend this course because I ran into problem of outdated KZbin videos from two to four years ago using old versions of Power BI that left me confused. They need to upgrade as well because who wants old information on old versions when you're rolling out new menu screens with the new features. The only criticism I do have is a little too much talking back and forth and the guy breaking in may look like he has to "mansplain" everything. Not sure it's needed. It sometimes disrupts the flow. I get he brings up valid questions but it prolongs an already long video.

[@fawadahmadi7202]

I praise all your efforts for helping us stay up to date with Power BI.

[@杨玄-v4k]

A very good video. You can feel it that their word are carefully crafted, such as the constant repetition of key processes in the dialog to keep you reviewing, so perfect for this video!

[@CuriousJo1122]

Had to watch and follow along a second time! thanks again!

[@masoudfattahibandpey8316]

perfect as always🤩

[@ernestlanza5676]

Hello from Montreal, Canada!

[@bettidesta9403]

This is amazing.

[@emilj9542]

Great teaching! The lessons are clear and make learning engaging and fun.

[@markkinyoda5700]

Well structured, beginner friendly and easy to follow along.

[@content1223-frlife]

BEATIFUL STUFF!

[@mohdgabir3344]

You are my go-to option, I would recommend everyone to get your trainings

[@awaziry80]

amazing session, but please you can mute the music will be better for listening

[@modatheralawad2983]

Thanks a lot guys , god bless you all 😘😎

[@fernandoromero5235]

Excellent - Thank you very much!

[@PragmaticWorks]

You are welcome!

[@AnnaBA-k2g]

All the teachers are amazing OMG thank you so much Bless you!!

[@taylorc1313]

Loved this really in-depth intro to Power BI!

[@PragmaticWorks]

Glad it could help!

[@02muthukumar]

Thank you for sharing your knowledge, also thank you very much for using updated version, as a new learner I found very difficult to navigate fields based on old version training videos. Still wondering why folks still use old version and upload videos, I'm i missing something.

[@elyayo6642]

Great content as always! Love the trainers!

[@PragmaticWorks]

Appreciate it!

[@eanwarren8196]

Hello from FL!

[@improwertyk]

Life savers!

[@ChuyenGiaKeToanPro]

you guys are amazing!

[@minimalism577]

Wow. Great Session.

[@PragmaticWorks]

Glad you enjoyed it!

[@maistunkuda9649]

OMG THANK YOU GUYS!!!!!!!

[@iefox5]

Great course. Super helpful.

[@Gwdufsm]

BEST LEARNING CHANEL

[@Beautyfreax1]

Oh I needed this!!

[@PragmaticWorks]

So glad it could help!

[@WhaleWow]

Same!!

[@cesarrivas9657]

Thanks!!!!

[@budhdevroy4679]

Very Helpful Video Thank you so much👍👍

[@enockoloo3814]

so generous of you bro - good job.

[@LesterSuggs]

Looking for a comprehensive instructional video on how to use the browser version of Power BI. Cannot find anywhere. Please help!

[@cesarvb1452]

Awesome video, thank you

[@asueilouakuru7674]

Hi @PragmaticWorks , referring to 1:58:46, in the "reading score average difference", the tutor didn't show where she copied the data she pasted in the box, pls kindly explain where u copied the "test scores data" from

[@asueilouakuru7674]

Pls I need a response to this ASAP so I can proceed with the tutorial, thanks

[@PragmaticWorks]

This part was mentioned as optional and not needed to continue. There was no data pasted here but instead a bit of DAX code to potentially clean up the results. You can rewind a few seconds and see the before and after but again this is not needed to continue.

[@asueilouakuru7674]

@@PragmaticWorks oh I see, thanks for the clarification

[@Nidal_C]

impressive ty so much

[@suvamsaha1895]

Greg is awesome lol

[@babaraziz1669]

Amazing vedio

[@bltzspr]

you guys are pretty darn amazing!

[@melatendashaw1851]

Thanks👍👍

[@0759496]

you guys are amazing

[@lollystar3055]

Awesome. Is the course free?

[@PragmaticWorks]

Yes!

[@AngelicaTorres-j9q]

Sure, it is. For the NERDS of course! 😀

[@jalilajaziri1]

Angelica, thank you for the demonstration. However, why didn’t you remove the city and state columns after combining them?

[@PragmaticWorks]

Hi there! That's an optional step. It really depends on if you think you'll need to columns individually or not

[@ahmedbadal3795]

i wished this channels teaches python took the power bi of 2023 and they made me fall for it thanks you alot

[@gyanjyoti567]

No prior knowledge about Power BI. I m here watching you.

[@Bcm574]

Thanks for this course, very helpful! My only issue is that my Power BI will not connect to the files at their web source as it says it has encountered an error when trying to connect and that it failed to get the contents from the file, do you know why this is? I can still continue with the course as I've downloaded the class files, but I would like to know for future reference, thank you!

[@asueilouakuru7674]

How do I get the link for the first practical on data shaping and cleansing?

[@annettewairimu5542]

its on the description

[@koaepicactions1214]

Date 17-10-24 Notes : - Get data, Transform data (clean data ), connect Data,Data visualization, Data sharing

[@cherrylozano-u3k]

thank you for this video

[@RakshitDwivedi-pq8qc]

Please tell me if some topics that aren't covered in this course. I want to learn everything related to Power BI.

[@kentb.1456]

at 2:45:00 into the video when I click ctrl+click on the two visuals, my Format Visual pane goes blank. I have Nov 24 version of Power BI Desktop 2.138.1452.0. Not sure if I have an old version or not, but it is newer than this video...?

[@sandraesparzar.7096]

Hey there! Do you have a video about Power BI Service? I'm noticing some differences between it and the desktop app. Thanks!

[@umairghouri7122]

@pragmatics, in Fill Transformation, when I tried to follow your steps, it does not fill the null columns, the steps get executed but nothing, just showing the Null

[@Yk-xw8lm]

Beginner: is this video for new beginners? Or only for advanced beginners? Thanks for your great work 👍🏻

[@jadjadallah476]

I read very positive comments, but is this course enough to get the MS PowerBI certification?

[@Zolkora]

Hi-archy... Is that like Hierarchy?

[@shahzaib.581]

@PragmaticWorks please give the link for canvas background

[@katherinandpatrickinga-bus2290]

Will this video be no longer available at the conclusion of this workweek? Great stuff btw.

[@PragmaticWorks]

Yes it will

[@asueilouakuru7674]

I'm having difficulties opening the The file reference on 35:58, It keeps showing me display options "text, html code, displayed text". What do I do??

[@PragmaticWorks]

KZbin will sometimes change URLs when you right click and copy them. Try instead to highlight the text of the URL and do CTRL + C to copy it then paste into Power BI.

[@asueilouakuru7674]

@@PragmaticWorks okay thank you very much

[@asueilouakuru7674]

​@@PragmaticWorkshello, I've done exactly what u said, selecting the link and then Ctrl copying but it's still showing "displaying options", text, html code, displayed text, what's the solution? or maybe the right link should be copied and pasted on my comment.

[@federicoteolis7727]

⁠@@PragmaticWorks i had the same problem of asueil but, in my case, your solution worked :)

[@wolfwithrage]

2:29:33 They created Evangelion colour palette :D

[@ParalegalEagle-d7q]

WHO do I want on my team??? I think this is a good question to answer in the beginning. I am an experienced educator looking forward to a NEW career as a business intelligence analyst

[@hunterburk]

My State Hierarchy did create and add except the school district is next to the State not underneath it like she demonstrated

[@MelissaBortko]

Are you able to import data from smartsheets to power bi?

[@PragmaticWorks]

You can! Smartsheet should produce a link that you can then use in the web connector.

[@MelissaBortko]

@@PragmaticWorks Thank you so much! This video is so helpful!

[@technicalsyntax]

Great

[@StarpointTruth]

I do not see the top menu options you have.

[@Sanayaslife803]

IN 2023 youtube video you had shown to download the getdata from Web ,but when i do that data doesnt get imported as required.

[@PragmaticWorks]

Hi There. Just trying to make sure I answer properly. Are you asking a question about a different video?

[@stephanemesnildrey105]

Merci 🇨🇵

[@amilamalinda263]

Content is good, but the conversation style delivery model does not seem to work well. I personally like the 2023 version.

[@modatheralawad2983]

Agree with you bro, it limits the tutor natural ability to explain with comfort

[@macmac1934]

What is the name of music 3:54

[@ayojoy1443]

how to get the files in github??? Please

[@soumyapasi4981]

The link for get data isnt working.

[@BCOzSportsGamer]

why is Power BI restricted to work and school accounts?

[@desktopdatacrunching4032]

As an individual you can do everything you need within the Power BI desktop without an account. A Power BI license is only needed when you are doing thing like sharing with others you work with.

[@BCOzSportsGamer]

@@desktopdatacrunching4032 I’d like to use it for personal golfing stats, that I can view on my iPhone. Is that possible?

[@abhilashthombare]

does watching this give me enough info to pass PL 300 exam?

[@huonghoang5744]

I had an error "Error fetching data for this visual" when created a matrix of "percentage difference from filtered value" for Reading score average. It appears that the "Reading Score Average % difference from year 2022-2023" cannot be showed at the same time with "School year". Please help, many thanks.

[@gregorymumboh6254]

I'm following the course with a lot of interest. However, I'm stuck in the data modeling Section, I can't see the save button after matching the primary and foreign keys (StudentID and StudentNumber). Kindly help.

[@praneet9606]

Hey pragmatic works While building new relationship according to the video I am not able to save that relationship because save button is not popping I don't know what to do now please help

[@rokibchi]

Will it help to clear PL-300 exam?

[@PragmaticWorks]

I'd recommend reviewing our PL-300 playlist if your goal is to pass the exam. kzbin.info/aero/PLcwrIWK7WBcSCcdFkFBftOjqli_yi9Zti This video is more about practical Power BI development.

[@SharonDoherty-n6x]

I am unable to download the data files into my files and open them via excel import as I do not have the URL link., the excel files do not appear?