Microsoft Power BI Desktop Masterclass

Master Microsoft Power BI Desktop, Create Interactive Dashboards & Learn Advanced Analytics with DAX and Power Query

Buy $9.99 Free Preview

Course curriculum

1. Introduction
  FREE PREVIEW
2. Download Course Resources
3. Setting Expectations
  FREE PREVIEW
4. Preparing for the Microsoft PL-300 Exam (Nov. 2024)
  FREE PREVIEW
1. A Tour of Power BI
  FREE PREVIEW
2. Microsoft Power BI Tools
3. Install Power BI Desktop
4. Launch Power BI Desktop
5. QUIZ 1: Introducing Power BI
1. Introduction
2. Getting Data from Excel file
3. Getting Data from csv file
4. Connect to a Web Data Source
5. Getting Data from Databases
6. Connect to Microsoft Dataverse
7. Open a PBIX file or Excel data model
8. Change the data source for a PBIX file
9. DirectQuery, Import, and Dual Mode
10. QUIZ 2: Power BI Data Sources
1. Introduction
2. Getting your Data
3. Getting familiar with the Power BI Interface
4. Adding Stacked Column Chart & Pie Chart
5. Adding Interactions with Visuals
6. Line Charts & Drill Down
7. Matrix & Card Titles
1. Using the Power Query Editor
2. Reducing Rows & Extracting Data
3. Filtering, Setting Data Type and Replacing Values
4. Unpivoting Columns
5. Transforming Columns
6. PROJECT: US Population Data Analysis with Power BI – Part 1
7. PROJECT: US Population Data Analysis with Power BI – Part 2
8. QUIZ 3: Power Query: Transforming & Shaping Data
1. Combining Multiple Tables
2. Appending Data to a Single Query
3. Index Column & Cleaning Data
4. Model Relationships
5. Merging Data
6. PROJECT: Create a Sales Dashboard – Part 1
7. PROJECT: Create a Sales Dashboard – Part 2
8. QUIZ: Power Query: Combining & Merging Data
1. The Report View
2. Format Visualizations
3. Cards, Tables and Matrix
4. Conditional Formatting
5. Title formatting
6. Using Slicers
7. Filter reports and pages
8. Q&A – Create Visuals by Typing a Normal Sentence
9. Publish from Power BI Desktop
10. QUIZ: Reports, Visualizations, Filters and Q&A
1. Data Model: Section Overview
2. The Basics of Data Modeling
3. Getting Data & Setting up the Data Model
4. Relationships
5. QUIZ: Data Model Tour
1. Create your first Measure using SUM Function
2. DAX syntax
3. Add a Matrix using Measures
4. Count Products with COUNTA and COUNTROWS
5. Edit or Delete Measures
6. Find Empty Fields with COUNTBLANK
7. DISTINCTCOUNT Function
8. PROJECT: Build DAX understanding (Part 1)
9. PROJECT: Build DAX understanding (Part 2)
10. QUIZ: DAX Functions
1. Add a Calculated Column
2. Explicit vs. Implicit Measures
3. Summarization Methods
4. DIVIDE Function
5. SUMX Function
6. Date & Time DAX Functions
7. PROJECT: Build DAX understanding (Part 3)
8. PROJECT: Build DAX understanding (Part 4)
9. PROJECT: Build DAX understanding (Part 5)
10. PROJECT: Build DAX understanding (Part 6)
11. QUIZ: Calculated Columns & Measures
1. FIND Function
2. IF Function
3. OR Function
4. The Powerful CALCULATE Function
5. SWITCH Function
6. DEMO: Story-telling with Power BI – Part1
7. DEMO: Story-telling with Power BI – Part2
8. QUIZ: Logical & Filter Functions
1. Introduction
2. Designing the relationships between tables
3. Loading our Data into Power Query Editor
4. Data Cleanup Process
5. Creating New Tables & Making Relationships
6. Understanding Relationships & Creating a Calendar Table
7. Creating Story 1 Report (& Edit Interactions)
8. Creating Story 2 Report – Part 1
9. Creating Story 2 Report – Part 2
10. Creating Story 3 Report – Part:1 (Difference between Filters)
11. Creating Story 3 Report – Part 2
12. Creating Story 3 Report – Part 3
13. Creating Story 3 Report – Part 4

About this course

$9.99
99 lessons
8.5 hours of video content

Discover your potential, starting today

Enroll today

Microsoft Power BI Desktop Masterclass

Course curriculum

SECTION 1: Getting Started with Power BI Course

SECTION 2: Introducing Power BI

SECTION 3: Power BI Data Sources

SECTION 4: Design Your First Dashboard with Power BI

SECTION 5: Power Query: Transforming & Shaping Data

SECTION 6: Power Query: Combining & Merging Data

Reports, Visualizations, Filters and Q&A

Data Model Tour

DAX Functions

Calculated Columns & Measures

Logical & Filter Functions

Milestone Project: Create a Budget vs Actual Dashboard

About this course

Discover your potential, starting today