Case Study Details

Client:

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

Challenge:

The Client demanded MQSTech rewrite the software – a Java application used by the healthcare centers for management and reporting of 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.

BI Solution

To ensure scalability and short query response time, the MQSTech BI implementation team built an analytical Server data warehouse that would use a script to load data from the relational database. The latter was consolidated from 400 databases during the application development process and totaled 12GB.