Coco-ash12/COVID-19-Vaccination-impact-in-East-Africa-Countries

This project aims at highlighting the influence of COVID-19 vaccination in reducing the infection rate and mortality rate of COVID-19 in East Africa. # COVID-19-Vaccination-impact-in-East-Africa-Countries 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.** *public.tableau.com