Solution Overview:
Company:Leading Health System Company
Customer Profile:
Leading Health System Company
has evolved to become the largest non-profit hospital
in the Western United States.
Business Case:
The management of Leading Medical Center 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:
Design and build a data
mart solution to track and examine the quality of
nursing care.
Softwares & Requirements:
| Front-End: |
MS Front Office (ASP,Visual Basic, Excel & 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 Health System Company |
Contact Nrit for applying this work to your organization. |
| Project |
Data Mart for Nursing Administration Department |
Executive Summary :
Since its inception in 1902, Leading Health System Company has evolved to become the largest nonprofit hospital in the Western United
States - one that is internationally renowned for the best patient care modern medicine has to offer. Today, Leading Medical Center
(the core facility of the Leading Health System Company) is committed to providing superior outpatient, acute, sub-acute and home patient care, breakthrough biomedical research, graduate and undergraduate medical education, and community service. Leading Health System 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 Leading Health System 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 client 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.
|
| What was the problem? |
Quality of care, and measures to track, analyze and improve it are major concerns for Leading Health System. In addition, such
metrics play an important role in the regular accreditation and audit process conducted by the Joint Commission for Accreditation
for Healthcare Organizations (JCAHO). The management of Leading Health System Medical Center 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.
|
| Why Nrit ? |
Nrit has been implementing enterprise-wide BI solutions for Fortune 100 Clients for the last 9 years. Nrit has a vast experience in development of Data Warehouse and Data Marts, with a strong understanding of Data Architecture and Data Modeling along with the experience of using ETL tools such as Informatica, Ascential (Prism), Decision Stream (Cognos), and Acta (now part of BO). Other reasons for choosing NRIT were:
 |
Certified Business Intelligence developers with experience in Cognos tools. |
|
Excellent track record of success in BI and DW projects. |
|
Vendor independent opinion. |
|
Comprehensive assessment services. |
|
Broad experience across multiple technologies. |
|
Business case development (co. specific). |
|
Cost effective delivery capability. |
|
Technical excellence of resources. |
|
| Nrit's Solution |
Nrit worked with the Leading Health System 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 Leading Health System 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 were expanded to cover participating hospitals in CALNOC (California Nursing Outcomes Coalition), and these findings are used as a part of Cedar's periodic JCAHO Audit.
|
|
|
|
