% include navbar.html %}
  1. Corso Systems
  2. /
  3. Production Data Management System for a Diatomaceous Earth Processing Company

Production Data Management System for a Diatomaceous Earth Processing Company

Project Summary

A leading diatomaceous earth processing facility was storing some of its production data in Excel spreadsheets.

After using this method for a while the amount of spreadsheets on their server made it difficult to find specific information in a timely manner.

The best remedy for this problem was to move to a web-based solution. This approach provided a centralized database to store the data and an interface for authorized users to enter, edit, and view the data.

Project Details

Lovelock NV

Web-based tools, Technology Migration

  • Centralize production data
  • Decrease data management overhead
  • Optimize business processes
  • Understand existing processes
  • Develop web-based system
  • Implement system and train personnel on its operation
  • Increase value of data by integrating with process data
  • Reduced overhead costs
  • Increased data utilization
  • Increased productivity


Our staff worked with a large diatomaceous earth processing facility to implement a web-based system to store and analyze its production data.

We used the client's existing paper and Excel based tools to develop a database schema for the data.

With the database in place we developed the web-based front end to enter new data and access existing records. In addition to data entry forms the interface included automated reporting functionality allowing users to select a date-range and/or specific process areas to view production data.

The system generates nightly reports and sends them to key personnel automatically.

In addition to tabular views of the data, the system includes pareto charts to track downtime and product loss reasons for a range of dates as well as process OEE.

The system also includes the ability to automatically gather and store data from the process historian.


  • FactoryTalk Historian
  • SQL Server
  • jQuery
  • Javascript


Centralized database of production data

Advanced analysis tools for production losses, downtime and OEE data.

Automated reports sent out to key personnel on a regular basis.

See other case studies: