en flag +1 214 306 68 37
BI Implementation for 200 Healthcare Centers

BI Implementation for 200 Healthcare Centers

Healthcare, Software products
MS SQL Server, Java


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


The Customer commissioned ScienceSoft to 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.


To ensure scalability and short query response time, ScienceSoft’s 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 process and totaled 12GB.

revenue dashboards

occupancy dashboards

Currently, ScienceSoft’s 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


The Customer’s clients are now able to improve their management processes thanks to prompt analytics reports. Together with ScienceSoft, 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

Have a question to our team or need help with your project?

Our team is ready to provide client references, estimate your project, or answer any other question related to your IT initiative.

Upload file

Drag and drop or to upload your file(s)


Max file size 10MB, up to 5 files and 20MB total

Supported formats:

doc, docx, xls, xlsx, ppt, pptx, pps, ppsx, odp, jpeg, jpg, png, psd, webp, svg, mp3, mp4, webm, odt, ods, pdf, rtf, txt, csv, log

More Case Studies