BI SolutionSeptember 15, 2022
The Customer is an Australian based group that offers software to help 200 healthcare centres and retirement homes to process data related to patients and medication as well as build various types of reports.
The Customer commissioned Mane Consulting to rewrite the software – a Java application used by the healthcare centres 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, Mane Consulting’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 totalled 12GB.
The Customer’s clients are now able to improve their management processes thanks to prompt analytics reports. Together with Mane Consulting, the Customer is also planning to build OLAP-cubes to store aggregated data for advanced healthcare data analytics and information processing.