下载PDF

实例探究 > Creating a real-time Key Performance Indicator dashboard with GainSeeker Suite

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

技术

分析与建模 - 预测分析
应用基础设施与中间件 - 数据可视化
功能应用 - 企业资源规划系统 (ERP)

适用行业

电子产品
航天
汽车

适用功能

商业运营
质量保证

用例

预测性维护
过程控制与优化
实时定位系统 (RTLS)

服务

系统集成
软件设计与工程服务

挑战

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.

关于客户

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 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.

运营影响

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.