Reduced time for monthly reporting to SIR – Swedish Intensive Care Register – down from a couple weeks to just a few minutes with automated reporting in QlikView
Background
Karolinska University Hospital is one of Scandinavia’s premier health facilities. Together with the world-respected Karolinska Institute, it leads in medical breakthroughs in Sweden.
Supports approximately 1,600 beds with 1.4 million patient visits per year and seven surgeries per hour.
Headquartered in Stockholm, Sweden
Annual budget of $1.5 billion with 15,000 employees
Challenges
- Unable to access and analyze data in ICU Klinisoft system with reports and ad-hoc analysis requests
- Inability to assess type of patients, resources and outcomes
- Prior SIR reporting is quite time consuming with spreadsheets and involving several resources
- Static reports provided no help for the doctors for answering the real life questions needed in the OR / ICU
Solution
- Deployed QlikView to ~ 20 users across 2 functions Care Delivery Analysis: Assess statistics on morbidity rates and success across all areas of operations based on treatments to provide insight to recommended treatments
- Financial Analysis: Develop reports and KPIs for SIR – Swedish Intensive Care Register for monthly regulation reporting
- Rapid implementation in 7 days
- Leveraged QlikView Server to aggregate data from Klinisoft, intensive care planning and medical journal system handling high volumes of data
Benefits
- Reduced time for SIR reporting by 99% down from a couple weeks to just a couple of minutes through an automated trigger
- Provided BI platform for flexible analysis by physicians to analyze and explore data to get answers to ad-hoc queries
- Improved hospital utilization through more efficient resource planning and staffing
- Delivered a common dashboard providing a single version of the truth and instilling confidence in the organization
