Microsoft On-Demand: Power BI Intermediate Course Outline

*** This is an On-Demand (self-study) course, 180-day, 24/7 access via the internet ***
(Applicable State and Local taxes may be added for On-Demand purchases, depending on your location.)
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 exercises. Note: The 180-day course access period begins at time of purchase.

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

Prerequisites
Before attending this course, students should have the general knowledge equivalent to what is covered in:
DA-100: Analyzing Data with Power BI or Excel BI Tools: Power BI for Excel Users.

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

Do You Still Prefer a Live, Instructor-led Class?
Already know On-Demand, self-study training is not right for you? We also offer this same course content in a live, instructor-led format. For details, click on the link below:
Power BI Intermediate (Instructor-led Class)

Course Outline

Intermediate Power Query
Import Data from PDFs
Connect to webpages from Power BI Desktop
Get webpage data by providing examples
Combined files (binaries) in Power BI Desktop
Use Fuzzy Matching to Combine Disparate Data Sets
Using Data Profiling
Add a Column from Examples
Add a Custom Column with M

Intermediate Data Modeling
Create and use What-If Parameters to Visualize Variables 
Using Grouping and Binning in Power BI Desktop
Set and user Date Tables in Power BI Desktop
Use Quick Measures for Common Calculations

Script Visuals
Create R Visuals in Power BI Desktop
R Integration: Installing an R Environment
Create Python Visuals in Power BI Desktop
Python Integration: Installing Python

Advanced Report Design
Using Report Themes in Power BI Desktop 
Use Conditional Formatting in Tables 
Using Drillthrough in Power BI Desktop
Adding Data-Driven Images to Power BI Reports
Using Parameters
Create and Use Report Templates in Power BI Desktop

Advanced Dashboard Design
Use Dashboard Themes in the Power BI Service
Import and Display KPIs in Power BI
KPI Visuals
The Multi KPI Visual
The UNICHAR Function 

Analytics
A tiny introduction to machine learning and predictive analysis in Power BI
Forecasting with ARIMA
Visualizing and Operationalizing R Data in Power BI Desktop
View outline in Word

GPBINT

Attend hands-on, instructor-led Microsoft 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.