/Covid-Data-Exploration-SQL

This project involved querying and ordering COVID-19 data at a global and regional level, focusing on cases, deaths, and percentages. Additionally, I integrated COVID-19 cases data with vaccination records, calculating total vaccinations, population percentages, and creating temporary tables and views for visualization.

Comprehensive COVID-19 Data Analysis and Visualization

Project Description:

This project represented a multifaceted exploration of COVID-19 data, with the aim of providing a deeper understanding of the pandemic's global and regional dynamics.

Scope:

The project encompassed a detailed analysis of COVID-19 data, with a focus on both global and regional aspects of the pandemic. Additionally, The second phase of the project involved integrating COVID-19 cases data with vaccination records to assess the progress of vaccination efforts in different regions.

Tasks:

  • counties with highest infection rate wrt population counties with highest infection rate wrt population

  • counties with maximum death count counties with maximum death count

  • continents with maximum death count continents with maximum death count

  • for whole world whole world

  • total vaccinations total vaccinations

  • coomon table expression coomon table expression

  • temporary table temp table

  • creating a view view

Insights and Trends:

The analysis aimed to uncover trends and insights into the impact of the pandemic on various regions and continents, providing a more nuanced understanding of the crisis.

This comprehensive analysis and visualization project contributed to informed decision-making in the context of public health, providing a deeper understanding of the pandemic's impact and vaccination progress. It underscored my proficiency in handling intricate data analysis tasks and refining my data engineering and visualization skills.