Osi-Chidera-John/Pan-African-Vaccination-Coverage-Analysis-Using-SQL-2021-2023-

Examines regional trends, country performance, healthcare workforce impact, disease-specific vaccinations, and year-over-year growth using a WHO-inspired healthcare dataset. # Vaccination Coverage Analysis Across Africa (2021–2023) ## Introduction Vaccination remains one of the most effective public health interventions for reducing childhood mortality and preventing the spread of infectious diseases. This project explores vaccination coverage trends across African countries and regions between **2021** and **2023** using a synthetic dataset inspired by World Health Organization (WHO) reporting structures. The objective was to identify regional performance patterns, country-level leaders and laggards, vaccination growth trends, healthcare workforce efficiency, and demographic differences in vaccine distribution through advanced SQL analysis. --- ## Background The inspiration for this project came from a clinical posting at Nnamdi Azikiwe University Teaching Hospital during my training as a Medical Laboratory Science student. During the posting, I observed large numbers of mothers waiting in long queues to vaccinate their children. This experience sparked my curiosity about vaccination coverage beyond my local environment and motivated me to investigate immunization trends across Africa. Finding reliable continental vaccination data proved challenging. After extensive searching, I discovered a synthetic dataset on Kaggle designed around WHO vaccination reporting standards. While synthetic, the dataset provided a realistic framework for analyzing vaccination trends, workforce deployment, and regional healthcare performance across African countries. --- ## Project Objectives This project sought to answer the following questions: * Which African regions achieved the highest vaccination coverage? * Which countries were the strongest and weakest performers? * How did vaccination campaigns change year-over-year? * What relationship exists between healthcare workforce size and vaccination outcomes? * How do urban and rural vaccination programs compare? * Which diseases received the highest vaccination attention? --- ## Tools Used …