Automating Historian Data analytics – driving value in production processes

By Elliott Middleton, Director of Product Management, AVEVA

In the time of the pandemic, manufacturing operations looking to pivot production to new items and improve productivity have become more reliant on data historians providing sensor data analytics. Traditionally, only operations teams physically present in plants had access to operational data in control systems, but with widespread remote working and digital transformation initiatives, offsite engineers now require access to data too.

Data historians take high-speed sensor readings and record them. Depending on the industry,readings including temperatures, pressure, flow rates and conveyor speeds are taken constantly, millisecond to millisecond, and then preserved. In recent times with the rise of IIoT device connectivity, collecting and processing that operational data automatically in historians is becoming more affordable and accessible.

Automating data collection key to modernizing 
Automating the collection of operational data is especially important in the food and beverage sector, where there are fast production lines and multiple products. In the past, smaller food and beverage manufacturers used a paper-based chart recorder to record sensor measurements. They might have as many as five measurements on a chart recorder. In contrast, automated data collection systems collect and store millions of measurements.

Previously, there was only so much physical space to place that chart recorder, so manufacturers had to be selective about the data recorded. Invariably,they then needed something that wasn’t on the paper.Now, with control systems, IIoT sensors, and edge devices, it is easier to collect and record everything that might be useful,for anything from process improvement to troubleshooting. Regulatory reporting is the focus for using historians to store operational data in some industries. Automating the collection and storage of operational data enables businesses to produce the data they need for compliance.

Diagnostics and troubleshooting

The next step is extracting the value from that data. 71% of manufacturers we surveyed said one of the key values of historian data came from diagnostics and troubleshooting. Similarly, 43% said it helped identify process improvement opportunities and 56% used it to help reduce energy consumption.Automated data collection and analysis reveals patterns and trends that can support and speed up troubleshooting. If operators can find out in 30 seconds what the problem was, instead of in five minutes, then they can correct that much faster.

In consumer goods and food and beverage manufacturing, high-speed packaging lines are the norm and so is jammed packaging material. For example, if a yogurt plant that is producing 10 cartons a second is down for a minute, with 100 small faults a day –that’s 600 yogurt cartons affected.Accurate data is also key to downtime tracking, production costing and energy consumption reporting, enabling manufacturers to increase uptime and allocate energy cost to individual production units.

Very often manufacturers don’t know what they don’t know. Accurate data provides fresh insight. Data can drive productivity and profitability by spotting opportunities for process improvement. For example, a mechanical bag filling application had several steps. The systems integrator committed to supplying a system that would deliver a rate of filling two and a half bags a minute. Then they discovered they were able to fill three and a half bags a minute. At that point, many would have said,“Great we overachieved, we’re done”.

This particular system integrator recorded the processing steps in the data historian. They ran a report on these processing steps, discovering the number of milliseconds that each operation took on average. This uncovered a wide variation in the time it took to close the bag. They investigated the reasons for the variation and shaved five seconds off of the longest time. That increased production by 20%. Each bag was worth $250, so that translated to almost three quarters of a million dollars a dayworth of increased production.

More Accessible
Traditionally, this detailed operational data was only accessible in the control room. While that simplifies some of the security challenges, it is problematic when more and more people could benefit from that data. Increasingly, sites are mirroring it to more accessible systems on the business network or online. This hybrid approach is ideal for improved and more timely decision making by more people. Now engineers can access the data from their mobile phones and from home when they need to. That has proved invaluable in the Covid-19 era.

In less traditional manufacturing applications, the accurate data is still quite valuable, but sites lack the needed infrastructure, staff and expertise.In developed economies, health and beauty products are sold in large containers. However, in emerging economies, those are too expensive, so products are produced in smaller packaging.

To avoid high distribution costs, local shampoo plants operate from a miniature plant the size of a shipping container. Whereas in North America there might be four large plants, in an emerging economy that would be replaced by 50 shipping container-sized plants. Similarly, some water treatment plants operate in a shipping container, to clean water in remote locations, such as mining operations. There is no room for servers or IT engineers to handle data onsite. But the information is just as valuable to small operation and using a fully-managed cloud solution makes it cost-effective even for these small sites.

Operations leaders looking to the cloud used to consider security to be a major concern. For some time, there was the perception that on-premise data storage was a more secure option than allowing the data to leave the organization. That has changed. There is an increasing recognition of the high level of security of the cloud itself – and secure, send-only data architectures protect outbound data. Cloud data is now safely behind multilayered security that is hard to match in a small, on-premise collection of servers

A highly automated process is prerequisite to collecting and getting the best from historian data, providing insight to improve diagnostic troubleshooting and identify improvement opportunities. As more organizations gain access to sensor data, more job functions can leverage it. Many small and medium size manufacturers are still getting by with paper-based chart recorders, or perhaps with a basic data-loggers.

Long term, though there is an inexorable trend towards automated data collection, data historians, and cloud-based solutions. Faster reporting and diagnostics will drive productivity and profitability gains that will provide an unbeatable competitive edge.

data analyticsData Historians
Comments (0)
Add Comment