Customer success story

Healthcare Business Intelligence

Industry
Healthcare
Location
Saudi Arabia
Goals
To build a reporting solution to provide KPIs for the health of 50K+ employees all over the country
Type
SAP BI Implementation

Technologies Involved

SAP ECC

SAP BW

SAP IS-Health

SAP BI

Analyze the past to know about the health of your patients for better health in the future.

Challenges

  • 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 Solution

  • 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.

The Result

  • 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.