Data Analytics track work for the AnalystLab Africa Experience Lab — using the HealthConnect Clinic dataset to investigate appointment attendance and no-show patterns.
# healthconnect-experience-lab
Data Analytics track work for the AnalystLab Africa Experience Lab — using the HealthConnect Clinic dataset to investigate appointment attendance and no-show patterns.
## Week 4: HealthConnect Project Kickoff & Problem Understanding
From Week 4,HealthConnect Clinic** —
a fictional healthcare provider looking to use data and AI to reduce missed appointments
and improve patient support.
**My role (Data Analytics Track):** Understand the appointment dataset and identify how it
can be used to investigate appointment attendance and no-show patterns.
**This week I:**
- Reviewed the Data Dictionary and dataset structure (5,000 records, 18 variables)
- Conducted a data quality assessment (missing values, duplicates, value ranges)
- Identified 8 key variables likely relevant to no-show behaviour
- Defined 6 business questions to guide future analysis
- Proposed 5 KPIs, each linked to a business question
- Outlined an initial analysis approach and key assumptions/limitations/risks
**Files:**
-
docs.google.com
-
docs.google.com
**Next up (Week 5):** Begin calculating the proposed KPIs and comparing no-show rates
across the identified variables.