As a global market leader and innovator in Food, Environment, BioPharmaceutical and Clinical Testing, the client has the need to keep the overview of their laboratory productivity and testing quality. For further analysis, data from the other business processes must be added and there is the need to have the possibility to analyse with extra layering.
We developed and implemented an extendable Business Datawarehouse to combine laboratory data, financial, human resource and sales data on a set of dashboards and reports for analysis. We also developed a method to add external data to the data warehouse, in a standardised and structured way. We developed this on the Microsoft Cloud products: Azure Data Factory, Power BI, Power Apps and Flow.