“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 system 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 segments. Key data analyzed included central tendencies associated with trauma-population characteristics, average time of patient stays, the nature of the trauma, and frequency of occurrences.
Qbase built an automated process that analyzed over 15 million data elements and produced reports on both the Southwest Ohio Regional Trauma System as a whole and on each member hospital, accomplishing in 40 days what had previously taken 400. For the first time, the hospital association now had a standardized 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.