Ajany47/Healthlink_-SDOH_Analytics

A Power BI + Excel project analyzing Social Determinants of Health (SDOH) to address healthcare disparities in The Gambia. # HealthLink SDOH Analytics – Power BI Project **Internship Project | AMDARI Work Experience Program (Healthcare Analytics)** **Project Title:** Leveraging Social Determinants of Health (SDOH) Analytics to Address Healthcare Disparities in The Gambia --- ## 🔍 Overview This project analyzes how demographic, geographic, and social factors impact healthcare outcomes in The Gambia. It aims to support equitable healthcare planning by identifying trends, high-risk populations, and areas in need of intervention. Built using: - ✅ Power BI (Dashboards, KPIs, Geospatial Analysis) - ✅ Power Query in Excel (Cleaning & Modeling) - ✅ Power Automate (Scheduled refresh & alert) --- ## 📁 Project Deliverables - 📄 `HealthLink_SDOH_Report.docx` - 📊 Interactive Dashboard Screenshots - 📈 PBIX (Power BI file) - 🧾 Dataset --- ## 📌 Key Insights - Basse region had the highest hospital admission rate (65.84%) - Low literacy is linked to higher disease prevalence - 34% of respondents reported poor transport access - Women accessed more preventive care than men - Most chronic diseases occurred in ages 18–35 --- ## 🎯 Recommendations - Expand health literacy programs - Improve transport infrastructure - Promote preventive care in low-education regions - Target interventions using dashboard-driven geospatial insights --- ## 🛠 Tools & Technologies | Tool | Purpose | |-------------|-------------------------------| | **Power BI** | Dashboards & Visual Analytics | | **Excel/Power Query** | Data Cleaning & Integration | | **Power Automate** | Scheduled Refresh & Alerts | --- ## 📷 Dashboard Previews --- ## 👤 Author **Olubunmi Adenekan** LinkedIn Profile Portfolio/GitHub --- ## 🔖 Tags `#HealthcareAnalytics` `#PowerBI` `#SDOH` `#AMDARI` `#ExcelAnalytics` `#PowerAutomate` `#PublicHealth`