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

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

Company Size
1,000+
Region
  • America
Country
  • United States
Product
  • GainSeeker Suite
  • AS400-based ERP system
Tech Stack
  • Statistical Process Control (SPC) Software
  • Data Acquisition and Analytics
  • ERP System
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Cost Savings
  • Customer Satisfaction
  • Productivity Improvements
Technology Category
  • Analytics & Modeling - Predictive Analytics
  • Application Infrastructure & Middleware - Data Visualization
  • Functional Applications - Enterprise Resource Planning Systems (ERP)
Applicable Industries
  • Aerospace
  • Automotive
  • Electronics
Applicable Functions
  • Business Operation
  • Quality Assurance
Use Cases
  • Predictive Maintenance
  • Process Control & Optimization
  • Real-Time Location System (RTLS)
Services
  • Software Design & Engineering Services
  • System Integration
About The Customer
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.
The Challenge
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.
The Solution
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.
Operational Impact
  • 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 ability to drill down into detailed information through control charts, Pareto charts, and other visualization tools enhances the manager's understanding of business performance and areas needing attention.
Quantitative Benefit
  • 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.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.