Back to Projects

COVID-19 Impact Analysis

Interactive Tableau visualization analyzing COVID-19's impact on India — tracking vaccination rollout, weekly case surges, and death rate trajectories with demographic context.

TableauData VisualizationSQL

Problem Statement

The COVID-19 pandemic generated massive amounts of data across countries, but raw numbers alone don't tell the story. The challenge was to build an interactive visualization that contextualises India's pandemic trajectory — vaccination progress, case surges, and death rates — against demographic indicators like Human Development Index, median age, and population density. The goal: surface clear before-and-after vaccination patterns and make the data explorable for anyone, built entirely within Tableau using joined public datasets.

Approach & Methodology

1

Data Collection & Joining

Imported multiple public COVID-19 datasets into Tableau, including daily case counts, vaccination records, death statistics, and country-level demographic indicators (HDI, median age, population density). Performed data joins directly within Tableau on country and date keys to create a unified analytical dataset.

2

Demographic Context Layer

Created a KPI header showing India's key demographic indicators — Human Development Index (0.6), Median Age (28.2), Population Density (450.4) — alongside pandemic-specific metrics: Percentage of Population Vaccinated (1.929%), Percentage Population Dead (0.035%), and Percentage of Population Infected (1.389%). These provide essential context for interpreting the pandemic data.

3

Temporal Trend Visualization

Built three interconnected time-series charts — Total People Vaccinated (cumulative), Weekly New Cases (with wave identification), and Weekly Death Rate — all aligned on the same time axis (March 2020 – May 2021). Color-coded bars distinguish pre-vaccination (orange) from post-vaccination (blue) periods to highlight the intervention effect.

4

Vaccination Impact Analysis

Overlaid vaccination introduction markers on death rate and case charts to visually demonstrate the causal relationship between vaccine rollout and declining mortality. The death rate chart clearly shows a sharp decline in death rate even though there is a sharp increase in the number of cases after vaccination, while case volume shows the second wave's severity was not matched by proportional mortality.

Architecture

architecture-diagram

  ┌─────────────────────────┐    ┌─────────────────────────┐
  │   COVID-19 Case Data    │    │   Vaccination Records   │
  │   (Daily by country)    │    │   (Daily by country)    │
  └───────────┬─────────────┘    └───────────┬─────────────┘
              │                              │
              └──────────┬───────────────────┘
                         │  Tableau Data Join
                         │  (country + date keys)
                         ▼
              ┌─────────────────────────┐
              │   Demographic Data      │
              │   HDI, Age, Density     │
              └───────────┬─────────────┘
                         │  Joined
                         ▼
              ┌─────────────────────────┐
              │     Tableau Desktop     │
              │  Calculated Fields      │
              │  Interactive Filters    │
              │  Before/After Coloring  │
              └───────────┬─────────────┘
                         │
                         ▼
              ┌─────────────────────────┐
              │  Interactive Dashboard  │
              │  KPI Cards + 3 Charts   │
              │  Vaccination · Cases ·  │
              │  Death Rate Trends      │
              └─────────────────────────┘

Results & Impact

2.2M+

Peak Weekly Cases

India second wave (Feb 2021)

140M+

Vaccinated

Total people vaccinated

Sharp Drop

Death Rate Decline

Despite increase in cases after vaccination

1.389%

Population Infected

Of total population

0.6

HDI

Human Development Index

28.2

Median Age

Years

Visualized the dramatic impact of vaccination on death rates — sharp decline in death rate even though there is a sharp increase in the number of cases after vaccination
Captured India's devastating second wave: weekly new cases peaked at 2.2M+ around February 2021
Tracked vaccination milestone of 140M+ total people vaccinated with clear inflection points
Built demographic context layer showing HDI (0.6), median age (28.2), and population density (450.4) for analytical framing
Created before/after vaccination comparison revealing vaccination as the critical intervention in reducing mortality

Vaccination Impact — Key Findings

HDI
0.6
Median Age
28.2
Pop. Density
450.4
% Vaccinated
1.929%
% Dead
0.035%
% Infected
1.389%
Total Vaccinated
140M+

Cumulative vaccinations across India

Peak Weekly Cases
2.2M+

India's devastating second wave — Feb 2021

Death Rate Before
3.5

Peak weekly death rate (pre-vaccination era)

Death Rate Decline
Sharp Drop

Despite sharp increase in cases after vaccination

Tableau Dashboard

Live · Interactive Dashboard
Open in Tableau Public
public.tableau.com · COVID-19 Impact Analysis — India

Loading dashboard…

Vaccination Impact

Sharp decline in death rate even though there is a sharp increase in the number of cases after vaccination

Second Wave Severity

2.2M+ weekly cases peak around February 2021

Vaccination Milestone

140M+ total people vaccinated across India

Back to Projects