No te pierdas Inspire 2024, que se llevará a cabo del 13 al 16 de mayo de 2024 en The Venetian, Las Vegas. Regístrate ahora.

Customer Story

Change Grow Live

 

Change Grow Live Key Stats

Industry: Not For Profit

Department: BI/Analytics/Data Science

Region: Europe

Saved a full week

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

Created a holistic view

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

Switched from monthly

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

 

3 Reasons Change Grow Live Chose Alteryx

Creating meaningful insights:

Executives and frontline service providers can pull actionable insights from data.

Powerful workflows, simple management:

Teams can build workflows without previous Alteryx experience, and old workflows can be updated with ease.

Raising the profile of analytics — and the organization:

Detailed, reliable insights help the team build credibility both within the organization and with external partners.

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.

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.

 

Recommended Resources

 
Customer Story
Gregory Welteroth Improves Marketing ROI With Alteryx
GWA helps clients gain a competitive advantage by using data insights to reach more potential customers.
  • Analytics Automation
  • Process Automation
  • Analytics Leader
Learn More
 
Customer Story
Siemens Energy democratizes data to support digitalization
Global energy company powers digital transformation and saves 1000s of hours of manual work.
  • Process Automation
  • Business Leader
  • BI/Analytics/Data Science
Learn More
 
Customer Story
Growing a data-culture, naturally, at Roquette
A global leader in plant-based ingredients implemented Alteryx to enable strategic decision-making at scale.
  • Data Prep and Analytics
  • Data Science and Machine Learning
  • Process Automation
Learn More