Qlik Case Studies National Frozen Foods Corporation enhances production analysis with QlikView

Edit This Case Study Record

	National Frozen Foods Corporation enhances production analysis with QlikView Qlik

National Frozen Foods Corporation enhances production analysis with QlikView

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries	Consumer Goods
Use Cases	Real-Time Location System (RTLS) Predictive Maintenance
Services	Data Science Services System Integration
Challenge	National Frozen Foods Corporation, a leading private label packer of vegetables, faced challenges with poor visibility into production data. The company found it difficult to analyze data across disparate IT systems for ERP, warehouse management, HR, and other systems. There was no way to package company data to executives and other employees. The company recently upgraded its legacy ERP, Warehouse Management, and other systems to better accommodate the selection, quality, varieties of crops, seasonality, growing methods, and inventory management needs of customers. While those systems provided better access to the information management and operations professionals needed, the source was limited to exported data in Microsoft Excel. This proved difficult and time-consuming, particularly for those users with non-technical backgrounds. Read More
About Customer	Seattle-based National Frozen Foods Corporation is a $100 million+ privately-held company that processes, packs and freezes vegetables for a variety of customers including major grocery chains and consumer brands in the North American, Asian and Australian markets. Employing over 600 full-time and up to 1,400 seasonal personnel, the company produces over 300 million pounds of frozen corn, peas, beans and carrots per year. The company recently upgraded its legacy ERP, Warehouse Management and other systems to better accommodate the selection, quality, varieties of crops, seasonality, growing methods and inventory management needs of customers. Read More
Solution	National deployed QlikView to 200 employees. The first application was deployed in 1 week. With 64-bit QlikView, National is now able to aggregate and analyze 1-5 terabytes of data sourced from different systems across multiple departments. Real-time production analysis allows plant managers to spot anomalies and trends In output. Role-specific dashboards give all employees access to the data they need to perform their job on a daily basis. Since first deploying QlikView for production analytics, National’s IT team has used the platform to deploy over 100 applications across all departments. Meersman has also used QlikView to populate the company’s “My National” web portal, which provides personalized analysis via tabs and dashboards based on an employee’s job function and permissions. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Application Infrastructure & Middleware - Data Exchange & Integration

Applicable Industries

Consumer Goods

Use Cases

Real-Time Location System (RTLS)

Predictive Maintenance

Services

Data Science Services

System Integration

Challenge

National Frozen Foods Corporation, a leading private label packer of vegetables, faced challenges with poor visibility into production data. The company found it difficult to analyze data across disparate IT systems for ERP, warehouse management, HR, and other systems. There was no way to package company data to executives and other employees. The company recently upgraded its legacy ERP, Warehouse Management, and other systems to better accommodate the selection, quality, varieties of crops, seasonality, growing methods, and inventory management needs of customers. While those systems provided better access to the information management and operations professionals needed, the source was limited to exported data in Microsoft Excel. This proved difficult and time-consuming, particularly for those users with non-technical backgrounds.

About Customer

Seattle-based National Frozen Foods Corporation is a $100 million+ privately-held company that processes, packs and freezes vegetables for a variety of customers including major grocery chains and consumer brands in the North American, Asian and Australian markets. Employing over 600 full-time and up to 1,400 seasonal personnel, the company produces over 300 million pounds of frozen corn, peas, beans and carrots per year. The company recently upgraded its legacy ERP, Warehouse Management and other systems to better accommodate the selection, quality, varieties of crops, seasonality, growing methods and inventory management needs of customers.

Solution

National deployed QlikView to 200 employees. The first application was deployed in 1 week. With 64-bit QlikView, National is now able to aggregate and analyze 1-5 terabytes of data sourced from different systems across multiple departments. Real-time production analysis allows plant managers to spot anomalies and trends In output. Role-specific dashboards give all employees access to the data they need to perform their job on a daily basis. Since first deploying QlikView for production analytics, National’s IT team has used the platform to deploy over 100 applications across all departments. Meersman has also used QlikView to populate the company’s “My National” web portal, which provides personalized analysis via tabs and dashboards based on an employee’s job function and permissions.

Impact #1	Delivered real-time production analysis system during crucial harvesting season
Impact #2	Developed role-specific dashboards for all employees
Impact #3	QlikView was a key tool in bridging a newly-acquired company’s data systems with National’s

Impact #1

Delivered real-time production analysis system during crucial harvesting season

Impact #2

Developed role-specific dashboards for all employees

Impact #3

QlikView was a key tool in bridging a newly-acquired company’s data systems with National’s

Benefit #1	Improved efficiency of dry goods packaging by 25%

Benefit #1

Improved efficiency of dry goods packaging by 25%

Download PDF Version

Overview

National Frozen Foods Corporation enhances production analysis with QlikView

Operational Impact

Quantitative Benefit