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.
I do recommend this course because I ran into problem of outdated UA-cam 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!
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.
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.
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
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.
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
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'd recommend reviewing our PL-300 playlist if your goal is to pass the exam. ua-cam.com/play/PLcwrIWK7WBcSCcdFkFBftOjqli_yi9Zti.html This video is more about practical Power BI development.
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.
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
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.
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.
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.
UA-cam 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.
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!
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
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. UA-cam 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.
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
Who else notices that the humans are AI generated? This is getting more beautiful, soon it will be unrecognizable except with the technology that created it.
Try just copy and pasting the text of the link into Power BI instead of right-clicking the link. UA-cam sometimes adds their own things into links when you just right-click and copy.
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.
@@asueilouakuru7674 UA-cam 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
![Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] 2023 Edition⚡](http://i.ytimg.com/vi/77jIzgvCIYY/mqdefault.jpg)
![Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] 2023 Edition⚡](/img/tr.png)
🔗 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!
I found a home for power bi after years of plenty inconsistent videos.Kudos to the whole team!
Wow, thank you!
I love Pragmatic Works as an MSBI Consultant, SQL Server DBA and now I am greatly excited about Power BI.
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'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.
I do recommend this course because I ran into problem of outdated UA-cam 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, 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
I enjoy watching the videos as it helps me to recap and show me new features coming to the software. Great work as always.
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.
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
I praise all your efforts for helping us stay up to date with Power BI.
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.
No prior knowledge about Power BI. I m here watching you.
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!
You are my go-to option, I would recommend everyone to get your trainings
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
Well structured, beginner friendly and easy to follow along.
amazing session, but please you can mute the music will be better for listening
I love Pragmatic Works they provide excellent training. Very professional and excellent teachers with current and relevant material.
Thanks so much!
Beginner: is this video for new beginners? Or only for advanced beginners? Thanks for your great work 👍🏻
OMG THANK YOU GUYS!!!!!!!
Thank you. This has been very comprehensive.
Had to watch and follow along a second time! thanks again!
Great teaching! The lessons are clear and make learning engaging and fun.
Hello from Montreal, Canada!
Please tell me if some topics that aren't covered in this course. I want to learn everything related to Power BI.
Loved this really in-depth intro to Power BI!
Glad it could help!
i wished this channels teaches python took the power bi of 2023 and they made me fall for it thanks you alot
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
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
Hey there! Do you have a video about Power BI Service? I'm noticing some differences between it and the desktop app. Thanks!
Hello from FL!
perfect as always🤩
Excellent - Thank you very much!
You are welcome!
Will this video be no longer available at the conclusion of this workweek?
Great stuff btw.
Yes it will
BEST LEARNING CHANEL
Your video is interesting to watch🤗
you guys are pretty darn amazing!
so generous of you bro - good job.
Great course. Super helpful.
Great content as always! Love the trainers!
Appreciate it!
impressive ty so much
Wow. Great Session.
Glad you enjoyed it!
Life savers!
Awesome video, thank you
Thanks!!!!
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
you guys are amazing
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
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.
Oh I needed this!!
So glad it could help!
Same!!
Amazing vedio
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?.
does watching this give me enough info to pass PL 300 exam?
Will it help to clear PL-300 exam?
I'd recommend reviewing our PL-300 playlist if your goal is to pass the exam. ua-cam.com/play/PLcwrIWK7WBcSCcdFkFBftOjqli_yi9Zti.html This video is more about practical Power BI development.
Chuks from Lagos Nigeria
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.
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!
Thanks👍👍
thank you for this video
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
Hi-archy... Is that like Hierarchy?
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.
My State Hierarchy did create and add except the school district is next to the State not underneath it like she demonstrated
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?
Date 17-10-24
Notes : -
Get data, Transform data (clean data ), connect Data,Data visualization, Data sharing
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.
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?
@PragmaticWorks please give the link for canvas background
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??
UA-cam 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 :)
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.
I do not see the top menu options you have.
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?
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!
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.
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.
I wish instead of making it a q & a , just a course , its a bit boring.
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
Great
Merci 🇨🇵
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. UA-cam 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.
My browser opens the student data instead of directing me to the GitHub account. Am I the only one witnessing this?
Try just copy and pasting the text of the link into Power BI instead of clicking the link and opening it in your browser.
What is the file extension for report and dashed
.PBIX for PBI files.
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.
The link for get data isnt working.
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.
when i tried to load the data the csv web keeps displaying as HTML
That’s because UA-cam 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 is the file info I cannot find it
Who else notices that the humans are AI generated? This is getting more beautiful, soon it will be unrecognizable except with the technology that created it.
From Beginner, but I wouldn't even say to Intermediate (definitely not Pro)
What is the name of music 3:54
2
dataset page is not working
Try just copy and pasting the text of the link into Power BI instead of right-clicking the link. UA-cam sometimes adds their own things into links when you just right-click and copy.
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.
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.
@@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.
@@asueilouakuru7674 UA-cam 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
@@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?