“These are intuitive decisions we might have made otherwise, but now they have been backed up by irrefutable data. It's not a problem for our surgeons or anesthesiologists to accept this as the data we need to act on.”

Kathleen Brooks, Administrative Director for Perioperative Services Bassett Healthcare

Benefits• Improved process to drive on-time case starts from 48% to 85%• Increased charge capture by 30%• Increased surgical throughput with streamlined processes• Green lighted the opening of a dedicated trauma room and fully staffed a

surgical department at the underutilized rural facility• Gained the freedom to analyze data without the need for IT

About Bassett Healthcare• Regional health system of four hospitals and 23 community

health centers serving residents of an eight-county region in central New York, USA. The centerpiece of Bassett Healthcare is The Mary Imogene Bassett Hospital, an 180-bed acute care, inpatient teaching facility. Supports 7 operating rooms and conducts roughly 7,000 surgeries per year

• Headquartered in Cooperstown, New York• Achieved ~ $300 million in revenue with 3,500 employees• Industry: Healthcare

Challenges• Improve quality patient care through operational improvements

to address inefficient manual processes and bottlenecks• Gain insight into utilization and performance of surgical rooms

to increase coverage, on-time starts and surgeon satisfaction

Solution• Deployed to ~15 users across 5 functions in US:

Executive Analysis: Develop MIS system and balanced scorecard in next wave for insight across organizationClinical Operations Analysis: Measure day-to-day surgical department operations. Measure surgical benchmarks, such as type of cases, number of cases by surgeon, after-hours cases, and turnaround timeResource Planning Analysis: Monitor utilization of surgical departments in main hospital and rural facilities to ensure staffing and availabilityFinancial Analysis: Monitor utilization of surgery rooms on a rolling 3 month basis by CFO to assess future cash flowQuality Assurance Analysis: Assess historical data to gauge whether hospital had enough trauma-related orthopedics cases each day to warrant a dedicated operating room

• Rapid implementation in just days with pre-built views with SIS Analytics powered by QlikView

• Leveraged SIS Analytics (QlikView) to integrate data across the primary systems for finance, materials and clinical

QlikView Customer Snapshot – Bassett Healthcare

QlikView Customer Snapshot – Blekinge Hospital

Benefits• Delivered annual budget surplus by tracking financial indicators• Reduced medical costs by 5% or $1.1 million by analyzing prescription patterns

• Increased caregiver availability with shortened patient waiting times by monitoring inflow/outflow patterns – finding bottlenecks

• Improved treatment by analyzing survival expectancy data

• Streamlined regulatory-compliance reporting processes

About Blekinge Hospital• Among leading healthcare providers in Sweden serving the

150,000 inhabitants of Blekinge County in southern Sweden• Supports more than 500,000 patient visits per year• Approximately $500 million in budget with 5,000 employees• Industry: Healthcare

Challenges• Decrease expenditures for prescribed medical products • Improve availability of services by reducing patient waiting times• Provide one system to all data sources spanning clinical,

financial and administrative systems for ad hoc analysis

Solution• Deployed QlikView to ~2,400 users in 4 functions in Sweden:

Supply Chain Analysis: Exploit statistical pharmaceutical data on prescriptions, usage patterns, and less expensive alternativesClinical Operations & Care Delivery Analysis: Track key operational inflow/outflow patterns; Analyze caregiver availability statistics (patient lead/wait times); Analyze survival expectancy data by treatmentFinancial Analysis: Monitor financial performance against budgetResource Planning Analysis: Measure equipment and staff scheduling

• Next steps will include MIS and balanced scorecard• Deployed in < 4 weeks for pharmaceutical app with 2 resources• Leveraged QlikView to aggregate more than 5 million records across

a suite of disparate systems including Prima for HR, Provisio for operations, Raindance for finance, Melior for medical journals and Conrad for x-ray systems

“It is a great advantage to us that we, who know our hospital’s operations, are able to design QlikView applications ourselves. The traditional BI software requires specialists who must interpret needs but never understand them as we do. And they cost much more.”

Leif Fransson, Statistician & IT AnalystBlekinge Hospital

QlikView Customer Snapshot – Bouman GGZ

