From Excel to Power BI-Course Introduction: Understand Power BI
A Note on Power BI Access and Course Contact Information
Course Introduction and Objectives
()
Overview of Power BI
()
Lesson: Understand Power BI Licenses
()
STOP: Retrieve a Course Sample Dataset
Regarding DAX Query View
Regarding Power BI Interface
From Excel to Power BI-Lesson 1: Import and Clean Excel Data in Power BI
Lesson: Understand Data Importation and the Table View
()
Overview of the Table View in Power BI
()
Import a File from Excel
()
Use Get Data to Connect to Data Sources
()
Try a Sample Dataset from Power BI Desktop
()
Lesson: 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
()
Replace Errors in a Column
()
From Excel to Power BI-Lesson 2: Model and Visualize Data in Power BI
Lesson: Introduction to Data Modeling, Report View, and Visualizations
()
View Relationships in the Model View
()
Edit or Remove Relationships
()
Add a New Relationship Between Tables and Columns
()
Lesson: Understand the Report View
()
Overview of the Report View in Power BI
()
Add a Visualization
()
Overview of Format Features for Visualizations
()
Change the Visualization Type
()
From Excel to Power BI-Lesson 3: Work with Different Types of Visualizations
Lesson: Understand Text Visualization Types
()
Create a Visualization Card
()
Create a Table Visualization
()
Create a KPI Chart
()
Create a Key Influencers Chart
()
Lesson: Intro to Chart Visualizations
()
Create a Scatter Chart
()
Create a Waterfall Chart
()
Create a Funnel Chart
()
Create a Ribbon Chart
()
Lesson: Filters, Slicers, and Data Drilling
()
Create a Slicer
()
Analyze Your Visualization
()
Drill Down and Drill Up in a Visualization
()
From Excel to Power BI-Lesson 4: Work with Dashboards in Power BI Online
Lesson: Introduction to Power BI Service
()
Publish a Dataset or Report
()
View My Workspace in the Power BI Service
()
View Workspaces in the Power BI Service
()
Overview of Dashboards
()
Create a New Dashboard
()
Add a Tile to a Dashboard
()
Pin a Tile from a Report
()
Subscribe to a Power BI Dashboard
()
Share a Report Via Email
()
Share a Report To a Teams Channel
()
Export a Report to PowerPoint
()
From Excel to Power BI-Cumulative Assessment
Congratulations!
KA Retailers Sample Datasets-LcHs8FWQTcm7UZpjTgnlvw.xlsx
(356 KB)