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

Edit This Case Study Record

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

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

Alteryx

Technology Category	Analytics & Modeling - Big Data Analytics Analytics & Modeling - Predictive Analytics
Applicable Industries	Cement Mining
Use Cases	Inventory Management Time Sensitive Networking
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Big Data Analytics

Analytics & Modeling - Predictive Analytics

Applicable Industries

Cement

Mining

Use Cases

Inventory Management

Time Sensitive Networking

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.

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

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.

Impact #1	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.

Impact #1

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.

Benefit #1	Saved a full week of working time every month, now producing a key report in just one minute
Benefit #2	Switched from monthly to daily reports during COVID, to help support vulnerable service users
Benefit #3	Automated manual processes, turning days and weeks of work into minutes

Benefit #1

Saved a full week of working time every month, now producing a key report in just one minute

Benefit #2

Switched from monthly to daily reports during COVID, to help support vulnerable service users

Benefit #3

Automated manual processes, turning days and weeks of work into minutes

Download PDF Version

Overview

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

Operational Impact

Quantitative Benefit