BI Implementation for 200 Healthcare Centers

About the Client

The Client is an American company that offers software to help 200 healthcare centers and retirement homes process data related to patients and medication and build various types of reports.

Rewriting Healthcare Software to Enable Prompt Reporting

The Client commissioned INNERLUXES to rewrite its software — a Java application used by healthcare centers for management and reporting of data on medication inventory, clinical services, patient data, marketing activities, and more. Within the project, the Client also wanted the tool to enable quality population health analytics with prompt reports.

A SQL Server Data Warehouse Consolidating 200 Databases

To ensure scalability and short query response times, INNERLUXES's BI implementation team built an analytical Microsoft SQL Server data warehouse that uses a Transact-SQL script to load data from the relational database. That relational database was consolidated from 200 databases during the application development process and totaled 12 GB.

INNERLUXES's BI developers build reports with the JReport tool. Among the reports are:

• Medication Classification Report
• Missed Medications
• Hospital Readmissions
• Employee Performance Report
• Community Marketing Activity Summary

Prompt Analytics Reports Across 200 Centers

The Client's end clients are now able to improve their management processes thanks to prompt analytics reports. Together with INNERLUXES, the Client 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.