Princewill-Data-Labs/Malaria-Trends-Healthcare-Access-in-Nigeria
Domaine:
healthcareCréateur:
Pri
Hôte:
An interactive Microsoft Excel dashboard analyzing malaria trends and healthcare accessibility in Nigeria (2021–2025).
# 🦟 Malaria Trends and Healthcare Access in Nigeria (2021–2025)
---
# Table of Contents
- Project Overview
- Background
- Problem Statement
- Project Objectives
- Dataset Description
- Dataset Structure
- Data Dictionary
- Data Preparation
- Data Cleaning Process
- Exploratory Data Analysis (EDA)
- Dashboard Development
- Dashboard Components
- Key Performance Indicators (KPIs)
- Dashboard Insights
- Trend Analysis
- Challenges Identified
- Recommendations
- Tools & Techniques Used
- Project Deliverables
- Conclusion
- Author
---
# Project Overview
Malaria remains one of Nigeria's most pressing public health challenges, contributing significantly to illness, mortality, and increasing pressure on healthcare infrastructure. Despite various intervention programs, the disease continues to affect millions annually due to environmental conditions, seasonal transmission, inadequate healthcare accessibility, and socio-economic factors.
This project presents an interactive Microsoft Excel dashboard developed to analyze malaria trends and healthcare accessibility across selected Nigerian states between **2021 and 2025**.
The dashboard transforms raw healthcare data into meaningful visual insights that enable healthcare professionals, policymakers, NGOs, and researchers to identify disease patterns, evaluate healthcare access, and support evidence-based decision-making.
---
# Background
Nigeria records one of the highest malaria burdens globally. Understanding the relationship between malaria prevalence, healthcare availability, population distribution, and seasonal rainfall is critical for improving healthcare planning and disease prevention.
This dashboard was developed to simplify complex healthcare data into interactive visualizations that support strategic decision-making.
---
# Problem Statement
Although several malaria intervention programs have been implemented across Nigeria, the country continues to experience high infection rates and preventable …