Case Studies Creating a real-time Key Performance Indicator dashboard with GainSeeker Suite
Edit This Case Study Record

Creating a real-time Key Performance Indicator dashboard with GainSeeker Suite

Analytics & Modeling - Predictive Analytics
Application Infrastructure & Middleware - Data Visualization
Functional Applications - Enterprise Resource Planning Systems (ERP)
Aerospace
Automotive
Electronics
Business Operation
Quality Assurance
Predictive Maintenance
Process Control & Optimization
Real-Time Location System (RTLS)
Software Design & Engineering Services
System Integration
The Operations Manager for a leading manufacturer of electronic operator interface solutions faced a critical issue: the lack of timely access to essential business metrics such as monthly sales goals, gross profit margin, on-time deliveries, and first pass yield targets. This deficiency made it challenging to meet production goals while maintaining quality. The company had critical data stored in its ERP system (AS400), but extracting and formatting this data required special queries and manual processing in spreadsheets, which was cumbersome and time-consuming. As a result, the necessary information was often not available in a timely manner, severely hampering the manager's ability to make informed business decisions. The Operations Manager envisioned a solution where he could turn on his computer every morning and review a daily dashboard of the company's critical business metrics, generated automatically, with the ability to drill down into more detailed information as needed.
Read More
Hertzler Systems has been a leader in Statistical Process Control (SPC) software and Six Sigma for over twenty-five years. They provide the leading real-time data acquisition and analytics SPC software, the GainSeeker Suite. Hertzler Systems serves a diverse customer base, including prominent companies such as BAE Systems, Crown Audio, McCormick & Company, Inc., Hormel Foods Corporation, Snyders of Hanover, Titleist & Footjoy, IDEX Corporation, and TaylorMade-Adidas Golf Worldwide. Their software and services enable clients to connect, collect, analyze, and visualize data, building a data infrastructure for making data-driven decisions. These capabilities help clients improve throughput and yield, enhance cycle times, reduce costs and errors, and increase profitability.
Read More
The customer collaborated with QualiFine Inc., an authorized Hertzler Integration Partner, to develop a solution. Every night, and any other time the manager requests, the GainSeeker Suite queries data from the company's AS400-based ERP system. These queries are summarized in GainSeeker Dashboards and displayed on the manager's desktop. The manager can drill into these dashboards to view control charts, Pareto charts, or other appropriate visualization tools as needed. This automated system provides the manager with a real-time snapshot of the company's critical business metrics, enabling quick and informed decision-making. The solution effectively addresses the challenge of timely data access, allowing the manager to monitor key performance indicators such as monthly sales goals, gross profit margin, on-time deliveries, and first pass yield targets with just a few mouse clicks.
Read More
The manager now has a real-time snapshot of the company's critical business metrics on a single screen, providing a clear overview of business performance and customer satisfaction levels.
The automated system tracks over a hundred daily shipments, highlighting any issues or problem areas, which allows the manager to quickly address and resolve them.
The manager can easily monitor monthly goals for sales, gross profit margin, on-time deliveries, and first pass yield targets, significantly improving decision-making and operational efficiency.
The automated system tracks over 100 shipments daily, highlighting issues or problem areas.
The manager can monitor monthly goals for sales, gross profit margin, on-time deliveries, and first pass yield targets with just a few mouse clicks.
Download PDF Version
test test