Udohe/National-Health-Facilities-Overview-

This project presents a comprehensive data analysis and interactive dashboard on the state of health facilities in Nigeria. The goal of this analysis is to move beyond just counting facilities and instead evaluate functionality, distribution, and infrastructure gaps across states and local government areas (LGAs). # National-Health-Facilities-Overview- Project Overview This project presents a comprehensive data analysis and interactive dashboard on the state of health facilities in Nigeria. The goal of this analysis is to move beyond just counting facilities and instead evaluate functionality, distribution, and infrastructure gaps across states and local government areas (LGAs). Using data analytics and visualization techniques, this dashboard provides insights that can support data-driven healthcare planning and resource allocation. Objectives Analyze the total number of health facilities in Nigeria Determine the percentage of functional vs non-functional facilities Identify states with the highest number of facilities Highlight states with the highest number of non-functional facilities Examine LGAs with the highest concentration of facilities Analyze facility types (Primary, Secondary, Tertiary) Reveal regional imbalances in healthcare infrastructure Key Insights 46,000 total health facilities identified nationwide 34,000 functional facilities (74.29%) 12,000 non-functional facilities (25.71%) Primary healthcare centers make up the majority of facilities Some states have high facility counts but also high non-functionality rates Infrastructure is concentrated in certain states and LGAs The analysis shows that infrastructure availability does not always guarantee performance, emphasizing the importance of maintenance, funding, staffing, and effective resource allocation. Tools & Technologies Used Microsoft Power BI – Dashboard creation & data visualization Microsoft Excel – Data cleaning & preprocessing DAX (Data Analysis Expressions) – Calculated measures & KPIs Project Structure Copy code ├── Dataset/ │ └── health_facilities_data.xlsx ├── Dashboard/ │ └── national_health_facilities.pbix ├── Images/ │ └── dashboard_preview.png └── README.md Dashboard Features KPI Cards (Total Facilities, Functional, Non-Functional, % Functional) Monthly Trend Analysis State-Level Co …