Welcome to ONLC Training Centers

Microsoft On Demand: Power BI Intermediate Course

Price:$595

Need a price quote?

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


Microsoft On Demand: Power BI Intermediate Course

 

*** 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:
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 nationwide 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.

GENERAL INFO

Class Format
Class Policies
Student Reviews


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com