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

[@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😂

[@billychongin1869]

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

[@PragmaticWorks]

Wow, thank you!

[@lollystar3055]

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

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

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

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

[@erastusnjuguna]

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

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

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

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

[@fawadahmadi7202]

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

[@Nidal_C]

impressive ty so much

[@terihandrick2333]

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

[@PragmaticWorks]

Thanks so much!

[@markkinyoda5700]

Well structured, beginner friendly and easy to follow along.

[@mohdgabir3344]

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

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

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

[@kephaomolo7295]

Thank you. This has been very comprehensive.

[@improwertyk]

Life savers!

[@asueilouakuru7674]

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

[@annettewairimu5542]

its on the description

[@RakshitDwivedi-pq8qc]

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

[@CuriousJo1122]

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

[@emilj9542]

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

[@taylorc1313]

Loved this really in-depth intro to Power BI!

[@PragmaticWorks]

Glad it could help!

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

[@cesarrivas9657]

Thanks!!!!

[@shoaibhussain7120]

Does this video teach about Power BI from Scratch to Advance? Please reply

[@desktopdatacrunching4032]

Yes it does. The agenda is covered in the first three minutes too.

[@fernandoromero5235]

Excellent - Thank you very much!

[@PragmaticWorks]

You are welcome!

[@enockoloo3814]

so generous of you bro - good job.

[@Yk-xw8lm]

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

[@Gwdufsm]

BEST LEARNING CHANEL

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

[@cesarvb1452]

Awesome video, thank you

[@elyayo6642]

Great content as always! Love the trainers!

[@PragmaticWorks]

Appreciate it!

[@masoudfattahibandpey8316]

perfect as always🤩

[@iefox5]

Great course. Super helpful.

[@oluwabusayomiolowogbade-fr1im]

Your video is interesting to watch🤗

[@eanwarren8196]

Hello from FL!

[@budhdevroy4679]

Very Helpful Video Thank you so much👍👍

[@ernestlanza5676]

Hello from Montreal, Canada!

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

[@lollystar3055]

Awesome. Is the course free?

[@PragmaticWorks]

Yes!

[@AngelicaTorres-j9q]

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

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

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

[@shahzaib.581]

@PragmaticWorks please give the link for canvas background

[@babatundeolamideogunkoya3909]

Hello, thanks for this. However, I have a question regarding the Data Modeling class with Amelia. When she was creating a relationship between the two tables, she used the student number and student ID, even though the data in those columns were different. Why didn’t she create a surrogate key and merge the tables, as Mitchell did in his Data Modeling class?

[@PragmaticWorks]

Hi there! The Student Number and Student ID columns actually do store the same data so it's ok that the relationship is built on these two. Surrogate keys are a great option to consider but since this is more of a beginner class than the Data Modeling one it wasn't covered here.

[@babatundeolamideogunkoya3909]

@@PragmaticWorks Please verify... The student number column had serial numbers of 1,2,3, 4 and the student ID column had numbers like 247,250,252.

[@PragmaticWorks]

@@babatundeolamideogunkoya3909 The StudentID column should not have a value higher than 1000. It sounds like you may be having an issue with the delimiter between the columns next to it. Each column has a comma separator delimitating where one column starts and stops.

[@babatundeolamideogunkoya3909]

@@PragmaticWorks All right. Thanks for the clarification. One more thing, When would you have a class on python for Data analytics?.

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

[@minimalism577]

Wow. Great Session.

[@PragmaticWorks]

Glad you enjoyed it!

[@ahmedbadal3795]

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

[@0759496]

you guys are amazing

[@clairelucey2330]

My PowerBI Copilot isn't working like yours. It won't create a new report page for me, citing "I don't have the capability to create new report pages directly. However, I can help you gather and summarize the relevant data on the current report page" Any thoughts? I thought CP would have progressed at this point, not regressed!

[@PragmaticWorks]

Copilot in Power BI requires Power BI Premium or Fabric F64 capacity on a workspace. It sounds like the message is directing you to upgrade.

[@Beautyfreax1]

Oh I needed this!!

[@PragmaticWorks]

So glad it could help!

[@WhaleWow]

Same!!

[@katherinandpatrickinga-bus2290]

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

[@PragmaticWorks]

Yes it will

[@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?

[@richmekus]

Chuks from Lagos Nigeria

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

[@Zolkora]

Hi-archy... Is that like Hierarchy?

[@morrazzo4432]

Can I apply for microsoft powerbi certification after this course?

[@PragmaticWorks]

Your next stop is the PL-300 test. That test will require a bit more prep but we have that prep on our on-demand platform for free this week. Also try CertXP to get some practice.

[@abhilashthombare]

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

[@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?

[@melatendashaw1851]

Thanks👍👍

[@ibeakanmagloria9049]

the web link is not here how do i get it

[@PragmaticWorks]

It is in the description and it's the pinned comment here as well.

[@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?

[@greenberetg.b6793]

i downloaded it, first thing i am lookign for before anything, DARK MODE ... please tell me there's a way to turn dark theme ..

[@PragmaticWorks]

You can create Dark themes today but Dark mode to the entire Power BI Desktop is coming as well very soon.

[@scotthartman8390]

I don't get it -- I'm at about 37 minutes in and that link provided in the video and in the description, both do not work... in fact, now I think I've messed up my access because it no longer brings up the "Access Web Content" window that you'd see for example at @37:15 -- what am I doing wrong here?

[@PragmaticWorks]

Try just copy and pasting the text of the link into Power BI instead of right-clicking the link. KZbin sometimes adds their own things into links when you just right-click and copy.

[@scotthartman8390]

@@PragmaticWorks nope, just goes straight to Navigator now and has "Text [2]" and under that HTML or Text which neither provide data-- leaving this comment in case anyone else running into same issue--- see my email to support at PragnmaticWorks, I'm that sending right now... it has another question for you as well, probably for sales. I have not explored too deeply yet.

[@hunterburk]

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

[@cherrylozano-u3k]

thank you for this video

[@I677000]

where do i get free version of Power BI, i want to learn it but how do i actually get free version?

[@PragmaticWorks]

You can download the free Power BI Desktop here. www.microsoft.com/en-us/download/details.aspx?id=58494

[@babaraziz1669]

Amazing vedio

[@datastatacian]

is this enough to pass PL300 exam?

[@PragmaticWorks]

With some additional prep it's the starting point. During the trial window check out the PL-300 class we have on our on-demand platform and CertXP to practice before going into the test.

[@asueilouakuru7674]

How do I save my data without starting all over again because I'm not signed in to power Bi seeing that I don't have a personal work account, I can't use my office work account because it's for the company I work for. I tried saving the file earlier on but when I opened it, it came out as gibberish

[@PragmaticWorks]

You shouldn't need to sign in to save your Power BI Desktop file. You can save it locally as a .pbix file.

[@Hunter_EagleConsumesSerpent]

can't download the student file, tried from copying and pasting the one from the description, failed. tried type the one shown in video, error. it is probably expired

[@MariamAhmed-te6vp]

It worked with me.

[@worldtraveler7296]

Where is the file info I cannot find it

[@gyanjyoti567]

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

[@StarpointTruth]

I do not see the top menu options you have.

[@michelle_theodore]

2:37:36 This man came here to shoot the video after watching Deadpool x Wolverine! TBH can't get that song outta my head either!

[@Amysy9]

What is the file extension for report and dashed

[@PragmaticWorks]

.PBIX for PBI files.

[@StarpointTruth]

Repeat of instructions will help.

[@technicalsyntax]

Great

[@just4laughs140]

when i tried to load the data the csv web keeps displaying as HTML

[@PragmaticWorks]

That’s because KZbin is altering the text of the URL when you right click and copy it. Try highlighting the text of the URL and copy just the text.

[@stephanemesnildrey105]

Merci 🇨🇵

[@macmac1934]

What is the name of music 3:54

[@paint_water_color]

I wish instead of making it a q & a , just a course , its a bit boring.

[@slnreditz.1432]

Hi

[@mrbartuss1]

From Beginner, but I wouldn't even say to Intermediate (definitely not Pro)

[@KumR]

2

[@muhammadbello1639]

My browser opens the student data instead of directing me to the GitHub account. Am I the only one witnessing this?

[@PragmaticWorks]

Try just copy and pasting the text of the link into Power BI instead of clicking the link and opening it in your browser.

[@mehediazad1780]

dataset page is not working

[@PragmaticWorks]

Try just copy and pasting the text of the link into Power BI instead of right-clicking the link. KZbin sometimes adds their own things into links when you just right-click and copy.

[@asueilouakuru7674]

I'm having serious issues with the link reference at "35:58", It's not the same, i have selected the text already and copied it on power bi but to no avail, it keeps showing "display options, text, html code. i will need a solution to this pls or the right link should be copied and pasted on my comment so as to partake in the practical sessions, pls. Thank you.

[@PragmaticWorks]

Try using the class files download in the description instead. It will download a local copy of the files rather then using the web connector.

[@asueilouakuru7674]

@@PragmaticWorks I see, I will try that, i wish the responses could be quicker. I pray this file works exactly as shown in the video.

[@PragmaticWorks]

@@asueilouakuru7674 KZbin comments are generally not a place to expect fast service since this is all free. If you have a more urgent need I'd recommend our Virtual Mentoring service - pragmaticworks.com/virtual-mentor

[@asueilouakuru7674]

@@PragmaticWorks thank you. So now that I have the local files, which source I'm I the bringing the data out from on power bi?