Health Care Company -

Health Care Company

This Revenue Cycle Management Reporting solution provides a fully automated dashboard with a consolidated view of claims and payment data that is drillable for all levels of management within 24 hours of the data being available.

Client Challenges

This health plan's enormous amounts of data, combined with manual financial reporting processes, resulted in time-consuming, labor-intensive revenue cycle management and a reliance on Excel spreadsheets for revenue cycle management. Meanwhile, executives and finance analysts continued to lack timely, convenient access to revenue reports and data.

  • Time-consuming aggregation of data. Aggregating revenue figures on a monthly basis required one to two weeks.
  • Poor visibility to key metrics, trends and issues. The revenue cycle management staff’s current dashboard provided slow, inconvenient access to a limited number of metrics. Users had no visibility to a number of key metrics required or a way to identify important trends and issues at a glance.
  • Manual data manipulation. To compile needed data and create many regular and ad hoc reports at the Extract Transformation and Load (ETL) level, analysts were forced to retrieve raw transaction data from a source data mart that could contain literally billions of transactions and required hours to generate the queries to export into Excel. Analysts would then perform calculations and roll up data to another level.
  • Inefficient distribution of reports restricted to limited users without appropriate security. To create financial reports, finance analysts relied on manual processes of manipulating Excel spreadsheets on an ad hoc and regular monthly basis. These spreadsheets would then be distributed–without appropriate security–to executives only, even though the content was useful to financial analysts throughout the company
Senturus Solution

Senturus successfully leveraged the client's existing investment in its self-service reporting environment and delivered a dramatically improved dashboard that enabled the client for the first time to easily analyze massive amounts of data from eight divisions.

Using the client's existing self-service reporting environment, Senturus built out the “Business Intelligence Stack” to provide the conformed dimensions and reporting layer necessary to meet revenue cycle management requirements. The meta-data layer transforms the existing database and fields into standard business-related descriptions for a fully self-service reporting environment. Clients can access summary tables in Framework Manager, extract data and create reports.

  • The reporting layer provides database access, a significant improvement over analysts’ former reliance on SQL to extract data, enter and manipulate figures using Excel spreadsheets, and then distributing the spreadsheets to individuals. This process is now automated: enabling finance analysts to easily generate and distribute standard and ad hoc reports more quickly, efficiently and securely.
  • Multi-Dimensional Reporting Expression (MDX) is used to create multi-dimensional OLAP cubes for reporting. Summary level data is modeled into cubes that now have pre-aggregated data associated with summary level reporting. As a result, reports can be run against the database in one-hundredth of the time, and analysts can “slice and dice” data to create reports quickly, and in real time.

Equipped with Senturus’ solution, financial analysts receive a fully automated and aggregated monthly dashboard in less than 24 hours after data has been audited across the entire organization instead of waiting as much as two weeks to access the dashboard. The new dashboards highlight issues, irregularities and trends, using user-friendly directional arrows, color codes and other techniques. The revenue cycle management group is able to produce multiple reports and distribute critical information across the entire organization that gives not just executives, but also finance managers throughout the company, the ability to manage their organization.

About the Client

One of the nation’s largest not-for-profit health care companies, this healthcare provider employs approximately 190,000 employees and physicians and serves more than 9 million people from 37 hospitals and 611 medical office buildings in nine states and the District of Columbia.

Financial analysts now have the power to quickly and easily create a monthly heatmap that highlights issues, irregularities and trends and to produce standard and customized reports that deliver need-to-know revenue information across the entire organization.