mouli005-star/ghana-healthcare-intelligence

AI-powered IDP agent for Ghana healthcare facility analysis — Databricks × Accenture Hackathon 2026 # 🏥 Ghana Healthcare Intelligence System **Databricks × Accenture Hackathon 2026 | Virtue Foundation Track** --- ## 🎯 Problem Statement By 2030, the world faces a shortage of over 10 million healthcare workers. In Ghana, 797 healthcare facilities exist across 16 regions — but distribution is critically uneven. Patients in Upper East, Savannah, and North East regions have zero access to surgery, ICU, or emergency care within their region. The Virtue Foundation needed an intelligent system to: - Identify WHERE the gaps are - Understand WHAT capabilities are missing - Recommend WHERE to deploy limited medical resources --- ## 💡 Our Solution An end-to-end **Intelligent Document Parsing (IDP) Agent** built on Databricks that extracts, enriches, and analyzes Ghana's healthcare facility data using AI to surface actionable medical desert intelligence. --- ## 🏗️ Architecture --- ## 📊 Key Results | Metric | Value | |--------|-------| | Total facilities analyzed | 797 | | Facilities with procedures (before IDP) | 183 | | Facilities with procedures (after IDP) | 260 | | Medical desert regions identified | 6+ critical | | Anomalies detected by AI | 55 | | Average AI confidence score | 0.72 | | Regions with NO surgery capability | 6 | | Regions with NO ICU | 10+ | --- ## 🔴 Critical Findings - **Upper East, Savannah, North East** — no surgery, no ICU, no blood bank - **North East Region** — MDI score of 0.15 (lowest in Ghana) - **55 facilities** flagged with suspicious capability claims - **Greater Accra** has 42 facilities clustered in 27km radius while rural areas remain unserved --- ## 🛠️ Tech Stack | Layer | Technology | |-------|-----------| | Data Platform | Databricks (Delta Lake, Notebooks, SQL Dashboards) | | AI Extraction | OpenAI GPT-4o | | Architecture | Medallion (Bronze → Silver → Gold) | | Geospatial | Geopy, Folium, Haversine | | Orchestration | PySpark + Pandas | | Visualization | Databricks SQL Dashboards, Folium Maps | | Planning UI | ipywidg …