Customer success story
Healthcare Business Intelligence
Analyze the past to know about the health of your patients for better health in the future.
- Multiple systems used to manage KPIs for patients’ health.
- Heavy depends on time-consuming excel based reporting. Sometimes it took weeks to collect data from different systems and present final analytical reports.
- Very hard to identify trends based on past patients’ data and information.
- The master data of all the patients who were employees of the company resided in SAP ECC and the company has already implemented industry solution SAP IS-Health.
- Some data of the patients was also managed in different lab and pharmacy systems which were customized solutions.
- SAP Business Warehouse was selected as the main environment to build all the Info Cubes for analytical reporting.
- Info Cubes loaded data from SAP ECC, SAP IS Health and customers lab and pharmacy solutions and linked all the records of each patient in one place.
- The solution loaded 10 years of historical data in SAP BW.
- The front-end reporting solution was developed using Adobe Flex and Xcelsius. Some SAP BI solutions were also used for reporting.
- All the important stakeholders in the hospitals had excellent insights about patients’ health and they were able to make strategies and initiatives which they could not think of before.
- Ability to slice and dice the data and come up with different types of reports and healthcare KPIs for patients and a performance of labs and pharmacies.
- Significant improvement in the operations and planning based on insights.