Okeowigs/COVID-19-Trends-and-Impact-in-Africa-January-2020-August-2021-

Africa’s COVID-19 data was analyzed to uncover pandemic trends, highlight regional disparities, and provide national, regional, and continental recommendations that strengthen preparedness and improve future public health responses across the continent. COVID-19 Trends and Impact in Africa (January 2020 – August 2021) Project Summary This project analyzes the spread, severity, and health outcomes of the COVID-19 pandemic across Africa from January 2020 to August 2021. Using confirmed cases, recoveries, and deaths recorded during the period, the study identifies trends, evaluates regional performance, and highlights disparities that shaped the pandemic's impact on African populations. Problem Statement The COVID-19 pandemic affected countries globally, but its progression in Africa followed a unique pattern influenced by testing capacity, healthcare infrastructure, demographics, and intervention strategies. Limited early surveillance and inconsistent reporting hindered timely response. There was a critical need to derive insights from available data to strengthen preparedness and improve health outcomes across the continent. Project Objectives 1. Examine the timeline and progression of COVID-19 cases across Africa. 2. Identify countries and regions with the highest burden of infections and deaths. 3. Assess recovery and mortality outcomes geographically. 4. Draw insights on the effectiveness of national and regional response mechanisms. 5. Provide evidence-based recommendations for improving pandemic readiness. Industry Type Healthcare and Public Health Surveillance Stakeholders • Africa CDC • WHO Regional Office for Africa • Ministries of Health • Researchers and Epidemiologists • International Development Partners (UN, World Bank, NGOs) • Media and General Public Definition of Success Reduction in COVID-19 morbidity and mortality remains the ultimate indicator of public health success. Methodology The analysis was conducted using Microsoft Excel as part of my learning experience at Vephla University. The following approach was applied: • Data Cleaning and Structuring using Power Query Editor • Transformations: Formatting date fields, removing duplicates, validating region/country entries • Data Analysis …