Qlik Case Studies Centerstone Research Institute employs QlikView for TDWI award-winning solution

Edit This Case Study Record

	Centerstone Research Institute employs QlikView for TDWI award-winning solution Qlik

Centerstone Research Institute employs QlikView for TDWI award-winning solution

Qlik

Technology Category	Analytics & Modeling - Big Data Analytics Analytics & Modeling - Predictive Analytics Application Infrastructure & Middleware - Data Exchange & Integration Application Infrastructure & Middleware - Data Visualization
Applicable Industries	Education Healthcare & Hospitals
Applicable Functions	Business Operation Quality Assurance
Use Cases	Predictive Maintenance Process Control & Optimization Real-Time Location System (RTLS)
Services	Data Science Services System Integration
Challenge	Centerstone Research Institute (CRI) faced increasing economic pressure as the global economic crisis affected state and local budgets. Funding cuts were proposed at a time when demand for the services Centerstone provides was rising – a “perfect storm” with serious business and clinical implications. To weather the financial pressures without severely cutting services, CRI sought a Business Intelligence/Data Warehousing (BI/DW) solution that would simultaneously improve the quality of care for patients while reducing revenue leaks. CRI’s strategy behind the BI/DW solution was to empower management and staff with easy access to actionable information related to business and clinical practices. Read More
About Customer	Centerstone Research Institute (CRI) is the research affiliate of Centerstone, the USA’s largest not-for-profit provider of community-based behavioral healthcare programs. CRI conducts service and clinical studies and partners with leading research institutions to advance knowledge of mental health and addiction disorders. CRI studies provide behavioral healthcare professionals across the world with new insights and innovative treatment options. Locally, Centerstone serves more than 70,000 individuals and their families annually through a multitude of different programs at more than 120 facilities and 150 community locations. Read More
Solution	With limited financial resources to invest in an enterprise BI solution, CRI combined open source technologies for data warehouse infrastructure (Postgres, Jaspersoft, Pentaho, KNIME) with vendor solutions that add value in targeted areas, including dashboards (QlikView) and predictive modeling (SAS, SPSS). QlikView empowers clinicians, managers and front desk staff through web-accessible dashboards and analysis sourced from the DW’s 132 GB of data across 300 tables, representing more than 1,500,000 clinical services. Examples include Services and Revenue Dashboard, Staff Productivity Dashboard, Admissions Dashboard, Clinical Outcomes Dashboard, Appointments Analysis, and Enterprise Analysis. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Big Data Analytics

Analytics & Modeling - Predictive Analytics

Application Infrastructure & Middleware - Data Exchange & Integration

Application Infrastructure & Middleware - Data Visualization

Applicable Industries

Education

Healthcare & Hospitals

Applicable Functions

Business Operation

Quality Assurance

Use Cases

Predictive Maintenance

Process Control & Optimization

Real-Time Location System (RTLS)

Services

Data Science Services

System Integration

Challenge

Centerstone Research Institute (CRI) faced increasing economic pressure as the global economic crisis affected state and local budgets. Funding cuts were proposed at a time when demand for the services Centerstone provides was rising – a “perfect storm” with serious business and clinical implications. To weather the financial pressures without severely cutting services, CRI sought a Business Intelligence/Data Warehousing (BI/DW) solution that would simultaneously improve the quality of care for patients while reducing revenue leaks. CRI’s strategy behind the BI/DW solution was to empower management and staff with easy access to actionable information related to business and clinical practices.

About Customer

Centerstone Research Institute (CRI) is the research affiliate of Centerstone, the USA’s largest not-for-profit provider of community-based behavioral healthcare programs. CRI conducts service and clinical studies and partners with leading research institutions to advance knowledge of mental health and addiction disorders. CRI studies provide behavioral healthcare professionals across the world with new insights and innovative treatment options. Locally, Centerstone serves more than 70,000 individuals and their families annually through a multitude of different programs at more than 120 facilities and 150 community locations.

Solution

With limited financial resources to invest in an enterprise BI solution, CRI combined open source technologies for data warehouse infrastructure (Postgres, Jaspersoft, Pentaho, KNIME) with vendor solutions that add value in targeted areas, including dashboards (QlikView) and predictive modeling (SAS, SPSS). QlikView empowers clinicians, managers and front desk staff through web-accessible dashboards and analysis sourced from the DW’s 132 GB of data across 300 tables, representing more than 1,500,000 clinical services. Examples include Services and Revenue Dashboard, Staff Productivity Dashboard, Admissions Dashboard, Clinical Outcomes Dashboard, Appointments Analysis, and Enterprise Analysis.

Impact #1	The system helped produce a $12-15 million increase in annual revenue in one year without appreciable increases in cost.
Impact #2	Staff productivity rose 30% and time spent providing clinical service rose 10% for each staff, suggesting a reduction in administrative time.
Impact #3	The quality of services provided also increased, including a 25% rise in treatment plan completion and improvements in clinical consistency such as a 20% rise in case rate eligibility.

Impact #1

The system helped produce a $12-15 million increase in annual revenue in one year without appreciable increases in cost.

Impact #2

Staff productivity rose 30% and time spent providing clinical service rose 10% for each staff, suggesting a reduction in administrative time.

Impact #3

The quality of services provided also increased, including a 25% rise in treatment plan completion and improvements in clinical consistency such as a 20% rise in case rate eligibility.

Benefit #1	Increased revenue by 30%
Benefit #2	Improved staff productivity by 30%
Benefit #3	Improved quality of services by 25%

Benefit #1

Increased revenue by 30%

Benefit #2

Improved staff productivity by 30%

Benefit #3

Improved quality of services by 25%

Download PDF Version

Overview

Centerstone Research Institute employs QlikView for TDWI award-winning solution

Operational Impact

Quantitative Benefit