Welcome to ONLC Training Centers

Power BI Intermediate Course

Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $995

Savings options:

 Learning Credits
Need a price quote?

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

Need a class for a group?

We can deliver this class for your group. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class from your home or office.


Power BI Intermediate Course

 

Power BI is one of our most popular class series and these classes can fill weeks ahead. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get a class date you prefer, it's best to register as far in advance as possible.

Power BI is one of our most popular class series and these classes can fill weeks in advance. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get the class date you prefer, it's best to register as far in advance as possible.

Power BI Intermediate Course Overview

This hands-on, online instructor-led course is intended as a continuation of our introductory-level courses PL-300: Microsoft Power BI Data Analyst and/or Excel BI Tools: Power BI for Excel Users in Power BI. This course covers common intermediate-level tasks and some of Power BI’s most desirable new features.

Power BI Intermediate Course Prerequisites

Before attending this course, students should have the general knowledge equivalent that is covered in:
Excel BI Tools: Power BI for Excel Users or PL-300: Microsoft Power BI Data Analyst.

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

Note: This class is also available in our On-Demand, eLearning Format.

Can't miss 2 days out of the office to take the live, instructor-led course? Learn at your own pace and in your own time with our self-study On-Demand course. For details, click this link:
Microsoft On-Demand: Power BI Intermediate

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

Analytics

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

 

View outline in Word

BPBINT

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