Texas Children's Hospital is an internationally recognized full-care pediatric hospital located in the Texas Medical Center in Houston. One of the largest pediatric hospitals in the United States, Texas Children's Hospital (TCH) is dedicated to providing the finest possible pediatric patient care, education and research. Since opening its doors in 1954, TCH has cared for more than one million children from every corner of the world, and has more than 2.2 million patient encounters a year.
CHALLENGE
Nurse researchers, cardiology physicians and researchers created spreadsheets to manage their day-to-day activities – a practice which resulted in more than 450 spreadsheets along with various other disparate sources. These clinicians were responsible for providing outcomes and research reports for consumption by the medical and surgical groups that often used different approaches to data management. The complexity of this data management infrastructure began to manifest into several issues including loss of productivity, low quality of data, increased costs and inefficient use of time.
SOLUTION DEPLOYED
Perficient created a data warehousing solution using Microsoft SQL Server as a backend with web/Windows-based data collection tools. This data was collected, extracted and transformed using complex workflows to produce a single system of record using SQL Server Integration Services, SQL Server, .NET and Microsoft Office suite.
This baseline system quickly processes 100,000 rows of data from multiple systems resulting in a business benefit of cost avoidance hours and new visibility to patient outcomes and research data by providing the users with a trusted single source for data needs.
BUSINESS VALUE DELIVERED
- Cost avoidance: As more analytics and reporting are handled by the system, the cumulative business value will increase into the thousands of hours redirected to other tasks
- Enhanced analytics and high-quality data mining: Rich SQL and business intelligence functionality allows for management of both in-depth and simple analytics
- Improved reporting tools: Layered on top of the analytics and data mining capability are business intelligence reporting functions that provide easy visibility into reporting for outcomes and research information that were previously difficult to ascertain