Healthcare Appointment Dashboard
The Healthcare Appointment Performance Dashboard provides a comprehensive overview of appointment activities, patient demographics, and operational efficiency across the healthcare facility.
Business Problem
Healthcare facilities often manage thousands of patient appointments across multiple departments, making it difficult to monitor attendance, waiting times, departmental workload, and patient demographics from raw data alone. Without a centralized reporting solution, identifying operational inefficiencies and improving patient experience becomes challenging.
Process
Performed Exploratory Data Analysis (EDA), cleaned and prepared the dataset in Power Query to ensure the data was accurate and ready for analysis. I created DAX measures for key business KPIs in a separate table with other measures needed for the dashboard, including Total Patients, Average Waiting Time, Appointment Reminders Sent, and Appointment Reminders Not Sent. I designed two interactive dashboard pages, Performance Overview and Operational Analysis, using appropriate visuals, slicers, and consistent formatting to make the dashboard easy to explore and interpret.
Project Goal
The goal of this dashboard is to provide a centralized view of healthcare appointment performance by monitoring appointment trends, patient attendance, operational efficiency, and demographic patterns. The dashboard enables healthcare managers to identify service bottlenecks, improve scheduling, reduce missed appointments, and make informed decisions using data.