BC COVID-19 Dashboard

A two-page Power BI dashboard visualizing COVID-19 trends across British Columbia using BCCDC open data, designed as a portfolio project to demonstrate data analytics and visualization skills.

Overview

This dashboard provides an interactive view of COVID-19 metrics in British Columbia, including case trends, regional breakdowns, and temporal analysis. The project showcases ability to work with public health data and create actionable visualizations.

Tech Stack

• Power BI Desktop - Dashboard development
• BCCDC Open Data - Public health data source
• DAX - Custom calculations and measures

Dashboard Features

Page 1: Overview

• Time-series trends of cases, hospitalizations, and deaths
• Key performance indicators (KPIs)
• Date range filtering

Page 2: Regional Analysis

• Geographic breakdown by health authority
• Comparative metrics across regions
• Interactive drill-down capabilities

Data Processing

• Cleaned and transformed raw BCCDC data
• Created calculated measures for rates and trends
• Designed data model for efficient querying

Visualizations

• Line charts for temporal trends
• Bar charts for regional comparisons
• Cards for KPI metrics
• Slicers for interactive filtering

Deliverables

• Published dashboard with screenshots
• .pbix file for reproducibility
• Documentation of data sources and methodology

Purpose

This project demonstrates:

• Data analysis and visualization skills
• Power BI proficiency
• Understanding of public health metrics
• Ability to communicate insights through visual design

What I Learned

• Power BI dashboard design and development
• Working with time-series public health data
• DAX formula creation
• Visual design principles for data communication
• Publishing and sharing BI reports

<!--
  See https://www.debugbear.com/blog/responsive-images#w-descriptors-and-the-sizes-attribute and
  https://developer.mozilla.org/en-US/docs/Learn/HTML/Multimedia_and_embedding/Responsive_images for info on defining 'sizes' for responsive images
-->

  
    <source
      class="responsive-img-srcset"
      
        srcset="/assets/img/covid-dashboard-overview-480.webp 480w,/assets/img/covid-dashboard-overview-800.webp 800w,/assets/img/covid-dashboard-overview-1400.webp 1400w,"
        type="image/webp"
      
      
        sizes="95vw"
      
    >
  

<img
  src="/assets/img/covid-dashboard-overview.png"
  
    class="img-fluid rounded z-depth-1"
  
  
    width="100%"
  
  
    height="auto"
  
  
  
  
    title="Overview page"
  
  
  
    loading="lazy"
  
  onerror="this.onerror=null; $('.responsive-img-srcset').remove();"
>

</picture>

</figure>

</div>
<div class="col-sm mt-3 mt-md-0">

</div>

</div>

–>