Dimensional Model facilitates care gap in Analysis for Healthcare Payer

GOING DEEPER ON THEIR CHALLENGE

A nationally recognized health insurance organization has been hampered with slow data processing times affecting important HEDIS reporting initiatives across the entire organization. This is a direct result of a stale data model which has been setup to store data in multiple locations. To make matters worse, the internal engine is managed using a Run ID time frame.

Because of this, users are required to have a firm understanding of Run ID protocol in order to extract the appropriate data from the appropriate hub. To compound the issue, the data is riddled with unnecessary fields that serve no real business purpose and causing confusion amongst end-users only further slowing down data processing and analysis & reporting capabilities.

UNDERSTANDING DATA IDEOLOGY’S SOLUTION

After a thoughtful discovery session, our team determined that a redesign of the current model into a modern dimensional model was needed to successfully consolidate the organization’s data. Ultimately, this would support faster processing times for their business intelligence resources as well as help the organization realize the strength of a single source of truth.

It was also determined that the Run ID protocol needed to be removed from the model to give users access to a time-based and event-date-based system to elevate their HEDIS program. As part of the redesign, our team would also ensure that data types were uniformed and removed unnecessary fields that may cause confusion among the end-users.

THE RESULTS

Effective communication with the organization’s business segments to answer specific questions regarding processes, use cases, data structure, and organizational needs allowed for the successful redesign of the data model which prioritized the consolidation of disparate data hubs into a central repository resulting in improved processing speeds and enhanced data visualization capabilities. We were also able to create dimensional models for specific HEDIS data that had never been exposed such as NCQA Benchmarking Data, CMS Stars Ratings, and RxAnte while continuing to provide product owners with their specific visions and requirements.

This sophisticated redesign was also able to remove Run ID protocol allowing for longitudinal HEDIS reporting. As a result of our data solutions, the payer organization was able to:

• Produce consolidated dashboards
• Efficiently identify gaps in care
• Delineate areas for targeted outreach
• Detect opportunities for provider billing education

These dashboards were also able to track the direct impact of outreach and provider education campaigns over time to determine the most effective approach.