Apetbally/nigeria-malaria-incidence-analysis

Analysis of 25 years of malaria incidence data across Nigeria using Excel, SQL, and Power BI Nigeria Malaria Incidence Analysis (2000–2024) An end-to-end data analytics project examining 25 years of monthly malaria surveillance data across 8 Nigerian states, covering data cleaning, exploratory analysis, and an interactive Power BI dashboard. Demo Video watch the full walkthrough here: Project Demo Video Project Objective Analyze malaria incidence data to identify trends, seasonal patterns, and geographic variations across Nigeria, and translate those findings into data-driven recommendations for malaria prevention and control. Dataset Source: Nigeria Monthly Malaria Data (2000–2024) Size: 2,400 rows × 9 original columns Coverage: 8 states across all 6 geopolitical zones — Kano, Kaduna, Borno, Kwara, Lagos, Ogun, Rivers, Enugu Granularity: Monthly, Jan 2000 – Dec 2024 Key fields: Confirmed Cases, Malaria Deaths, Malaria Incidence per 1,000, State, Region, Date Tools & Workflow Stage Tool Data cleaning & feature engineering Excel Exploratory Data Analysis MySQL Dashboard development Power BI 1. Excel — Cleaning & Feature Engineering Verified data integrity (no missing values or duplicates found) Engineered three new columns: Season (Rainy: Apr–Oct / Dry: Nov–Mar) Mortality Rate (%) = Deaths / Confirmed Cases × 100 Quarter Validated findings with pivot tables before moving to SQL 2. MySQL — Exploratory Data Analysis Queried the cleaned dataset to answer each analysis objective: Yearly national trends (incidence & mortality) Monthly/seasonal case distribution State and regional burden ranking (raw totals vs. per-capita rate) Five-year window comparison (2000–04 vs 2020–24) per state Quarterly aggregation See sql/eda_queries.sql for the full set of queries. 3. Power BI — Interactive Dashboard A 4-page report: Overview — national KPIs and 25-year trend lines (incidence & mortality) Seasonal & Geographic Patterns — monthly/quarterly seasonality and state comparisons State Deep Dive — interactive single-state trend vs. national average, with slicer-drive …