Microsoft Power BI Beginner to Intermediate Course: 4+ Hours Data Visualization Training

Microsoft Power BI Beginner to Intermediate Course: 4+ Hours Data Visualization Training

185.819 Lượt nghe
Microsoft Power BI Beginner to Intermediate Course: 4+ Hours Data Visualization Training
✅ Download the free course exercise files to follow along ➡️https://www.simonsezit.com/power-bi-beginner-to-intermediate-course-files/ 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. ✅ https://www.simonsezit.com/power-bi-beginner-to-intermediate-course-files/ 📝 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 200+ courses ⏩ https://www.simonsezit.com/courses/ 🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ https://simonsezit.lpages.co/ssit-14-day-free/ 💻 Watch more free popular training tutorials from Simon Sez IT: 🔥Check out our FREE 300+ hour training course playlist here ➡️ https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU ✅ Check out our free video playlist for data visualization 👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 ✅Power BI Tutorials for Beginners video playlist 👉 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i17tx3uoTc6xf9X7Nl2U-s ✅ Microsoft Excel Beginner's Training here 👉 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z ✅ Data Analysis using Microsoft Tools here 👉 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi 💬Stay in touch! SimonSezIT.com: https://www.SimonSezIT.com/ LinkedIn: https://www.linkedin.com/company/simon-sez-it/ FaceBook: https://www.facebook.com/SimonSezIT 🔔 Subscribe to our channel: https://www.youtube.com/simonsezittraining?sub_confirmation=1 If you enjoyed the video, please give a thumbs up 👍🏽 ;-)