Skip to content

Latest commit

 

History

History
131 lines (102 loc) · 4.72 KB

Documentation.md

File metadata and controls

131 lines (102 loc) · 4.72 KB

Maternal Healthcare Data Analysis & Insights

1. Introduction

Project Name: Maternal Healthcare Data Analysis & Insights

Objective:

To analyze maternal healthcare data using SQL and Excel to identify key insights that can help improve healthcare services and reduce maternal mortality rates.

SDG Alignment:

This project aligns with UN Sustainable Development Goal 3 (Good Health & Well-being), focusing on reducing maternal mortality and improving healthcare accessibility.

2. Problem Statement

Maternal healthcare faces significant challenges such as:

  • High maternal mortality rates in specific regions.
  • Limited access to quality healthcare facilities.
  • Lack of data-driven decision-making in healthcare planning.

The goal of this project is to leverage data analytics to provide actionable insights for healthcare improvement.

3. Data-Driven Approach

Why Data is Key?

  • Helps in identifying high-risk regions.
  • Supports resource allocation.
  • Aids in evidence-based policymaking.

Data Sources:

  • Patients Table: Contains patient demographics.
  • Maternal Visits Table: Logs visits to health facilities.
  • Outcomes Table: Records delivery success and complications.
  • Health Facilities Table: Stores details of medical centers.
  • Doctors Table: Includes doctor information and specialization.

4. Database Design (ERD)

Entity-Relationship Diagram (ERD)

The following entities and relationships define the database structure:

  • Patients (PK: patient_id) has one-to-many relationship with Maternal Visits.
  • Maternal Visits (PK: visit_id, FK: patient_id, FK: facility_id) connects patients to healthcare facilities.
  • Outcomes (PK: outcome_id, FK: patient_id) stores delivery success and complications.
  • Facilities (PK: facility_id, FK: location_id) represent hospitals and clinics.
  • Doctors (PK: doctor_id, FK: facility_id) link specialists to medical centers.

5. SQL Queries & Insights

Sample Queries Used:

  • Number of Maternal Visits per Facility: 
    SELECT facility_id, COUNT(*) AS total_visits
FROM MaternalVisits
GROUP BY facility_id;
  • Facilities with Highest Maternal Mortality: 
    SELECT facility_id, COUNT(*) AS maternal_deaths
FROM Outcomes
WHERE mother_survived = FALSE
GROUP BY facility_id
ORDER BY maternal_deaths DESC;
  • Common Maternal Health Complications: 
    SELECT complications, COUNT(*) AS occurrence
FROM Outcomes
GROUP BY complications
ORDER BY occurrence DESC;

6. Excel Dashboard Development

Pivot Tables & Charts Created:

  1. Number of Visits per Facility (Pivot Table)
  2. Bar Chart of Maternal Deaths per Facility
  3. Heatmap for Healthcare Access across Regions

Interactive Dashboard Elements:

  • Slicers for Filtering Data (Facility Name, Region)
  • Key Insights Displayed:
    • Number of antenatal visits per county.
    • Facilities with the highest maternal mortality.
    • Breakdown of maternal health complications.

7. Findings & Recommendations

Key Insights:

  • Certain facilities have significantly higher maternal mortality rates.
  • Some regions have fewer healthcare visits, indicating lack of access.
  • Most common complications include hemorrhage and infections.

Recommendations:

  1. Increase healthcare access in high-risk regions.
  2. Improve emergency response and maternal care.
  3. Enhance training for doctors in critical areas.

8. Challenges Faced

  • Incomplete Data: Some patient records were missing.
  • Data Formatting Issues: SQL to CSV export required adjustments.
  • Integration Difficulties: Linking SQL queries with Excel dashboard.

9. Future Work

  • Machine Learning for Predicting High-Risk Pregnancies.
  • Developing a Mobile App for Maternal Health Tracking.
  • Enhancing Real-time Data Collection from Healthcare Facilities.

10. Conclusion

This project demonstrates how data analytics can be leveraged to improve maternal healthcare outcomes. By identifying high-risk areas and optimizing resource allocation, we can work towards reducing maternal mortality and ensuring better healthcare services.

Final Steps:

  • Presentation Ready: A PowerPoint summary accompanies this document.
  • Excel Dashboard: Includes interactive charts for insights.
  • Pitch Deck Presentation: View Here

Thank You!

For further details, feel free to reach out.