wkofi/Ghana-health-facilities-dashboard

: A Power BI dashboard visualizing access to health facilities across Ghana using data from Datanix (Kaggle). # Access to Ghana Health Facilities Dashboard ### Overview This interactive Power BI project visualizes **access to healthcare facilities across Ghana**, helping to identify regional disparities and facility distribution patterns. The dashboard explores facility types, locations, and accessibility across all regions offering insights useful for policymakers, researchers, and data enthusiasts. ### Tools & Technologies - **Microsoft Excel** → Data cleaning and preprocessing - **SQL** → Data analysis and structuring - **Power BI** → Dashboard design, modeling, and visualization ### Dataset Source Data obtained from Datanix Blog and adapted from a **Kaggle open dataset** on Ghana’s health facilities. ### Dashboard Features The dashboard consists of **3 interactive pages**: 1. **Overview Page** Visual breakdown of facility distribution by region and facility type. 2. **Map View** — Geospatial visualization of facility locations using latitude and longitude. 3. **Key Insights / Summary** Automated narratives and interpretations highlighting major findings. ### Key Insights - **Ashanti Region** has the highest number of health facilities. - **Clinics** account for a significant share of total facilities across Ghana. - The **three northern regions** show below-average access compared to the national average. ### Skills Demonstrated - Data Cleaning & Transformation (Excel) - SQL Querying for Data Structuring - Power BI Data Modeling - Dashboard Storytelling & Narrative Visualization - Geospatial Analysis (Map Visuals) ### Access the Dashboard You can explore or download the interactive `.pbix` file to view the live visuals: Download Dashboard.pbix > *(Ensure Power BI Desktop is installed to open the file.)* ### Author **Wisdom Amankwah** Data Analyst linkedin.com ### How to Support If you found this project insightful, consider: - Starring ⭐ this repository - Sharing feedback or suggestions - Connecting with me on LinkedI …