ScienceSoft
Jun 04, 2024
No image
Completed
BI Implementation for 200 Healthcare Centers
$100,000+
4-6 months
United States
2-5
Service categories
Service Lines
Big Data
Domain focus
Healthcare
Programming language
SQL
Subcategories
Big Data
Data Analytics
Challenge
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.
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.
Solution
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.
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
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.
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
Results
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.
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.