Microsoft Power BI Beginner to Intermediate Course - Data Visualization Training

Overview

Dive into a comprehensive 4-hour 44-minute course on Microsoft Power BI, covering beginner to intermediate concepts in data visualization. Learn to navigate the Power BI dashboard, import data from various sources, merge queries using Power Query, and create table relationships. Master the creation and formatting of diverse visualizations, including column charts, map charts, gauge and card visualizations. Explore advanced features like adding slicers, filters, report titles, navigation buttons, and bookmarks. Practice with downloadable exercise files, following along with step-by-step instructions on importing Excel data, combining files, troubleshooting relationship issues, and applying conditional formatting. Gain hands-on experience in creating dynamic date lists, stacked column charts, treemap charts, and funnel charts, equipping you with essential skills for powerful business intelligence reporting.

Syllabus

- Simon Sez IT Intro
- What is Power BI
- Install Power BI Desktop
- A Tour of BI Desktop
- Explore Commonly Used Power BI Options
- Import Files from a Folder into Power BI Desktop
- Get Data from Excel and Text Files
- Changing Query Source
- Reference Queries to Create Additional Lookup Tables
- Merge Queries in Power Query
- Prevent Queries from Loading into Power BI Desktop
- Exercise 01
- Create Relationships Between tables
- Create a Dynamic List of Dates
- Create Additional Date Columns for Analysis
- Sort the Month and Weekday Names Correctly
- Mark the Table as a Date Table
- Hide Unnecessary Fields from Report View
- Exercise 02
- Importing Excel Data Files
- Combining Files and Removing Columns
- Splitting and Merging Columns
- Troubleshooting Relationship Issues
- Relationship Types
- Cross Filter Direction
- Visualizations
- Tables vs Matrix Tables
- Formatting Visualizations - Part 1
- Formatting Visualizations - Part 2
- Conditional Formatting
- Column and Line Charts
- Card Visualizations
- Map Charts
- Gauge Visualization
- Slicers and Filters
- Applying Design Elements
- Adding a Report Title
- Add Navigation Buttons with Bookmarks
- Card Visualizations and Filtering
- Line Charts: Male vs Female Customers
- Stacked Column Chart
- Treemap Chart
- Funnel Chart
- Matrix Table
- Conditional Formatting: Background Fill and Icon Sets