Welcome to ONLC Training Centers

Microsoft BI Tools On Demand: Power BI Intermediate

Microsoft Gold Partner


Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Microsoft BI Tools On Demand: Power BI Intermediate Course Outline

***Note: This is an On-Demand, Self-Study Class, 2 days of content, 6-months unlimited access, $595***
You may take this course at any time, there are no set dates. This On-Demand (self-study) training course includes expert lectures, demonstrations and lab exercises that cover the same content that is included in our instructor-led (ILT) class. (Applicable State and Local taxes may be added for On-Demand purchases, depending on your location.)

This course is intended as a continuation of our introductory-level courses in Power BI (20778: Analyzing Data with Power BI and/or BPBEX1: Excel BI Tools: Power BI for Excel Users). It covers common intermediate-level tasks and some of Power BI’s most desireable new features.

Before attending this course, students should have: - General knowledge equivalent to what is covered in 20778: Analyzing Data with Power BI.

At Course Completion
After completing this course, students will be able to:
• Import data from PDFs, regions of web pages, and collections of files
• Characterize data with data profiling
• Merge mismatched data sets with fuzzy matching
• Generate custom columns in Power Query
• Perform advanced data modeling
• Use Power BI time intelligence
• Work with custom scripts in R and Python
• Create KPIs and scorecards
• Use advanced report design techniques
• Use advanced dashboard design techniques
• Perform basic statistical analysis in Power BI

Course Outline

Intermediate Power Query
Importing from PDFs
Finding data in web pages
Getting tabular data
Getting data by providing an example
Importing the contents of a folder
Using fuzzy matching to combine disparate data sets
Creating custom columns in Power Query
Common math & string operations
M script
Columns by example

Intermediate Data Modeling
Adding What-If Parameters
Grouping and Binning
Using Time Intelligence
Generating DAX with Quick Measures

Script Visuals
Creating an R script visual
Installing an R environment
Creating a Python visual
Installing a Python environment

Advanced Report Design
Using report themes
Creating your own theme
Conditional formatting in tables and matrices
Using drillthrough in your reports
Adding data-driven images

Advanced Dashboard Design
Using dashboard themes
Using the KPI visual
Using the Multi KPI visual
Adding KPIs and trend analysis with DAX
Strategies for adding KPIs to tables & matrices
Importing from Excel data model
Conditional formatting
The DAX UNICHAR function
Image embedding

Characterizing your data
Revisiting the data profiler
Getting help from custom visuals
Moving averages
Linear regression in R
Time series forecasting in Python

View outline in Word


Attend hands-on, instructor-led Microsoft BI Tools On Demand: Power BI Intermediate training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Power BI Courses and select the one that's right for you.


Class Format
Class Policies
Student Reviews

Bookmark and Share

First Name

Last Name