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 160+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-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 ;-)