globalsmile/Tackling-the-Health-Crises-in-Africa-10Alytics-Hackathon-2022

# Tackling the Health Crises in Africa - 10Alytics Hackathon 2022 --- # Table of Contents - Problem Statement - Data Sourcing - Data Preparation - Data Modeling - Data Visualization and Analysis - Recommendation - Shareable link --- # Problem Statement The lack of access to adequate medical resources and facilities have led to the significant number of deaths. Some of these deaths could have been avoided by timely access to a medical professional or close proximity of hospitals. Health systems across Africa are underfunded and understaffed. Less than half of African citizens (52%) `about 615 million people` have access to the health care they need, the quality of health services across the continent is generally poor, and family planning needs of half the continent’s women and girls are unmet. The main focus is on Africa in this dataset and the purpose of this analysis is to provide solutions to the health challenges, especially in Africa. --- # Data Sourcing The Dataset used for this analysis was provided by 10Alytics and is available at: - 10Alytics hackathon 2022 datasets --- # Data Preparation Data cleaning and transformation was done in Microsoft Excel and the datasets were loaded into Microsoft Power BI Desktop for modeling and visualization. There are six datasets for this project.: - Causes of Deaths: The number of deaths and the causes across different countries from 1990 to 2019 - Number of Deaths by Age Group: Medical Doctors Per 10,000 population: Number of medical doctors per 10,000 medical practitioners in Africa - Medical Doctor Per 10000 Population: Number of medical doctors per 10,000 medical practitioners in Africa - ISO 3166_country-and-continent-codes-list-csv: The list of sovereign states and dependent territories by continent describing the list of countries by continent - World Population: Data from the UN Population Division provides consistent and comparable estimates (and projections) within and across countries over the …