Skip to main content
Power BI Intermediate - GPBINT
0%
Previous
Course data
General
Announcements
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 Intermediate - GPBINT
Skill Level
:
Beginner