Case Study

Achieving Hospital Price Transparency with a Powerful Data Platform

Leveraging Databricks and advanced technologies for efficient handling of large Machine-Readable Files (MRFs) and achieving Hospital Price Transparency.

A leading healthcare analytics software provider creates a central data platform to manage large MRF data efficiently, ensuring Hospital Price Transparency with advanced analytics.
Industry & Region: Healthcare IT Services, USA
Technology Stack:
Serverless Cloud Computing Platform: AWS Lambda, Serverless Data Integration Service: Databricks, Analytics Table Format: Databricks Delta, Data Processing Framework: Apache Spark, Data Visualization: Power BI
Client Overview
Our client is a well-known healthcare data analytics solutions enterprise in the US, empowering provider, payer, and payvider organizations to leverage healthcare data more efficiently and create better value in healthcare.
Business Challenge
Under the Hospital Price Transparency rule that came into effect on January 1, 2021, hospitals were publicly disclosing all types of standard charges including payer-specific negotiated charges, de-identified minimum/maximum negotiated charges, and discounted cash prices as mandated. The challenge our client faced was ingesting and utilizing this huge volume of pricing transparency data that was being generated as Machine-readable Files. Comprehending the MRF data using advanced analytics and visualizations was critical for insights and informed decision-making by patients, payers, and healthcare providers. However, their existing data system lacked advanced features to efficiently centralize and leverage the large MRF data to support pricing comparisons and other analytics.
Solution Offered
Our team developed a central data platform to source, transform, and store all MRF data for different data domains including Hospital Price Transparency. The platform was aligned with the latest industry benchmarks and allowed real-time analytics for actionable insights.
Utilizing cutting-edge tools like Databricks, the solution supported speedy ingestion, processing, and transformation of large Machine-readable Files on Hospital Price Transparency from diverse sources. The MRF data was parsed and stored in Databricks Delta tables for efficient querying and analysis.
The integration of the platform with Power BI created interactive and insightful visualizations over a dashboard. It allowed the users to compare the various standard charges associated with names of third-party payers and health plans, along with insights into the medical codes employed by hospitals for accounting or billing purposes.
The advanced analytics capabilities of the data platform also enabled outlier detection, identifying patterns, and flagging data points that fell outside the expected range for accuracy, reliability, and compliance of the pricing information.
Value Delivered
  • One data platform serving all transparency needs.
  • Automated and ‘always-on’ pipelines for data ingestion, transformation, data quality, and metadata management.
  • Secure, compliant, and easy-to-scale-and-maintain big data environment.
  • Improved user experience, decision-making, and innovation.
  • A solid foundation to drive value-based care initiatives.

Are you a healthcare organization looking to build an end-to-end data management platform with advanced analytics capabilities to overcome your data challenges?

Achieving Hospital Price Transparency with a Powerful Data Platform