Skip to content

bilalnaqvi7/Covid-19-Analysis-Python-Tableau

Repository files navigation

🦠 COVID-19 Analysis (Python EDA + Tableau Dashboard)

An end-to-end analytics project combining Python-based Exploratory Data Analysis (EDA) with an interactive Tableau dashboard to track global + India COVID-19 spread, compare severity, and visualize country-wise impact.


📌 Overview

This project analyzes COVID-19 case and vaccination data to generate actionable insights through:

  • Python EDA for cleaning, structuring, and trend exploration
  • Tableau dashboards for interactive, decision-ready visual storytelling

🎯 Key Dashboard Insights

  • Top 10 Confirmed Countries (ranking by total confirmed cases)
  • Global Cases Map (geographic spread visualization)
  • Top 10 Deaths (Treemap) (high-mortality countries)
  • Top 10 Recoveries (Bubble Chart) (recovery comparison across countries)
  • Confirmed vs Deaths (Scatter Plot) (severity vs volume relationship)

🔥 Impact (Impact via Action)

  • Impact via data cleaning | transformed raw case + vaccine datasets into analysis-ready tables | improved reliability of insights
  • Impact via EDA | analyzed country-wise confirmed/deaths/recoveries trends | identified high-burden regions faster
  • Impact via dashboarding | built Tableau visuals (map, treemap, scatter, ranking charts) | enabled quick comparison across countries
  • Impact via severity mapping | plotted confirmed vs deaths to highlight risk clusters | simplified prioritization for monitoring

🧰 Tech Stack

  • Python (EDA)
  • Tableau (Dashboarding + Visualization)
  • Data Cleaning + Formatting
  • Univariate/Bivariate Analysis
  • CSV Processing

📂 Repository Contents

  • Covid 19 Analysis.ipynb — Python EDA notebook
  • Covid 19 Analysis.twb — Tableau workbook
  • Covid 19 Analysis Dashboard.pdf — Dashboard export
  • covid_19_india.csv — India COVID dataset
  • covid_vaccine_statewise.csv — Vaccination dataset

🚀 How to Run

  1. Open Covid 19 Analysis.ipynb and run the notebook to reproduce EDA outputs
  2. Open Covid 19 Analysis.twb in Tableau and refresh data sources
  3. View Covid 19 Analysis Dashboard.pdf for the final dashboard snapshot

📩 Output

A clean Tableau dashboard delivering:

  • Global COVID snapshot
  • Top 10 country rankings (confirmed/deaths/recoveries)
  • Confirmed vs deaths severity mapping
  • Geographic spread visualization

About

Performed exploratory data analysis on Covid-19 dataset on parameters like global cases, deaths, recoveries, etc in Jupyter notebook via Python libraries like Pandas and Seaborn. Built a dashboard visualising the findings on Tableau desktop.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors