Qlik Case Studies Global food provider uses QlikView to improve sales analysis reporting

Edit This Case Study Record

	Global food provider uses QlikView to improve sales analysis reporting Qlik

Global food provider uses QlikView to improve sales analysis reporting

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Food & Beverage Retail
Applicable Functions	Quality Assurance Sales & Marketing
Use Cases	Predictive Maintenance Supply Chain Visibility
Services	Data Science Services
Challenge	Bakkavör, a leading provider of fresh prepared foods and produce, was facing challenges with its sales data analysis due to the presence of more than 20 business units in the UK, each having a different Enterprise Resource Planning system and a different process for the analysis of their sales data. This resulted in too many bespoke applications or manual processes and not enough simplicity and consistency. The complexity of the system made it difficult and time-consuming to provide data accurately, leaving little time for actual analysis. Read More
About Customer	Bakkavör is a leading provider of fresh prepared foods and produce with operations in the UK, Continental Europe, America, Canada, Africa, and Asia. The company has more than 20 business units within the UK alone, each with a different Enterprise Resource Planning system and a different process for the analysis of their sales data. This has resulted in a complex system with too many bespoke applications or manual processes and not enough simplicity and consistency. Read More
Solution	Bakkavör, through business intelligence (BI) partner Informance, chose QlikView, a powerful analysis tool capable of extracting and analysing data from any number of sources in seconds. Initially, Informance delivered a template for QlikView with rapid BI / Business Discovery capability. A pilot and proof of concept were built around Bakkavör’s Scottish based business and concentrated on Sales Analysis. After the pilot was deemed a success, QlikView was expanded across Bakkavör’s UK-based businesses, replacing the Access-based legacy system used by the Bakkavör Spalding business, with promotional data as well as sales analysis included. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Food & Beverage

Retail

Applicable Functions

Quality Assurance

Sales & Marketing

Use Cases

Predictive Maintenance

Supply Chain Visibility

Services

Data Science Services

Challenge

Bakkavör, a leading provider of fresh prepared foods and produce, was facing challenges with its sales data analysis due to the presence of more than 20 business units in the UK, each having a different Enterprise Resource Planning system and a different process for the analysis of their sales data. This resulted in too many bespoke applications or manual processes and not enough simplicity and consistency. The complexity of the system made it difficult and time-consuming to provide data accurately, leaving little time for actual analysis.

About Customer

Bakkavör is a leading provider of fresh prepared foods and produce with operations in the UK, Continental Europe, America, Canada, Africa, and Asia. The company has more than 20 business units within the UK alone, each with a different Enterprise Resource Planning system and a different process for the analysis of their sales data. This has resulted in a complex system with too many bespoke applications or manual processes and not enough simplicity and consistency.

Solution

Bakkavör, through business intelligence (BI) partner Informance, chose QlikView, a powerful analysis tool capable of extracting and analysing data from any number of sources in seconds. Initially, Informance delivered a template for QlikView with rapid BI / Business Discovery capability. A pilot and proof of concept were built around Bakkavör’s Scottish based business and concentrated on Sales Analysis. After the pilot was deemed a success, QlikView was expanded across Bakkavör’s UK-based businesses, replacing the Access-based legacy system used by the Bakkavör Spalding business, with promotional data as well as sales analysis included.

Impact #1	QlikView has made the creation of weekly reporting data much quicker, easier, and more flexible.
Impact #2	Accurate decisions can be made more quickly, because all the data is available within a day (and more often than this if required), from one source.
Impact #3	QlikView’s introduction has improved accountability and consistency within Bakkavör, by making information available to all users instantly.

Impact #1

QlikView has made the creation of weekly reporting data much quicker, easier, and more flexible.

Impact #2

Accurate decisions can be made more quickly, because all the data is available within a day (and more often than this if required), from one source.

Impact #3

QlikView’s introduction has improved accountability and consistency within Bakkavör, by making information available to all users instantly.

Benefit #1	50% reduction in time taken to produce weekly reports
Benefit #2	More accurate and faster decisions

Benefit #1

50% reduction in time taken to produce weekly reports

Benefit #2

More accurate and faster decisions

Download PDF Version

Overview

Global food provider uses QlikView to improve sales analysis reporting

Operational Impact

Quantitative Benefit