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.
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.
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.
The data is then visualized with Microsoft PowerBI. As 80 KPIs naturally contain a lot of information, the dashboard had to be built up carefully and completely thought-through, otherwise users could have felt overinformed quickly. Hence, the dashboard was kept very simple, showing only the relevant data on one page. Multiple drill down layers allowed to get a quick overview over the best and worst KPIs, and still get the necessary detail to know where the root cause for the good and bad performance is.
Value added for Lonza:
About the customer:
Lonza is a global leader in Life Sciences with headquarter in Basel, Switzerland, more than 100 sites and offices around the global and approximately 14’500 employees. The company is providing products and services in the area of pharma, consumer healthcare and nutrition.