Projects
SQLPower BI
03

COVID-19 Analysis

Explored global COVID-19 trends and case fatality rates using SQL for data exploration and Power BI to let users interrogate the data themselves.

Downloaded the static CSV from Our World in Data and split it into two files:

  • Covid Deaths
  • Covid Vaccinations

Both files were imported into a SQL database for exploration. Specific queries were then loaded into Power BI, with Power Query handling any additional transformations.

The report has two tabs: Continent grouping (showing infection and mortality rates by continent over time) and Country grouping (with a toggle to switch between Mortality Rate and Infection Rate by country).

The current version uses a static CSV snapshot. For a production-ready dashboard I would look to automatically pull fresh data via an API or webscraping, so the report stays current whenever Power BI refreshes.