The mission of the RHC-A and its more than 17,000 staff members is to provide world-class, proactive and patient-centered health care for approximately 600,000 service members, retirees, and their families.

RHC-A needed a solution to integrate its data repository of 187 unique metrics across business, quality, and performance data into a model that could show MTF commanders the five most important metrics to them by functional area.

There was no single view of the siloed data and RHC-A needed a solution with a comparative view over time for forecasted and actual metrics. To provide meaningful data with methodology and rationale, we created a data repository for their 187 unique metrics, and categorized them so that RHC-A could view the top five metrics most important to each functional area. The data was too substantial (100+ GB) to fit into an Excel spreadsheet and caused continual crashes and stalls, so we created a dashboard where commanders could get a comparative view over time for forecasted and actual metrics. TIAG’s team calculated new metrics to quantify variability, financial impact, and ability to change within each installation. Our solution guarantees reproducibility for each analysis and RHC-A is able to innovate and leverage more data than ever before and optimize resources to further mission accomplishments.

By building an interactive dashboard to enable user-driven exploration of the data, we empowered each MTF commander with clear insights around key mission areas important to their facility. The time to complete analysis is now a matter of minutes for repeat analysis and report generation, including an updated dashboard for more than 30 simultaneous users.