Skip to main content
Power BI for Excel Users and Power BI Intermediate GPBEIN
0%
Previous
Course data
General
Announcements
Course Overview
Course Overview - Introduction
Getting Started
Getting Started - Overview
Introducing Power BI - Lecture
A Quick Look at Power BI Desktop - Lecture
A Quick Look at the Power BI Service - Lecture
Lab 1: Set Up the Lab Environment
Power BI and Excel
Power BI and Excel - Overview
Upload Excel Data to the Power BI Service - Lecture
Using Excel as a Data Source - Lecture
OneDrive for Business with Excel - Lecture
Import Excel Workbooks into Power BI Desktop - Lecture
Lab 2: Power BI and Excel - Exercise 1: Use Excel as a Data Source
Exercise 2: Import an Excel Data Model and Power Views - Lab
Getting Data
Getting Data - Lecture
Connecting to a Database - Lecture
Connecting to a CSV File - Lecture
Lab 3: Getting Data - Exercise 1: Analyzing Web page data using Power BI Desktop
Exercise 2: Shape Data in the Subject Table - Lab
Exercise 3: Create Visualizations Using the Report View - Lab
Shaping and Transforming Data
Shaping and Transforming Data - Lecture
Lab 4A: Shaping and Transforming Data - Exercise 1: Analyzing sales data from Excel and an OData feed
Exercise 2: Combine the Products and Orders Queries - Lab
Exercise 3: Build Visuals Using Your Data - Lab
Lab 4B: More Shaping and Transforming Data - Exercise 1: Get data from a web site
Exercise 2: Shape Data
Exercise 3: Combine Data
Exercise 4: Build Reports
Exercise 5: Share Your Work
Modeling Data
Modeling Data - Lecture
How to Manage your Data Relationships - Lecture
Optimizing Data Models - Lecture
Introduction to DAX - Lecture
Calculated Measures in DAX - Lecture
Calculated Tables in DAX - Lecture
Explore your Time-based Data - Lecture
Lab 5: Modeling Data - Exercise 1: Create your own measures in Power BI Desktop
Exercise 2: Create Calculated Columns in Power BI Desktop - Lab
Visualizations
Visualizations - Lecture
Group Interactions Among Visualizations - Lecture
Using Custom Visualizations - Lecture
Lab 6: Visualizations - Exercise 1: Add Custom Visuals
Publishing and Sharing
Publishing and Sharing - Lecture
Quick Insights in Power BI - Lecture
Create Workspaces in Power BI - Lecture
Manually Refresh and Republish Your Data - Lecture
Export Dashboards and Reports to PDF - Lecture
Lab 7: Publishing and Sharing - Exercise 1: Explore Dashboards and Reports with the Retail Analysis Sample
Exercise 2: Publish a Power BI Desktop Solution to the Power BI Service - Lab
Course Overview - Accessing the Courseware (OneNote Notebook)
Course Overview - Accessing the Courseware (OneNote Notebook)
OneNote Courseware
Lab 0: Set Up the Lab Environment
Lab 0: Set Up the Lab Environment
Intermediate Power Query
Importing Data from PDFs - Lecture
Connect to Webpages from Power BI Desktop - Lecture
Get Webpage Data by Providing Examples - Lecture
Combine Files (Binaries) in Power BI Desktop - Lecture
Use Fuzzy Matching to Combine Disparate Data Sets - Lecture
Add a Column from Examples - Lecture
Add a Custom Column with M - Lecture
Lab 1 - Exercise 1: Import Data from PDF
Exercise 2: Import Data from a Web Page - Lab
Exercise 3: Merge the Data Sets - Lab
Exercise 4: (Optional) Visualize your Data - Lab
Exercise 5: Use Fuzzy Matching - Lab
Intermediate Data Modeling
Adding What-if Parameter - Lecture
Using Grouping and Binning - Lecture
Using Time Intelligence - Lecture
Lab 2 - Exercise 1: Using What-if Parameters
Exercise 2: Using Grouping and Binning - Lab
Exercise 3: Using Time Intelligence and Quick Measures - Lab
Script Visuals
Create R Visuals in Power BI Desktop - Lecture
Create Python Visuals in Power BI - Lecture
Lab 3 - Exercise 1: Install a Python Environment
Exercise 2: Create a Python Visual - Lab
Exercise 3: Install the Microsoft R Open Execution Environment  - Lab
Exercise 4: Create an R Visual - Lab
Advanced Report Design
Use Report Themes in Power BI Desktop - Lecture
Customize Report Themes - Lecture
Use Conditional Formatting in Tables - Lecture
Use Drillthrough in Power BI Desktop - Lecture
Add Data-Driven Images to Power BI Reports - Lecture
Lab 4: Designing Your Reports - Exercise 1: Use Report Themes
Exercise 2: Use Conditional Formatting in Tables - Lab
Exercise 3: Add a Drillthrough Filter - Lab
Exercise 4: Add Data-Driven Images - Lab
Advanced Dashboard Design
Build a Better Dashboard - Lecture
Import and Display KPIs in Power BI - Lecture
KPI Strategies - Lecture
Use Dashboard Themes in Power BI - Lecture
Lab 5: Advanced Dashboard Design - Exercise 1: Using the built-in KPI Visual 
Exercise 2: Use the Multi KPI Custom Visual - Lab
Exercise 3: Use Conditional Formatting as an Indicator - Lab
Exercise 4: Enhanced Indicators using the UNICHAR Function - Lab
Exercise 5: Publish Report to the Power BI Service and Create a Dashboard
Analytics
Characterizing your Data - Lecture
Lab 6: Analytics - Exercise 1: Smooth Your Data with a Moving Average
Exercise 2: Use the R ARIMA Custom Visual - Lab
Exercise 3: Use R to Generate an ARIMA Projection - Lab
Exercise 4: Use R to Generate an Exponential Triple Smoothing Projection - Lab
Next
Side panel
Categories
All categories
AI Learning Hub
AI Essentials
Level 1: Generative AI Foundation
Level 2: Grounding AI with your Data
Level 3: Automating AI Workflows
Copilot First-Step Kit
Claude
ChatGPT
Microsoft Copilot
M365
Office
Excel
Word
Outlook
PowerPoint
Power Platform
Power BI
Power Apps
Power Automate
SharePoint
Microsoft Official
Adobe
CompTIA
Holding
Webinars
Programming
WordPress
Accounting
Google
Upskilling Series
Home
Log in
Username
Username
Password
Password
Forgot your password?
Log in
Categories
Collapse
Expand
All categories
AI Learning Hub
AI Essentials
Level 1: Generative AI Foundation
Level 2: Grounding AI with your Data
Level 3: Automating AI Workflows
Copilot First-Step Kit
Claude
ChatGPT
Microsoft Copilot
M365
Office
Excel
Word
Outlook
PowerPoint
Power Platform
Power BI
Power Apps
Power Automate
SharePoint
Microsoft Official
Adobe
CompTIA
Holding
Webinars
Programming
WordPress
Accounting
Google
Upskilling Series
Home
Course info
Power BI for Excel Users and Power BI Intermediate GPBEIN
Skill Level
:
Beginner
