Engineered wood products case study: Build real time mobile production reporting system

A wood products company was looking to implement a real time mobile production reporting system where reports could be consumed on desktop PC, tablet or phone.

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

Share this story

More news and insights

Industry Partnership Testimonial – Trent Langley, The Robot People

Food processing case study: Build paperless quality system

Food processing case study: Create reporting system for newly installed robots

Find out how we transform the efficiency of manufacturing