{"id":9,"date":"2026-06-05T14:46:46","date_gmt":"2026-06-05T14:46:46","guid":{"rendered":"https:\/\/www.datascientist.ca\/blog\/?p=9"},"modified":"2026-06-05T14:47:33","modified_gmt":"2026-06-05T14:47:33","slug":"title-power-bi-tutorial-canadian-healthcare-wait-times-dashboard-using-cihi-data","status":"publish","type":"post","link":"https:\/\/www.datascientist.ca\/blog\/title-power-bi-tutorial-canadian-healthcare-wait-times-dashboard-using-cihi-data\/","title":{"rendered":"Power BI Tutorial: Canadian Healthcare Wait Times Dashboard Using CIHI Data"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">If you work in healthcare analytics or want to build a real-world Power BI portfolio project, this tutorial walks you through building a fully interactive Canadian healthcare wait times dashboard from scratch using publicly available CIHI data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is not a toy dataset. The project uses real Canadian Institute for Health Information wait time data covering priority procedures across all provinces \u2014 the same data published on the official CIHI website, which we validate against directly in the tutorial.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>What You Will Learn<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This tutorial covers the complete Power BI workflow from raw data to finished dashboard:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Importing and cleaning raw CIHI wait time data in Power Query<\/li>\n\n\n\n<li>Converting text-based time and indicator fields into numeric values<\/li>\n\n\n\n<li>Creating custom period types including Standard, Full Year, and COVID Extra periods<\/li>\n\n\n\n<li>Building DAX measures for benchmark analysis, 50th percentile, and 90th percentile calculations<\/li>\n\n\n\n<li>Designing an overview dashboard tracking percentage of patients treated within benchmark<\/li>\n\n\n\n<li>Building trend analysis pages and top procedure comparisons<\/li>\n\n\n\n<li>Creating matrix visuals at province and regional levels<\/li>\n\n\n\n<li>Using interactive bubble charts for deep-dive analytics<\/li>\n\n\n\n<li>Validating Power BI results against the official CIHI website<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Who This Is For<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This project is well suited for Power BI beginners and intermediate users looking to move beyond sample datasets, data analysts and BI developers working in Canadian healthcare, students building a portfolio with real public data, and anyone interested in understanding how Canadian healthcare wait time data is structured and analyzed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tools Used<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Power BI, Power Query, DAX, and the CIHI Wait Times public dataset \u2014 all free and publicly available.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tutorial Walkthrough<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The full tutorial runs just over two hours and covers every step in detail. Here is what each section covers:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>00:00 \u2014 Introduction and overview<\/li>\n\n\n\n<li>06:43 \u2014 Walkthrough of the completed dashboard<\/li>\n\n\n\n<li>17:27 \u2014 Validating Power BI numbers against the CIHI website<\/li>\n\n\n\n<li>20:06 \u2014 Deep dive analytics using bubble charts and line charts<\/li>\n\n\n\n<li>22:56 \u2014 Starting from scratch with raw data<\/li>\n\n\n\n<li>25:26 \u2014 Data cleaning and Power Query transformations<\/li>\n\n\n\n<li>38:53 \u2014 Building DAX measures for KPIs and benchmarks<\/li>\n\n\n\n<li>53:35 \u2014 Building the overview dashboard<\/li>\n\n\n\n<li>1:14:59 \u2014 Trend dashboard page<\/li>\n\n\n\n<li>1:47:06 \u2014 Matrix table at province and regional level<\/li>\n\n\n\n<li>1:53:52 \u2014 Advanced bubble chart analytics<\/li>\n\n\n\n<li>2:09:51 \u2014 Final CIHI validation and closing remarks<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Watch the Full Tutorial<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Power BI Tutorial: Canadian Healthcare Priority Procedure Wait Times Dashboard\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/jV__acnLqSc?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">If you found this useful, the full Power BI course covering this project and more is available at <a href=\"https:\/\/www.datascientist.ca\/powerbi_course.html\">DataScientist.ca<\/a>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Category:<\/strong> Power BI Tutorials<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Paste the actual YouTube URL in place of <code>YOUR_YOUTUBE_URL_HERE<\/code> and you&#8217;re ready to publish. Want me to do the next video too?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you work in healthcare analytics or want to build a real-world Power BI portfolio project, this tutorial walks you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[11],"tags":[10,7,8,4,5,9,6],"class_list":["post-9","post","type-post","status-publish","format-standard","hentry","category-power-bi-tutorials","tag-canadian-healthcare","tag-cihi","tag-dashboard-tutorial","tag-dax","tag-healthcare-analytics","tag-power-bi","tag-power-query"],"_links":{"self":[{"href":"https:\/\/www.datascientist.ca\/blog\/wp-json\/wp\/v2\/posts\/9","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.datascientist.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.datascientist.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.datascientist.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.datascientist.ca\/blog\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":2,"href":"https:\/\/www.datascientist.ca\/blog\/wp-json\/wp\/v2\/posts\/9\/revisions"}],"predecessor-version":[{"id":12,"href":"https:\/\/www.datascientist.ca\/blog\/wp-json\/wp\/v2\/posts\/9\/revisions\/12"}],"wp:attachment":[{"href":"https:\/\/www.datascientist.ca\/blog\/wp-json\/wp\/v2\/media?parent=9"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.datascientist.ca\/blog\/wp-json\/wp\/v2\/categories?post=9"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.datascientist.ca\/blog\/wp-json\/wp\/v2\/tags?post=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}