iamannieluv2288/MALARIA-IN-AFRICA-FROM-2007---2017

This project analyzes the incidence, treatment, and prevention of malaria across Africa from 2007 to 2017. The insights focus on key metrics such as reported malaria cases, treatment coverage, and rural population demographics. This analysis provides insights into malaria cases across 54 African countries over a ten-year period, focusing on trends, demographic distributions, and healthcare interventions. The findings from this dashboard offer valuable insights for healthcare organizations, policymakers, and international bodies to strategize disease prevention and resource allocation. METHODS USED: 1.Data Collection and Cleaning: · The raw dataset likely included malaria case statistics, population demographics, and healthcare services by country over the specified period. · Data cleaning techniques 2.Data Aggregation: · Summation and averages were calculated for variables like malaria incidence, reported cases, rural/urban population, and healthcare interventions. · Grouping data by year, country, and category (e.g., rural population) helped create detailed trends and comparisons. 3.Visual Design: · Key performance indicators (KPIs) were created for high-level summaries (e.g., total countries analyzed, average malaria cases reported). · Chart types such as line graphs, bar charts, and donut charts were used to visualize trends, distributions, and proportions effectively. 4.Insights Derivation: Trends in malaria cases, rural/urban population distributions, and healthcare interventions were analyzed to identify high-risk countries and areas requiring focus. TOOLS USED: 1.Power BI: · Utilized for data visualization and interactive dashboard design. · KPIs were leveraged to make the dashboard dynamic and informative. KEY INSIGHTS: 1.Total number of 54 African countries are included in the analysis. 2.This analysis showed that there is an average of 190.09 Incidence of Malaria per country in the African countries considered. 3.This analysis recorded a total Reported Malaria Cases of 1.07 million across all countries. 4. Population Context: Average Rural Population is 56.84% of the population and Average Urba …