Project · WRK-006

Workshop Inspection & Energy Board

An inspection and power-usage board for a machining workshop. It runs on the shop-floor screen, and inspections are filled in on a phone.

Online
Workshop Inspection & Energy Board
Category
Data Visualization
Status
Online
Created
Jun 20, 2025
Updated
Aug 30, 2026
  • React
  • ECharts
  • Python
  • InfluxDB
  • MQTT

Project background

Two production lines, twenty-odd machines. The power meters could already report data, but nobody was reading it. Inspections were still paper forms, filed at month end.

Problem

  • The power bill kept rising, and nobody could say which machine or shift was responsible;
  • Missed inspections only came to light after something broke;
  • Management wanted a big screen, but not one that just looked nice.

Approach

Pull the meter data in and show it by line and by machine. Move inspections to QR codes on each machine, and flag overdue ones in amber on the big screen.

Key features

  • Floor plan with each machine shown as running, idle or alert;
  • Power usage by day and by shift;
  • Scan-to-inspect: one QR code per machine;
  • Overdue alerts pushed to the shift lead;
  • Monthly Excel export of inspections and power usage.

Architecture

Meters report over MQTT through a gateway; a Python service writes to InfluxDB. React and ECharts on the front end, one API shared by the big screen and phones. Hosted on the factory's internal network.

What we handled

On-site data integration, dashboard design, front and back end, the inspection workflow, and the on-premise deployment.

How it went

Version one had far too many charts. The workshop manager said you couldn't read anything from three metres away. Version two kept the floor plan and one chart, with text twice as large.

Screenshots

Demo data. Machine names have been changed.

What went wrong

Wi-Fi on the shop floor is patchy, so phone submissions sometimes failed. We added local drafts that upload when the signal comes back (later turned into a standalone prototype in the Lab).

Outcome

The board revealed two air compressors idling overnight. After fixing that, the monthly power bill dropped noticeably, and overdue inspections now get caught the same day.

Current status

Live. Configuration changes when new machines arrive.

Next

The client is considering vibration sensors for simple early fault warnings.