Transforming Healthcare with Scalable BI Solutions

Gornium redesigned a Java-based healthcare platform for an American company, implementing a scalable SQL data warehouse and BI-powered reports. Our solution optimized medication tracking, clinical data, and patient management, enabling real-time analytics for 100+ healthcare centers.

Healthcare, Software products

STUDY

Transforming Healthcare with Scalable BI Solutions for 100+ Health Centers.

Customer

The Customer is an American company that offers software to help over 100+ healthcare centers and retirement homes to process data related to patients and medication as well as build various types of reports.

Challenge

The Customer commissioned Gornium to rewrite the software – a Java application used by healthcare centers to manage and report data on medication inventory, clinical services, patient data, marketing activities, and others. Within the project, the Customer also wanted the tool to allow its users to enable quality population health analytics with prompt reports.

Solution

To ensure scalability and short query response time, the Gornium BI implementation team built an analytical Microsoft SQL Server data warehouse which would use a Transact-SQL script to load data from the relational database. The latter was consolidated from 200 databases during the application development and totaled 12GB.

Currently, Gornium BI developers build reports with the JReport tool. Among the reports, there are:

Medication Classification Report

Missed Medications

Hospital Readmissions

Employee Performance Report

Community Marketing Activity Summary

Results

The Customer’s clients can now improve their management processes thanks to prompt analytics reports. Together with Gornium, the Customer is also planning to build OLAP cubes to store aggregated data for advanced healthcare data analytics and information processing.

Technologies and Tools

MS SQL Server, Transact-SQL, JReport.