Download PDF
Qlik > Case Studies > Centerstone Research Institute employs QlikView for TDWI award-winning solution
Qlik Logo

Centerstone Research Institute employs QlikView for TDWI award-winning solution

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
The 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 The 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.
The 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.
Operational Impact
  • The system helped produce a $12-15 million increase in annual revenue in one year without appreciable increases in cost.
  • Staff productivity rose 30% and time spent providing clinical service rose 10% for each staff, suggesting a reduction in administrative time.
  • 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.
Quantitative Benefit
  • Increased revenue by 30%
  • Improved staff productivity by 30%
  • Improved quality of services by 25%

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.