Advanced Microsoft Power BI course image

Advanced Microsoft Power BI

Take your Power BI work further with advanced DAX, Query Editor transformations, spatial analytics, R integration, and the security and governance needed to deploy it.

$900.00

Description

Take your Power BI work further with advanced DAX, Query Editor transformations, spatial analytics, R integration, and the security and governance needed to deploy it.

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 for people who already build working Power BI reports and models and now need the harder techniques. You will write advanced DAX patterns, handle messy sources in the Query Editor, map data with ArcGIS for Power BI, and bring R into your reports. You will finish by tuning performance and securing a model so it can be deployed and governed with confidence.

Who it is for

This course suits data analysts, BI analysts, and report developers who maintain production Power BI content that other people rely on.

Prerequisites

You already build Power BI reports and basic data models

You are comfortable writing simple DAX measures

Completion of WCCI's Data Model Design Using Power BI course, or equivalent experience, is recommended

Requirements

Requires a Windows PC

Power BI Desktop (free, Windows only)

R installed locally for the R module

R visuals in the Power BI service need a paid Power BI Pro or Premium Per User licence

Publishing to a shared workspace and testing row-level security need a paid Power BI Pro or Premium Per User licence or a Fabric capacity

ArcGIS for Power BI must be enabled by your tenant administrator

What you will be able to do

  • You will be able to write DAX measures that use variables, running totals, moving averages, and calculated tables.
  • You will be able to clean and normalise messy sources in the Query Editor using conditional columns, error handling, and merges.
  • You will be able to build a spatial analysis in ArcGIS for Power BI with reference layers, buffers, and drive-time areas.
  • You will be able to use an R script as a data source and add an R visual to a report, and explain its licensing and refresh limits.
  • You will be able to find and fix slow visuals with Performance Analyzer by reducing columns and granularity.
  • You will be able to secure a model with row-level security roles, workspace roles, sensitivity labels, and endorsement.

Syllabus

1

Advanced DAX Patterns 2 hours

Variables in measures, Running totals, Moving averages, Calculated tables.

Lab: You will add a set of running-total and moving-average measures to a sales model and check them against a known result.
2

Advanced Query Editor Transformations 1.5 hours

Conditional columns, Error rows, Merge queries, Normalising messy sources.

Lab: You will turn an inconsistent multi-source extract into one clean, refreshable table.
3

Spatial Analytics with ArcGIS for Power BI 1.5 hours

Location types, Reference layers, Buffers, Drive-time areas.

Lab: You will map customer locations and add a drive-time area around a site to compare coverage.
4

R in Power BI 1.5 hours

R script data sources, R visuals, Licensing limits, Refresh limits.

Lab: You will load data through an R script and build one R visual, then note where it will and will not render.
5

Performance Tuning 1 hour

Performance Analyzer, Removing unused columns, Reducing granularity.

Lab: You will measure a slow report page, apply two model changes, and record the improvement.
6

Secure and Deploy 1.5 hours

Row-level security roles, Workspace roles, Sensitivity labels, Endorsement.

Lab: You will create and test row-level security roles on a model and prepare it for endorsement in a shared workspace.
+

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

Advanced Microsoft Power BI

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