Customer success story

Healthcare Business Intelligence

Goals: To build a reporting solution to provide KPIs for the health of 50K+ employees all over the country

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.