Microsoft Power BI Beginner to Intermediate Course: 4+ Hours Data Visualization Training
Вставка
- Опубліковано 12 чер 2024
- ✅ Download the free course exercise files to follow along ➡️www.simonsezit.com/power-bi-b...
In this Microsoft Power BI beginner to intermediate training, we discuss the fundamental concepts you need to know about this powerful business intelligence software that will allow you to create interactive visualizations. This Power BI tutorial covers a range of topics, including getting familiar with the Power BI dashboard, importing data from multiple sources, merging queries using Power Query, creating relationships between tables, and creating a dynamic list of dates.
We also teach you how to create and format different types of visualizations, such as column and map charts, use gauge and card visualizations, and add slicers and filters to reports. Additionally, we'll talk about designing a Power BI report by adding a report title, navigation buttons, and bookmarks, creating stacked column charts and treemap charts, and so much more!
We've even included downloadable course files from our paid-for courses so you can follow along and complete the exercises in this course. This will help you put what you are learning into practice and master MS Power BI.
✅ www.simonsezit.com/power-bi-b...
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Simon Sez IT Intro
00:00:19 - What is Power BI
00:04:41 - Install Power BI Desktop
00:06:50 - A Tour of BI Desktop
00:13:49 - Explore Commonly Used Power BI Options
00:19:12 - Import Files from a Folder into Power BI Desktop
00:31:41 - Get Data from Excel and Text Files
00:38:50 - Changing Query Source
00:43:04 - Reference Queries to Create Additional Lookup Tables
00:49:40 - Merge Queries in Power Query
00:56:37 - Prevent Queries from Loading into Power BI Desktop
00:59:43 - Exercise 01
01:00:40 - Create Relationships Between tables
01:10:27 - Create a Dynamic List of Dates
01:16:23 - Create Additional Date Columns for Analysis
01:25:36 - Sort the Month and Weekday Names Correctly
01:28:23 - Mark the Table as a Date Table
01:29:32 - Hide Unnecessary Fields from Report View
01:34:31 - Exercise 02
01:35:04 - Importing Excel Data Files
01:39:28 - Combining Files and Removing Columns
01:44:00 - Splitting and Merging Columns
01:48:55 - Troubleshooting Relationship Issues
01:55:18 - Relationship Types
02:00:45 - Cross Filter Direction
02:05:23 - Visualizations
02:14:00 - Tables vs Matrix Tables
02:20:25 - Formatting Visualizations - Part 1
02:27:10 - Formatting Visualizations - Part 2
02:30:17 - Conditional Formatting
02:43:01 - Column and Line Charts
02:56:56 - Card Visualizations
03:02:53 - Map Charts
03:12:34 - Gauge Visualization
03:22:11 - Slicers and Filters
03:30:42 - Applying Design Elements
03:38:35 - Adding a Report Title
03:48:25 - Add Navigation Buttons with Bookmarks
03:58:49 - Card Visualizations and Filtering
04:11:28 - Line Charts: Male vs Female Customers
04:18:41 - Stacked Column Chart
04:24:40 - Treemap Chart
04:30:45 - Funnel Chart
04:37:02 - Matrix Table
04:41:35 - Conditional Formatting: Background Fill and Icon Sets
🌍 Get unlimited training with Simon Sez IT’s 160+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for data visualization 👉 • Data Visualization - M...
✅Power BI Tutorials for Beginners video playlist 👉 • Power BI Tutorials for...
✅ Microsoft Excel Beginner's Training here 👉 • Microsoft Excel Beginn...
✅ Data Analysis using Microsoft Tools here 👉 • Data Analysis using Mi...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
ua-cam.com/users/simonsezittra...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-) - Наука та технологія
✅ Download the free course exercise files to follow along ➡www.simonsezit.com/power-bi-beginner-to-intermediate-course-files/
🔥Check out our FREE 300+ hour training course playlist here ➡ua-cam.com/users/playlist?list...
✅ Check out our free video playlist for Data Visualization 👉ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
✅Power BI Tutorials for Beginners video playlist 👉 ua-cam.com/play/PLzj7TwUeMQ3i17tx3uoTc6xf9X7Nl2U-s.html
✅ Microsoft Excel Beginner's Training here 👉 ua-cam.com/play/PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z.html
✅ Data Analysis using Microsoft Tools here 👉 ua-cam.com/play/PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi.html
I have provided my email address to get the practice files, but, I have still not received the practice files. I have checked my spam folder and there is nothing there.
@@sel4sie Same here. I have been waiting for days. 😮💨
Enjoyable
Done
I love this woman
The way she explains.
Her voice.
The content.
Everything just wonderful.
Thanks a lot
I don't know if its Ashby Voice but the calmness in the approach of teaching and explaining things makes it so very easy to understand and follow up. I have learned a whole lot from your lectures on different courses and thanks a Bunch to Simon and Ashby for all these.
Glad you think so! Thanks for visiting our channel to watch it :-)
I really appreciate this tutorial..Thanks a lot. I would also really appreciate of we can get the missing videos of how Deborah calculated the DAX Measures. There were some missing steps that we didn't get to see
Amazing course, thank you!
COMPLETELY HUMBLED BY YOUR TEACHINGS, TRULY APPRECIATE THIS AS AN AUTODIDACT, MATERIAL LIKE THIS IS GOLDEN.
Why are you SHOUTING!
I joined really late, almost towards the end and I learnt some very amazing things i didn't know how to do in PowerBI before; i am thrilled with the navigation buttons and condition formatting. Thank you for the knowledge.
You explain things so well, thank you for the opportunity to learn from you. Now, i have a full understanding of the guage visualization 😃
You're welcome and thank you for the kind words! ☺
Excellent tutorial, I am an absolute beginner and learning so I can move forward in my career, this has significantly benefit me. Going to practice and practice until all this becomes second nature to me. Thank you
You're very welcome! 😊
What's the point in making a 4 hour tutorial when the viewers can't even follow throughout the video.
There are some sections missing between 01:44:00 - Splitting and Merging Columns and 01:48:55 .
The files in 2nd module are not even present in the exercise files. It's so frustrating to leave the course after watching 2 hours.
so far it is the most valuable tutorial ! I recommand it !
Glad you are enjoying the training. 😀
Another significant learning that I can apply to our office work!....
Thanks Ben Diesel Basic Automotive, we are happy the training is something you can use at work ;-)
The explaination is at just the right pace and precise explaination to make me understand
Glad you enjoyed it. Thanks for watching! 🙂
We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
Watching this course for 30 minutes in already. This guys has some passion in his voice and gives me the vibe that Bear Grylls is delivering this training :D .
Amazing work, thank you so much, i'm gonna put in my bookmarks
Awesome, thank you!
We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
THis is one THE BEST clasess for PBI :-) I put it in Category of Chris Dutton .. or maybe better. Thanks Deborah !
ASHBY IS THE BEST!!! WHAT A TEACHER! WHAT A PASSION! THANKS, ASHBY!!♥️♥️♥️
I'm glad you enjoyed it. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
That's training is really good for us...... Thank you for that 😊
My pleasure 😊
Excellent tutorial, kindly include a video for calculated for calculated measures....
why is there a skip between first and second module?
There are some sections missing between 01:44:00 - Splitting and Merging Columns and 01:48:55 - Troubleshooting Relationship Issues the file looks completely different with Product Id and Location ID added to the main file but cannot see how this was done
I love this training🤗
Glad we could help!
Very helpful. Thank you😊
You bet!
Thank you
An intermediate and an advanced course after that course would be very much appreciated
Helpful video thanks alot
Glad it was helpful! 😊 Thanks for watching.
Best tutor ever, thank you very much
You're welcome and thanks for the kind comments 🙂
We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
I can't thank you enough for your tutorials. I have immensely benefitted from your works and would like to say, God bless you. I hope to contact you for private coaching at a later time.
Thank you so much for your kind words! I'm glad my tutorials have been helpful to you. 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Great video for beginner.
Glad you think so! 😊
I really love how you present such complicated subject in an easy and concise manner. Is it possible to have a tutorial on how to present a comparative table of MTD, YTD, PYD and variance analysis like the Income Statement? Would appreciate it much.
Excellent job sir
Thanks for watching our training, Opeyemi Olasunkanmi 😀
Thank you so much
You're most welcome, Nguyen Phuong
Excellent this is really nice
Thank you! Cheers!
I really love your training, but I still have a question : how to add the new period's data to the existing published Power BI report? Thank you
Really thanhs for the speakimg slovly.
You are very welcome! Thanks for watching 🙂
We have additional free tutorials for various data analysis tools and services here 👉
ua-cam.com/play/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Thanks
Welcome
Nice tut, please how are the unitcost calculated in the merged Sales table, from from the 4 Sales dataset ?
I subscribe and be the one of your email subscriber!! Please do the beginner - intermediate - advanced cilps for powerbi, Thank you so much
This is beginner to intermediate course
Yes!!!!! Will there be handouts????
We have free exercise files to download and follow along with the class.
Always watch your vids and they are well presented. I was following along with the second part of the course where debbie was doing the tutorial but I think there are some sections missing between 01:44:00 - Splitting and Merging Columns and 01:48:55 - Troubleshooting Relationship Issues the file looks completely different with Product Id and Location ID added to the main file but cannot see how this was done
I am also a bit sad that those parts are missing, especially the key measures! Generally I am grateful for the videos being uploaded on a free platform, alongside tutorial files, thanks @SimonSezIT!
I am about to watch the video, do you think that there are parts missing in the video where I might get stuck in the middle because last time also I got stuck watching the Power BI beginner course by Debby due to something missing in between after the 1st part of it, what do you think ?
It is really annoying when firstly they change presenters, and secondly when the steps are not reproducable.
Very good course, just feels like the beginner part was left started, like the course is chopped in the middle and they start again with intermediate content from scratch at 1:35:08
Hello, thank you Simon. Your video is great! However, i wanted asking, i noticed that the data-set used by the 1st instructor is different from that of the 2nd instructor who's a female. The data-set for the 1st instructor is available for download but not that of the 2nd instructor. Pls can you help with this or make clarifications?
The data file shown on 1:48:55 is not available in the course files folder. Could you re-share it?
I love your accent 😀
Hi Sir, if there is a set of different Excel files and there are steps applied to them, like merge, combine and group, and there is an update in one/many Excel files in terms of values and it is not possible to update each and every column value, in this cane how can we replace the Excel file/files (keeping the same file name) so that the all the steps can/will be applied as it is after file replacement
Thank you for the video, the exercise has not be sent to my email.. can you if it is technical issue or not
So how did you get the KPI Measures table?
Hi Simon, this is really good, I have watched a couple of times, but i have a question and try to find the solution; how can I sort out category's value per specific month while maintaining other periods'' value as well? It seems Power BI only can sort out by total if keep every single month's value. It would be much appreciated if you can provide some guidance.
I think it is the Calculate sum formula with Filter in it with the specific month. So other filters wont modify this specific duration's value.
Everything was quite clear except how you were able to bring in the country ID in the table? Kindly explain!!!
I just completed Excel tutorial and now I'm here.
Hope you enjoyed it! Thanks for watching! 🙂
Very clear and best explanations I have found. Nice to be UK rather than US or Indian for a change :) Can Deb do the voice for my sat nav?
Wow, thanks! Glad it was helpful. 🤩 Unfortunately no Sat Nav voiceovers, but a number of other courses on our channel and on our website are taught by Deb. So for more excellent teaching, please do check them out.
could you share what tool you are using to make this arrow 25:45
To properly complete the tutorial you have to go to their site and subscribe for monthly or whatever plan you prefer, it's not really a complete tutorial here.
That being said, whatever given here is helpful and thanks for that.
Thanks for the kind comments 🙂
When i m importing the data i have several more columns but i dont get the '' amount'' column.
I am merging salestable product coloumn with product table product column but result comming null, how to solve this
Hello, Sir!
I have used data with Combine and Transform data in power query and then close & apply.
When I used card and drag the order I'd then it was showing 40K, instead of 1.22 M like yours. Even though I have combined data it is showing data of only 2016.
Can you please help me with this??
can you find the answer for this query?
After merging my queries in power query, my ID keeps giving "null" values instead of numbers.
Where are the tutorials on how to create the DAX measures? Really shocked this is not included in a Beginner/Intermediate course.
Looks like they selectively read feedback too!
Wow...
When I initially load Sales and then put it as SalesPrep and close and apply I keep getting errors but I did the exact thing as the instructor. It says its the date column however the date column has the correct data type. Confuse
Change Regional settings as the UK from File> Option & Settings > Option > Regional Settings
Is this Full course
hello dear , i appreciate you cours , but we can not see well. your screen is white
Thank you. Are you seeing a blank white screen? Maybe you can try refreshing the page to see the video. Also, to ensure the best video experience, set the video playback quality to 1080p HD. Click on the gear icon ⚙ located in the bottom right corner.
Is there anybody has the issue like me: The selection matches 0 of 1220615 rows from the first table? This occurs when I am in the step of merging products from Merge1 and Products table.
It's been proceed when I used fuzzy matching. But Why didn't it work without fuzzy matching?
I cont use because power bi need microsoft company or school registerd account
The "amount" column value comes in text form for me. Can someone help me?
Replace values in this column from '.' to ',' before converting them
No Exercise file send to my mail
Great tutorial and great tutor! Keep it up!
Thanks a lot!
how can power BI be installed on macbook
As far as I know, Power BI Desktop is not supported on Mac devices at the moment. Power BI Service is a cloud-based version that may be accessible using a Mac but with less functionalities as the desktop version.
@@SimonSezIT can I start from there then, I mean using the cloud based version because as of now, I don’t have access to Microsoft Windows and I really want to follow along on your power BI beginners to intermediate course…..
By the way, I really must commend your effort on your contents….you taught me how to use excel, now I use it to analyze my data and tell compelling stories at work. I built a playlist from your contents on tools needed on data analytics pathway.
A really big thank you 🙏🏻
PLEASE WHO CAN PROVIDE ME WITH THE DATA USED?
Thanks for watching!
You can download the course files here 👉www.simonsezit.com/power-bi-beginner-to-intermediate-course-files/
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Presenter doesn't explain what BI stands for
Power BI is a business intelligence tool as defined in the video description.
This is so annoying. The course is not complete There are huge gaps between the beginner and intermediate tutorials. Why upload this video if it incomplete?
Can never download the free course exrcise files???
Hi Don. Sorry to learn about this issue. I tested the download and it worked. The file is a zip file, so check to ensure it's not getting blocked from some type of security or firewall.
@@SimonSezIT Ah i was supposed to recieve and email from you folks explaining how to get information...but hey guess what...never happened...yes I checked all spam etc...shazam none at all. If you cannot provide free information why one would even bother getting your product...Pathetic at best
anybody else having problems downloading free excercises? hit reply button...thanks
Thank you
You're welcome