Download PDF
Information Builders > Case Studies > Data Drives Decisions at Grand River Hospital
Information Builders Logo

Data Drives Decisions at Grand River Hospital

Technology Category
  • Application Infrastructure & Middleware - Database Management & Storage
  • Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries
  • Healthcare & Hospitals
Applicable Functions
  • Business Operation
  • Quality Assurance
Use Cases
  • Predictive Maintenance
  • Remote Asset Management
Services
  • Data Science Services
  • System Integration
The Challenge
Grand River Hospital, a 615-bed community hospital in Ontario, Canada, was struggling with outdated data management technology. The hospital's IM/IT environment included more than 60 source systems, and an 11-member decision-support team depended on the IM/IT department to produce reports. Team members specialized in their own specific systems, making the production of cross-segment reports especially difficult. Hospital officials wanted to pull data from all these systems into one cohesive source and facilitate timely and accurate reporting for hospital decision-makers.
About The Customer
Grand River Hospital is a 615-bed community hospital with 3,100 employees and 582 physicians and midwives. The hospital serves more than 500,000 residents in the Waterloo Region of Ontario, Canada, delivering a full range of acute and restorative care, including: cancer, childbirth, pediatrics, intensive care, emergency medicine, rehabilitation, renal, mental health and addictions, medicine, stroke, surgery, and complex continuing care services on two main campuses.
The Solution
To achieve their goals, Grand River Hospital implemented integration and business intelligence (BI) technology from Information Builders. They used iWay DataMigrator to extract, transform, and load (ETL) five years of historical data from these systems into an enterprise data warehouse. DataMigrator includes introspection tools to examine a database schema so that system designers can select precisely what database information will be accessed, and develop rules for doing so. The hospital also used Information Builders’ advanced ETL platform to integrate several additional information systems. The new data warehouse has become the foundation for advanced analytics such as case costing – a detailed tracking of costs related to each patient. The hospital also uses WebFOCUS and InfoAssist to supplement an existing system of dashboards, scorecards, and reports.
Operational Impact
  • Grand River now has one consolidated data warehouse. Clinicians, administrators, and financial personnel can better answer complex questions that span multiple systems, from payroll and financials to patient scheduling, laboratory, and admissions.
  • The hospital can more easily track emergency room wait-times, levels of care in each department, and patient diagnoses to ensure that individuals receive the right medications.
  • They can also determine which doctors are performing well based on quality outcomes and can monitor a wide variety of hospital procedures.
Quantitative Benefit
  • In the past it could take three weeks to get the reports that would provide these insights; now clinical information is available in a more timely fashion.

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.