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.
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
Harder Imports and Data Profiling 2 hours
PDF tables, Web pages, Fuzzy-match merges, Custom columns, Data profiling.
Modeling for Time 1.5 hours
What-if parameters, Grouping and binning, Time intelligence with quick measures.
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.
KPIs and Scorecards 1 hour
KPI visual, Goals and targets, Check-ins.
Advanced Report and Dashboard Design 1.5 hours
Report themes, Conditional formatting, Drill-through, Data-driven images.
Basic Statistical Analysis 1.5 hours
Analytics pane, Reference lines, Forecasting, Outlier detection.
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.
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.