Still too much manual data being pulled in your organization and stored in spreadsheets with limited visibility?


Manual exports and manual reports feel harmless until the person with the spreadsheet isn’t around or until the spreadsheet is so hopelessly out of date that it is no longer even useful.
When was the last time you did a PI System audit? As in, a FULL audit. Have you asked questions like:
Is the PI System up to date?
Is the hardware/OS that PI is running on fully supported?
How many tags do we have now and are we close to our limit?
How many of those tags are bad or stale?
Are our interfaces optimized or are they skipping scans?
Is our data quality good enough to start running the AI tools against that our C-suite is demanding?
How about AF? Is it overloaded? How many calculations don’t work and are just eating overhead?
We had a customer that was trying to stay on top of this information. They had 16 facilities and almost 6 million tags across many PI Systems. They were collecting data via the following ways:
Taking screenshots of interface configurations and dumping the data into excel
Trying to catch bad and stale tags via SQL queries that were bogging the entire PI System down
Pulling other data as they could into Excel and trying to merge it all
By the time they got the data collected, it was already out of date, and they still had 30 or more PI systems to go.
When manual work turns into a real problem
One screenshot is nothing. One quick excel sheet? Nah, not too bad either. You will pry Excel out of our cold, dead hands as it is still useful in many cases. However, A whole operation such as the one described above that leans on manual exports into excel is a different story.
Every step done by hand is a chance for a number to get entered wrong, a file to get saved in the wrong place, or a step to get skipped when someone is rushing. Spread that across many sites and many people and you do not have one version of the truth anymore. You have five or six versions of it, and none of them are arrived at the same way. When upper management starts asking hard questions and the answer is “well, George and Fred are still here, and they are on top of it.” This isn’t a good answer. I assure you, George and Fred are drowning. They don’t have time to stay on top of the day-to-day firefighting, much less stay on top of system audits.
It is not cheap either, even though it never shows up as a line item. We have watched companies fly several of their best people, along with a vendor expert, out to a site and have them sit there for a week (or two even), screen scraping data by hand. The flights and hotels add up, but the real cost is those people not doing the work only they can do. They are spending their valuable time where their expertise could really be used on the empty exercise of data collection. Not only that, but the company also loses ground because the experts are simply collecting data instead of actually making things better. So the work only the experts can do piles up while the manual data collection happens. Every company Industrial Insight is facing this issue, no matter the industry or level of maturity and sophistication. No one has enough experts like we have within their ranks. Everyone needs outside help these days. No company is immune.
What we do instead
One of our people asked a simple question during a meeting: “Why the heck are you doing that?” The response was “well, this is the only way we can get this valuable information.” Our employee’s incredulous response was that it should and could be automated and to give him a few days for a first pass at a PowerShell script that scrapes everything they want within minutes and stores it in a database for retrieval.
It morphed into a web-based dashboard on top of information that gets populated in the database weekly by the PowerShell scripts, automatically. No more data collection by hand, no more screen scraping, no more “which Excel sheet is the latest.” All the information they need is at their fingertips, at any time, and is no more than a week old.
From there, we can build a plan to rectify the issues, which is where the expertise should be deployed – not in screen scraping and data entry. The task to mitigate years of what could be deemed as neglect, but is in fact the same issue almost every company Industrial Insight works with faces – declining expertise that is stretched too thin so only the most urgent matters are handled.
This task of getting the system where it needs to be is still very daunting, as there is MUCH to accomplish and get things where we all want them, but now, both we and the company can use our collective intellectual capital on building and working the plan instead of the never-ending task of figuring out “how bad is it?”
We started small, showed that automating data collection worked, then built the full stack of PowerShell scripts, SQL databases, and web-based dashboards that wiped out the week or two of manual screen scraping their experts were doing on every visit across many visits per year, forever. Now the data is collected weekly, automatically, across their sites. Their PI coordinator, Tim Sandford, started calling our team the PI and OT System Green Berets. His point was that their small internal team with our help could suddenly cover a whole lot more ground with WAY less effort than they were expending before.
Start with what hurts most
You do not have to automate everything at once, and honestly you shouldn’t. Start with the manual tasks eating the most hours, because those are usually the easiest to script and the fastest to pay for themselves. The rest builds from there.
This is not about replacing anyone or even growing the team. It is about handing the boring, repeatable stuff to a script so your engineers can spend their time on the work that actually needs their expertise and experience.
If your Health Audits are non-existent or hopelessly outdated, or you are looking at new cybersecurity requirements, you really need to get the information you need, fast, so that you can get the systems in place that deliver high-quality data with less cyber risk.
Want to see where you actually stand?
That is what our free Data Historian System Health and Opportunity Assessment is for. We look at your data health, point out where the manual work is quietly costing you, and give you a short list of what to automate first. No strings, no obligation. Just your real numbers and a plan you can actually use.
Book yours at industrialinsightinc.com/assessment.
See it. Solve it. Sustain it.




Comments