Microsoft Power BI Beginner to Intermediate Course - Data Visualization Training

- 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