NehemiahJay/Nigeria-Health-Facility-analysis

Analysis containing all the 37 states in Nigeria # Nigeria Health Facility Access & Coverage Analysis **Tool:** Excel · **Type:** Data Cleaning, PivotTables, Dashboard Design **Author:** Nehemiah — LinkedIn · Notion Portfolio **Repo:** github.com --- ## Overview This project analyzes Nigeria's national health facility registry to answer: > **Where is healthcare facility capacity concentrated vs. thin, by state and tier — and how much of the network has unverified operational status?** Built for a **Health System Operations / Planning Manager** audience — the goal was to move beyond "here's a chart of the data" into a set of findings a planner could actually act on. --- ## Data Sources - **Nigeria Health Facilities Registry** — Humanitarian Data Exchange (HDX) 46,146 facility records → cleaned to 45,748 · 36 states + FCT - **State population estimates** — National Bureau of Statistics (NBS), in collaboration with the National Population Commission (NPC), used for the per-capita facility analysis **Data vintage note:** facility records carry survey timestamps ranging from **December 2018 to July 2020**. All findings reflect facility status as of that survey window, not real-time conditions — stated upfront rather than buried in a limitations section. --- ## What's in This Repo | File | Description | |---|---| | `analysis_on_nigeria_health_facilities.xlsx` | Full workbook — README, Decision Log, raw data, cleaned data, PivotTables, dashboards, Insights, Recommendations | The workbook is organized as: - **README** — project overview and navigation (this document, in sheet form) - **Decision Log** — every data-quality issue found and how it was handled, with rationale - **Raw Data** — unmodified source data, as downloaded - **Cleaned Dataset** — analysis-ready data (45,748 rows) - **Pivot Tables** — native PivotTables answering each research question - **Helper Sheet** — supporting tables for charts not directly compatible with PivotTables - **Dashboar …