Technology Category
- Analytics & Modeling - Big Data Analytics
- Analytics & Modeling - Real Time Analytics
Applicable Industries
- Cement
- Healthcare & Hospitals
Applicable Functions
- Maintenance
- Quality Assurance
Use Cases
- Behavior & Emotion Tracking
- Leakage & Flood Monitoring
Services
- System Integration
- Testing & Certification
About The Customer
The customer in this case study is a $2.5 billion health system in the Southeast undergoing an Epic EHR conversion. They sought HCPA’s help for go-live revenue monitoring. The health system was facing challenges due to the vast undertaking of implementing an EHR, which if not managed properly, could lead to significant financial issues. The health system needed to understand the effects of changes on revenue and required insights necessary for accurate revenue capture. They were also dealing with factors like revenue volatility, annual pricing adjustments, natural disasters, and the volume of historical data, which made establishing a performance baseline extremely difficult.
The Challenge
Health Care Program Advisors (HCPA), a boutique healthcare consulting firm based in Atlanta, Georgia, specializes in revenue cycle management, information systems, business intelligence, and clinical and operations performance excellence. They partner with prestigious hospitals and health systems across the nation. One of the significant challenges they face is assisting health systems in mitigating adverse financial consequences during electronic health record (EHR) implementations. EHRs are designed to maintain patient health records, streamline administrative tasks like scheduling and billing, and maintain accuracy and patient safety. However, implementing an EHR is a vast undertaking and can often leave health systems with significant financial issues if not managed properly. HCPA uses Alteryx for revenue monitoring before and after implementation, assisting health systems in understanding the effects of changes on revenue and offering insights necessary for accurate revenue capture. However, factors like revenue volatility, annual pricing adjustments, natural disasters, and the volume of historical data make establishing a performance baseline extremely difficult without advanced tools.
The Solution
To appropriately baseline and assess revenue, HCPA leveraged Alteryx, a tool capable of analyzing historical revenue, generating baselines to measure conversion performance, and identifying issues in real time. Using Alteryx Designer, HCPA cleansed data from various sources, normalized pricing changes over a four-year timeframe, and evaluated impacts to revenue such as growth, seasonality, and COVID. Designer’s fuzzy matching capabilities were crucial in matching mis-mapped revenue across the health system. The real game-changer was the ability to combine Alteryx with other business intelligence tools for a seamless end-to-end process. HCPA used Snowflake, Alteryx, and Tableau to drive real-time insights for its client. Snowflake was used to create a single source of truth that made datasets more standardized and accessible. Tableau was key to the revenue monitoring project because visualizations helped the client see the comparisons between the baseline and current performance in real time, allowing for corrective action to mitigate adverse financial impact.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
System 800xA at Indian Cement Plants
Chettinad Cement recognized that further efficiencies could be achieved in its cement manufacturing process. It looked to investing in comprehensive operational and control technologies to manage and derive productivity and energy efficiency gains from the assets on Line 2, their second plant in India.
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
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.
Case Study
HaemoCloud Global Blood Management System
1) Deliver a connected digital product system to protect and increase the differentiated value of Haemonetics blood and plasma solutions. 2) Improve patient outcomes by increasing the efficiency of blood supply flows. 3) Navigate and satisfy a complex web of global regulatory compliance requirements. 4) Reduce costly and labor-intensive maintenance procedures.