rachelbirma-jpg/AnalystLab-Week4-HealthConnect-Analysis

Week 4 HealthConnect Clinic data analysis project for the AnalystLab Africa Internship. # AnalystLab Week 4 – HealthConnect Analysis ## Project Overview This project is part of my Week 4 Data Analytics assignment for the AnalystLab Africa Internship Programme. The task focuses on understanding the HealthConnect Clinic appointment dataset, assessing its initial data quality, identifying important variables related to appointment attendance and no-shows, developing relevant business questions, and proposing potential KPIs for further analysis. ## Dataset The dataset contains: - 5,000 appointment records - 18 variables - Appointment outcomes: Attended, Cancelled, and No-Show ## Week 4 Activities - Reviewed the dataset structure and data dictionary - Conducted an initial data quality assessment - Identified variables relevant to attendance and no-shows - Developed five business questions - Proposed five potential KPIs - Documented the initial analysis approach and limitations ## Files in this Repository - AnalystLab Week4 Project Summary.pdf - HealthConnect Week4 Data Quality Assessment - PDF.pdf - HealthConnect_Appointment_Data.xlsx - HealthConnect_Week4_Initial_Analysis_Rachel_Nuhu.pdf ## Tools Used - Microsoft Excel - Microsoft Word ## Author Rachel Nuhu Birma Data Analytics Intern – AnalystLab Africa