Data Exploration:
Two years of COVID

Project Overview

Objectives

The goal is to build a report that shows summarized information about the deaths, cases and vaccinations corresponding to the period of 2020-2021 to understand how the pandemic is currently developing in the world.

Data Preparation

Importing Data

Data sourced from Our World in Data. The process involved extracting data from CSVs, importing into SQL Server, executing queries, and visualizing results in Tableau.

Asking the Questions (SQL)

SELECT 
    MAX(total_cases) AS TotalCases, 
    MAX(total_deaths) AS TotalDeaths, 
    (MAX(total_deaths)/MAX(total_cases)*100) AS DeathPct 
FROM clean_owid_covid;

SELECT 
    MAX(population) AS WorldPop, 
    MAX(people_fully_vaccinated) AS Vaccinated, 
    MAX(people_fully_vaccinated)/MAX(population)*100 AS VaccPct
FROM clean_owid_covid;

SELECT date, MAX(new_cases) AS NewCases 
FROM clean_owid_covid 
GROUP BY date 
ORDER BY date;

SELECT location, MAX(total_deaths) AS TotalDeaths 
FROM clean_owid_covid
WHERE continent IS NOT NULL
GROUP BY location
ORDER BY TotalDeaths DESC
LIMIT 5;

SELECT location, 
    MAX(people_fully_vaccinated) AS PeopleFullyVax,
    MAX(people_fully_vaccinated)/MAX(population)*100 AS PctFullyVax
FROM clean_owid_covid
WHERE continent IS NOT NULL
GROUP BY location
ORDER BY PeopleFullyVax DESC;

Results (Dashboard)

Conclusions