Week 1: Understand Power BI and Power BI Data Analysis-Welcome to Week 1
Welcome to Data-Driven Decisions with Power BI!
()
Introduction to Power BI
()
A Note on Power BI Email Compatibility
Introductory Material
STOP: Retrieve a Course Sample Dataset
Week 1: Understand Power BI and Power BI Data Analysis-Lesson 1: Understand Power BI
Understand Power BI
Overview of Power BI
()
Understand Power BI Licenses
()
Week 1: Understand Power BI and Power BI Data Analysis-Lesson 2: Import Data into Power BI
Import Data or Connect to a Data Source
()
Import a File
()
Import Data from a Web Page
()
Use Get Data to Connect to Data Sources
()
Connect to a Power BI Dataset
()
Try a Sample Dataset from Power BI Desktop
()
Practice with Sample Datasets from Power BI Service
()
Week 1: Understand Power BI and Power BI Data Analysis-Lesson 3: Understand the Data View
Understand the Data View
()
Overview of the Data View in Power BI
()
Week 1 Check-In
()
Week 1: Understand Power BI and Power BI Data Analysis-Lesson 4: Clean and Transform Data
Clean and Transform Data
()
Access the Power Query Editor
()
Overview of the Applied Steps List in Power Query Editor
()
Execute Basic Math Operations to a Column
()
Round Values in a Column
()
Replace Errors in a Column
()
Week 2: Introduction to Modeling Data and Report Visualizations-Welcome to Week 2
Introduction to Data Modeling, Report View, and Visualizations
()
Week 2: Introduction to Modeling Data and Report Visualizations-Lesson 1: Understand the Model View
Understand the Model View
()
Overview of the Model View in Power BI
()
Week 2: Introduction to Modeling Data and Report Visualizations-Lesson 2: Work with Relationships in Model View
View, Add and Edit Relationships in Model View
View Relationships in the Model View
()
Edit or Remove Relationships
()
Add a New Relationship Between Tables and Columns
()
Week 2 Check-In
()
Week 2: Introduction to Modeling Data and Report Visualizations-Lesson 3: Understand the Report View and Visualizations
Understand the Report View
()
Overview of the Report View in Power BI
()
Adding Visualizations to Report Canvases
Add a Visualization
()
Overview of Format Features for Visualizations
()
Change the Visualization Type
()
Week 2: Introduction to Modeling Data and Report Visualizations-Lesson 4: Understand, Create and Format Text Visualizations
Understand Text Visualization Types
()
Create a Visualization Card
()
Format a Visualization Card
()
Create a Table Visualization
()
Format a Table Visualization
()
Create a KPI Chart
()
Format a KPI Chart
()
Create a Key Influencers Chart
()
Format a Key Influencers Chart
()
Week 3: Navigate Reports and Visualizations-Welcome to Week 3!
Introduction to Navigating Reports and Visualizations
Week 3: Navigate Reports and Visualizations-Lesson 1: Create and Format Chart Visualizations
Intro to Chart Visualizations
()
Create a Scatter Chart
()
Modify Scatter Chart Analytics
()
Create a Waterfall Chart
()
Create a Gauge Chart
()
Create a Funnel Chart
()
Format a Funnel Visualization
()
Create a Ribbon Chart
()
Format a Ribbon Chart
()
Use Geospatial Map Visualizations
()
Use Map Visualizations
()
Week 3 Check-In 1
()
Week 3: Navigate Reports and Visualizations-Lesson 2: Connecting Visualizations and Queries
Turn Questions into Answers with Custom Visualizations
()
Create a New Table Query
()
Turn a Question into a Visualization
()
Create and Teach a Q&A Visualization
()
Add Suggested Questions to a Q&A Visualization
()
Week 3: Navigate Reports and Visualizations-Lesson 3: Gain Insights with Filters and Drillthroughs
Filters, Slicers, and Data Drilling
()
Create a Slicer
()
Explore the Filters Pane
()
Filter a Field
()
Analyze Your Visualization
()
Drill Down and Drill Up in a Visualization
()
Format a Matrix
()
Export Data from Visualizations
()
Week 3: Navigate Reports and Visualizations-Lesson 4: Publish Reports
Introduction to Report Publishing
()
Publish a Dataset or Report
()
Week 3 Check-In 2
()
Week 4: Navigate the Power BI Service-Welcome to Week 4
Introduction to Power BI Service
()
Week 4: Navigate the Power BI Service-Lesson 1: Get Started with Workspaces
Introduction to Workspaces
()
View My Workspace in the Power BI Service
()
View Workspaces in the Power BI Service
()
View the Access Permissions
()
Share a Workspace
()
Week 4: Navigate the Power BI Service-Lesson 2: Work with Dashboards
Introduction to Working with Dashboards
()
Overview of Dashboards
()
Create a New Dashboard
()
Add a Tile to a Dashboard
()
Pin a Tile from a Report
()
Pin a Live Page
()
Pin the Whole Report Page as a Live Tile
()
Subscribe to a Power BI Dashboard
()
Share a Report Via Email
()
Week 4 Check-In
()
Week 4: Navigate the Power BI Service-Lesson 3: Datasets and Reports
Use Datasets and Reports
Change the View in a Dataset
()
Download a Copy of a Report
()
Generate Quick Insights for a Report
()
Week 4: Navigate the Power BI Service-Lesson 4: Work with Apps
Introduction to Apps
()
Connect to Apps
()
Create App Workspaces
()
App Creation Additional Reading
Week 4: Navigate the Power BI Service-Lesson 5: Integrate with Microsoft Suite
Power BI and Microsoft Integration
()
Understand Power BI and Microsoft Teams Integration
()
Share a Report To a Teams Channel
()
Start a Teams Chat From a Slicer in Power BI
()
Embed Reports in SharePoint Online
()
Export a Report to PowerPoint
()
Power BI: Download and Install Analyze in Excel
()
The Power Platform
Week 5: Final Review-Final Review
Note: Final Review
Congratulations!
()
Final Note