Power BI Certificate (Online at your own pace)

Gain insights into your data using business intelligence software – Power Business Intelligence. Power BI is a widely used business analytics service offered by Microsoft. Power BI Desktop is a complete data analysis and report creation tool that you install for free. Discover the process of creating interactive reports. Integrate financial, marketing, or any other source data in your accounting system, Excel, or on the Web. Streamline the data to what is needed using Power Query. Create charts, maps, and other visuals to see your data in real time. Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using relationships and DAX (Data Analysis Expressions). Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports and analyze your results. This certificate will enhance your skills in data analysis, giving you greater insight into your organization’s performance and allowing you to make more informed decisions.

This Certificate must be taken in the following order:

Introduction
Intermediate
Advanced

Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ

Class Details:

Introduction to Power BI
Unit 1: Overview Power BI Components Install Power BI Desktop (free software) Getting started		Unit 2: Connect with Data Sources Types of data sources Import Excel and text files Connect to databases (Access) Import data from the Web
Unit 3: Transform Data Introduction to Power Query Shape data Filter data Understand the Data Model		Unit 4: Creating Reports Overview Create visuals Format reports Share your files

Intermediate Power BI
Unit 1: Power Query Review the ETL Process Insert columns using different methods Group, Summarize, Pivot, and UnPivot data Merge and Append queries		Unit 2: Data Modeling What Data Modeling is Modeling Options Create and manage relationships Create Date table
Unit 3: DAX Introduction to DAX Calculate columns and measures Time Intelligence functions Quick Measures		Unit 4: Reports Filters versus Slicers Visual Hierarchies and Drill downs Drillthrough Define visual interactions Apply conditional formatting

Advanced Power BI
Unit 1: Power Query Utilize Column profile, distribution, and quality Perform fuzzy match Duplicate versus Reference queries Debug errors		Unit 2: Data Modeling What a Star Schema is Understand relationship types Manage relationships
Unit 3: DAX Understand contexts CALCULATE function COALESCE function Compute visual totals accurately		Unit 4: Reports Insert Objects Create Bookmarks

Marion Williams

With over 20 years of IT and training experience, Marion Williams has been responsible for designing custom solutions using Access and Excel/VBA. As a trainer, Marion has delivered over 200 seminars to CPA associations across Canada. As technology evolved, Marion currently uses her skills to specialize in training Power BI – a tool used for business intelligence.

Marion earned the FLMI designation which is a comprehensive business education in the context of the insurance and financial services industry with a specialty in Information Technology.

Sections

OE-62120b-ugc-S26

Starts Mon, Apr 6th 2026 12:01 AM - 11:59 PM

Online

Price: $495.00 Min Age 18 yr.

Enroll Now