Skip to content

PrathaJain02/covid-data-analysis-sql-tableau

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

5 Commits
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

πŸ“Š COVID Data Analysis (SQL + Tableau)

🎯 Project Objective

Analyze global COVID-19 data using SQL to uncover trends in cases, deaths, and vaccinations, and visualize insights using Tableau.


πŸ›  Tools Used

  • SQL (Data Analysis & Aggregation)
  • Tableau (Data Visualization)
  • Excel / CSV Data

πŸ“‚ Project Workflow

  1. Data exploration and cleaning using SQL
  2. Calculation of infection rate, death percentage, and vaccination trends
  3. Use of CTEs, Window Functions, Temp Tables, and Views
  4. Dashboard creation in Tableau

πŸ”Ž Key SQL Analysis Performed

  • Total cases vs total deaths
  • Infection rate per population
  • Highest death count by country & continent
  • Global COVID metrics
  • Rolling vaccination analysis using window functions

πŸ“· Dashboard Preview

Dashboard Preview


πŸ’Ό Business / Analytical Impact

This project demonstrates how SQL analysis can be used to transform raw health data into insights that support trend analysis and decision-making.

🌐 Live Tableau Dashboard

View Dashboard on Tableau Public

About

SQL data analysis and Tableau dashboard for global COVID trends and vaccination insights.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors