GDAHA: Data Analytics

“Before working with Qbase, the turnaround time for reporting was measured in months. Now it is measured in days and weeks.”

– BRYAN BUCKLEW President and CEO, Greater Dayton Area Hospital Association

Client Description

Greater Dayton Area Hospital Association is a full service, not-for-profit association of 21 facilities whose primary focus is providing quality healthcare. GDAHA is the central collection point for these hospitals’ data, which is used to analyze trends in healthcare services to improve quality and patient care.

Challenge

Greater Dayton Area Hospital Association wanted to use data analytics to provide insights into its members’ trauma event data in ways that would help them improve healthcare. The prevailing challenge was turning the incredibly large amount of data into reports that provided an accurate assessment of how the association and its members were doing operationally.

The association had collected information on trauma events from its member hospitals that are part of the Southwest Ohio Regional Trauma System over a seven-year period. This enormous database was stored in a complex legacy data repository. The data consisted of 57 reference tables and one source table, where record counts ranged from 5 to 20,000 and field counts varied from 5 to 769 multi-valued data fields. The legacy sys­tem did not provide an aggregate view of trauma events for the individual hospitals. Before Qbase, a manual process was used that took over 400 days to aggregate, catalogue and analyze the data.

Solution

GDAHA hired Qbase to take its members’ 2006 data and mold it into individual seg­ments. Key data analyzed included cen­tral tendencies associated with trauma-population characteristics, average time of patient stays, the nature of the trau­ma, and frequency of occurrences.

Qbase built an automated process that analyzed over 15 million data elements and produced reports on both the South­west Ohio Regional Trauma System as a whole and on each member hospital, accomplishing in 40 days what had pre­viously taken 400. For the first time, the hospital association now had a standard­ized single view of trauma events for 14 institutions across an 11-county region.

Result

By running trauma event data through Qbase Data Discovery, the data was transformed into timely, accurate information for decision-making. GDAHA learned key areas to improve delivery of patient healthcare. Qbase’s solution helped members understand and compare their staffs’ experience in terms of arrival days and times, types of trauma, and other aspects of trauma events that affect hospital staff and quality of care.