Back to Projects
ExcelTableauData VisualizationData AggregationAnalytics

COVID-19 Data Dashboard

Built an interactive COVID-19 data analytics workbook in Microsoft Excel, analyzing 85,000+ rows of global pandemic data across 210 countries and 6 continents. The project explores the pandemic from multiple angles — total case and death comparisons, population-normalized metrics, vaccination rollout effectiveness, and time series trend identification.

Files & Attachments

No files attached yet.

Demo Video
No demo video yet

Add a caption or description for the demo video…

1

Total Cases vs Deaths Analysis

Overview
  • Aggregated 85,000+ rows of daily COVID-19 data across 210 countries into a continent-level dashboard to visualize where the pandemic hit hardest.
Approach
  • Built a continent summary table using SUMIFS formulas, clustered bar charts comparing six continents, filterable country-level Excel Tables, and conditional formatting for drill-down.
Results
  • Identified a 1,000× difference in case rates between continents — Europe led with 44.9M cases while Oceania recorded just 43,000. Death rates ranged from 1.32% (Asia) to 2.70% (South America).
Tools
  • Microsoft Excel, Data Visualization, SUMIFS, Conditional Formatting
2

Time Series Wave Analysis

Overview
  • Tracked 148 million COVID-19 cases across 6 continents over 16 months (Jan 2020 – Apr 2021), aggregating daily data into monthly time series to identify pandemic waves.
Approach
  • Built a wave peak analysis using INDEX/MATCH and MAX formulas, calculated case-death lag metrics, computed case fatality rates at peak, and tracked month-over-month growth.
Results
  • Identified three distinct global surges. Europe showed a classic 2-month case-death lag — cases peaked Nov 2020 but deaths didn't follow until Jan 2021.
Tools
  • Microsoft Excel, Month-Over-Month Formulas, Time Series Aggregation
3

Vaccination Analysis

Overview
  • Analyzed global COVID-19 vaccination rollout across 191 countries — while 1.1 billion people started vaccination, only 52.5% completed the full course.
Approach
  • Built clustered bar charts comparing people vaccinated vs fully vaccinated, focused on top-15 nations in Europe to highlight disparities, and filterable country-level Excel Tables.
Results
  • Completion rates varied from 72% in Africa to just 16% in Oceania. Asia led in raw volume (537M) but had only 36.8% completion. Rwanda achieved 100% completion, Algeria reported zero.
Tools
  • Microsoft Excel, Completion Rate Formulas