🤦‍♂️Why are Aetna's Price Transparency Files Absurdly Large? ...ZOMBIE RATES (aka Not Applicable Rates) 🧟‍♂️💀

⛏ Only 309 (0.05%) out of 638,094 Rates for Knee Arthroscopies in TX, were global rates associated with an Orthopedic Surgeon. This is just one example of the process the BSI Analytics Engine goes through to filter and sift MRF data. 📊🔍

Instead of 174GBs, the BSI filters could shrink this file to less than 9GBs.📉

I want to emphasize that not all of the Aetna MRF data is bad, but you need significant expertise to filter through all of the irrelevant Zombie Rates to capture useful information.

Reach out if you'd like to learn more about how Bright Spot Insights can help your organization. 💡🤝

👨‍💻Analysis Conducted by: Bright Spot Insights

Aetna Tx In Network – Filtering Zombie Rates(2023-05-23).pdf