Industry
Engineered Wood Products
Task
Build real time mobile production reporting system
DTX technology was engaged to design and build a reporting system utilising both the Microsoft Power BI and SQL Server Mobile Reports platforms connected to a SQL Server database hosted on the Microsoft Azure cloud to deliver real time production reporting across multiple devices.
During the design phase DTX worked with the corporate IT team and site production teams to:
- design the Azure database schema
- design the replication topology for moving the site production data to the Azure database in real time
- design the Power BI and SSRS Mobile report layouts
The build phase required 3 months with DTX delivering all database and report development.
The delivered solution provides:
- reporting of real time and historic production, OEE and downtime metrics
- reports tailored to PC, tablet and phone form factors
- drill through from region level down through plant, department and process level
- customised reporting for each process type