Power BI Tutorial: Canadian Healthcare Priority Procedure Wait Times Dashboard

In this complete Power BI dashboard tutorial, we explore wait times for priority procedures across Canada using CIHI healthcare data. You’ll learn how to transform raw wait time datasets into a fully interactive healthcare analytics dashboard with powerful visualizations and DAX measures. Complete Data and project file: https://drive.google.com/drive/folder... This tutorial covers the entire Power BI workflow — from importing and cleaning raw CIHI wait time data to building advanced dashboards for benchmark analysis, percentile trends, provincial comparisons, and regional healthcare insights. 📌 In this tutorial you will learn: ✔ Importing and transforming CIHI wait times raw data ✔ Cleaning text-based time and indicator fields in Power Query ✔ Creating numeric year and custom period fields ✔ Building DAX measures for benchmark and percentile analysis ✔ Designing overview and trend dashboards ✔ Creating matrix visuals at province and regional levels ✔ Building interactive bubble charts and advanced visualizations ✔ Comparing Power BI results with the official CIHI website ✔ Healthcare analytics dashboard design best practices This project is perfect for: Power BI beginners and intermediate users Data analysts and BI developers Healthcare analytics professionals Students building portfolio projects Anyone interested in Canadian healthcare data analysis 📊 Tools Used: Power BI Power Query DAX CIHI Wait Times Data If you enjoy data analytics, healthcare dashboards, and Power BI projects, make sure to like, subscribe, and turn on notifications for more tutorials. #PowerBI #HealthcareAnalytics #DataAnalytics #CIHI #DashboardDesign #PowerBIDashboard #BusinessIntelligence #DataVisualization #DAX #powerquery Timeline – Power BI CIHI Wait Times Dashboard Tutorial 00:00 – Introduction Brief overview of the tutorial and what the session will cover. 06:43 – Reviewing the Completed Power BI Dashboard on CIHI Wait Times Walkthrough of the final dashboard, key KPIs, visuals, and overall analytical insights. 17:27 – Verifying Numbers Between Power BI Dashboard and CIHI Website Cross-checking dashboard calculations against the official Canadian Institute for Health Information (CIHI) website data for accuracy and validation. Complete Data source 20:06 – Deep Dive into CIHI Wait Time Data Analyzing wait time performance using integrated bubble charts, line charts, and clustered charts. 22:56 – Starting the Project from Scratch Using Raw CIHI Wait Times Data Importing raw data and setting up the Power BI project structure. 25:26 – Data Cleaning and Transformation of Time-Related Data in Text Format Using Power Query to clean and standardize text-based time fields. 29:30 – Converting Indicator Result Text Field into Numeric Values Transforming text-based indicator results into numeric format for calculations and visualization. 30:52 – Creating Numeric Year Field from Text Field Extracting and converting year information into a usable numeric field. 32:09 – Creating Period Type (Standard, Full Year, COVID Extra) Building custom period categories for more accurate data analysis and reporting. 38:53 – Creating Important Measures Developing DAX measures for benchmark analysis, percentile calculations, and KPI reporting. 53:35 – Working on Overview Dashboard Building the overview page focused on percentage of patients treated within benchmark. 1:14:59 – Creating the Trend Dashboard Page for CIHI Wait Time Data Designing trend analysis visuals to monitor changes over time. 1:29:48 – Working on Top 3 Indicators / Procedures Trend Analysis Analyzing benchmark performance, 50th percentile, and 90th percentile trends for top procedures. 1:47:06 – Creating Matrix Table for Benchmark, Volume, 50th & 90th Percentile Building a detailed matrix visual at province and regional levels. 1:53:52 – Deep Dive into CIHI Wait Times Data Using Bubble Charts and Related Visuals Advanced visual analytics using interactive bubble charts and supporting visuals. 2:09:51 – Comparing Data with the CIHI Wait Times Website & Closing Remarks Final validation against the CIHI website and tutorial conclusion.