COVID-19 Data Analysis (SQL + Tableau)

📊 Overview

This project analyzes global COVID-19 data using SQL and Tableau to uncover trends in infection rates, mortality, and vaccination progress.

🎯 Objectives

• Analyze total cases and deaths across countries
• Identify countries with the highest infection and mortality rates
• Track vaccination progress over time
• Calculate key metrics such as death percentage and infection rate

🛠️ Tools & Technologies

• Microsoft SQL Server (SSMS)
• SQL (T-SQL)
• Tableau (Data Visualization)
• Excel (initial data inspection)

📁 Dataset

• Source: Our World in Data (COVID-19 Dataset)
• Includes: Cases, deaths, population, vaccinations

🔍 Key SQL Analysis

1. Total Cases vs Total Deaths

• Calculated death percentage per country
• Evaluated severity of COVID-19 impact globally

2. Infection Rate by Population

• Compared total cases relative to population size
• Identified countries with highest infection rates

3. Countries with Highest Death Count

• Ranked countries based on total deaths
• Analyzed global distribution of fatalities

4. Vaccination Progress

• Used window functions to calculate rolling vaccination totals
• Measured effectiveness of vaccination rollout over time

📊 Tableau Dashboard

An interactive dashboard was created in Tableau to visualize:

• Global cases, deaths, and death percentage
• Total deaths by continent
• Percent population infected by country (map visualization)
• Infection trends over time

🔗 Live Dashboard

View the interactive dashboard here: https://public.tableau.com/app/profile/larson.st.cyr/viz/CovidDashboard_17541579876190/Dashboard1

📈 Key Insights

• Europe and North America had the highest total death counts
• Infection rates varied significantly across countries and regions
• Vaccination rollout showed a strong correlation with reduced death growth over time

📸 Visualizations

• Global COVID-19 Dashboard (Tableau)
• Infection rate map by country
• Death count by continent (bar chart)
• Infection trend over time (line chart)

🚀 What I Learned

• Writing advanced SQL queries using joins, aggregations, and window functions in SSMS
• Transforming raw datasets into structured, query-ready formats
• Building interactive dashboards in Tableau to communicate insights effectively
• Connecting SQL outputs to visualization tools for end-to-end analysis