Microsoft Power BI Intermediate course image

Microsoft Power BI Intermediate

Take the next step in Power BI with harder imports, time intelligence, R and Python visuals, KPIs and scorecards, advanced report design, and basic statistical analysis.

$900.00

Description

Take the next step in Power BI with harder imports, time intelligence, R and Python visuals, KPIs and scorecards, advanced report design, and basic statistical analysis.

Price$900Per person
Time9 course hoursOn-demand video and labs, plus 1 hour of coaching
DeliveryOn-demand asynchronous trainingWith online support and 1 hour of coaching
CredentialCertificate of completionFrom We Can Code IT

About this course

This course is the next step after a first Power BI course. You will import and profile data from PDFs and web pages, use fuzzy matching and custom columns, and model for time with what-if parameters and time intelligence. You will also add R and Python visuals, build KPIs and scorecards, design more polished reports and dashboards, and apply basic statistical analysis such as forecasting and outlier detection.

Who it is for

This course suits data analysts, reporting analysts, and team leads who already publish basic Power BI reports and want the next set of tools.

Prerequisites

Completion of a first Power BI course, or equivalent experience building and publishing basic reports

WCCI's Microsoft Power BI for Excel or Level 1 Report Builder course is a good starting point

Requirements

Requires a Windows PC

Power BI Desktop (free, Windows only)

R and Python installed locally for the script visuals module; your IT team may need to approve the installs

Python and R visuals render in the Power BI service only with a paid Power BI Pro or Premium Per User licence

Creating and sharing scorecards needs a paid Power BI Pro licence

What you will be able to do

  • You will be able to import and profile data from PDF tables and web pages and combine sources with fuzzy-match merges and custom columns.
  • You will be able to add what-if parameters, groups, bins, and time intelligence measures to a model.
  • You will be able to build one R visual and one Python visual and explain where each will render.
  • You will be able to create a KPI visual and a scorecard with goals, targets, and check-ins.
  • You will be able to apply themes, conditional formatting, drill-through, and data-driven images to a report.
  • You will be able to add reference lines, a forecast, and outlier detection to a visual.

Syllabus

1

Harder Imports and Data Profiling 2 hours

PDF tables, Web pages, Fuzzy-match merges, Custom columns, Data profiling.

Lab: You will combine a PDF table and a web table with fuzzy matching and profile the result for quality issues.
2

Modeling for Time 1.5 hours

What-if parameters, Grouping and binning, Time intelligence with quick measures.

Lab: You will add a what-if parameter and time intelligence measures to test a pricing scenario.
3

R and Python Visuals 1.5 hours

R script visuals, Python script visuals, A regression in R, A forecast in Python, Where script visuals render.

Lab: You will build one regression visual in R and one forecast visual in Python.
4

KPIs and Scorecards 1 hour

KPI visual, Goals and targets, Check-ins.

Lab: You will build a scorecard with three goals linked to report data and record a check-in.
5

Advanced Report and Dashboard Design 1.5 hours

Report themes, Conditional formatting, Drill-through, Data-driven images.

Lab: You will redesign a report with a theme, conditional formatting, and a drill-through detail page.
6

Basic Statistical Analysis 1.5 hours

Analytics pane, Reference lines, Forecasting, Outlier detection.

Lab: You will add reference lines, a forecast, and outlier detection to a sales trend and explain what they show.
+

Coaching sessions 1 hour

One-on-one or small-group coaching, scheduled with your coach.

How it is delivered

How you learn

On-demand asynchronous training with online support, plus 1 hour of coaching.

Live or in person

Live online or in-person sessions are available for an additional fee. Email admissions@wecancodeit.org for details.

TechCred

Eligible credential

Microsoft Power BI Intermediate

Reimbursement applies only to the credential approved in your TechCred application, so use the exact credential name shown on this page.

Funding

Ohio's TechCred program may reimburse eligible Ohio employers up to $1,000 per person, per credential, and up to $30,000 per application, for eligible costs such as tuition and certification costs.

This price is within TechCred's maximum of $1,000 per person, per credential.

Timeline

The current application period opens at 9:00 a.m. on October 1, 2026 and closes at 3:00 p.m. on October 30, 2026.

Training must start no earlier than the first day of the application period and be completed within 12 months of the award date.

What we provide

For each learner, We Can Code IT provides an itemized per-person invoice that shows the exact credential name, and a certificate that shows the learner's name, the credential and the date earned (or the vendor's exam record for certifications). We can also send a written quote to include with your TechCred application.

Pricing is the same for all customers, whether or not you use TechCred.

We Can Code IT is an independent training provider. Being listed as an eligible TechCred provider is not an endorsement by the State of Ohio and does not guarantee funding. The Ohio Department of Development makes all TechCred decisions, so check the state's current program guidelines before you apply. Program details: the State of Ohio’s TechCred page.

Enroll your team

One or a few learners

Choose the number of seats, add the course to your cart and check out.

A group, or a written quote

Send the form below for group enrollment or a written quote to include with your TechCred application. We reply within one business day. You can also email admissions@wecancodeit.org.

Request group enrollment or a written quote

Tell us about your team and we will reply within one business day.

← Back

Thank you for your response. ✨

We Can Code IT, LLC, 26300 Cedar Rd, Suite 1105, Beachwood, OH 44122. Registered with the Ohio State Board of Career Colleges and Schools, Registration No. 15-03-2064T.

Syllabus