Reference Case: Lonza, Project Magicview


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.



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.

Figure 1: system setup
Figure 1: system setup

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.

Figure 2: Dashboard setup

Value added for Lonza:

  • Less time needed for reporting, as manual effort falls away
  • Self-service capabilities: People can look at reports with live data at any time, no need to ask anyone to supply data. They can now inform themselves at any time.
  • Establishment of internal benchmarking
  • Single source of truth

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.

Contact Us

We're not around right now. But you can send us an email and we'll get back to you, asap.

Not readable? Change text. captcha txt