This project aims at highlighting the influence of COVID-19 vaccination in reducing the mortality rate of COVID-19 in East Africa. Combined and derived metrics were sourced, then cleaned of irrelevant data with MS Excel, while pgAdmin4(PostgreSQL) was used to edit queries for data exploration and data visualization was done with Tableau.
Metrics in the East Africa COVID_19 Vaccinations.xlsx includes:
| Variable | Description |
|---|---|
| Country | Name of East African countries |
| Date | Timeline of total cases |
| Total Cases | Daily amount of total cases |
| People_fully_vaccinated | Total number of people fully vaccinated |
| People_vaccinated_atleastonce | Total number of people vaccinated atleast once |
| Country | Name of African countries |
| Total Cases | Total number of Covid-19 cases |
| Total Deaths | Total number of deaths |
| Total Recovered | Total number of recovered cases |
| Active Cases | Total number of active cases |
| Total Cases_per_1Mpop | Total cases per 1 million of the population |
| Deaths_per_1Mpop | Total deaths per 1 million of the population |
| Total Tests | Total number of Covid tests done |
| Tests_per_1Mpop | Covid tests done per 1 million of the population |
| Population | Population of the country |
Variables - People_fully_vaccinated and People_vaccinated_atleastonce were derived with PostgreSQL:
derived_vaccination.sql
Data cleaning tool: MS Excel
Query editing tool: PostgreSQL(pgAdmin4)
Data visualization tool: Tableau Public. https://public.tableau.com/app/profile/angela.ashley.osuzoka/viz/COVID-19VaccinationimpactinEastAfrica/COVID-19VaccinationimpactinEastAfrica?publish=yes