Challenge
Telemetry stayed inside SCADA, and power engineers compiled consumption by workshop by hand once a month. Overruns and peak loads showed up only afterwards, on supplier invoices.
What we did
- Designed SCADA telemetry ingestion over OPC UA through an intermediate bus
- Built a MS SQL Server warehouse with SSIS loads every 5 minutes
- Built dashboards for consumption by workshop, peak loads and energy use per product type
- Prepared an operating procedure for the client IT team
Outcome
Engineers used to see consumption and peak loads only at month-end; now they see them during the day and plan load schedules ahead. Energy use per product type is used to compare shifts. The analytics never touches equipment control.