How to Reduce Healthcare Labor Costs by Using an EDW and Analytics

Article Summary

In the shift to value-based care, Texas Children’s Hospital began to see its bottom line decline and needed an immediate solution to address labor and productivity challenges. The hospital set out to develop a methodology to help them allocate labor resources appropriately to the demand for services.


Thumbnail sample of Texas Children's Hospital Labor Productivity dashboard

“Health Catalyst’s Labor Productivity application, combined with the enterprise data warehouse platform, has opened up a tremendous opportunity for us to decrease the cost structure of delivering world-class health care.”

– Catherine Codispoti, Director, Clinical Planning and Financial Management

Featured Outcomes
  • Labor cost savings
  • More timely insights from near-real-time data
  • Increased adoption among operations managers
  • Capital expense elimination
  • Cost savings from automated data aggregation
  • Data transparency in a growing organization

TEXAS CHILDREN’S HOSPITAL, a not-for-profit organization consistently ranked among the top children’s hospitals in the nation, recognized the importance of using technology to enable the delivery of higher-quality and lower-cost patient care. What hospital leaders found when they rolled out the Health Catalyst LateBinding ™ Enterprise Data Warehouse (EDW) and advanced healthcare analytics applications was not only the ability to analyze data on demand to improve clinical quality but also ways to increase labor productivity while reducing costs.
Here’s how it happened.


Texas Children’s was moving from a reimbursement model based on percentage of charges to an APR-DRG payment structure. Like most organizations experiencing the shift to value-based care, the hospital began to see its bottom line decline. This trend created a new urgency at Texas Children’s to fully understand its costs in relation to its revenues.

Texas Children’s was tasked with devising a way to measure costs in comparison to revenue. Their goal was to establish and track metrics that would enable them to identify trigger points affecting the hospital’s margin.

Well aware that salaries and benefits are the largest expense category for healthcare organizations—accounting for 35-45 percent of hospital costs nationwide and even 70-80 percent in some units—the Texas Children’s team knew that managing labor costs could have a significant effect on the hospital’s margin. They set out to develop a methodology to help them allocate labor resources appropriately to the demand for services.

Analyzing Productivity Using Work Hours per Unit of Service

As a first step in its effort to analyze labor productivity, Texas Children’s established a unit of measurement. The Texas Children’s team adopted work hours per units of service (WHPUOS) as the parameter for understanding how labor expenses affect margin. A unit of service—for example, a patient visit, a radiology procedure or an emergency department admission—is a way to measure service volume over a period of time. By comparing the volume to the number of hours worked in that same period, hospitals can understand how productive their workforce is. WHPUOS—actual hours worked divided by the volume for the same period—is therefore a measure of productivity.

The WHPUOS metric offers a consistent method for assessing labor needs foreach unit of service. It enables organizations to flex staffing levels with volume fluctuations. The Texas Children’s team determined that understanding and tracking WHPUOS would help them improve productivity, allocate resources and minimize the cost of premium labor such as overtime, agency work and call time. Tracking the metric, however, was easier said than done.

Cobbling Reports: An Inefficient, Unsustainable System for Analytics

To track WHPUOS, Texas Children’s began manually pulling data from the Enterprise Resource Planning (ERP) system, the EHR and other administrative service sources. This was a cumbersome process, as hospital staff would pull from multiple systems and then attempt to sort and assemble the data into a usable format. They would then forward the data to a third-party hosting vendor that correlated the data. This process of cobbling reports together was resource intensive—the manual data pulls alone consumed on average more than half of a full-time employee. On top of that, Texas Children’s was paying hosting and support costs for the third-party solution. Even with this time- and resource-consuming process in place, timely data was never available to drive staffing decisions. In fact, the data wasn’t available for analysis until a minimum of six weeks after it was captured in the source systems.


Texas Children’s needed a better solution, and they found it in Health Catalyst’s healthcare enterprise data warehouse (EDW) platform. Texas Children’s had already implemented the EDW to drive higher-quality, lower-cost clinical care. They realized that by simply running an additional analytics application on top of their existing EDW platform, they could efficiently and accurately manage labor and productivity.

Built on top of the EDW—which combines data from the EHR, time clock, ERP, and budgeting source systems—the Health Catalyst Labor Productivity Advanced Application delivers a view of staffing levels, volume and productivity across Texas Children’s various cost centers. The application enables the business and unit managers to track WHPUOS efficiently and accurately. It delivers information into the hands of decision makers to help them manage their business.

Managers will be able to track performance as often as daily to see exactly how well labor is being allocated and make rapid modifications to counter scheduling problems. In the event that labor utilization outpaces volume, managers can drill further into labor data to understand utilization at the job code level.

Concrete Results

Health Catalyst’s Labor Productivity application has quickly delivered measurable benefits to Texas Children’s. In its first year of implementation, with the application rolled out to 65 percent of its units, the hospital has achieved:

Labor cost savings

The application has enabled Texas Children’s to analyze near-real-time and retrospective data to understand its staffing patterns in relation to the demand for services. Consequently, the organization has been able to reallocate its core staff to better match demand—driving increased operational efficiency. Using the application to analyze staffing levels and ratios, the hospital is bringing labor expenditures in line with actual volumes and staffing goals. Texas Children’s estimates significant labor cost savings to date, approximately a 2 percent reduction in total salaries and benefits. More savings are anticipated as the operations team rolls the application out to the hospital’s remaining units.

More timely insights from near-real-time data

By replacing manual processes with the EDW and the Labor Productivity application, Texas Children’s is able to deliver data 66 percent faster and help drive labor decisions. Timely data enables more effective and accurate labor management than the previous approach of cobbling disparate reports from a multitude of systems to feed an offsite analytics point solution.

Increased adoption among operations managers

Only a handful of unit managers were using the third-party solution Texas Children’s had adopted to assess productivity. Since implementing the Health Catalyst Labor Productivity application, the number of managers using data to drive staffing decisions has increased 500 percent. Why? The new solution’s near real-time data is significantly more relevant to managers than data two to three months old. The application’s easy-to-use dashboard helps managers effectiveness is driving greater accountability among managers to use data to improve their units’ performance.

Capital expense elimination

By simply adding an advanced analytics application to run on its existing EDW platform, Texas Children’s has been able to sunset the third-party hosted solution it had used for analyzing productivity.

Cost savings from automated data aggregation

By replacing manual data pulls with automated data integration, the EDW is driving an estimated Net Present Value (NPV) of more than $425,000 savings over a four-year period.

Data transparency in a growing organization

Texas Children’s has grown substantially over a short period of time. In this environment, data transparency has become more important than ever. Making data available to operational, clinical and financial leaders across all patient care areas enables leadership to collaborate effectively, think globally and make more informed decisions about how the hospital can improve its performance.

Sample of Texas Children's Hospital Labor Productivity dashboard

View additional analytics stories in healthcare.

Improving Population Health Through the Use of Data and Reporting

This website stores data such as cookies to enable essential site functionality, as well as marketing, personalization, and analytics. By remaining on this website you indicate your consent. For more information please visit our Privacy Policy.