Four supportive friends with arm around eachothers shoulders
Customer Story

Change Grow Live

Four supportive friends with arm around eachothers shoulders

Change Grow Live Key Stats

Industry: Not for Profit
Department: BI/Analytics/Data Science
Region: Europe

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

of users and services, with workflows pulling data from multiple systems

to daily reports during COVID, to help support vulnerable service users

The business of changing lives

Change Grow Live is the largest provider of drug and alcohol support services in the UK. With more than 4,000 staff and 1,500 volunteers, Change Grow Live has a wide reach that’s expanded rapidly since it began as an offender rehabilitation initiative in 1977. More than 100,000 individuals come to Change Grow Live every year for structured support, covering everything from overcoming opioid addictions to escaping domestic violence.

“We’re in the business of changing people’s lives,” explains Jeff Crouch, Director of Information at Change Grow Live. “It’s about making people healthier and happier. And in some cases, we’re genuinely helping keep people alive.”

Change Grow Live’s programs are supported by a central team of data analysts and scientists, as well as individual teams working with specific services. “We support the organization with good information,” says Crouch. “Our analysis helps people make better decisions, both on the front line and at the executive level.”

As a fast-growing organization, Change Grow Live’s leadership needed a lot of different monthly and quarterly reports to monitor its progress, which the team created and presented using Microsoft Excel. But additional ad hoc analysis requests meant Crouch and his team didn’t have the time or resource to focus on Change Grow Live’s future — or turn their vast stores of data into deeper insight.

“Excel is great for many applications, but it has drawbacks at an enterprise level. Processing and analyzing data in spreadsheets is repetitive, tedious, and potentially error-prone when it’s so manual,” says Crouch. “When you present your findings there are always more questions, and our spreadsheets couldn’t answer them fast enough. After 10 years of huge growth, Excel was creaking.”

With the go-ahead from executives to review Change Grow Live’s data model, Crouch and his team worked with consultancy TrueCue to find the best solution — one that would do justice to the data they had, and help support vital community services.


Switching out Change Grow Live’s engine

Change Grow Live strives to be an agile organization, one that responds to changes quickly. That meant the team needed a data analytics solution that could slot into their infrastructure without disrupting the crucial analytics function Crouch had built.
“We didn’t want a clunky data warehouse,” says Crouch. “And it needed to fit neatly. I liken it to changing the engine while the plane is still flying; it had to be seamless, or it would impact the whole organization.”
Change Grow Live chose Alteryx Designer, implementing analytic process automation alongside Tableau for an end-to-end analytics process that handles everything from ingestion to presentation. It pulls data from 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 has proved popular with the team, especially when Change Grow Live brought new graduates into the team. “The first task we gave them was to optimize our Alteryx workflows and improve efficiency,” says Crouch. “We’re confident enough to say that new recruits don’t need experience with Alteryx — just the enthusiasm to learn.”
Because it’s easy to optimize and adapt workflows, Crouch’s team hasn’t had to rip and replace processes as the organization’s needs have evolved. “We’re still using Alteryx workflows from four or five years ago,” explains Crouch. “All we need to do is make small changes to accommodate new requirements.”

Alteryx met our skillset well. The drag and drop interface is such a fast way to work — and you can just download it and get going. We knew Alteryx had options for scheduling too, which meant it could scale with us.

From business as usual to tackling unprecedented challenges

“We went through everything that was done manually, and automated absolutely everything we could. Days and weeks of time turned into minutes — and all that extra time can be reinvested into delivering more valuable insights,” says Crouch.
One of Change Grow Live’s most significant reports, the ‘Structured Treatment Report’, which details key activity across all its services, and displays performance figures, averages, and trends, previously took most of a working week to produce, every month. It was the first workflow they rebuilt in Alteryx — and now it takes less than a minute to produce.
The team had been working with Alteryx for several years, building an analytics function that was integral to Change Grow Live’s operation, when it encountered a new challenge: how to deliver vital, life-saving services when the world shuts down.
Like other health organizations, Change Grow Live’s services were hugely impacted by COVID-19 shutdowns; moving to digital service isn’t easy when you’re supporting more than 34,000 people on medication-assisted recovery programs.
Access to opioid alternatives, such as methadone, is crucial for helping maintain service users’ wellbeing and preventing them from relapsing. But many of Change Grow Live’s service users are considered clinically vulnerable, which meant the organization needed to ensure they had reliable access to their medication — and face-to-face support when they needed it. “We had to act quickly to support our most vulnerable service users, so data was front and center of our COVID response,” says Crouch.
Change Grow Live’s monthly reports became daily reports, with the data and analytics team running Alteryx workflows out-of-hours to deliver updates first thing every morning. To start with, this process required an analyst to manually trigger each workflow individually at 5 AM, but implementing Alteryx Server means Change Grow Live can now automatically run all its workflows together.
By combining millions of rows of data, from various systems and sources, Change Grow Live leadership can 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. And these changes driven by COVID will support service improvements for years to come.

Using the data and working as quickly as we did was a huge factor in keeping our service users safe in our response to COVID.

Building on the foundation with predictions and forecasting

Working with Alteryx has helped Crouch and his team build up the profile of the data and analytics function within Change Grow Live and beyond. “People lose faith if they receive wonky data,” says Crouch. “Working in Alteryx and Tableau helps build credibility and professionalism, especially with external organizations like the Care Quality Commission.”

With its workflows built in Alteryx Designer and scheduled using Alteryx Server, Crouch’s team is now working on the next stages of analytics maturity. For example, Change Grow Live’s services collect a huge amount of unstructured data through case notes, referral letters, and other documents. One of the team’s pipeline projects is looking at text mining and semantic analytics to pull data directly from those sources, adding yet more detail to their insights. There’s also scope to explore predictive analytics, assessing and forecasting the impact of different risk factors on service users.

Every decision Crouch’s team makes — and every workflow it builds — ultimately supports vital care and support for vulnerable people throughout the UK, underpinned by data and deep insight.

Assess Your ROI Potential

image
abstract image
Blog
3 min to read

Top Priorities for Corporate Tax Departments

The success of tax departments depends on the establishment of a balance between the demands of technology and employees’ needs rather than the number of technical solutions it has at its disposal.

Alteryx Platform
Analytics Leader
Business Leader
Read Now
abstract image
Blog
5 min to read

How to Increase ROI Through Data Democratization 

See 4 things you should do to increase ROI through democratization.

Analyst
Analytics Leader
Business Leader
Read Now
abstract image
Blog
5 min to read

Why Alteryx is a Better Choice for Enterprise Analytics

Why Alteryx is a better choice for organizations that want to experience a unified analytics platform that is easy to use and upskills your existing workforce to enable a democratized approach to data.

Business Leader
Analytics Leader
Alteryx Platform
Read Now

Transform Your Analytics

Get ready to unlock hidden insights in your data.