On Demand: More than Meets the Eye: Assessing The Value of a Structural Heart Program-Q&A

Q&A

Pdf Summary

The document outlines the analytical approach taken by MedAxiom in evaluating healthcare service lines, specifically focusing on pre- and post-procedure visits linked to Transcatheter Aortic Valve Replacement (TAVR). The analysis considers a 'halo' period that includes data 30 days before and up to 90 days after an initial clinic visit to examine financial and clinical performance impacts. An earlier model looked at a broader timeframe, examining 12 months before and after the TAVR procedure.<br /><br />All patients who had an index clinic visit are included in the analysis, irrespective of DRG assignment changes due to complications, though the system allows filtering out such outliers. Regarding cost allocations, care is taken to avoid double-counting of services across different cost centers, though this can affect profitability assessments in these areas. The analytical suite provides varied insights across its modules and answers different operational questions.<br /><br />Data for the analysis is sourced from an integrated enterprise data lakehouse/warehouse, which gathers information from Epic, McKesson Performance Manager, ARMUS, and external datasets. SQL is utilized to develop the data marts, while Power BI is the primary tool for data visualization, providing flexibility in reporting, complemented by input from finance and accounting departments. Historically, Tableau was also used.<br /><br />The project initially faced challenges in accessing data but benefited significantly from increased administrative support and centralized data departments over time. Key performance indicators tracked include case volumes, year-over-year (YOY) trends, financial performance metrics such as payor mix, charges, payments, and direct costs, along with quality outcomes like length of stay, mortality, and readmission rates. Overall, the collaboration with various stakeholders is emphasized as critical to the successful implementation and adoption of these analytic tools.

Keywords

MedAxiom

healthcare service lines

Transcatheter Aortic Valve Replacement

TAVR

financial performance

clinical performance

data lakehouse

Power BI

key performance indicators

stakeholder collaboration