This project provides a deep dive into the global impact of the COVID-19 pandemic by transforming raw data into meaningful insights. Using a combination of SQL Server for backend data engineering and Tableau for frontend visualization, I analyzed infection rates, mortality statistics, and vaccination progress across the globe. The analysis covers the period from early 2020 through early 2021.
Database: SQL Server (T-SQL)
Visualisation: Tableau Desktop
The data processing involved complex queries to clean and aggregate information from two primary tables: CovidDeaths and CovidVaccinations.
Join Operations: Merged death and vaccination tables on location and date.
Window Functions: Utilized SUM(CONVERT(int, vac.new_vaccinations)) OVER (Partition by dea.location...) to create a running total of vaccinations per country.
CTEs & Temp Tables: Used Common Table Expressions and Temporary Tables to perform calculations on newly created columns, specifically to determine the percentage of the population vaccinated over time.
Views: Created permanent views in the database to store data for later visualization in Tableau.
The final dashboard provides an interactive summary of the pandemic's trajectory:
Global Impact: A high-level overview showing 150,574,977 total cases and 3,180,206 total deaths, resulting in a global death percentage of approximately 2.11%.
Continental Trends: A bar chart comparing total death counts, showing Europe and North America with the highest figures.
Geospatial Mapping: Interactive maps visualizing the "Percent of Population Infected" and "Percentage of Vaccinations" by country.
Infection Forecast: A line graph detailing the average percent of infection per country by month.
Images/: Screenshot of the final dashboard.
This project was inspired by and based on a two-part educational video series focused on data analyst portfolio building by Alex The Analyst (https://youtu.be/qfyynHBFOsM?si=hvs-Usy_rnll_QfQ, https://youtu.be/QILNlRvJlfQ?si=u3VZxbtJskDWxgoi)