Creating the data model (from zero to something usable)
The team started by defining the core tables and relationships needed to represent paint-booth behavior. This included:
- Operational telemetry (streaming_mock_data, mock_data)
- Weather inputs (streaming_weather_mock_data)
- Energy consumption and savings (streaming_energy_savings)
- Lookup tables and configuration models
You can see this structure laid out in the project’s data diagram.
Bringing streaming telemetry into one unified view
To make the simulation model possible, SoftServe needed all incoming signals, like internal booth metrics, external weather data, and energy measurements, to speak the same language.
That meant unifying:
- Timestamps
- Sampling rates
- Naming conventions
- Booth/line identifiers
- Units of measurement
The final model shows this clearly: all three telemetry streams feed into structured tables that match a single schema.
Cleaning, aligning, and preparing time-series data
The raw signals were captured at different intervals and sometimes with missing or lagged values (which is common in industrial systems). For the simulation dashboard to behave like the real booth, the data had to be:
- Cleaned
- Synchronized
- Normalized
- Mapped to the correct booth and line
- Aligned along a shared timeline
The high-resolution telemetry tables in the data model make it clear that extensive data cleaning and synchronization were completed before any simulation work could begin.
Building the simulation-ready dataset
Once telemetry streams were brought into a single structure, the team could finally use them to drive the simulation model.
The simulation model required:
- Continuous, aligned time-series inputs
- Realistic behavioral relationships between signals
- Stable patterns that represent the booth’s real dynamics
This is why the data foundation mattered so much. It was the enabler for the simulation dashboard and the AI controller.
Preparing the dataset for machine learning
The project didn’t initially have the kind of historical dataset needed to train an AI model. But once the structured data model was built, SoftServe could use telemetry patterns to:
- Identify how the booth reacted to internal and external conditions
- Correlate energy use with airflow settings and environment
- Understand how different components behaved under load
This prepared the ground for the AI agent that would later recommend and eventually automate optimal ventilation settings.
The solution
Once we finally had clean, unified data flowing, the first thing the client saw was the Power BI dashboard. This became the control center for everything:
- Daily, weekly, and per-booth energy savings
- Actual vs. expected power usage
- Temperature and humidity stability
- Ramp-up times
- Real-time equipment behavior (valves, heat wheels, pumps)
- AI corrections and out-of-window events
Then the agents arrived
With the data foundation in place, SoftServe introduced an AI agent that could actually control the booth.
The model understood:
- Temperature and humidity trends
- Airflow dynamics
- Valve positions and heat wheel speeds
- How all of that translated into energy use
And instead of reacting late (like the old system), the agent predicted what the booth would need and adjusted settings proactively.
Of course, you don’t just let an AI loose in a live paint booth.
So SoftServe built a digital twin dashboard of the booth where every airflow change, humidity spike, and valve adjustment could be tested safely.
In the simulator, the team ran dozens of scenarios:
- Different weather conditions
- Different airflow or temperature setpoints
- Rapid environmental changes
- How equipment behaved under load
This is where the team validated model decisions and made sure the agent behaved safely and predictably before ever touching production equipment.
A real-time IoT pipeline to close the loop
Once validated, the agent was connected to the real booth through a production-grade, Azure-hosted IoT pipeline.
This pipeline:
- Streamed telemetry from every sensor
- Fed live conditions into the model
- Applied recommended setpoints
- Checked all decisions against safety rules
- Logged everything for audit and traceability
This created a true closed-loop system where data insights, action, and verification all happened automatically.
One of the biggest wins?
The solution didn’t require ripping out legacy systems.
SoftServe integrated directly with:
- The plant’s PLC logic
- Existing safety systems
- Their Azure environment
- Operational dashboards
A smarter paint booth, powered by AI, built on the data foundation we created, without rebuilding the entire infrastructure.
With clean, unified data powering the AI and digital twin, the operational improvements started to show up almost immediately.