An end-to-end healthcare analytics solution was designed using Excel-generated sample data, Microsoft SQL Server, and Tableau. Operational data was modeled, validated with SQL, and transformed into executive dashboards for KPI monitoring, trend analysis, and executive decision support.

The solution provides leadership with a centralized view of Emergency Department patient flow, staffing efficiency, throughput, operational trends, and patient experience metrics.

Morning arrival surges increased provider demand and contributed to longer door-to-provider times.

Higher patient volumes aligned with increased Left Without Being Seen (LWBS) rates, highlighting opportunities to improve staffing alignment and patient flow.

These findings indicate that demand patterns, staffing alignment, triage workflow, and patient throughput should be evaluated together when addressing Emergency Department performance.

Successful implementation of these recommendations is expected to improve Emergency Department throughput, reduce patient wait times, optimize provider utilization, decrease LWBS rates, enhance patient satisfaction, and strengthen executive decision-making through continuous KPI monitoring.

Aligning staffing and triage workflows with demand patterns can improve patient flow and reduce operational bottlenecks, while standardized performance reviews provide leadership with a consistent mechanism for monitoring progress.

This project demonstrates an end-to-end healthcare analytics and performance improvement methodology—from defining the business challenge and developing a relational SQL database to creating executive dashboards, identifying root causes, developing strategic recommendations, designing an implementation roadmap, and establishing ongoing performance monitoring.

The project demonstrates how operational healthcare data can be translated into actionable insights that support better Emergency Department performance, patient flow, and patient-centered care.