Benefits• Provided an integrated view into operations by gaining insight into metrics that are

interconnected across data systems• Removed sense of compartmentalization in the organization• Combined data warehouse and BI analysis in one solution• Improved process efficiencies and DTC tracking driving more affordable healthcare

delivery• Delivered common dashboard of information to management

About Bouman GGZ• Largest mental health organization in the Netherlands,

specializing particularly in addiction. Bouman provides services at over fifty locations in the Zuid-Holland-Zuid region, spread across the municipalities of Rotterdam, Schiedam, Vlaardingen, Dordrecht, Leerdam, Gorinchem and Spijkenisse

• Workforce of more than 850 employees• Industry: Healthcare

Challenges• Consolidate data across three main systems – clinical, financial

and administrative systems• Raise efficiency to make healthcare more affordable• Generate real-time management information system

Solution• Deployed QlikView to ~30 users across 4 functions in the

Netherlands:Clinical Operations & Care Delivery Analysis: Monitor patient flow patterns, duration of stay, and treatment activity Resource Planning Analysis: Analyze staffing and schedulingFinancial Analysis: Measure performance against budget with costsRevenue Cycle Analysis: Track DTCs (Diagnosis Treatment Combinations for reimbursement, Signal DTCs past due so as to not miss revenue

• Rapid implementation in < 2 weeks with support from JIS• Leveraged QliKView to aggregate data from several systems

including a financial system (Decade), HRM system (Beaufort) and clinical system (User)

• Tools such as Cognos and Oracle proved limiting in analysis flexibility and speed of deployment

“What is so good about QlikView is that managers can view the latest information any time they want: about DTCs (Diagnosis Treatment Combinations), their budgets, personal data… you name it. And all it takes is a few mouse clicks.”

Kees Schenkels, Head of ICTBouman GGZ

QlikView Customer Snapshot – Children’s Healthcare

Benefits• Time savings from not spending hours combing through

medical records, but now being able to analyze data and focusing all energy on the ultimate goal of quality improvement

• Improved processes to help prevent adverse events and improve the quality of patient care

About Children’s Healthcare Services• Leading non-profit organization caring for children is the only

pediatric specialty healthcare center in Nebraska. Patients are referred from throughout the region for the treatment of complex or unusual diseases in addition to pediatric primary care. Supports 142-bed facility and roughly 50,000 patients per year

• Headquartered in Omaha, Nebraska• Industry: Healthcare

Challenges• Gain visibility into operations to improve the quality of care• Access, integrate and analyze data across disparate systems -

clinical, financial and administrative systems

Solution• Deployed QlikView to ~ 50 users across 3 functions in US:

Clinical Operations & Care Delivery Analysis: Measure patient flow and throughput to identify bottlenecks to streamline operations, reduce medical errors and improve patient qualityResource Planning Analysis: Monitor physician and surgical facility utilization and schedulingFinancial Analysis: Assess cash flows from surgical utilization; Profile surgeons with revenue, cost and profit per surgery with breakdowns for surgery costs and post surgery cost and outcomes

• Leveraged QliKView as the delivery system to aggregate data from its data warehouse in combining information from its clinical, financial and administrative systems including:

–Patient care information from Sunrise Clinical Manager System –Ambulatory care information from Epic Systems–Radiology and laboratory data from Misys Healthcare Systems

“QlikView will mine a data warehouse and present managers with a graphical view of the information they need to improve quality and safety.”

Allana Cummings, Vice President & CIOChildren’s Healthcare Services

QlikView Customer Snapshot – Danderyds Hospital

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

About Danderyds Hospital• 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• Industry: Healthcare

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 outcomeResource 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.

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.

QlikView Customer Snapshot – DDG

Benefits• Provided MIS for insight into the performance of the GP posts and whether the call center meets the

quality requirements• Improved effectiveness of response to patient demand• Self-sufficient management reporting providing comprehensive operational visibility without

dependence on IT • Integrated reporting from multiple data sources• Faster generation of more detailed information• Pioneering application attracting interest from similar GP services

Challenges• Generate management information to measure and monitor

operational performance• Acquire insight into whether the GP post is delivering on its 30-

minute call-back obligation

Solution• Deployed QlikView to ~10 users across Service & Support to

analyze the complete call-to-care metrics in the Netherlands:Call Center Analysis: Monitor call center metrics such as call volume, wait times, and durationService Response Analysis: Measure service responsiveness against 30-minute call back obligationDispatch Analysis: Assess on-site service with dispatch, routes and drive time to get on-site

• Rapid implementation in less than 1 week• Leveraged QlikView to aggregate and unlock data from its

Adastra call management and patient registration system, GPS-based vehicle tracking system, and Microsoft Access database

“Thanks to QlikView, it takes much less time and effort to retrieve figures, analyse them and generate the information needed to manage operations. In the past, we spent a whole day collecting and organising management data. Now management can retrieve data itself with two or three mouse clicks--no specialised knowledge required!”

Wim Addens, Systems ManagerDoktersdiensten Groningen (DDG)

About Doktersdiensten Groningen (DDG)• General practioners emergency healthcare call services for

Groningen and North Drenthe, Netherlands. DDG consists of 278 GPs supporting more than 650,000 patients in the region.

• Supporting more than 150,000 calls annually resulting in telephone consultation or emergency home visit

• Headquartered in Groningen, Netherlands

• Industry: Healthcare

QlikView Customer Snapshot – Diakonhjemmet Hospital

Benefits• Provided internal MIS dashboard to continuously streamline processes to

improve quality of patient care and safety• Complied with regulatory requirements for reporting on quality statistics to

national health bodies• Reduced patient wait times by removing bottlenecks• Increased bed capacity with improved scheduling

About Diakonhjemmet Hospital• Leading private hospital responsible for healthcare services for

~113,000 inhabitants in the western part of Oslo, Norway. The hospital serves in the fields of internal medicine, surgery and radiology, plus laboratory services with 7 clinical, 5 service and 6 administrative departments

• Supports 280 beds, 13,000 inpatients, 76,000 outpatients, 43,000 radiology exams and 1 million lab tests

• Headquartered in Oslo, Norway• Approximately $175 million in budget with 1,500 employees • Industry: Healthcare

Challenges• Meet regulatory requirements for compliance and reporting on

quality statistics to national and regional health bodies• Need to meet reporting demands for management board,

functional departments and internal planning

Solution• Deployed QlikView to ~ 75 users across 3 functions in Norway:

Clinical Operations & Care Delivery Analysis: Monitor patient flow model through the system and identify bottlenecks in process – such as with the wait times between visits from a general practitioner referring a patient to a specialist; Assess performance by physician, case type, etc.Financial Analysis: Analyze financial performance of actuals versus budget; Manage AR tracking and collectionSupply Chain & Resource Planning Analysis: Measure and assess bed utilization and scheduling to increase capacity

• Deployed QlikView as internal MIS – DIA-LIS providing a common dashboard for all management levels

• Rapid implementation with limited IT resources (1 person)• Leveraged QliKView to aggregate data across its clinical,

financial and administrative systems handling records for more than 90,000 patient visits annually

“QlikView serves as our MIS platform providing continuous feedback on performance indicators across finance, clinical and administrative processes – all focused on driving quality improvements.”

Andy Hyde, Director of Quality and InnovationDiakonhjemmet Hospital

“Analyzing data with QlikView is incredibly simple. I like to compare it to a washing machine – cleaning up all of the information stored within our hospital’s different systems and making it spotless.”

Margareta Davegård, PR ManagerHelsingborg Hospital

Benefits• $240,000 in annual cost savings with 33% reduction in controllers due

to efficiency gains• Staff leveraging information to draw insights to reduce patient waiting

times and improve patient care• Improved patient safety through insight into diagnoses• Analyze data across systems – clinical, materials and finance

About Helsingborg Hospital• One of Sweden's largest privatized emergency hospitals and

one of the most advanced healthcare providers with ~500 beds and supporting 450,000 annual patient visits

• Headquartered in Helsingborg, Sweden in the Skåne region• Achieved ~ $300 million in revenue with 3,500 employees• Industry: Healthcare

Challenges• Maintain regional leadership position and high standards of

service and medical care• Improve the quality of information and statistics that abound in

the numerous data systems to drive operational improvements

Solution• Deployed QlikView to ~265 users across 5 functions in Sweden:

Executive Analysis: Develop MIS system and balanced scorecard in next wave for insight across organizationSupply Chain Analysis: Assess pharmaceutical costsClinical Operations & Care Delivery Analysis: Track patient inflow and waiting times to improve medical delivery; monitor medical journals and diagnoses to improve patient care Financial Analysis: Track financials to monitor financial viabilityResource Planning / HR Analysis: Monitor staffing levels and schedules driving performance; measure patient scheduling against metrics

• Rapid implementation of four applications in 4 weeks• Leveraged QlikView to link together more than 1.5 million records across a

suite of disparate systems including Prima for HR, Provisio for operations, Raindance for finance, Melior for medical journals and Conrad for x-ray systems

• Next steps include rolling out QlikView to more than 3,000 users

QlikView Customer Snapshot – Helsingborg Hospital

QlikView Customer Snapshot – Karolinska Hospital

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 the answer to an ad-hoc query• 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

About Karolinska University Hospital• One of Scandinavia’s premier health facilities. Together with the

world-respected Karolinska Institutet, it leads in medical break-throughs in Sweden. Supports approximately 1,600 beds with 1.4 million patient visits per year and 7 surgeries per hour

• Headquartered in Stockholm, Sweden• Annual budget of $1.5 billion with 15,000 employees• Industry: Healthcare

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• Current 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 1 functions in Sweden:

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 to aggregate data from Klinisoft, intensive

care planning and medical journal system handling high volumes of data

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.

Challenges• Detailed analyses of large volumes of patient data to comply

with far reaching German health service regulations

Benefits• Achieved higher ROI with QlikView given its low TCO which was 13% of a

comparable solution for the initial investment• Ability to analyze data down to individual doctors, patients and diagnoses

across multiple accounting periods to meet regulatory reporting requirements

• Fast, flexible analyses of vast amounts of data (unachievable with traditional BI) with outstanding ease of use

About Kassenärztliche Bundesvereinigung (KBV)• National Association of Statutory Health Insurance Physicians or

(KBV) is one of major players in Germany‘s national health service

• Umbrella organization for 17 regional Associations of Statutory Health Physicians (ASHIPS), which act as clearinghouses for payments by German health insurance system

• Voice for physicians‘ interests in regulatory matters and preparer of statisical analyses of delivered medical services

• Headquartered in Berlin, Germany

• Industry: Healthcare

Solution• Deployed QlikView to ~ 90 users within 2 functions in Germany:

Clinical Operations & Care Delivery Analysis: Completed several projects:- Pharmaceutical Database: Query against drug and vaccine information-Physicians Registry: Analyze physician, geography and morbidity data to assess and secure sufficient healthcare coverage across the countryFinancial & Revenue Cycle Analysis: Completed several projects:-Uniform Standard of Evaluation: Simulate stipulated renumeration for medical services by statutory health insurances and assess profitability-Standard Benefit Volumes: Assess volume of medical services delivered by physician against imposed limitations during each accounting period

• Developed POC in one day analyzing 300 million records

• Implemented the first application in less than a week• Leveraged QlikView (64-bit) to aggregate two billion records measuring 15-20 terabytes of data• Enforced strict user authentication to comply with the stringent privacy requirements that apply for personal health data

“QlikView enables us to analyze data volumes up to the order of two billion records measuring 15 to 20 terabytes quickly and easily – there is simply no other vendor or product with anything like the ability to move these large amounts of data.”

Eva Obermeyer, Head of Accounting DepartmentKBV

QlikView Customer Snapshot – KBV

Challenges• Detailed analyses of large volumes of patient data to comply with far reaching German

health service regulations• Controlling of pharmaceuticals with treatments – by physician, medicine, patient, frequency,

treatment etc.

Benefits• Ability to analyze data down to individual doctors, patients and diagnoses across

multiple accounting periods to meet regulatory reporting requirements• Provided analysis for benchmarking within region – for example in identifying if the

region / hospitals have enough physicians• Delivered easy to use tool allowing users to perform flexible ad-hoc analysis across

different time periods• Improved transparency in data and performance within the hospital network in

region related to quality of care and costs

About Kassenärztliche Vereinigung Niedersachsen• Regional Association of Statutory Health Insurance Physicians

(ASHIP), acting as a clearinghouse for payments by the German health insurance system. KVN is the regional association for the federal state of Niedersachsen, Germany

• Voice for physicians‘ interests in regulatory matters and preparer of statisical analyses of delivered medical services

• Headquartered in Hannover, Germany

• Industry: Healthcare

Solution• Deployed QlikView to ~125 users growing to 200 users across 3 functions in Germany:

Clinical Operations Analysis: Track patient profiles and monitor where patients originate within region to ensure healthcare coverage within the region (Integrate patient data with Microsoft Map Point)

Care Delivery Analysis: Pharmaceutical Database: Query against drug and vaccine information by physician, medicine, patient, frequency and treatment

IT Analysis: Manage system log files

• Leveraged QlikView (64-bit) to aggregate millions of records measuring across hospital network within region

QlikView delivers KVN a flexible, easy to use tool allowing KVN to mine the data and provide high value consulting advice to its hospital and physician network.

QlikView Customer Snapshot – KVN

“With QlikView, we can identify related issues and solve problems, which would have previously been completely lost in the mass of data.”

Uschi Schäfer, Medicine ControllingMarien Hospital Gelsenkirchen

Benefits• Improved patient care through more transparency, efficient

control and optimization of internal clinical processes• 80% reduction in audit time down from 3 weeks to 2-3 days

through increased productivity during annual audits and budget negotiations with health insurance funds

• Rapid and broad adoption by users thanks to exceptional user-friendliness and flexible ad-hoc data analysis

About Marien Hospital Gelsenkirchen• Leading academic training hospital and a pioneer of IT

supported hospital management with approximately 500+ beds and ten specialized divisions

• Headquartered in Gelsenkirchen, Germany• Achieved ~ $85 million in revenue with 1,100 employees• Industry: Healthcare

Challenges• Amplify transparency within the clinic to achieve greater

efficiency in administering internal services• Take proactive steps in preparation for the statutory demands

of Diagnosis Related Groups (DRG) during annual budget negotiations with health insurance fund representatives

Solution• Deployed QlikView to ~ 30 users across 4 functions in Germany:

Clinical Operations & Care Delivery Analysis: Track nominal and actual comparison of DRG data such as dates of admission and discharge, primary / secondary diagnosis, operations, age, and weight of newbornsFinancial & Revenue Cycle Analysis: Analyze financials - actuals versus budget; Manage DRG reporting and negotiations with insurance fundsIT Analysis: Evaluate interface protocols and firewall attacks as well as increase the safety of sensitive patient informationSix Sigma & Quality Management Analysis: Analyze BQS quality assurance data submitted to the government to improve overall patient quality and compliance to meet statutory regulations

• Rapidly developed DRG analysis in 3 weeks with Transact • Leveraged QlikView to extract all key clinical data for 27,000

annual patients from SAP HR, DRG system, KIS and Excel

QlikView Customer Snapshot – Marien Hospital

QlikView Customer Snapshot – NHS

Benefits• Delivered platform for users to get the intelligence they need to be

more effective and improve the performance of the Hub• Considered leading way for NHS management intelligence• Saved hours of management time in reporting and analysis• Delivered project ahead of time and on budget

About The National Health Service (NHS)• The NHS is the publicly funded health care system of England.

providing the majority of healthcare in England, from general practitioners to hospitals, long-term healthcare, dentistry and ophthalmology

• NHS launched the Collaborative Procurement Hubs (CPH) project which works with trusts and confederations in a phased approach to develop CPHs across the NHS that provide a regional procurement focus

• Headquartered in London, England• Budget of $210 billion with 1.3 million employees• Industry: Healthcare

Challenges• Pull together, format and present financial data from a range of

applications throughout the Hub’s Trust sponsor bodies• Identify areas across trust network to reduce contract spend as

part of supply chain excellence program within the CPH

Solution• Deployed QlikView to ~250 users (consisting of category managers in

the hubs and financial personnel at the hospital trusts) focused on Supply Chain analysis throughout the UK:

Benefits Reporting: Measure savings from contract bulk purchasing and communicate savings to hospital trust bodies; Financial directors within each hospital trust can assess savings down to the invoiced line itemSpend / Cost Analysis: Analyze spend data on cost per item by volume across regional hospitals to identify opportunities for savingsSupplier and Purchaser Analysis: Monitor supplier database and performance with purchaser hierarchies Benchmarking Analysis: Establish cross trust and inter-hub communication and collaboration with performance benchmarkingCategory Management Analysis: Ensure no outliers in costs by category and ensure materials are in right place at right time

• Deployed in <12 weeks - NW Hub; <3 months - Life Source Hub• Leveraged QliKView (64-bit) to aggregate data from the data systems

within the Hub and across the trust bodies

“We’ve developed QlikView for supplier database and purchaser hierarchies. By being able to include this level of data, we have managed to give ourselves a level of insight into potential scales of economy that has not been available before. This is an invaluable ability for an organization that’s entire existence is based on reducing costs through purchasing in bulk.”

Jan Nangle, Procurement Hub, NHS

QlikView Customer Snapshot – Ochsner Health System

Benefits• Reduced costs sufficiently to be able to cost justify a new $1.3 million Da Vinci Robot which

provides minimally invasive surgery for prostatectomy patients• Used analytics at a key board meeting to demonstrate the number of cases the new robot would

affect and its return on investment. Gained the budget approval for purchase• Saved more than 24-hours per month in resources used for reactive report generation, enabling

them to reallocate these resources to more strategic initiatives• Moved to a proactive management approach through the use of real-time information with ability

to perform ad-hoc analysis

About Ochsner Health System• A leading healthcare organization that includes a main campus

hospital and clinic as well as 24 clinics throughout its region. Widely recognized as a center of excellence for research, patient care and education. Ochsner has ~ 475 beds, 18 operating rooms and supports 13,543 surgeries per year

• Headquartered in New Orleans, Louisiana• Non-profit organization with 7,000 employees• Industry: Healthcare

Challenges• Shift from a reactive mode to proactive decision-making• Gain a complete understanding of the performance metrics of

their clinical operations

Solution• Deployed QlikView to 20 users across 2 functions in US:

Clinical Operations Analysis: Monitor surgical room utilization and turnaround times to maximize capacity. Identify long turnaround times between cases in OR and streamline process Resource Planning Analysis: Measure surgical room utilization and impact on revenue generation as 70% of revenue driven from surgeries; Assess # of procedures and costs by case for manual surgery versus potential for robotic surgery

• Rapid implementation in just days with pre-built views with SIS Analytics powered by QlikView

• Leveraged SIS Analytics (QlikView) to integrate data across the primary systems for finance, materials and clinical

On a daily basis, the CEO views a dashboard of performance metrics such as utilization to assess the health of the organization.

Leveraged analytics to measure surgical throughput for a particular procedure. Analysis used to cost justify a new $1.3 million Da Vinci Robot.

QlikView Customer Snapshot – Prince William Health

Benefits• Projected decrease in write-offs of insurance claims by 65% down from $15 million to $5

million per year• Reduced revenue cycle costs by bringing AR tracking, monitoring and collection

internally (previously outsourced)• Improved revenue by analyzing physician scorecards to extend contract renewals to the

high performing physicians• Increased capacity of facilities through streamlined processes and optimized scheduling

About Prince William Health System• Prince William Hospital is a 170-bed, not-for-profit hospital

focused on providing exceptional, quality healthcare for the inhabitants in the Manassas, Virginia area

• Headquartered in in Manassas, Virginia• Industry: Healthcare

Challenges• Lack real-time visibility into AR process given outsourcing of

management and tracking and limited reporting• Reduce write-offs for insurance claims• Assess physician performance for contract renewal process

Solution• Deployed QlikView to ~15 users across 3 functions in US:

Financial Analysis: Analyze physician scorecards – tracking by physician, what facilities operate in, # of patients, # of visits and operations, and revenue/cost/profitability by operations; Identify top performing physicians Revenue Cycle Analysis: Manage AR collections and claims processing with health insurance funds and patients; Measure cycle time of collectionResource Planning Analysis: Monitor utilization of facilities and corresponding staffing to optimize coverage and capture previously lost revenue due to capacity constraints

• Rapid implementation in less than 5 days• Leveraged QliKView to aggregate data from disparate systems

spanning clinical, financial and administrative systems

Quality of patient care and operational performance driven from dashboards and scorecards measuring physician performance, facility utilization, and revenue cycle metrics.

Challenges• Provide MIS across healthcare network of 10 hospitals• Optimize resources for best results from every healthcare effort

(Region Skåne Intensive Care Services at 5 hospitals)• Coordinate six different operational systems

(Region Skåne Habilitation and Assistive Technology Services) • Improve patient waiting times and management of patient flow

(The Eye Clinic at Malmö University Hospital)

QlikView Customer Snapshot – Region Skåne

Benefits• Intensive Care Services: Resources, procedures and results

shared among five hospitals, enabling collective and meaningful analysis on how to improve quality and efficiency of care

• Habilitation and Assistive Technology Services: Operational visibility and easy-to-understand interpretation of integrated data from six systems with visual analysis and presentation

• Eye Clinic: Patient wait times reduced from a year to a few days

About Region Skåne • Regional public body responsible for health, medical and dental

services in region Skåne, the southernmost county in Sweden. Manages 9 hospitals, Primary Care Skåne and Public Dental Care Skåne with workforce of 28,000 employees

• Headquartered in Kristianstad, Sweden

• Industry: Healthcare

Solutions• Deployed QlikView to ~1,000 users in 4 functions in Sweden:

Executive Analysis: Develop MIS for key metrics across hospital networkClinical Operations & Care Delivery Analysis: Analysis and reporting of data from specially developed PasIva intensive care system (ICU)Resource Planning Analysis: Monitor staff and patient scheduling (HATS)Financial Analysis: Measure performance against budgets and costs

• Leveraged QlikView (64-bit) to link together more than six systems spanning clinical, financial and administrative areas

“It is difficult to put a value on better information but of course it is worth a lot to us to know that we can trust the answers we receive. QlikView’s speed, accuracy, ease of use, and visual presentation give us the information access and reliability we need.”

Ewamay Cederholm, IT ManagerHabilitation and Assistive Technology ServicesRegion Skåne

QlikView Customer Snapshot – Sahlgrenska Hospital

Benefits• 99% decrease in time to access patient-critical information

(from hours and days down to seconds) to save patient lives• Reduced the complication rate to zero and eliminated

unnecessary tests and costs saving $1 million annually• New capabilities to efficiently describe, record, quantify and

analyze patient procedures building history to improve treatments and patient outcomes

• New analyses for measuring patient flows, groupings and costs • Scalability to quickly analyze millions of records of data

About Sahlgrenska University Hospital• A university and a regional hospital that provides emergency

and basic care for its 700,000 inhabitants in the Gothenberg, Sweden region. Regarded as Northern Europe's largest hospital with 2,700 beds

• Annual budget of $1.1 billion with 17,000 employees• Located in Gothenberg, Sweden• Winner of ComputerWorld Honors Program Laureate Award in

2007 for deployment of IT to benefit society• Industry: Healthcare

Challenges• Find optimal treatments for severe head injuries and an easy to use tool to

aid doctors in predicting complications from surgery• Provide medical professionals with faster access to critcial information

when responding to emergency cranial surgeries• Integrate data from Siemens Melior patient journal system with five other

hospital systems

Solution• Deployed QlikView to ~25 users across 2 functions in Sweden:

Care Delivery Analysis: Analyze patient flow, patient history, treatments, procedures, and survivability data - all focused on improving the ability to identify and treat complications, such as meningitisFinancial Analysis: Measure patient groups and associated costs

• Automates decision support by alerting doctors by email when indicators show an increased risk of getting meningitis• Leveraged QlikView to aggregate data from Melior with other hospital systems to provide a complete and immediate

picture of patient situations and interactions with medical services

“The most important thing is to make the right decision quickly, it can be the difference between life and death. When I receive a patient, I can place myself in front of a computer and get information immediately. Now I have the total picture in front of me. I don’t have to search in different databases and waste precious minutes.”Daniel Stålhammar, Associate ProfessorSahlgrenska University Hospital