04Mar
Corona virus is one pandemic which has and will never leave the entire globe the same. With its first case recorded in 2019, the pandemic went on to take millions of lives around the world.
Exploring through the Nigeria's Covid-19 dataset, it became obvious how these virus affected lives and the Nation, Nigeria.
Below are the exploratory analysis that was done on the datasets (Covid Deaths and Covid Vaccinations) using Microsoft SQL Server Management Studio. Each of the datasets have over 85,000 records.
(1) Querying to get the two datasets:
Result:
(2) Selecting the Covid deaths data to work with
Result
(3) Total Cases vs Total Deaths in Nigeria by Day ( This shows the likelihood of dying)
Result:
(4) Total Cases vs Population in Nigeria (Shows what percentage-population got Covid):
Result:
(5) Country's infection rate compared to population ( Shows what percentage-population got covid)
Result:
(6) Total cases of each country
Result
(7) Showing Countries with Highest Death Count per Population
Result:
(8) Total Deaths by Continent
Result:
(9) Total Population vs Vaccinations (Shows Percentage of Population that has received at least one Covid Vaccine)
Result:
Data Source: Our World in Data
Tool: Excel and Sequel Server Management Studio
Comments
