RawJenny/AMCA

Analysis of Malaria Cases in Africa (2007–2017) # AMCA Analysis of Malaria Cases in Africa (2007–2017) This project analyzes malaria cases reported across 54 African countries from 2007 to 2017. The aim is to evaluate incidence trends, healthcare responses (such as drug distribution and preventive treatment in pregnancy), and regional differences in sanitation and population profiles. Problem Being Addressed: Malaria remains a major public health challenge in Africa. The analysis aims to uncover insights into which countries are most affected, identify gaps in sanitation and healthcare delivery, and support strategic planning for malaria reduction. Key Datasets and Methodologies: The analysis was conducted in Power BI using card visuals, bar charts, pie charts, and line graphs. Data sources included country-level malaria reports, sanitation records, and population demographics (urban and rural). 3. Story of Data Data Source: The dataset was likely sourced from public health repositories such as WHO, UNICEF, and national health systems in Africa. Data Collection Process: Data was collected and aggregated at the country level annually, covering both disease metrics and public health infrastructure indicators. Data Structure: • Rows: Country-year entries • Columns: Malaria cases, incidence rate, antimalarial drug distribution, rural/urban population, safe sanitation access, and preventive treatments in pregnancy. Important Features and Their Significance: • Malaria Incidence & Cases: Core metrics to evaluate disease burden • Safe Sanitation: Indirect measure of environmental health • Preventive Treatments & Antimalarial Drugs: Indicators of public health response • Population Demographics: Help contextualize exposure and risk Data Limitations or Biases: • Urban/rural ratios may be based on estimates. • Countries with low reporting infrastructure may underrepresent actual malaria burden. 4. Data Splitting and Preprocessing Data Cleaning: Data was normalized for visualization, and all numeric fields were converted t …