Clinic Patient Appointment Analysis

Clinic Patient Appointment Analysis Dashboard | PowerBI and Microsoft Excel

• Data: Analyzed over 110.5k patient appointments from an Atlanta-based clinic
• Insights: Found 20% no-show rate, 60% mis-scheduled appointments, and 98% received no SMS notifications. Recommended reminder system, proper scheduling, and pickup/drop-off for disabled patients.
• Skills: Data Transformation, Analysis, Processing, Cleaning, and Visualization.

Analysis of patient appointment data from an Atlanta based clinic that struggles with high rate of no-show appointments, where patients with similar demographics fail to make their appointments. The goal of this analysis was to find trends in patient appointment data to identify reasons for patient no-show at appointments. Based on this summary, recommendations are made to target these most significant factors noticed from the patient appointment data analysis.