Visualizing Invisible Energy Costs

Problem Statement: In large-scale manufacturing, electricity bills are a major operating cost, yet they often remain a “Black Box.” Factory managers struggle with manual meter readings, lack of real-time visibility into power consumption trends, and inability to correlate energy spikes with specific production processes.

The Challenge: The client needed a centralized system to collect data from multiple Digital Multimeters distributed across the factory. The system had to handle high-frequency data (Voltage, Current, Power, THD), process it for cost analysis, and present it on a responsive web dashboard accessible from anywhere.

Our Solution: Event-Driven IoT Platform

We architected “Factory Insight,” a robust monitoring solution built on the Node-RED ecosystem for reliable data acquisition and Vue.js (Quasar Framework) for a high-performance frontend user interface.

System Architecture Diagram

Key Features

  1. Real-time Telemetry: Live monitoring of electrical parameters including Voltage (V), Current (A), Power (kW), Power Factor, and Frequency (Hz).
  2. Power Quality Analysis: Monitors Total Harmonic Distortion (THD) to detect “Dirty Power” that could damage sensitive machinery.
  3. Cost Intelligence: Automatically calculates estimated electricity costs ($/THB) based on consumption, helping in budget forecasting.
  4. Advanced Reporting: Generates Daily, Weekly, and Monthly energy reports with “Export to Excel/CSV” functionality for further audit.

Key Technologies Implemented

TechnologyRole in System
Vue.js 3 (Quasar)Responsive & Fast Frontend Dashboard
Node-REDIoT Gateway, Data Aggregation, and API Backend
MySQLHistorical Data Storage
Modbus RTUCommunication protocol with Power Meters

Business Results

  • Data Integrity: Implemented “Gap Filling” logic (aggregateBackfillSequential.js) to ensure continuous data streams even during network hiccups.
  • Operational Efficiency: Replaced manual logbooks with automated digital reports, saving hours of engineering time per week.
  • Predictive Maintenance: THD monitoring allows early detection of motor or drive anomalies before failure occurs.

Expert Insight: Reliability is key in data logging. We utilized Node-RED not just as a smart aggregator that pre-processes raw Modbus data into hourly and daily summaries, significantly reducing the query load on the MySQL database for long-term reporting.


Ready to optimize your factory’s energy usage? Contact us at: wisit.paewkratok@gmail.com