We start off with a broad view of all the data available to us. After this, we
select all the relevant data that we will begin exploring, in this instance we
are interested in location, date, total_cases, new_cases, new_deaths and
population
Utilising SQL we then begin investigating queries of interest, this includes the
following:
-Looking at total cases vs total deaths
-Looking at total cases vs population , converting these figures into
percentages and aliasing new columns for clarity
-Looking at countries with the highest infection rate versus the population
-showing the countries with the highest death count per population
And many other exploratory analysis queries.
By joining the data of covid deaths and covid vaccinations we are able to
compare sets of data for further analysis such as correlations or exploring
highest total vaccinations by country using a descending order function.
Finally, by creating View tables we are able to prepare tables of data, ready
for visualisation in tools such as PowerBI or Tableau