Wevision began collaboration with Nordlab by focusing on the largest laboratory to identify data needs and cost drivers. In the next phase, the analysis was extended to all laboratories to identify differences. The implementation was then carried out in close co-operation with the Head of Finance & Administration, operational staff, and the IT service provider.
Data from different data sources was extracted and transformed with a repeatable ETL process before loading to the calculation tool. Later, NordLab developed a data warehouse solution that combined data from different information systems, enabling the streamlining of the ETL process.
Key features of the solution:
- All locations and processes are modelled: from cost equivalence to external accounting
- Calculations are performed at the most granular level possible: individual test transaction
- Full Profit and Loss view for all key dimensions, e.g. test transaction, customer (billable), sub-product, product, workstation, department, and location were obtained
- End-to-end capacity utilisation view; enabling resource management