Download PDF
Alteryx for Healthcare: Streamlining Supply Chain Forecasting
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
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.
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 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
Quantitative Benefit
Related Case Studies.
Case Study
Case Study: Pfizer
Pfizer’s high-performance computing software and systems for worldwide research and development support large-scale data analysis, research projects, clinical analytics, and modeling. Pfizer’s computing services are used across the spectrum of research and development efforts, from the deep biological understanding of disease to the design of safe, efficacious therapeutic agents.
Case Study
Hospital Inventory Management
The hospital supply chain team is responsible for ensuring that the right medical supplies are readily available to clinicians when and where needed, and to do so in the most efficient manner possible. However, many of the systems and processes in use at the cancer center for supply chain management were not best suited to support these goals. Barcoding technology, a commonly used method for inventory management of medical supplies, is labor intensive, time consuming, does not provide real-time visibility into inventory levels and can be prone to error. Consequently, the lack of accurate and real-time visibility into inventory levels across multiple supply rooms in multiple hospital facilities creates additional inefficiency in the system causing over-ordering, hoarding, and wasted supplies. Other sources of waste and cost were also identified as candidates for improvement. Existing systems and processes did not provide adequate security for high-cost inventory within the hospital, which was another driver of cost. A lack of visibility into expiration dates for supplies resulted in supplies being wasted due to past expiry dates. Storage of supplies was also a key consideration given the location of the cancer center’s facilities in a dense urban setting, where space is always at a premium. In order to address the challenges outlined above, the hospital sought a solution that would provide real-time inventory information with high levels of accuracy, reduce the level of manual effort required and enable data driven decision making to ensure that the right supplies were readily available to clinicians in the right location at the right time.
Case Study
Gas Pipeline Monitoring System for Hospitals
This system integrator focuses on providing centralized gas pipeline monitoring systems for hospitals. The service they provide makes it possible for hospitals to reduce both maintenance and labor costs. Since hospitals may not have an existing network suitable for this type of system, GPRS communication provides an easy and ready-to-use solution for remote, distributed monitoring systems System Requirements - GPRS communication - Seamless connection with SCADA software - Simple, front-end control capability - Expandable I/O channels - Combine AI, DI, and DO channels
Case Study
Fusion Middleware Integration on Cloud for Pharma Major
Customer wanted a real-time, seamless, cloud based integration between the existing on premise and cloud based application using SOA technology on Oracle Fusion Middleware Platform, a Contingent Worker Solution to collect, track, manage and report information for on-boarding, maintenance and off-boarding of contingent workers using a streamlined and Integrated business process, and streamlining of integration to the back-end systems and multiple SaaS applications.
Case Study
Driving Digital Transformations for Vitro Diagnostic Medical Devices
Diagnostic devices play a vital role in helping to improve healthcare delivery. In fact, an estimated 60 percent of the world’s medical decisions are made with support from in vitrodiagnostics (IVD) solutions, such as those provided by Roche Diagnostics, an industry leader. As the demand for medical diagnostic services grows rapidly in hospitals and clinics across China, so does the market for IVD solutions. In addition, the typically high cost of these diagnostic devices means that comprehensive post-sales services are needed. Wanteed to improve three portions of thr IVD:1. Remotely monitor and manage IVD devices as fixed assets.2. Optimizing device availability with predictive maintenance.3. Recommending the best IVD solution for a customer’s needs.
