Background

The global business services organization (GBSO) is providing internal services in the processes of supplier-to-pay, order-to-cash and Finance. Before the dashboard was implemented, they had suffered under the difficulty of having unharmonized definitions, multiple source systems which have taken a lot of time to connect to and were complex to handle. Additionally, there was no single source of truth, so it occurred that discussions were made based on different foundations.

To improve their situation and their provided services, they started a project which aim was to create an automated dashboard that can measure 80 KPIs, splitted across four categories: Costs, People (customers and employees), Efficiency and Quality.

Major challenges:

The challenges for this project were to find a way, how 80 KPIs can be measured, without flooding the dashboard consumers with too much information. Additionally, a way had to be found to connect to different technologies and bringing all information together. Since multiple source systems are used, this added complexity to the master data management.

Approach:

Working closely together with all key stakeholders, Sereviso specified the exact requirements for each KPI. Sources, filters and further settings were identified before starting the development to avoid double work. With the help of standard connectors, the sources were connected fairly quickly and loaded into a SQL Server database, where the staging and data transformation is taking place.