Leveraging QlikView to monitor and optimize bed usage and utilization with staffing and patient scheduling to ensure the delivery of quality patient care and safety.
Background
Leading hospital providing elective and emergency healthcare, primarily to the inhabitants of northern and northwestern metropolitan Stockholm supporting roughly 250,000 appointments and 30,000 treatments
Located in Stockholm, Sweden
Working with ~$300 million in budget with 3,000 employees
Challenges
- Gain visibility on utilization of beds and patient scheduling to optimize existing resources
- Unlock value of data trapped across systems with operation planning, medical journals and administrative systems
Solution
- Deployed QlikView to ~ 35 users in physician and administrative personnel across 2 functions in Sweden:
- Care Delivery Analysis: Track patient history, treatments, duration of stay, cost, and clinical outcome
- Resource Planning Analysis: Assess utilization of beds and operating rooms for actuals versus planned; Identify and remove bottlenecks to increase availability and capacity;
- Optimize patient scheduling and staffing to maximize resources; Produce data to justify need for additional resources in beds and staffing
- Rapid implementation in only a few weeks
- Leveraged QlikView to aggregate data across multiple systems including bed usage system, medical journal with Siemens Melior, and operations planning with Orbit.
Benefits
- Optimized utilization of beds with improved logistics in patient scheduling, staffing, and bed availability
- Improved data analysis on diagnosis, treatments and outcome analysis by case, procedure, and physician
- Provided system to monitor utilization levels to justify need for additional resources with beds and staff to maintain high levels of quality in patient care and safety
