blue hexagon pattern
Customer Story

The Salvation Army Improves Data Migration Process By 5x With Alteryx

The Salvation Army Key Stats

Industry: Non-Profit
Department: Business Intelligence
Region: Asia-Pacific

hours saved in manual effort

workers in Workday migration

+ automated migrations

Automating the migration of 10,000 worker records into Workday

As one of the world’s largest social welfare organizations, and with more than 1,650,000 members working in over 128 countries, it’s safe to say The Salvation Army has a large headcount to track. This was especially true for the organization’s Australian territory known as Salvos, as they house numerous job categories including officers, volunteers, workers, and independent contractors.

So when Sambit Das, a Workday Data Test Lead, was assigned to the Salvos project of migrating over 200,000 rows of data for 10,000 workers from multiple legacy systems into Workday, he knew he was in for a challenge. “The state of systems and data flow at Salvos was complex, with no single source of truth of the national workforce,” Das says. “The sheer volume of historical data was overwhelming. It was duplicated, unlabeled and unharmonized in different systems like Microsoft Excel spreadsheets and hard copy files. Creating organizational reports such as national level workforce reporting, tracking integrity checks, and training compliance data was time-consuming.”

“We needed a solution that could automate our data migration and transformation processes in an easy and repeatable way.”

salvation-army-sambit-square-portrait

Sambit Das
Workday Data Test Lead
Salvation Army

If we quantified savings from all of our Alteryx workflows that were developed, we have easily generated savings of over 2,000 hours of manual effort to date.

Finding a solution that automated a complex analytic workflow

“My search for a solution led to the paper Alteryx Workday Data Migration by Cynthia Eckles (an employee of Alteryx), who had used Alteryx to support Workday data migration in 2018,” Das says. “I decided to reach out to her on LinkedIn, and after a video chat with her, I was inspired to use Alteryx as the data migration and transformation tool for this daunting task.

“It was very exciting to use the platform as a beginner,” Das continues. “I had never been so excited in my career to use a solution on a day-to-day basis that has the power Alteryx does to solve these challenging tasks. You could visually see the data being cleaned in each step of the workflow.

During the multiple rounds of data loading and cleansing, Das and his team used Alteryx to automate and optimize a series of mundane and complex processes, including:

  • Transform raw data into Workday workbooks, then validate and confirm that the data in the current system matched what was in Workday
  • Optimize business processes to determine which role can initiate, approve, review, and complete a business process within Workday
  • Generate a live feed of data from Workday to transform, clean, and transfer the data to the third-party system IPS
  • Automate data validations for Workday data migration
  • Conduct real-time data audits of Workday to make sure we were constantly reviewing and cleaning data issues that may impact upcoming payroll runs
“We were able to automate and develop a repeatable data migration process that made my team’s lives much easier, and it enabled us to work through the migration process at a much quicker pace than it would have it if we did this manually,” Das Says

3 reasons The Salvation Army Chose Alteryx:

image

01

Easy, repeatable automation
image

02

Drag-and-drop functionality
image

03

Ability to configure and integrate to other systems

One solution for thousands of hours saved

“If we quantified savings from all of our Alteryx workflows that were developed, we have easily generated savings of over 2,000 hours of manual effort to date,” Das Says. “Additionally, the Platform gave us the ability to be able to prototype data migration with a live dataset through the various data cycles, and payroll parallel runs enabled us to keep reducing lead time.

“My program manager was able to see the value right away, so it’s been easy for team leads to pick up on the time savings and want to learn more for themselves as well.”



I had never been so excited in my career to use a solution on a day-to-day basis that has the power Alteryx does to solve these challenging tasks.

What's Next?

Building a culture of analytics, one step at a time

So what's next? For a large, data-dependent organization like The Salvation Army, a Platform like Alteryx that allows anyone to perform drag-and-drop data blending, analytics, and data science is a key to enabling a shift in culture from manual and painful to automated and powerful.

“Our department heads are seeing the power of the Platform and the effort that it can save for manual work, so now it’s being introduced across other departments like the procurement team. People are now celebrating data work that’s being done in Alteryx, which is not something you typically see out of data-heavy projects,” Das says.

What’s next for Das and his team? “We’re looking at completing a phase two of the migration, which would be to migrate 30,000 to 40,000 worker and volunteer data into Workday,” Das says. “I also think we are going to take advantage of the predictive analytics and assisted modeling capabilities in Alteryx to tackle other projects. The data we are working with is huge across the organization, so it will be important to use that culture of analytics we are slowly but surely creating here.”

Share the insights with your team


roi-calculator

Analytic Automation that adds up

With Alteryx Analytic Process Automation™, organizations can realize top-line growth, bottom-line savings, risk reduction, and efficiency gains.
Wavy colorful lines intersecting
Blog Post
3 min to read

2021 Alteryx Podcast Wrap-up

In this special crossover podcast episode, hosts Maddie Johannsen and Susan Currie Sivek relive some of their favorite standout moments and special guests.

Analyst
Analytics Leader
Data Scientist
Read Now
BT Group small hero
Customer Story
5 min to read

How BT is Automating Regulatory Compliance with Alteryx and PwC

BT and PwC prioritized speed, transparency, and knowledge management to achieve amazing results including a 75% reduction in time to insight.

Analyst
Data Scientist
Analytics Leader
Read Now
Image of HTML code
Use Case
4 min to read

Customer Account Segmentation

Gain a data-driven understanding of customer accounts to optimize interactions at scale

Education
Energy & Utilities
Entertainment & Media
Read Now

Put your data to work

86% of new Alteryx users deliver business value in their first week. Join thousands of practitioners who are breaking data barriers and dragging and dropping their way to insights.

Man and woman working at desk

Free Trial

Experience the power and ease of Alteryx