- Import Files from a Folder into Power BI Desktop
7
- Get Data from Excel and Text Files
8
- Changing Query Source
9
- Reference Queries to Create Additional Lookup Tables
10
- Merge Queries in Power Query
11
- Prevent Queries from Loading into Power BI Desktop
12
- Exercise 01
13
- Create Relationships Between tables
14
- Create a Dynamic List of Dates
15
- Create Additional Date Columns for Analysis
16
- Sort the Month and Weekday Names Correctly
17
- Mark the Table as a Date Table
18
- Hide Unnecessary Fields from Report View
19
- Exercise 02
20
- Importing Excel Data Files
21
- Combining Files and Removing Columns
22
- Splitting and Merging Columns
23
- Troubleshooting Relationship Issues
24
- Relationship Types
25
- Cross Filter Direction
26
- Visualizations
27
- Tables vs Matrix Tables
28
- Formatting Visualizations - Part 1
29
- Formatting Visualizations - Part 2
30
- Conditional Formatting
31
- Column and Line Charts
32
- Card Visualizations
33
- Map Charts
34
- Gauge Visualization
35
- Slicers and Filters
36
- Applying Design Elements
37
- Adding a Report Title
38
- Add Navigation Buttons with Bookmarks
39
- Card Visualizations and Filtering
40
- Line Charts: Male vs Female Customers
41
- Stacked Column Chart
42
- Treemap Chart
43
- Funnel Chart
44
- Matrix Table
45
- Conditional Formatting: Background Fill and Icon Sets
Description:
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.
Microsoft Power BI Beginner to Intermediate Course - Data Visualization Training