Alteryx > Case Studies > Alteryx for Healthcare: Streamlining Supply Chain Forecasting

Alteryx for Healthcare: Streamlining Supply Chain Forecasting

Alteryx Logo
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
About The 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.
The 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.
The 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.
Operational Impact
  • 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.
Quantitative Benefit
  • Cut process time by 75%
  • Saved hundreds of hours using Alteryx
  • Anticipate seven figure savings over the course of the next five years due to standardization of items and drugs

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.