QlikView for healthcare
Table of contents
QlikView for healthcare: top solutions for healthcare providers
3
QlikView for healthcare: population management
4
QlikView for healthcare: meaningful use reporting
and attestation
6
QlikView for healthcare: accountable care enablement
7
QlikView for healthcare: revenue cycle management
& financial reporting
8
QlikView for healthcare: hospital performance,
quality measures
10
QlikView for healthcare: patient satisfaction
11
QlikView for healthcare: supply chain optimization
12
QlikView for healthcare: labor productivity
14
QlikView for healthcare: physician performance management
15
QlikView for healthcare: OR and ED
performance improvement
17
QlikView for healthcare
Top solutions for healthcare providers
Discover why more than 1,000 healthcare
providers spanning hospitals, nursing and
residential care facilities, and ambulatory
services worldwide have turned to QlikView
to overcome business intelligence challenges
and improve performance.
QlikView delivers true self-service BI that empowers business users by driving innovative decision-making. While QlikView can be applied to practically any business area, the top solutions for healthcare providers highlight some of the most common areas QlikView is deployed across hospitals, clinics, home care, hospice, and surgical facilities.
Each solution includes examples of QlikView apps that are intended to showcase the art of the possible and act as a best practice example of deploying QlikView in a particular business area. The following one-page solution data sheets are comprised of an overview, sample app screenshots and real-world customer stories. Examples of each solution can be demonstrated or shared by contacting your Qlik representative.
Top QlikView
healthcare solution
areas:
• Population management – transition care team, readmission reduction • Meaningful use • Accountable care
enablement
• Revenue cycle management & financial reporting
• Hospital performance – quality measures • Patient satisfaction • Supply chain optimization • Labor productivity • Physician performance
management
• Or and ed performance improvement
• Infection control and monitoring
Challenge
One way to reduce readmission rates and ensure better patient outcomes is to minimize errors that commonly occur in the care transition process. According to the U.S. Department of Health & Human Services, “nearly one in five Medicare patients discharged from the hospital is readmitted within 30 days. This translates to approximately 2.6 million seniors at a cost of over $26 billion every year.” Standing in the way of better care transition, is a lack of information, insight, and collaboration. To realize improvement in this area, providers need access to critical patient data regarding demographics, socioeconomic status, disease states, medications, care plans, and much more. All of this data needs to be shared seamlessly among the providers of medical, social, and support services involved in each transition. And with so many different roles involved in the end-to-end patient care process, users need unimpeded access to this data in real time.
Solution
Qlik and the partner community have built a number of ‘QlikView Apps’ to help healthcare organizations like yours seize every opportunity to improve patient population management, reduce transition care errors, and minimize readmission rates. With QlikView, you can:
• Empower all roles involved in the end-to-end patient care process to access and share critical patient data in real-time
• Track KPIs for the transition care process and identify readmission issues to make continuous improvements
• Collaborate with all parties during the transition process to ensure better patient outcomes
• Calculate a patient’s predicted risk of readmission based on a range of criteria that you define
• Record and analyze the patient experience so that all parties understand their performance levels
• Build, maintain, and analyze patient-centered care plans that persist across time and settings
• Identify and reconcile patient requirements regarding medication, emergency plans, patient goals, and much more
QlikView for healthcare:
population management
The insight you need to improve transition care and minimize readmissions
Example: Missed visits dashboard
Physicians want to provide the best
care they can for their patients. They
invest a lot of time and deserve a solid
performance understanding based on
how they’ve cared for patients as a
group.
Customer Examples
•
Allina Health uses QlikView to maintain a patient census, monitor the patient experience, and track preventable
readmissions. Dashboards are used to identify readmissions that are clinically-related; to calculate the predicted risk
of readmission within 30 days; and to assist hospital- and clinical-based teams in collaborating with care providers
to deliver an optimal patient experience. Combined with the abilities to drill down into the data, ask relevant
questions, and gain and share insight, QlikView empowers users to be self-sufficient and interact with information in
real-time to ensure the best patient outcomes possible.
•
Children’s Healthcare of Atlanta (CHOA) uses QlikView to power a diabetes registry that enables clinicians and
researchers to track its patient diabetes population and analyze the data to recognize patterns. An analytical
dashboard allows users to view and track patient visits, measure health outcomes, detect patterns, find new
treatments, analyze performance data, and track clinical practice guidelines. Collecting, viewing, and reporting on
data in the registry is easy too – with standardized data sets that are highly interactive. And all of this is done using
a highly intuitive interface that doesn’t require assistance from IT or a separate report writer.
Challenge
For hospital and healthcare providers in the US, change has come due to new healthcare regulations that are now in effect. The meaningful use requirement for electronic health records (EHR) seeks to ensure that providers use new EHR systems to achieve better patient outcomes. At the broadest level, these requirements aim to help organizations like yours increase quality, safety, and efficiency; better engage patients and families; more effectively coordinate care; improve public and population health; and ensure privacy and security for personal health information. Across all of these areas, you need demonstrate meaningful use according to specific measures defined by the Centers for Medicare & Medicaid Services (CMS). Many EHR systems, however, lack the data visibility and analysis capabilities to track these measures effectively across facilities – which makes meaningful use reporting and attestation a challenge.
Solution
Qlik and the partner community have built a number of ‘QlikView Apps’ to help organizations like yours increase healthcare data visibility and analyze your ability to meet meaningful use requirements. With QlikView, you can:
• Analyze EHR systems and a wide variety of other core systems to track patient care, identify the root cause of patient outcomes, and demonstrate meaningful use to remain in compliance with federal mandates
• Build specific dashboards that align to each measure defined by the CMS and track your progress on meeting targeted goal
• Streamline meaningful use reporting by aggregating healthcare data across multiple EHR systems and viewing overall progress for all measures • Achieve meaningful use certification faster with greater data visibility and
more powerful reporting capabilities
• Combine meaningful use data with other data across healthcare systems to ensure better patient outcomes and excel in areas that go beyond meaningful use requirements
Customer examples
• ThedaCare – the largest healthcare provider and employer in Northeast Wisconsin – has been able to reduce its annual BI costs by 50% with QlikView. ThedaCare uses QlikView as an analytical engine for its EPIC EHR system and performs meaningful use reporting that combines data from a Lawson system for even deeper cost analysis insight.
• Bellin Healthcare uses QlikView for EHR analysis and meaningful use reporting and attestation. This healthcare provider – known for its comprehensive heart program – was able to achieve 100% adoption forits CMO, physicians, affiliates, IT, and quality Leaders within just 70 days of deployment.
QlikView for healthcare:
meaningful use reporting and attestation
Getting the most out of your electronic health records systems
Example: Dashboard for organization-wide meaningful use measure review
Example: Dashboard for Medicare/Medicaid submission analysis by eligible provider
QlikView dramatically reduces the
time to answer business and clinical
questions. It’s helping ThedaCare
transition to a truly analytical
environment where any information
can be rapidly accessed, analyzed
and viewed exactly as needed.
— Brian Veara, manager of Decision Resources,
Challenge
If you’re a healthcare provider, you probably know that ACO (Accountable Care Organization) is one of the hottest new buzzwords in healthcare reform these days. But what does it mean for how you operate on a daily basis? The bottom line is this: more collaboration and sharing of information. The Center for Medicare and Medicaid Services (CMS) sees the ACO model as a new way to link reimbursement to quality improvements and cost-of-care reductions. Here, the CMS incentivize doctors and hospitals to form ACO networks that collaboratively deliver quality care at lower costs to Medicare beneficiaries. An important principle is ACO responsibility for quality care and per capita costs for defined patient populations – accountability for which will be monitored and measured by the CMS through the Medicare Shared Services program for participating ACOs. Over time, performance measurements and requirements will grow increasingly more sophisticated. All of this puts the onus on healthcare organizations like yours to find new ways to continuously improve performance and patient outcomes, work more effectively with partnering organizations in the ACO network, and respond in a flexible manner to a slew of new CMS reporting requirements.
Solution
Qlik and the partner community have built a number of ‘QlikView Apps’ to help healthcare organizations like yours seize every opportunity associated with establishing an ACO and driving better, more cost effective healthcare delivery. With QlikView, you can:
• View and analyze financial information to better manage new payment arrangements based on an MSSP model that modulates the risk and reward equation for participating ACOs
• Monitor quality measures to ensure ACO success, drill down to find areas of improvement, and even perform predictive analytics to improve quality moving forward • Monitor and report on preventive care programs – such as immunizations and
disease screening – that help improve the health of patient populations and drive down overall costs
• Share data with network partners, insurance companies, and regulators to better coordinate care delivery as part of the ACO model • Streamline and improve transition care across partnering organizations to ensure better patient outcomes and minimize readmissions • Mine data to reveal the prevalence of certain illnesses per ACO region – and then address these illnesses at the community level to drive
overall improvements
• Link quality measures and patient outcomes to fee schedules to justify physicians and administrator bonuses based solid data
Customer examples
• Allina Health needs a strong information infrastructure in order to maintain ACO status. The company uses QlikView to help manage and visualize the enormous amount of data required for ACO government reporting. Information is pulled from a data warehouse put into various dashboards. The ability to put this data – nearly 2 terabytes worth – into the hands of people who can use it effectively has provided great benefits to the organization. It enables Allina to evaluate how it is performing, identify areas for improvement, and discover ways for clinicians and care teams to deliver better care to patients.
• Another customer uses QlikView’s associative experience to reveal interesting insights – the kind that are important for ACO success. At this organization, a knowledge worker, not a data scientist, discovered that 92% of patients over 74 years old developed blood infections from outpatient gallbladder removal procedures. Today a proactive measure is in place to prevent this issue. This helps the organization improve patient outcomes and satisfaction.
QlikView for healthcare:
accountable care enablement
Leveraging information to lower costs and improve patient care
Example: comparative analysis and the diagnosis scorecard
Because of QlikView, clinicians have
an awareness of their performance in
comparison to other staff and it’s all very
transparent. Physicians want to provide
the best care they can for their patients.
They invest a lot of time and deserve a
solid performance understanding based
on how they’ve cared for patients as a
group. This is all part of our performance
improvement strategy.
Challenge
Healthcare providers are facing rising costs, long revenue cycles, bad debt, and increased claims write-offs. At the same time healthcare is becoming even more complex with the shift to Evidence-Based Medicine (EBM), Pay for Performance (P4P), Diagnosis-Related Groups (DRG) and Consumer-Directed Health Plans (CDHP). Providers have reason to fear the higher costs and lower reimbursements that accompany these emerging models. And coupled with the reality of too many providers either losing money or just breaking even - the need to speed up revenue while reducing collections cost has never been greater.
Solution
Qlik and the partner community have built a number of ‘QlikView Apps’ to help healthcare organizations like yours take control of your entire revenue cycle, so you can seize every opportunity to improve profitability. Using the QlikView Business Discovery platform, healthcare CFOs, financial analysts and accounting professionals can:
• Gain visibility across processes affecting cash flow, net cash, bad debt, and cost-to-collect
• Improve workflows for patient admissions, claims administration, denial management, fraud detection, and insurer contract management • Profile costs and revenue by facility, practice, physician, procedure, etc. • Real-time monitoring of cost controls, actual spend versus budget
across all departments to stay in constant control of bottom-line financial performance
And healthcare finance departments can use QlikView to: • Automate planning, budgeting, and forecasting tasks • Increase cost capture during care delivery
• Decrease insurance claims write-offs • Increase charge capture
• Reduce time and cost to collect reimbursements
• Reduce time and cost of financial compliance reporting (IFRS, SOX, etc.) as well as P4P and DRG tracking, reporting, and cost accounting
QlikView for healthcare: revenue
cycle management & financial reporting
Accelerate reimbursements, decrease claims write-offs,
and increase charge capture
Example: hospital profit and charges dashboard
Example: profit by procedure and payer analysis
In four months of using QlikView,
we developed more applications
and dashboards than we had in
two years with other BI tools.
— Michael Thompson, Director of Business
Customer examples
• Managing more than half a million patient visits annually at three hospitals and 16 neighborhood locations, Children’s Healthcare of Atlanta (CHOA) is one of the largest clinical care providers for children in the country. CHOA offers access to more than 30 pediatric specialties and is ranked among the top children’s hospitals by Parents magazine and U.S. News & World Report. In less than a month, CHOA developed financial applications with QlikView that took nine months with previous BI tools. 500 employees are now using QlikView to analyze revenue management, service line spending, research hypotheses, and cost effectiveness. By securely analyzing over 100 million records to achieve unprecedented visibility, CHOA is using QlikView to revolutionize its information delivery to reduce costs, increase quality, ensure compliance, and improve outcomes. Reporting time has been reduced by more than 65%, and CHOA has eliminated the 10 -12 day waiting period for research-related queries. CHOA also developed a dashboard in QlikView that provides a holistic view of revenue management across hospitals and lines of service, and is the equivalent to information previously available in 50 different static reports.
• Northeast Georgia Health Systems (NGHS) is a not-for-profit community health system that provides the comprehensive medical services through its 500-physician strong medical staff. NGHS has deployed QlikView as part of its enterprise intelligence strategy to rapidly integrate and analyze data from clinical, financial, and resource management systems for better operations and improved quality of care. QlikView provides NGHS users with the ability to analyze data from its revenue cycle management, Ambulatory Electronic Medical Record (EMR), and surgical management systems. Today, QlikView has improved insight into denial management, operating room turnover, surgical cost control, and ambulatory practice patterns.
Challenge
To improve care and reduce costs, many hospital and healthcare organizations are turning to evidence-based medicine (EBM). The objective is to marshal all the possible information available to support decision-making in a way that minimizes harm and maximize benefits in the diagnosis, investigation, and management of individual patients. This can help organizations dramatically improve hospital quality and performance. But to follow through on this objective, organizations need to empower healthcare professionals to search for and access relevant data in real-time – without depending on IT. Users should be able to rapidly integrate and analyze business intelligence data from clinical, financial and resource management systems to support the decision-making process anywhere, anytime.
Solution
Qlik and the partner community have built a number of ‘QlikView Apps’ to help healthcare organizations like yours seize every opportunity to improve hospital performance, support quality measures, and facilitate EBM. With QlikView, you can:
• Streamline and track the effectiveness of EBM processes • Identify and track key patient safety and care quality metrics • Synchronize resource scheduling with patient flow models to improve
patient care and reduce wait times
• Improve patient safety from immediate access to consolidated diagnostic information, reducing opportunities for medical errors
• Ensure trusted and timely regulatory compliance by delivering on key operational, patient safety, and quality of care metrics
• Simplify compliance reporting, patient administration, and transitions to Electronic Medical Records
• Monitoring metrics and benchmark performance against similar facilities • Institute clinical care optimization methodologies
• Save precious time in ERs and ICUs
• Improve decision-support for Computer-based Patient Record systems
Customer examples
• Thedacare – the largest healthcare provider and employer in Northeast Wisconsin – deployed QlikView to 1,200 business and clinical users in the US. This has allowed the organization to track healthcare system performance, and implement patient care benchmarks that aggregate information on how clinical teams and doctors perform and how patients respond to treatments. Service performance metrics provide details on lab turnaround times, call center activity, and appointment scheduling to improve overall quality.
• According to Michael Thompson, Director of Business Intelligence at Children’s Healthcare of Atlanta, “QlikView provides our users with direct access to intelligence that can immediately impact quality of care, influence clinical research and improve operational efficiencies.”
QlikView for healthcare: hospital
performance, quality measures
Drive better decision-making in support of evidence-based medicine
Example: quality metrics by facility, physician, and diagnosis
We set improvement targets and
monitor our progress toward achieving
them. We also have many ad hoc needs,
like what are the potential root causes
for outcomes. QlikView gives us real
analysis not just reporting. Answers are
just a few clicks away. And everybody can
use QlikView whether they’re executives,
clinical staff, physician’s assistants, nursing
staff or administrators.
— Brian Veara, Manager of Decision Resources,
ThedaCare
Example: elective wait times and length of stay analysis
Challenge
In today’s rapidly evolving performance-driven healthcare environment, patient satisfaction is emerging as one of the most critical healthcare quality measures. Hospital- and clinical-based Consumer Assessment of Healthcare Providers and Systems (CAHPS) surveys are becoming standard practice, and are mandatory for Accountable Care Organizations (ACO). That’s why it’s critical to integrate patient and consumer feedback with the rest of your clinical, financial, and resource management systems. By doing so, doctors, nurses, clinical technicians, and hospital administrators can work more collaboratively to improve patient outcomes and satisfaction.
Solution
Qlik and the partner community have built a number of ‘QlikView Apps’ to help healthcare organizations like yours seize every opportunity to monitor and improve patient satisfaction. With QlikView, you can:
• Build patient experience dashboards that pull real-time data from CAHPS surveys and yield insight into key patient satisfaction metrics
• Access and analyze survey data from a wide range of patient survey systems including Press-Ganey, NRC Picker, Professional Research Consultants (PRC), Avatar, Healthstream, and the Jackson Organization
• Combine survey data with other KPIs to drive system-wide improvements for better patient outcomes and to meet ACO and meaningful use requirements • Maintain Medicare and Medicaid payment levels by quickly generating reports
that demonstrate acceptable patient satisfaction levels as required by the Affordable Care Act of 2010 (ACA)
• Use a patient census dashboard to track patient loads in real time and detect overburdened departments that can impact both patient and employee satisfaction
• Analyze historical patient census data to proactively allocate hospital resources to better manage daily surgical volumes and physician loads
Customer example
Allina Health is a not-for-profit healthcare system dedicated to the prevention and treatment of illness and enhancing the greater health
of individuals, families, and communities throughout Minnesota and western Wisconsin. Allina uses QlikView to help improve patient satisfaction and care delivery. Benefits have included:
• 40% increase in optimal stroke care between 2010 and 2012
• 12% system-wide improvement in the overall patient experience rating for hospital CAHPS • 20% reduction in cardiovascular care length of stay (within 5 months)
• 30% increase in depression care remission in the 5-7 month window since January 2012
• 80% increase in the use of Bivalirudin for percutaneous coronary intervention to better treat high-risk bleeding cases
Qlikview for healthcare:
patient satisfaction
Improved visibility and collaboration for improved patient outcomes
QlikView truly is a self-service BI
model where users from all corners
of the organization can go out and
get the information themselves and
not be dependent on the BI team.
This allows us to maintain a small and
agile BI team. BI is the most efficient
way for a healthcare organization to
improve without greatly increasing its
administrative cost.
— Mike Doyle, Enterprise Data Warehouse Manager,
Allina Health
Challenge
The healthcare supply chain is one of the most significant drivers of healthcare costs overall. The fact is, today’s provider’s can easily tie up 40-50% of their cost in complex, far-flung supply networks with little understanding of core issues such as ROI and the impact on organizational performance. To help drive down these costs, the Affordable Care Act (ACA) of 2010 is changing the way providers manage their supply chains. The new emphasis is on value – with the aim of improving patient outcomes. Providers now need to model their supply chains to manage risks, measure quality, and ensure the best outcomes possible. This requires a completely new set of metrics that focus less on supply chain transactions and more on supply chain strategy. Providers need to make supply chain management an executive-level concern – assessing the relationships they maintain with vendors to drive more value, analyzing performance across facilities to identify best practices, and reporting to the executive board as well as regulators to demonstrate progress. No longer is supply chain management a back office function. Today it is inextricably linked to the clinical outcomes that every provider seeks to improve.
Solution
Qlik and the partner community have built a number of ‘QlikView Apps’ to help healthcare organizations like yours seize every opportunity associated with improving supply chain performance for better, more cost-effective healthcare delivery. With QlikView, you can:
• Consolidate, visualize, and analyze financial and supply chain data from multiple systems across facilities
• Aggregate suppliers and consolidate spend with top vendors to negotiate volume discounts and leverage relationships to drive quality • Perform spend vs. cost analysis to arrive at accurate ROI calculations • Ensure on-time delivery for critical medical supplies and efficiently manage
inventory levels to run a lean operation that keeps costs down • Share and view inventory across facilities to better control costs and
minimize excessive ordering
• Continuously evaluate supplier performance according metrics such as delivery accuracy and high return volumes that can be linked to erroneous ordering, poor processes, inaccurate data, and damaged products • Analyze and manage contracts and contract performance according to
agreed upon SLAs to drive quality throughout the supply chain
QlikView for healthcare:
supply chain optimization
Transforming the healthcare supply chain
to drive better patient outcomes
Example: supplier spend analysis
One of the product’s strongest
selling points internally, is exactly the
reason we chose QlikView above
any of the alternatives – its simplicity.
Training can be done en masse in a
two hour session, and because people
understand it, they use it regularly.
— Jan Nangle, Information Service Manager, North
• Empower decision-makers with dramatically improved insight into the end-to-end supply chain
• Use secure mobile access to stay fully informed about supply chain dynamics and make decisions on-the-go
• Enable executive insight into supply chain performance with dashboards that monitor key performance indicators (KPIs) across multiple dimensions
• Remain in compliance by generating accurate reports that reflect supply chain realities in real time
Customer examples
• When it comes to managing the healthcare supply chain, few organizations have a more daunting job than the Nation Health Service (NHS) of the United Kingdom. The North West NHS Collaborative Procurement Hub (NWCPH) helps NHS manage this supply chain using QlikView – which it deployed to 70 users in just 12 weeks. Today, NWCPH can monitor supplier and purchaser performance, manage categories more effectively, and perform spend analysis to drive down procurement costs. Over the course of two years, the organization has cut more than $66 million in procurement costs, improved regional hub performance with better insight, and saved hours of management time in reporting and analysis.
Challenge
Under tremendous pressure to drive down costs, hospitals everywhere are looking to drive higher rates of efficiency for their most valuable resource – the doctors, nurses, and other staff members who deliver the care patients receive on daily basis. The obstacle is an inability to align labor costs with care requirements – which leads to excessive overtime and a dependence on costly staffing agencies. To drive down labor costs and increase efficiency, managers need timely access to a wide range of data and KPIs including productive hours, overtime, number of patients, and full- time employees per occupied bed (FTE/OB). When managing hospital networks that span entire regions, this challenge becomes even more complex.
Solution
Qlik and the partner community have built a number of ‘QlikView Apps’ to help healthcare organizations like yours seize every opportunity associated with ensuring the highest rates of labor productivity. With QlikView, you can:
• Analyze labor data for your entire network by region, hospital, department group, shift and job to better measure performance from multiple perspectives
• Use a scatter chart to analyze overtime variance across hospitals in your network and drill down to uncover underlying causes and find remedies for underperforming facilities
• Monitor and analyze planned budget versus actual spending for a wide range of criteria such as FTE/OB and overtime
• View charts and dashboards that make insightful correlations among a wide range of KPIs such as number of patients, overtime rate, FTE/OB, fulltime employees, and more
• Compare and contrast metrics across hospitals and departments to reveal best practices that work and identify areas for improvement
• Quickly view productive hours per hospital, department or shift using color- coded bar charts that denote proximity to target
• Use average hourly rate metrics to quickly calculate overtime, identify cost trends, and view variances from target over time
Customer examples
• Health South, the largest in-patient rehabilitation company in the country, deployed a labor productivity application on its QlikView platform and extended it across 100 of its hospitals. This application helps its c-level
executives, controllers, and other managers to manage labor costs and improve productivity throughout the organization. In the past, these executive would spend an inordinate amount of time gathering and aggregating data in spreadsheets to gain visibility into cost and productivity issues. Now, with QlikView, all of this information is available virtually instantaneously. This enables Health South to identify trends sooner so that it can address emerging cost and productivity issues before they adversely impact the care delivery and the bottom
QlikView for healthcare:
labor productivity
Driving performance improvement with better control over employee costs
Example: labor productivity dashboard overview
Example: labor productivity overtime analysis
I think QlikView is allowing us to
deliver better patient outcomes...
Before, we were looking at one or
two measures in conjunction with
patient outcomes. Now we are able
to look at a whole host of measures
and how those measures affect
patient outcomes.
line.
Challenge
One of the key components for improving health care outcomes is improving physician performance. This requires close monitoring of physician activities with the goal of improving quality and efficiency in tandem. Organizations that do this can not only improve outcomes but also drive down costs. Physician performance is also a critical component of the Affordable Care Act (ACA) of 2010 – which emphasizes a pay-for-performance approach over a pay-for-service approach to drive greater healthcare quality and affordability. The challenge comes with identifying and tracking performance metrics across all of your physicians and then reporting it all to the relevant regulatory agencies to demonstrate quality improvements.
Solution
Qlik and the partner community have built a number of ‘QlikView Apps’ to help healthcare organizations like yours seize every opportunity to improve physician performance. With QlikView, you can:
• Analyze volumes of data and establish outcome benchmarks against which physicians can assess their own performance
• Identify best practices that drive quality improvements across healthcare delivery facilities
• Dramatically improve performance transparency to target areas for improvement and facilitate easier reporting
• Enable greater collaboration throughout the extended healthcare organization to optimize outcomes
• Incentivize physicians to improve quality wherever possible by linking performance metrics directly to compensation structures
Customer Examples
• Allina Health is a not-for-profit healthcare system serving individuals, families, and communities throughout Minnesota and western Wisconsin. Allina uses QlikView to provide a scalable and user-friendly infrastructure
QlikView for healthcare: physician
performance management
The insight you need to improve the way physicians deliver care
Physician performance dashboard – scorecard
QlikView plays a big role in
supporting our performance
improvement initiatives. It helps the
organization improve across many
different facets and dimensions and
it’s been the best tool to help people
understand their performance. In the
future, we will look to get QlikView in
the hands of more users and develop
more dashboards.
— Mike Doyle, Enterprise Data Warehouse Manager,
Physician performance dashboard – costs and duration analysis
for monitoring performance and driving improvements. Enabling access to comprehensive data about ambulatory care quality across the organization, this infrastructure has helped Allina improve the transparency of physicians and clinician performance while also supporting collaboration for better patient outcomes.
• Sibley Heart Center Cardiology is the largest pediatric cardiology practice in Georgia and a subsidiary of Children’s Healthcare of Atlanta. Serving more than 30,000 patients annually, Sibley had a lot of data on hand to analyze. Using QlikView, the cardiology center analyzed 20 years of statistical data on patient diagnoses and treatments. For example, the hospital focused on one area involving patients with innocent heart murmur. As a result of this analysis, Sibley was able to identify best practices and make modifications to physician behaviors to drive better outcomes. Such an evidence-based approach to medicine, meanwhile, helps increase opportunities for grants. • ThedaCare is the largest healthcare provider and employer in Northeast
Wisconsin. Among a wide range of other uses, ThedaCare uses QlikView for disease management purposes – analyzing the root causes of patient outcomes and KPIs for a variety of preventive care programs. Disease management applications are designed to track how well ThedaCare physicians deliver patient care. Dashboards are used to monitor patient demand and flow, how patients respond to treatments, and many other clinical performance metrics. All of this helps the organization deliver the best quality care possible.
Challenge
Resource optimization for operating rooms (OR) and emergency departments (ED) is a critical piece of the puzzle for driving down healthcare costs while improving patient outcomes and satisfaction. The key is to accurately assess demand. When you underestimate demand, patient wait times go up and satisfaction goes down – along with perceptions of care quality. When you overestimate demand, you drive up costs by wasting supplies and medication – and by underutilizing clinical staff. In a world where hospitals are increasingly under pressure from the Affordable Care Act (ACA) of 2010 to improve the quality of care delivery, striking the right balance is all too important. This requires constant, real-time insight into demand so that you can develop plans and modify them according to evolving circumstances in order to maximize resource utilization.
Solution
Qlik and the partner community have built a number of ‘QlikView Apps’ to help healthcare organizations like yours seize every opportunity to improve OR and ED performance. With QlikView, you can:
• Assess historical data and analyze demand to maximize the use of facilities such as OR, ED, ICU, and patient beds
• More effectively schedule equipment, staff, specialists, and patient tests to drive efficiencies and maximize quality
• Monitor patient census fluctuations and adjust staffing requirements while taking account of parameters such as staff vacations, sick days, holidays, family leave, weather emergencies, retirements, etc.
• Maximize supply chain efficiencies to ensure the availability of all medical supplies
QlikView for healthcare:
OR and ED performance improvement
Optimizing resources with better insight into demand
Example: cross-hospital OR Utilization dashboard
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
Customer examples
NHS is the National Health Service of the United Kingdom – which is made up of a wide range of hospitals or “trusts” that deliver care on a daily basis. More than 140 of these trusts use QlikView to gain insight into healthcare delivery metrics and improve patient outcomes. One such trust, operating 21 facilities, uses QlikView to maximize OR resource utilization. This trust was able to:
• Identify reasons for low utilization – such as patient no-shows, unavailable medical staff, and last-minute cancellations
• Reassign facility time much more efficiently with an up-to-the-minute dashboard of OR activity
• Increase OR utilization by least 2% - which translates into £20,000 more per week in revenue across its 21 operating facilities
Mary Imogene Bassett Hospital is a 180-bed acute care, inpatient teaching facility that supports 7 operating rooms and conducts roughly 7,000 surgeries per year. This hospital uses QlikView to gain insight into the utilization and performanceof surgical rooms – which helps increase coverage, on-time starts, and surgeon satisfaction. Bassett was able to:
• Increase on-time case starts from 48% to 85% • Boost charge capture by 30%
• Increase surgical throughput with streamlined processes • Green light the opening of a dedicated trauma room • Gain the freedom to analyze data without the need for IT Another customer uses the QlikView to collect and analyze information regarding return visits to the ED. Now this customer can:
• View personal readmission measures and drill down into patient-level data • Associate data elements for insight into initial visit acuity, initial disposition
discharge, patient demographics, return information, and much more • View total system metrics and gain insight into physician practice variations • Collaborate with physicians to drive better performance
Children’s Healthcare of Atlanta (CHOA) uses QlikView to gather, organize, and analyze surgical services data. This has helped CHOA:
• Observe patterns in operating room scheduling, capacity utilization, and supply usage
• Track on-time starts, monitor turn-around times, and better equip rooms for greater efficiency and effectiveness
• Identify the most profitable activities by evaluating revenue generation by date, location, and procedure
• Increase OR revenues, improve performance, and ensure better patient outcomes
Example: case time analysis by location, physician, anesthesiologist, and procedures
One of the most useful aspects
of [QlikView] has been that of personal
accountability. When there is anecdotal
evidence to suggest a physician has a
poor history of on-time starts, accurate
data is crucial. The information from
QlikView enables me to sit down with
the physician, look at real-time data
and open an honest discussion about
the issue.
— Carolyn Goodman, Surgical Services Administrator, Children’s Healthcare of Atlanta
Challenge
When it comes to improving the quality of healthcare delivery and ensuring
better patient outcomes, few issues are more important than the effective
control and monitoring of healthcare-associated infections (HAIs). The
fact is, HAIs can dramatically drive up healthcare costs – and it’s already
been a few years since CMS has stopped reimbursing hospitals for treating
patients that acquire them. This means that both your strategies for
healthcare quality improvement and cost containment should both include
ways to minimize your rates of infection for bacterium such as Clostridium
difficile (C. diff) and methicillin- resistant Staphylococcus aureus (MRSA).
What’s more, the Centers for Medicare & Medicaid Services (CMS) is
incentivizing providers for reporting HAIs to the CDC’s National Healthcare
Safety Network (NHSN). The goal is to encourage better data collection
around HAI’s to uncover trends, identify best practices, and implement
improvements to drive rates down. This is all part of the CMS’s meaningful
use agenda – which requires providers like you to use data collected in
electronic health records (EHRs) to achieve better healthcare outcomes.
Solution
Qlik and the partner community have built a number of ‘QlikView Apps’
to help healthcare organizations like yours seize every opportunity to
improve infection control and monitoring. With QlikView, you can:
•
Monitor HAI rates across facilities in your network by aggregating
data from a wide range of systems and records including EHRs,
laboratory systems, surgical procedures, and pharmacy orders
•
Track hand-washing and sanitary procedures to determine effectiveness and establish best practices
•
Map the spread of infections through facilities or entire geographical regions to gain the insight needed to exert
maximum control
•
Observe HAI trends and report to the NHSN – both to improve healthcare quality and drive reimbursements
Customer examples
Cambridge University Hospital is one of the largest and most highly regarded academic health science centers in the United
Kingdom. This hospital uses QlikView to turn an enormous amount of HAI data into meaningful information that helps ensure
better patient outcomes. For example, the hospital uses QlikView to improve venous thrombosis (VTE) assessment and to
monitor rates of C. diff and MSRA infection in real-time without the need involve IT. Users can focus on specific areas of interest
and hone in on areas that need renewed focus to ensure patient-level improvements. This is helping the hospital save lives.
QlikView for healthcare:
infection control and monitoring
Improving patient outcomes and minimizing healthcare
costs with real-time insight into infection data
Example: clostridium difficile dashboard and analysis
In 20 years as a CEO I have
never seen a better investment from
information systems, it’s as simple
as that. And the return on investment
I think is fabulous. It’s assisted us
improve our VTE assessment, our
C Diff rates, our MRSA rates and
that’s saving lives you know so it does
translate into patient live saves.
— Gareth Goodier, CEO, Cambridge
© 2014 QlikTech International AB. All rights reserved. Qlik®, QlikView®, QlikTech®, and the QlikTech logos are trademarks of QlikTech International AB which have been registered in multiple
qlik.com
Insight Everywhere
Qlik has offices worldwide with expert, friendly staff ready to help you
drive smarter, faster decisions with QlikView.
For contact details please visit:
www.qlik.com/us/company/contact-us Global HeadquartersQlik Technologies, Inc. 150 N. Radnor Chester Road Suite E220
Radnor, PA 19087 Phone: +1 (888) 828-9768 Fax: +1 (610) 975-5987
