Alteryx Case Studies Alteryx for Healthcare: Streamlining Supply Chain Forecasting

Edit This Case Study Record

	Alteryx for Healthcare: Streamlining Supply Chain Forecasting Alteryx

Alteryx for Healthcare: Streamlining Supply Chain Forecasting

Alteryx

Technology Category	Cybersecurity & Privacy - Identity & Authentication Management Functional Applications - Inventory Management Systems
Applicable Industries	Healthcare & Hospitals Pharmaceuticals
Applicable Functions	Logistics & Transportation Warehouse & Inventory Management
Use Cases	Leasing Finance Automation Time Sensitive Networking
Challenge	The Supply Chain Analytics team at an American healthcare provider was facing a significant challenge. They were spending a considerable amount of time pulling and prepping data, which left minimal time for actual analysis. The team was primarily using Excel, which was not only time-consuming but also hindered any potential cost savings for the department. The team wanted to automate the process but lacked the necessary expertise. While they were proficient in Excel and Tableau, they had limited experience in automation or coding. After researching various software, they found that most required extensive knowledge of Python and R, which they did not possess. They discovered Alteryx, which was user-friendly and had extensive out-of-the-box functionality. Read More
About Customer	The customer in this case study is an American healthcare provider. They have several facilities across a variety of different departments. Their Supply Chain Analytics team was previously spending a lot of time pulling and prepping data, leaving little time for actual analysis. The team was proficient in Excel and Tableau but had limited experience in automation or coding. They were looking for a solution that would allow them to automate their processes and spend less time on data wrangling and more time on analysis to impact their bottom line. Read More
Solution	Alteryx provided the healthcare provider with a streamlined solution to analyze and make decisions for their supply chain organization. The software allowed the team to reduce their spend and optimize efficiency across different departments and practices. The team used Alteryx to automate their main method to pull data for the Opportunity Analysis. This process, which previously took over 40 hours of weekly scrubbing and data prep, was now automated and repeatable. The data analysts could then easily organize and analyze the findings in Tableau to make strategic decisions on supplier standardization, conversion, and cost information. Alteryx also allowed the team to monitor maverick buying of items, providing an increased level of granularity that enabled them to identify opportunities to minimize spend. The team is currently using Alteryx for a data-driven project to engage physicians to identify and standardize the use of items and drugs to produce the same outcomes at a lower cost. Read More Log in to view content
Contents

Technology Category

Cybersecurity & Privacy - Identity & Authentication Management

Functional Applications - Inventory Management Systems

Applicable Industries

Healthcare & Hospitals

Pharmaceuticals

Applicable Functions

Logistics & Transportation

Warehouse & Inventory Management

Use Cases

Leasing Finance Automation

Time Sensitive Networking

Challenge

The Supply Chain Analytics team at an American healthcare provider was facing a significant challenge. They were spending a considerable amount of time pulling and prepping data, which left minimal time for actual analysis. The team was primarily using Excel, which was not only time-consuming but also hindered any potential cost savings for the department. The team wanted to automate the process but lacked the necessary expertise. While they were proficient in Excel and Tableau, they had limited experience in automation or coding. After researching various software, they found that most required extensive knowledge of Python and R, which they did not possess. They discovered Alteryx, which was user-friendly and had extensive out-of-the-box functionality.

About Customer

The customer in this case study is an American healthcare provider. They have several facilities across a variety of different departments. Their Supply Chain Analytics team was previously spending a lot of time pulling and prepping data, leaving little time for actual analysis. The team was proficient in Excel and Tableau but had limited experience in automation or coding. They were looking for a solution that would allow them to automate their processes and spend less time on data wrangling and more time on analysis to impact their bottom line.

Solution

Alteryx provided the healthcare provider with a streamlined solution to analyze and make decisions for their supply chain organization. The software allowed the team to reduce their spend and optimize efficiency across different departments and practices. The team used Alteryx to automate their main method to pull data for the Opportunity Analysis. This process, which previously took over 40 hours of weekly scrubbing and data prep, was now automated and repeatable. The data analysts could then easily organize and analyze the findings in Tableau to make strategic decisions on supplier standardization, conversion, and cost information. Alteryx also allowed the team to monitor maverick buying of items, providing an increased level of granularity that enabled them to identify opportunities to minimize spend. The team is currently using Alteryx for a data-driven project to engage physicians to identify and standardize the use of items and drugs to produce the same outcomes at a lower cost.

Impact #1	The implementation of Alteryx has had a profound impact on the way the healthcare provider operates. The software has enabled the team to make a real impact and drive business outcomes. They now spend less time on data wrangling and more time performing analysis to impact their bottom line. The team has been able to automate their main method to pull data for the Opportunity Analysis, which has significantly reduced the time spent on data prep. They can now easily organize and analyze the findings in Tableau to make strategic decisions. The team has also been able to monitor maverick buying of items, providing an increased level of granularity that has enabled them to identify opportunities to minimize spend.

Impact #1

The implementation of Alteryx has had a profound impact on the way the healthcare provider operates. The software has enabled the team to make a real impact and drive business outcomes. They now spend less time on data wrangling and more time performing analysis to impact their bottom line. The team has been able to automate their main method to pull data for the Opportunity Analysis, which has significantly reduced the time spent on data prep. They can now easily organize and analyze the findings in Tableau to make strategic decisions. The team has also been able to monitor maverick buying of items, providing an increased level of granularity that has enabled them to identify opportunities to minimize spend.

Benefit #1	Cut process time by 75%
Benefit #2	Saved hundreds of hours using Alteryx
Benefit #3	Anticipate seven figure savings over the course of the next five years due to standardization of items and drugs

Benefit #1

Cut process time by 75%

Benefit #2

Saved hundreds of hours using Alteryx

Benefit #3

Anticipate seven figure savings over the course of the next five years due to standardization of items and drugs

Download PDF Version

Overview

Alteryx for Healthcare: Streamlining Supply Chain Forecasting

Operational Impact

Quantitative Benefit