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
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
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
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
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
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 meansREAD MORE