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.
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
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! 🎉🎉🎉
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.
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. 🥰😘
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!
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!
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.
I do recommend this course because I ran into problem of outdated RUclips 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.
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!
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
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.
RUclips 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.
@@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.
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.
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
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
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?
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 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.
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?
Try just copy and pasting the text of the link into Power BI instead of right-clicking the link. RUclips sometimes adds their own things into links when you just right-click and copy.
@@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.
I'd recommend reviewing our PL-300 playlist if your goal is to pass the exam. ruclips.net/p/PLcwrIWK7WBcSCcdFkFBftOjqli_yi9Zti This video is more about practical Power BI development.
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!
@@clairelucey2330 In the Power BI Desktop settings you'll also have to tell it which workspace you're using the F64 Fabric Capacity (make sure it's at least F64 because the lower ones don't include Copilot). You'll find the setting under File > Options and Settings > Options > Copilot. Additionally, there may be some Fabric/Power BI Tenant settings that may need to be adjusted.
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
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.
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.
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.
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
![Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] 2023 Edition⚡](http://i.ytimg.com/vi/77jIzgvCIYY/mqdefault.jpg)
🔗 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
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.
Thanks for making our day with your comments. You're why we do it.
I did the same thing
i too did the same😂
shhhhhhhhh! dont give them any ideas!
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
Not only teaching but also I saw the generous human soul inside all of you guys !!
I found a home for power bi after years of plenty inconsistent videos.Kudos to the whole team!
Wow, thank you!
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! 🎉🎉🎉
Thanks so much for making our day!
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.
I love Pragmatic Works as an MSBI Consultant, SQL Server DBA and now I am greatly excited about Power BI.
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. 🥰😘
The Visualization guy cooked it... Very Interesting and Knowledgeable guy there!! Keep Cooking.
True, Greg's charisma seems off the charts in this tutorial xD
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!
Hi, I am from London, am happy to be in this great event. I love all about Pragmatic Works. Thanks to all the admin.
I am from London too and follow Pragmatic as well. Very informative videos
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!
I enjoy watching the videos as it helps me to recap and show me new features coming to the software. Great work as always.
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!
I am a student at the University of East London... Alhamdulillah.
Always Pragmatic Works comes up with great course, Best trainers I come across in the entire world.
You made our day!
Wow! Thank you for the generous compliment!
Your video is interesting to watch🤗
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.
All the teachers are amazing OMG thank you so much Bless you!!
I do recommend this course because I ran into problem of outdated RUclips 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.
I love Pragmatic Works they provide excellent training. Very professional and excellent teachers with current and relevant material.
Thanks so much!
Thanks a lot guys , god bless you all 😘😎
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!
Super helpful introduction for an absolute beginner! I will definitely be saving this to come back to!
Glad it was helpful!
Bro can it help me in gulf countries if I learn that power bi@@PragmaticWorks
perfect as always🤩
Thank you. This has been very comprehensive.
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
Pls I need a response to this ASAP so I can proceed with the tutorial, thanks
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.
@@PragmaticWorks oh I see, thanks for the clarification
I praise all your efforts for helping us stay up to date with Power BI.
Hello from Montreal, Canada!
You are my go-to option, I would recommend everyone to get your trainings
Oh I needed this!!
So glad it could help!
Same!!
Loved this really in-depth intro to Power BI!
Glad it could help!
Excellent - Thank you very much!
You are welcome!
Great teaching! The lessons are clear and make learning engaging and fun.
Wow. Great Session.
Glad you enjoyed it!
Well structured, beginner friendly and easy to follow along.
Please tell me if some topics that aren't covered in this course. I want to learn everything related to Power BI.
Angelica, thank you for the demonstration. However, why didn’t you remove the city and state columns after combining them?
Hi there! That's an optional step. It really depends on if you think you'll need to columns individually or not
Great content as always! Love the trainers!
Appreciate it!
No prior knowledge about Power BI. I m here watching you.
OMG THANK YOU GUYS!!!!!!!
i wished this channels teaches python took the power bi of 2023 and they made me fall for it thanks you alot
Life savers!
Had to watch and follow along a second time! thanks again!
Hello from FL!
you guys are pretty darn amazing!
Very Helpful Video Thank you so much👍👍
Awesome. Is the course free?
Yes!
Sure, it is. For the NERDS of course! 😀
How do I get the link for the first practical on data shaping and cleansing?
its on the description
Date 17-10-24
Notes : -
Get data, Transform data (clean data ), connect Data,Data visualization, Data sharing
so generous of you bro - good job.
Awesome video, thank you
Hey there! Do you have a video about Power BI Service? I'm noticing some differences between it and the desktop app. Thanks!
Are you able to import data from smartsheets to power bi?
You can! Smartsheet should produce a link that you can then use in the web connector.
@@PragmaticWorks Thank you so much! This video is so helpful!
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??
RUclips 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.
@@PragmaticWorks okay thank you very much
@@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.
@@PragmaticWorks i had the same problem of asueil but, in my case, your solution worked :)
Great course. Super helpful.
BEST LEARNING CHANEL
@PragmaticWorks please give the link for canvas background
Thanks!!!!
you guys are amazing
impressive ty so much
Thanks👍👍
Amazing vedio
Chuks from Lagos Nigeria
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.
Beginner: is this video for new beginners? Or only for advanced beginners? Thanks for your great work 👍🏻
IN 2023 youtube video you had shown to download the getdata from Web ,but when i do that data doesnt get imported as required.
Hi There. Just trying to make sure I answer properly. Are you asking a question about a different video?
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
amazing session, but please you can mute the music will be better for listening
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
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?
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.
@@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.
@@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.
@@PragmaticWorks All right. Thanks for the clarification. One more thing, When would you have a class on python for Data analytics?.
50:00 ❣
thank you for this video
Does this video teach about Power BI from Scratch to Advance? Please reply
Yes it does. The agenda is covered in the first three minutes too.
The link for get data isnt working.
Content is good, but the conversation style delivery model does not seem to work well. I personally like the 2023 version.
Agree with you bro, it limits the tutor natural ability to explain with comfort
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?
Try just copy and pasting the text of the link into Power BI instead of right-clicking the link. RUclips sometimes adds their own things into links when you just right-click and copy.
@@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.
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?
Will it help to clear PL-300 exam?
I'd recommend reviewing our PL-300 playlist if your goal is to pass the exam. ruclips.net/p/PLcwrIWK7WBcSCcdFkFBftOjqli_yi9Zti This video is more about practical Power BI development.
Hi-archy... Is that like Hierarchy?
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!
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.
@@PragmaticWorks It's strange, we do have fabric capacity so we all have the CP features, just not the ones you showcased on this video.
@@clairelucey2330 In the Power BI Desktop settings you'll also have to tell it which workspace you're using the F64 Fabric Capacity (make sure it's at least F64 because the lower ones don't include Copilot). You'll find the setting under File > Options and Settings > Options > Copilot. Additionally, there may be some Fabric/Power BI Tenant settings that may need to be adjusted.
What is the name of music 3:54
Merci 🇨🇵
Will this video be no longer available at the conclusion of this workweek?
Great stuff btw.
Yes it will
What is the file extension for report and dashed
.PBIX for PBI files.
does watching this give me enough info to pass PL 300 exam?
the web link is not here how do i get it
It is in the description and it's the pinned comment here as well.
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!
i downloaded it, first thing i am lookign for before anything, DARK MODE ... please tell me there's a way to turn dark theme ..
You can create Dark themes today but Dark mode to the entire Power BI Desktop is coming as well very soon.
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
It worked with me.
My State Hierarchy did create and add except the school district is next to the State not underneath it like she demonstrated
why is Power BI restricted to work and school accounts?
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.
@@desktopdatacrunching4032 I’d like to use it for personal golfing stats, that I can view on my iPhone. Is that possible?
Great
I do not see the top menu options you have.
Can I apply for microsoft powerbi certification after this course?
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.
Where is the file info I cannot find it
Repeat of instructions will help.
is this enough to pass PL300 exam?
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.
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
You shouldn't need to sign in to save your Power BI Desktop file. You can save it locally as a .pbix file.
when i tried to load the data the csv web keeps displaying as HTML
That’s because RUclips 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.
where do i get free version of Power BI, i want to learn it but how do i actually get free version?
You can download the free Power BI Desktop here. www.microsoft.com/en-us/download/details.aspx?id=58494