Solution Overview:
Company:
Leading Hospital
Customer Profile:
The hospital has evolved to become one that is renowned
for the best patient care
modern medicine has to offer.
Business Case:
The management of the
hospital wanted to have the
ability to effective track the
quality of care that was being provided to its patients by the Nursing staff.
Solution Description:
Nrit designed a data mart
solution to track and examine
the quality of nursing care.
Softwares & Requirements:
Front-end: MS Front Office Automation and Visual.
Interdev (ASP, Visual Basic,
Excel, Outlook and Access), SAS;
Back-end: Oracle 8i, SQL Loader, PL/SQL
Country/Region:
USA
Audiences:
General User
USA : +1 732-744-3369 |
India : +1 732-945-4888 |
|
|
 |
| Business Intelligence - Case Study |
| Client |
Leading Hospital |
Contact Nrit about applying this work to your organization. |
| Project |
Data Mart |
Executive Summary:
Since its inception in early 20th century, this hospital has evolved to become one that is internationally renowned for the best
patient care modern medicine has to offer. It is committed to providing superior outpatient, acute, sub-acute and home patient care, breakthrough biomedical research, graduate and undergraduate medical education, and community service.
The hospital cares for some 150,000 patients per year, and over 1,000 primary care physicians and specialists attend to these
patients, supported by a support staff of many thousands more. Many patients are eligible to receive the newest treatments by participating in clients active clinical research program. More than 300 principal investigators and 500 employees are
involved in this research, resulting in over 300 papers appearing in peer-reviewed medical journals each year.
All of these world-class services are provided at a multi-building campus, where over 10,000 users access over 500 different information technology applications running on many different platforms. This has created a complex web of inter-related systems
that users have to navigate as part of doing their jobs. Perot Systems has a facilities management contract for managing the IT resources. The hospital also has an extensive Enterprise Information Systems (EIS) group that supports and develops the IT applications. Consulting assignments are handed out by the EIS department.
The hospital has been a client of Nrit since 2000.
|
|
| Some of the significant projects Nrit has implemented at the hospital are: |
|
 |
Quality of care, and measures to track, analyze and improve it are major concerns for the hospital management. |
|
In addition, such quality metrics play an important role in the regular accreditation and audit process conducted by the Joint Commission for Accreditation for Healthcare Organizations (JCAHO). |
|
Delays in data collection from various reporting units, data quality and the availability of data entry staff were all acute problems. |
|
The hospital was also tasked with receiving and processing such quality of care data from a statewide coalition of hospitals, and that further complicated the data processing problems outlined above, such as delays, inconsistent and error prone data, and difficulty in entering and cleansing the incoming data in a timely manner. |
|
|
The management of the hospital wanted to have the ability to effective track the quality of care that was being provided to its
patients by the Nursing staff. The ability to track different types of mistakes, together with all possible and potentially meaningful
data was deemed to be a crucial need by the Nursing Administration department.
|
|
| Nrit's Solution |
Nrit worked with the hospital's Nursing Administration management to understand their business needs and to design and
build a data mart solution to track and examine the quality of nursing care. This project gave the hospital a way of loading
utilization data into the data mart, and customized tools were developed to allow users to transform and analyze data, and to
produce custom reports.
This data mart's functionality was subsequently expanded to cover participating hospitals in the state-wide coalition of hospitals,
and these findings are used as a part of the hospital's periodic JCAHO Audit.
The project was developed in a multi-phased solution that:
|
|
Improved data quality by providing users with an intuitive, online data entry form with extensive data validation routines. |
|
Subsequently the back-end ETL processing engine further manipulated the data to create staging tables and data cleansing (Scrubbing). |
|
Made the new system very user friendly. |
|
Eliminated redundancies by automating the system. |
|
Provided the output reports in a consistent, automated manner, about 20 times faster than the previous manual approach. |
|
Some of the system produced customized reports that were sent to coalition-member hospitals. It eliminated need for extensive manual cleanup and manual data extracts & custom report generations.
|
|
|
|
