< Back to Case Studies

Duration

12 Months

Team Size

15

Budget

Over 150,000 USD

Technologies And Tools

MS SQL Server, Transact-SQL, JReport

Implementation For Healthcare Centers

healthcare IT in Asia

Project Details

CUSTOMER – USA

Client offers software to help healthcare centres and retirement homes to process data related to patients and medication as well as build various types of reports.

SOLUTION

To ensure scalability and short query response time, BEETSOFT built an analytical Microsoft SQL Server data warehouse which would use a Transact-SQL script to load data from the relational database.

Some of the generated reports are:

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

RESULTS

The Customer’s clients are now able to improve their management processes thanks to prompt analytics reports.