Skip to content
ralwo
Dashboards · Machine data · Plant monitoring

Data visualisation your shift can read in passing.

For us, data visualisation does not start with the chart but with the question of who needs which number, and when. We bring data from PLCs, MES, ERP and Excel together and build dashboards for the control room, maintenance and management – with live values, thresholds and last week for comparison.

The shared data foundation first, then the chart.

Data visualisation rarely fails at the chart – it usually fails because the data sits in five places. The PLC knows the cycle time and the current fault, the MES knows the order, the ERP knows the delivery date, and the shift handover lives in an Excel sheet. So we bring these sources together in one data foundation first: controllers via OPC UA or the S7 protocol, MES and ERP via their interfaces, spreadsheets and PDF reports via import. Only once every value carries a timestamp and a machine number is the chart worth drawing.

The dashboards we build on that basis are made for the shop floor, not the meeting room. A shift leader sees in passing whether the line is running, where it has stopped and how far the order has progressed – three numbers, not twenty filters. Maintenance sees states and thresholds live; management sees availability and scrap week on week. Where it fits, we build on ralwo PlantPulse; otherwise we develop the dashboard to your requirements.

Outcome

What you get when we visualise machine data.

Four things that exist in your operation after the project – not just a screen on the wall.

  • One data foundation instead of five exports

    Signals from PLCs and OPC UA, orders from MES and ERP, inspection values from Excel and PDF reports land in one time-series and master-data store with consistent machine numbers and timestamps. The nightly Excel export disappears, and every figure on the dashboard can be traced back to its source.
  • A machine data dashboard for each role

    The shift leader sees running state, piece count and order progress for the line; maintenance sees temperatures, vibration and fault messages per machine; management sees availability, scrap and throughput per week. Each view shows the three to five numbers that role needs, in a type size that is legible from five metres away.
  • Plant monitoring – live and with thresholds

    States, pressures, temperatures and counter readings arrive from the controller every second and appear without a detour through a spreadsheet. You set thresholds per machine; when one is exceeded, the tile and its status text change and the message names the machine, the signal and the time.
  • History for comparison, not just the moment

    Every value is stored so you can compare the current shift with last week, or one machine with its identical neighbour. Recurring stoppages, slowly rising temperatures and scrap peaks after tool changes become visible because the time axis is long enough. On request, anomaly detection reports deviations with an explanation.
How we work

Dashboard development in three steps.

The same approach as every ralwo project – seen here from the perspective of the data that should become visible.

  1. 01 Initial consultation: which number is missing, and for whom?

    approx. 30 min

    In about 30 minutes we clarify who in your operation is looking for which number today and where it sits – in the PLC, in the MES, in a spreadsheet. You learn which sources can be connected and what a first step would cost. Free of charge and without obligation.

  2. 02 Concept: data model and views

    1–2 weeks

    In one to two weeks we review signals and interfaces, define the data model and sketch the views for each role on paper – no code yet. You receive a list of the sources to be connected, the sketches and a quotation at a fixed price or on a time-and-materials basis.

  3. 03 Delivery and operation: one line first, then the rest

    2-week cycles

    We connect the first line, build the views in two-week cycles and mount the screen where the shift walks past. Whatever nobody reads, we remove. Afterwards the dashboard keeps running at the line – operated by us or by your IT team.

Is this for you

A good fit if …

  • the shift’s piece counts are copied from the PLC into a spreadsheet by hand every evening.
  • your maintenance team only hears about a fault once the machine has already stopped.
  • MES, ERP and the machine report the same KPI – with three different values.
  • management has to ask three people on Monday how the week went.
Questions

Frequently asked questions.

Less than most people assume. A first view needs three signals per machine: running state, piece counter and the current fault message. Almost every controller provides these – via OPC UA, the S7 protocol or Modbus. Order and target data come from MES or ERP as soon as a key such as the order number links the two worlds. If a signal is missing, we start with manual entry at a terminal.

A pilot with one line, two or three sources and one view per role is a manageable fixed-price project; each further line costs less because the data model and views are reused. It gets more expensive when many sources have to be connected, when your controllers do not speak an open protocol such as OPC UA, or when you need many different views. We give concrete figures after the initial consultation – before that they would only be estimates.

With a controller that has OPC UA and network access, the first live view is often up within the first two weeks of delivery. It takes longer when older controllers need a gateway first, when IT has to open access to the machine network, or when MES data needs cleaning before it can be used. We settle these points in the concept phase before delivery starts, so you know the order and the duration in advance.

Yes. The views run in the browser and adapt to the screen size: large on the monitor on the shop floor, compact on the maintenance technician’s phone, as a weekly overview on the management desk. Access from outside the plant runs through your VPN or a dedicated login with roles and permissions – whoever should only see the running state sees only that. Which view is needed on which device is settled in the concept.

We read; we do not replace. We connect controllers via OPC UA, S7 or Modbus, MES and ERP via their interfaces or database views, and Excel files and PDF reports via an import that detects changes. Everything lands in a separate data store with a shared timestamp and a shared machine number; your source systems keep running unchanged. If a system changes later, only that one connector is adapted, not the dashboard.
Articles

Further reading on this topic.

From the ralwo blog – background, worked examples and checklists, each with its sources.

Related services

Visible data is usually the first step.

Once the data foundation is in place, the next tasks are close at hand: automating the workflows that run on these numbers today, detecting anomalies with AI, or developing the application that fits your operation exactly.

  • Custom software development that follows your workflows.

    Every company works differently, and standard software rarely covers that completely. We develop bespoke software that fits your workflows, your staff and your system landscape – straightforward to use and extensible later on.
    More on custom software development
  • AI solutions for businesses: explainable, with source and confidence.

    Want to use AI but unsure where it makes sense in your operation? We look at your processes, name the cases where AI helps, and develop a solution that backs every output with its source and a confidence score.
    More on AI solutions for businesses
  • Process automation for everything still done by hand.

    Many tasks are still done by hand every day – that costs time and leads to errors. With process automation, recurring workflows run automatically: we connect your systems, simplify procedures and take load off your team.
    More on process automation

Free · No obligation · approx. 30 minutes

Let’s talk about your plant.

In a free initial consultation we clarify your goals, your data situation and the feasibility – with no obligation.

30minInitial consultation, free and without obligation