Olowookere-Abidemi/Malaria-Cases-Analysis-in-Africa-2007-2017-

The analysis highlights significant disparities in malaria burden across regions, with East and West Africa accounting for the majority of cases due to factors such as limited healthcare access and environmental conditions conducive to malaria transmission. # Malaria Cases Analysis in Africa (2007-2017) The analysis highlights significant disparities in malaria burden across regions, with East and West Africa accounting for the majority of cases due to factors such as limited healthcare access and environmental conditions conducive to malaria transmission. ## Introduction Between 2007 and 2017, Africa recorded 588 million malaria cases, with an average incidence rate of 176.01 cases per 1,000 population. The study reveals significant disparities in malaria burden across regions, with East and West Africa accounting for the majority of cases. Factors such as limited healthcare access and environmental conditions conducive to malaria transmission contributed to these trends. Urban populations fared better than rural populations, reflecting disparities in infrastructure and healthcare accessibility. Notable findings include a marked rise in reported cases attributed to improved data reporting mechanisms and localized outbreaks. Key prevention measures, such as anti-malarial drugs and bed nets, positively impacted case numbers, though their distribution remained uneven. The analysis underscores the need for targeted interventions in high-burden regions like East, West, and Central Africa, with a focus on rural areas. --- ## Methodology ### Data Cleaning - Removed irrelevant columns (e.g., "Geometry," "Latitude"). - Replaced blank cells with `0` for consistency. - Grouped countries into regions for granular insights. ### Power BI Tools #### 1. Custom Measures: - **Averages:** Bed net usage, drug usage, and incidence rates. - **Totals:** Cases, rural and urban populations. #### 2. Visualizations: - **Bar Charts:** Regional case distribution. - **Line Charts:** Annual trends. - **Scatter Plots:** Bed net usage effectiveness. - **Pie Charts:** Rural vs. urban population distribution. #### 3. Filters: - Interactive slicers for year, region, and country. --- ## Key Metrics - **Total Cases Reported:** 588 millio …