Download PDF
Creating a real-time Key Performance Indicator dashboard with GainSeeker Suite
Technology Category
- Analytics & Modeling - Predictive Analytics
- Application Infrastructure & Middleware - Data Visualization
- Functional Applications - Enterprise Resource Planning Systems (ERP)
Applicable Industries
- Electronics
- Aerospace
- Automotive
Applicable Functions
- Business Operation
- Quality Assurance
Use Cases
- Predictive Maintenance
- Process Control & Optimization
- Real-Time Location System (RTLS)
Services
- System Integration
- Software Design & Engineering Services
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.
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 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
Quantitative Benefit
Related Case Studies.
Case Study
Remote Temperature Monitoring of Perishable Goods Saves Money
RMONI was facing temperature monitoring challenges in a cold chain business. A cold chain must be established and maintained to ensure goods have been properly refrigerated during every step of the process, making temperature monitoring a critical business function. Manual registration practice can be very costly, labor intensive and prone to mistakes.
Case Study
Airbus Soars with Wearable Technology
Building an Airbus aircraft involves complex manufacturing processes consisting of thousands of moving parts. Speed and accuracy are critical to business and competitive advantage. Improvements in both would have high impact on Airbus’ bottom line. Airbus wanted to help operators reduce the complexity of assembling cabin seats and decrease the time required to complete this task.
Case Study
Aircraft Predictive Maintenance and Workflow Optimization
First, aircraft manufacturer have trouble monitoring the health of aircraft systems with health prognostics and deliver predictive maintenance insights. Second, aircraft manufacturer wants a solution that can provide an in-context advisory and align job assignments to match technician experience and expertise.
Case Study
Integral Plant Maintenance
Mercedes-Benz and his partner GAZ chose Siemens to be its maintenance partner at a new engine plant in Yaroslavl, Russia. The new plant offers a capacity to manufacture diesel engines for the Russian market, for locally produced Sprinter Classic. In addition to engines for the local market, the Yaroslavl plant will also produce spare parts. Mercedes-Benz Russia and his partner needed a service partner in order to ensure the operation of these lines in a maintenance partnership arrangement. The challenges included coordinating the entire maintenance management operation, in particular inspections, corrective and predictive maintenance activities, and the optimizing spare parts management. Siemens developed a customized maintenance solution that includes all electronic and mechanical maintenance activities (Integral Plant Maintenance).
