Power BI Certification Course Online
A self-paced track toward the Microsoft Certified Power BI Data Analyst Associate credential, built from a 12-hour Power BI bootcamp and a 6-hour advanced course. Coursework runs from core concepts through data modeling, visualization, and reporting....
What's included
- Software access during the course
- Power BI Data Analyst Associate exam with retake
- 24 hours of project-based instruction
- 58 training videos
- Instructor support for questions during the course
- Class recordings for 30 days
- Verified digital certificate of completion
- Instruction at an ACCET-accredited school
Overview
A self-paced track toward the Microsoft Certified Power BI Data Analyst Associate credential, built from a 12-hour Power BI bootcamp and a 6-hour advanced course. Coursework runs from core concepts through data modeling, visualization, and reporting.
Tuition adds six hours of private tutoring in two three-hour sessions. The Power BI Data Analyst Associate exam is included with a free retake, and students can substitute an additional tutoring hour for the exam.
Who this course is for
Analysts and business staff who work with reporting and want the Microsoft Power BI credential, whether or not they have used the tool before.
Tuition & enrollment
Enroll with Virtual Design and Construction Institute, the course provider.
Loading enrollment options…
Prefer to enroll directly? Open the course website.
Preview the course
Watch free previews and explore the lessons included with enrollment at VDCI.
Power BI Course Online
-
Course Overview & Setup
Lesson 1: Getting Started with Power BI
0:55
Introduces the structure of the Power BI course and explains how to use class files, PDFs, and step-by-step guides to build skills progressively.
This preview is temporarily unavailable. Please try again later.
-
Overview of Power BI
Lesson 1: Getting Started with Power BI
10:00
Explains what Power BI is, how it’s used for business intelligence, and how it compares to Excel, including an overview of Desktop, Service, and mobile access.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Installing the Power BI Desktop app
Lesson 1: Getting Started with Power BI
1:14
Walks through installing Power BI Desktop via the Microsoft Store, explaining update cycles and how to launch the application.
View enrollment options at VDCI -
Enrollment required
Create our First Visualization
Lesson 1: Getting Started with Power BI
16:02
Demonstrates importing data and creating basic visuals like tables and column charts while explaining data types and automatic visual suggestions.
View enrollment options at VDCI -
Enrollment required
Publishing and Sharing Reports
Lesson 1: Getting Started with Power BI
10:35
Covers publishing reports to the Power BI Service, including workspaces, sharing options, licensing, and browser-based access.
View enrollment options at VDCI -
Enrollment required
Managing Links to Data Source Files & Refreshing Data
Lesson 1: Getting Started with Power BI
2:15
Explains how Power BI connects to external data sources rather than embedding files and how to manage paths and refresh data.
View enrollment options at VDCI -
Transforming Data
Lesson 2: Transforming Data Using Power Query
10:00
Introduces Power Query for data transformation, including cleaning data, handling missing values, and improving performance through upstream changes.
This preview is temporarily unavailable. Please try again later.
-
Merge Queries
Lesson 2: Transforming Data Using Power Query
10:00
Explains merging tables in Power Query to combine related data and introduces normalized data concepts and lookup tables.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Append Queries
Lesson 2: Transforming Data Using Power Query
8:13
Demonstrates appending queries to combine multiple tables with the same structure into a single dataset.
View enrollment options at VDCI -
Enrollment required
Fill and Transpose
Lesson 2: Transforming Data Using Power Query
5:16
Covers advanced transformations such as fill down and transpose to correct poorly structured data.
View enrollment options at VDCI -
Enrollment required
Unpivot & Merge Columns
Lesson 2: Transforming Data Using Power Query
10:26
Demonstrates unpivoting data, combining date fields, assigning correct data types, and preparing datasets for time-based analysis.
View enrollment options at VDCI -
Enrollment required
Query Dependencies
Lesson 2: Transforming Data Using Power Query
1:43
Explores Query Dependencies to visualize how data sources and transformations connect and to troubleshoot complex models.
View enrollment options at VDCI -
Enrollment required
Getting Data from Multiple Files in a Folder (Appending from Folder)
Lesson 2: Transforming Data Using Power Query
4:59
Demonstrates importing and automatically appending files from a folder to support scalable data updates.
View enrollment options at VDCI -
Relationships
Lesson 3: Building the Adventure Works Report
10:00
Explains creating relationships between fact and dimension tables and introduces star schema modeling.
This preview is temporarily unavailable. Please try again later.
-
Adventure Works Importing Data and Building Relationships
Lesson 3: Building the Adventure Works Report
10:00
Walks through building a relational model using AdventureWorks data and validating automatically detected relationships.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adventure Works Designing and Building the Report
Lesson 3: Building the Adventure Works Report
7:20
Focuses on report design using text boxes, images, alignment tools, and layout best practices for professional presentations.
View enrollment options at VDCI -
Enrollment required
Adventure Works Intro to DAX Adding the Current Date
Lesson 3: Building the Adventure Works Report
7:22
Introduces DAX by creating a simple date measure and explains the difference between measures and calculated columns.
View enrollment options at VDCI -
Enrollment required
Adventure Works DAX Calculated Columns Profit or Loss
Lesson 3: Building the Adventure Works Report
14:04
Demonstrates creating calculated columns with DAX and using relationships and the RELATED function across tables.
View enrollment options at VDCI -
Adventure Works Removing the Default White Background from Visuals by editing the Theme
Lesson 4: Visuals, Slicers, and More
2:00
Shows how to customize Power BI themes to remove default styling and apply consistent global design changes.
This preview is temporarily unavailable. Please try again later.
-
Adventure Works Adding more visuals
Lesson 4: Visuals, Slicers, and More
3:17
Builds additional visuals to analyze sales by customer attributes while demonstrating interactive filtering.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adventure Works Slicers
Lesson 4: Visuals, Slicers, and More
20:24
Introduces slicers as interactive filters and demonstrates layout improvements and user-friendly labeling.
View enrollment options at VDCI -
Enrollment required
Adventure Works SUM vs SUMX
Lesson 4: Visuals, Slicers, and More
12:01
Explains the difference between SUM and SUMX in DAX and why iterator functions are needed for row-level calculations.
View enrollment options at VDCI -
Enrollment required
Adjusting a Desktop Report for Mobile Devices
Lesson 4: Visuals, Slicers, and More
2:58
Demonstrates optimizing reports for mobile using the mobile layout view and adjusting visuals for smaller screens.
View enrollment options at VDCI -
Global Superstore Import Data, Define Relationships, and Create Visuals
Lesson 5: Building the Global Superstore Report
10:00
Walks through importing and modeling Global Superstore data to reinforce ETL and star schema concepts.
This preview is temporarily unavailable. Please try again later.
-
Global Superstore Intro to Filters
Lesson 5: Building the Global Superstore Report
10:00
Introduces visual-, page-, and report-level filters and explains when filters are preferable to slicers.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore Top N Filter and Filter Across All Pages
Lesson 5: Building the Global Superstore Report
7:00
Demonstrates Top N filters to highlight best- and worst-performing items and explains how ties affect results.
View enrollment options at VDCI -
Enrollment required
Global Superstore Sales by Country Page
Lesson 5: Building the Global Superstore Report
9:27
Builds a multi-page report analyzing sales by country using slicers and geographic comparisons.
View enrollment options at VDCI -
Enrollment required
Global Superstore Edit Interactions
Lesson 5: Building the Global Superstore Report
4:16
Explains how to control visual interactions to compare filtered values against unfiltered totals.
View enrollment options at VDCI -
Global Superstore Controlling Filtering with SUM and SUMX
Lesson 6: Diving Deeper into DAX
8:46
Demonstrates using SUM and SUMX to control whether calculations respect or ignore filters.
This preview is temporarily unavailable. Please try again later.
-
Global Superstore CONCATENATEX, COUNT, and COUNTX
Lesson 6: Diving Deeper into DAX
7:42
Introduces CONCATENATEX, COUNT, and COUNTX for advanced aggregations and dynamic titles.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore CALCULATE
Lesson 6: Diving Deeper into DAX
5:03
Explains how CALCULATE applies filters within DAX expressions to create reusable measures.
View enrollment options at VDCI -
Enrollment required
Global Superstore Matrix Visual with Conditional Formatting Icons and Data Bars
Lesson 6: Diving Deeper into DAX
4:10
Builds a matrix visual with conditional formatting to highlight performance trends at a glance.
View enrollment options at VDCI -
Enrollment required
Global Superstore Quick Measures
Lesson 6: Diving Deeper into DAX
7:21
Uses Quick Measures to generate common DAX calculations like YTD and YoY while keeping measures organized.
View enrollment options at VDCI -
Global Superstore Maps
Lesson 7: Maps, Drill Down, and Drill Through
6:14
Creates map visuals with Azure Maps and explains data categorization and geographic field requirements.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore Drill Down
Lesson 7: Maps, Drill Down, and Drill Through
10:41
Demonstrates drill-down using hierarchies to move between summary and detailed views.
View enrollment options at VDCI -
Enrollment required
Global Superstore Drill Through
Lesson 7: Maps, Drill Down, and Drill Through
6:21
Builds drill-through navigation between report pages while preserving filter context.
View enrollment options at VDCI -
Global Superstore Scheduling Data Refreshes and Getting Data
Lesson 8: Refreshing Data, Dashboards & Databases
10:00
Explains local refresh versus scheduled refresh in the Power BI Service using OneDrive and shared models.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Dashboards
Lesson 8: Refreshing Data, Dashboards & Databases
4:02
Explains how Power BI dashboards aggregate pinned visuals while linking back to underlying reports.
View enrollment options at VDCI -
Enrollment required
Connecting to a Database
Lesson 8: Refreshing Data, Dashboards & Databases
4:00
Demonstrates connecting Power BI to databases like SQL Server and compares Import and DirectQuery modes.
View enrollment options at VDCI -
Enrollment required
Course Outro
Lesson 8: Refreshing Data, Dashboards & Databases
0:13
Encourages continued practice to improve efficiency, confidence, and the ability to build original Power BI reports.
View enrollment options at VDCI
Power BI Advanced Course Online
-
Course Overview & Setup
Lesson 1: Hierarchies and Sorting
1:03
Explore advanced Power BI training focused on data modeling, performance optimization, and data security.
This preview is temporarily unavailable. Please try again later.
-
Hierarchies
Lesson 1: Hierarchies and Sorting
10:00
Understand how to build and use hierarchies in Power BI to organize data into logical levels like category, subcategory, and product.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Custom Sort Order
Lesson 1: Hierarchies and Sorting
8:37
Learn how to implement custom sorting in Power BI using dedicated sort columns to control data order beyond default alphabetical or numerical sorting.
View enrollment options at VDCI -
Understanding Dates, Date Tables, and Fiscal Years
Lesson 2: Date Tables and Fiscal Calendars
10:00
Master date handling in Power BI by creating dedicated date tables that support time intelligence and fiscal calendars.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Date Hierarchies, Column Sorting, and Using our Calendar vs Fiscal Years
Lesson 2: Date Tables and Fiscal Calendars
8:06
Create custom date hierarchies and apply proper column sorting to ensure accurate time-based reporting.
View enrollment options at VDCI -
Data Modeling Diving Deeper
Lesson 3: Data Modeling
10:00
Dive deeper into Power BI data modeling concepts, including relationships, filter flow, and the role of DAX in calculations.
This preview is temporarily unavailable. Please try again later.
-
Data Modeling Example of a Common Many to Many Mistake
Lesson 3: Data Modeling
10:00
Identify common many-to-many relationship mistakes in Power BI and understand how they lead to incorrect calculations and duplicate results.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Data Modeling Many to Many & Bi Directional Filtering
Lesson 3: Data Modeling
14:12
Analyze advanced data modeling scenarios involving many-to-many relationships and bidirectional filtering.
View enrollment options at VDCI -
Enrollment required
Parameters
Lesson 3: Data Modeling
4:39
Enable dynamic reporting in Power BI by using parameters to let users adjust inputs like date ranges or calculation windows.
View enrollment options at VDCI -
Enrollment required
Inactive Relationships and USERELATIONSHIP
Lesson 3: Data Modeling
10:29
Leverage inactive relationships in Power BI and activate them using USERELATIONSHIP within DAX calculations.
View enrollment options at VDCI -
Enrollment required
Troubleshooting Data Modeling Problems
Lesson 3: Data Modeling
1:38
Diagnose common Power BI data modeling issues such as incorrect totals, broken relationships, and inconsistent DAX results.
View enrollment options at VDCI -
Intro to Row Level Security (RLS)
Lesson 4: Row-Level Security (RLS)
3:23
Understand how to implement row-level security (RLS) in Power BI to control data access at the user level.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Row Level Security (RLS) Static Roles
Lesson 4: Row-Level Security (RLS)
13:38
Configure static row-level security roles in Power BI using predefined filters to restrict data visibility.
View enrollment options at VDCI -
Enrollment required
Row Level Security (RLS) Dynamic Roles
Lesson 4: Row-Level Security (RLS)
15:42
Implement dynamic row-level security in Power BI by leveraging user login credentials to control data access.
View enrollment options at VDCI -
Enrollment required
Power BI Certification PL 300 Exam Info and Prep Materials
Lesson 5: Power BI Certification
2:41
Prepare for the Microsoft PL-300 Power BI certification exam with guidance on exam structure, study resources, and practice strategies.
View enrollment options at VDCI -
Connecting to a Database
Lesson 6: Databases and Query Folding
7:41
Connect Power BI to databases like SQL Server using import and DirectQuery modes.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Query Folding
Lesson 6: Databases and Query Folding
11:19
Optimize Power BI performance by understanding query folding and how transformations are pushed to the data source.
View enrollment options at VDCI -
Enrollment required
Course Outro
Lesson 6: Databases and Query Folding
0:11
Wrap up the Power BI training with key takeaways and encouragement to apply learned techniques in real-world projects.
View enrollment options at VDCI
Curriculum
What you'll learn
- Prepare and model data using Power Query and DAX
- Create interactive reports and dashboards
- Control data access with filters and security
- Publish, manage, and share content in Power BI Service
- Analyze insights and optimize report performance
Course outline
-
Power BI Course Online 12 hours
Develop skills in Power BI, an advanced data visualization platform, to design interactive and visually engaging charts, graphs, and maps. Bring in data from multiple sources, shape and examine information, tailor visual elements, and publish polished reports for sharing and presentation.
- Import and prepare data from sources such as Excel, CSV files, and online databases using Power Query
- Build interactive visuals, including charts, maps, cards, and slicers, to uncover trends and patterns
- Apply DAX (Data Analysis Expressions) to create measures, calculated columns, and custom summaries
- Create polished reports by adding titles, logos, and formatting for a professional presentation
- Manage relationships between tables to enable dynamic and responsive reporting
- Share and collaborate on reports through the Power BI Service with options for exporting, commenting, and app connections
- Create dashboards and understand how dashboards differ from reports when presenting to stakeholders
- Schedule data refreshes and manage reusable datasets to keep reports current and scalable
-
Power BI Advanced Course Online 6 hours
This advanced Power BI course focuses on building more reliable data models using proper relationships, filter flow, fiscal and calendar date tables, Row-Level Security, and more.
- Build better data models by understanding relationships, cardinality, and cross-filter direction
- Design reliable data models and avoid common modeling mistakes
- Create and use hierarchies to organize and drill into data
- Control visual order with custom sort columns
- Create reusable date tables supporting fiscal and calendar years
- Add parameters to make reports interactive and flexible
- Implement Row-Level Security (RLS) with Static and Dynamic roles