Microsoft Power BI Desktop Masterclass
Master Microsoft Power BI Desktop, Create Interactive Dashboards & Learn Advanced Analytics with DAX and Power Query
A Tour of Power BI
FREE PREVIEWMicrosoft Power BI Tools
Install Power BI Desktop
Launch Power BI Desktop
QUIZ 1: Introducing Power BI
Introduction
Getting Data from Excel file
Getting Data from csv file
Connect to a Web Data Source
Getting Data from Databases
Connect to Microsoft Dataverse
Open a PBIX file or Excel data model
Change the data source for a PBIX file
DirectQuery, Import, and Dual Mode
QUIZ 2: Power BI Data Sources
Introduction
Getting your Data
Getting familiar with the Power BI Interface
Adding Stacked Column Chart & Pie Chart
Adding Interactions with Visuals
Line Charts & Drill Down
Matrix & Card Titles
Using the Power Query Editor
Reducing Rows & Extracting Data
Filtering, Setting Data Type and Replacing Values
Unpivoting Columns
Transforming Columns
PROJECT: US Population Data Analysis with Power BI – Part 1
PROJECT: US Population Data Analysis with Power BI – Part 2
QUIZ 3: Power Query: Transforming & Shaping Data
Combining Multiple Tables
Appending Data to a Single Query
Index Column & Cleaning Data
Model Relationships
Merging Data
PROJECT: Create a Sales Dashboard – Part 1
PROJECT: Create a Sales Dashboard – Part 2
QUIZ: Power Query: Combining & Merging Data