More
Сhoose
Role: Business Analyst
Tools: SQL, Power BI, Excel
Category: Process Optimization
Case Study Overview
Optimizing patient intake procedures and resource utilization across multiple clinical departments at a regional medical center.
Problem Statement
Evaluate clinical queues to reduce patient waiting times, standardize triage, and streamline shift staffing.
Analytical Focus
Designing SQL queries to pull patient timestamps, clean admission logs, and identify bottlenecks in patient workflows.
The Analytical Approach
After facilitating workshops with clinical managers to map patient intake processes, I modeled data queries to trace elapsed times between registration, triage, and physician visits.
The compiled reports were developed into an interactive Power BI dashboard, highlighting department bottlenecks and physician availability in real time.
Results & Business Value
Key Metric Improvement
14% Decrease in Patient Waiting Times
- Standardized the patient registration forms, reducing paperwork delays.
- Reallocated staffing schedules during peak admission hours (4 PM – 8 PM).
- Enabled departmental heads to predict bed shortages 24 hours in advance.