Alteryx > Case Studies > Transforming Drug and Alcohol Support Services with IoT: A Case Study on Change Grow Live

Transforming Drug and Alcohol Support Services with IoT: A Case Study on Change Grow Live

Alteryx Logo
Technology Category
  • Analytics & Modeling - Big Data Analytics
  • Analytics & Modeling - Predictive Analytics
Applicable Industries
  • Cement
  • Mining
Use Cases
  • Inventory Management
  • Time Sensitive Networking
About The Customer
Change Grow Live is the largest provider of drug and alcohol support services in the UK. The organization, which began as an offender rehabilitation initiative in 1977, has expanded rapidly and now has more than 4,000 staff and 1,500 volunteers. Each year, over 100,000 individuals come to Change Grow Live for structured support, covering everything from overcoming opioid addictions to escaping domestic violence. The organization's programs are supported by a central team of data analysts and scientists, as well as individual teams working with specific services. The organization strives to be agile, responding quickly to changes and supporting its most vulnerable service users.
The Challenge
Change Grow Live, the largest provider of drug and alcohol support services in the UK, was facing challenges in managing and analyzing its vast data. The organization, which supports over 100,000 individuals annually, was relying on Microsoft Excel for creating monthly and quarterly reports to monitor its progress. However, the manual and repetitive nature of processing and analyzing data in spreadsheets was proving to be tedious and error-prone. Furthermore, the organization's rapid growth over the past decade had stretched Excel's capabilities to its limits. The additional ad hoc analysis requests were also straining the resources of the central team of data analysts and scientists, preventing them from focusing on the organization's future or deriving deeper insights from the data.
The Solution
To overcome these challenges, Change Grow Live collaborated with consultancy TrueCue to review its data model and find a suitable solution. The organization chose Alteryx Designer, implementing analytic process automation alongside Tableau for an end-to-end analytics process. This solution pulls data from various sources, including health records, referrals, assessment reports, prescription systems, discharge forms, and Change Grow Live’s case management system, to create holistic views of users and services. Alteryx’s simple user interface proved popular with the team, allowing them to optimize and adapt workflows as the organization’s needs evolved. The implementation of Alteryx Server enabled the organization to automatically run all its workflows together, combining millions of rows of data from various systems and sources. This allowed the leadership to segment the data at service, region, and individual service user level to identify who needs more support and the best way to deliver it safely.
Operational Impact
  • The implementation of Alteryx Designer and Tableau has transformed the way Change Grow Live manages and analyzes its data. The organization has been able to automate manual processes, saving significant amounts of time that can now be reinvested into delivering more valuable insights. The solution has also enabled the organization to respond quickly to changes, such as the COVID-19 pandemic, by switching from monthly to daily reports to better support its vulnerable service users. Furthermore, the credibility and professionalism of the data and analytics function within Change Grow Live have been enhanced, building trust with external organizations like the Care Quality Commission. The organization is now exploring the next stages of analytics maturity, including text mining, semantic analytics, and predictive analytics.
Quantitative Benefit
  • Saved a full week of working time every month, now producing a key report in just one minute
  • Switched from monthly to daily reports during COVID, to help support vulnerable service users
  • Automated manual processes, turning days and weeks of work into minutes

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

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.