Blog

Steve Comeau

Steve Comeau is a Senior Business Intelligence Developer for Hallam-ICS. Steve has over 20 years in control systems, specializing in data historians, database programming, and report development.
Find me on:

Recent Posts

Jan 29, 2019 | Written by Steve Comeau | Process Control and Plant Automation, Manufacturing Intelligence

Introduction and Optimization of Data Historians


A Data Historian is a type of time-series database designed to efficiently collect and store process data from a SCADA or automation system. The stored data can then be used to display trends of process data on charts, create reports, or perform data analysis.

READ MORE

Mar 29, 2018 | Written by Steve Comeau | Process Control and Plant Automation, Manufacturing Intelligence

Microsoft Access Databases Are Still Popular

Over the years from the mid-1990s until the present, I have developed many Microsoft (MS) Access database applications for clients and for in-house projects.  Most of these databases are still in use at client sites and others are still used within Hallam-ICS on projects.

READ MORE

Dec 07, 2017 | Written by Steve Comeau | Manufacturing Intelligence

Equipment Energy Usage – My Favorite MI Project in 2017

Looking back on 2017, the Manufacturing Intelligence team has worked on many fascinating projects.  I would like to tell you about my favorite project for the year, involving collecting data and reporting on equipment energy usage, which is a common need at many facilities.

READ MORE

Dec 05, 2017 | Written by Steve Comeau | Manufacturing Intelligence

Looking Back on 2017: Excel Is Still Relevant For Reports And Data Analysis

There are many modern data visualization and data analytics tools used for manufacturing intelligence (MI).  Some, such as Microsoft’s PowerBI, have advanced data visualization capabilities that make products such as Excel seem rather dated; yet, Excel continues to be widely used.

READ MORE

Jun 15, 2017 | Written by Steve Comeau | Manufacturing Intelligence

Choosing the Right Database Type for Manufacturing Intelligence


This blog posts explores the common database types and schemas used for manufacturing intelligence and facilities reporting.

Manufacturing sites and large facilities can generate a large amount of process data that is stored in databases, which are used as data sources for reports.

READ MORE

Dec 15, 2016 | Written by Steve Comeau | Process Control and Plant Automation, Manufacturing Intelligence

Faster Batch Reports from Multiple Data Sources


No one wants to wait minutes for a control system batch report to run. When reports need to run fast, design choices must be used that focus on the needs of the end user and consumers of the data. The standard for report design is to base the report data on “a single version of the truth”. This approach generally means

READ MORE