Qlik Case Studies Fleura builds knowledge paradise using information from QlikView

Edit This Case Study Record

	Fleura builds knowledge paradise using information from QlikView Qlik

Fleura builds knowledge paradise using information from QlikView

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Retail
Applicable Functions	Human Resources
Use Cases	Supply Chain Visibility Inventory Management
Services	Data Science Services System Integration
Challenge	Fleura Export B.V., a Dutch importer and exporter of cut flowers and cut foliage, was facing challenges due to its complex organizational structure. The company, which is managed centrally, has buying subsidies and sales offices in various countries, a range of operations, and different IT systems. This complexity was increasingly impacting the company’s course of business. The company's information provision had turned into chaos with scores of Excel reports and emails complicating the management of the company. In early 2006, Fleura started looking for a Business Intelligence (BI) solution with a consolidation tool for its financial reports and a reporting tool for its buying subsidies to replace the obsolete Oracle solution it was using. The company wanted a cutting-edge product which would be easy to use, fast to implement and self-explanatory, therefore requiring no extensive training given the complex structure of its organization. Read More
About Customer	Fleura Export B.V. was established in 1970 and is one of the largest Dutch importers and exporters of cut flowers and cut foliage. Its headquarters and wholesale warehouse are based in Aalsmeer, The Netherlands. The group achieves a large part of its sales through a tight network of 46 of its own branches with a predominantly Cash & Carry function. Through this proven and powerful concept Fleura has been market leader for many years in Germany and The Netherlands; and the expansion is continuing with Austria, Italy, Poland and the Czech Republic opening up new markets. The transport organization, consisting of 75 drivers, ensures that the products are delivered daily, on time and cooled. Fleura employs over 700 people and generates annual sales of around €200 million. Read More
Solution	Fleura opted for QlikView as their Business Intelligence (BI) solution. The first step in the implementation process was to streamline their data structure. They unified all the financial reports from the various countries and systems and incorporated them into a single Excel report. This data was exported to their central SQL Server database, which acts as the source for QlikView. They built a total of three applications, the first one being a financial application. The second application was an operational application for their buying subsidies. With QlikView, they could easily disclose this data, drill down to detail level, and gain new insights. Finally, they developed an ADP-based HRM application to track data such as overtime, productivity and sick leave per employee. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Retail

Applicable Functions

Human Resources

Use Cases

Supply Chain Visibility

Inventory Management

Services

Data Science Services

System Integration

Challenge

Fleura Export B.V., a Dutch importer and exporter of cut flowers and cut foliage, was facing challenges due to its complex organizational structure. The company, which is managed centrally, has buying subsidies and sales offices in various countries, a range of operations, and different IT systems. This complexity was increasingly impacting the company’s course of business. The company's information provision had turned into chaos with scores of Excel reports and emails complicating the management of the company. In early 2006, Fleura started looking for a Business Intelligence (BI) solution with a consolidation tool for its financial reports and a reporting tool for its buying subsidies to replace the obsolete Oracle solution it was using. The company wanted a cutting-edge product which would be easy to use, fast to implement and self-explanatory, therefore requiring no extensive training given the complex structure of its organization.

About Customer

Fleura Export B.V. was established in 1970 and is one of the largest Dutch importers and exporters of cut flowers and cut foliage. Its headquarters and wholesale warehouse are based in Aalsmeer, The Netherlands. The group achieves a large part of its sales through a tight network of 46 of its own branches with a predominantly Cash & Carry function. Through this proven and powerful concept Fleura has been market leader for many years in Germany and The Netherlands; and the expansion is continuing with Austria, Italy, Poland and the Czech Republic opening up new markets. The transport organization, consisting of 75 drivers, ensures that the products are delivered daily, on time and cooled. Fleura employs over 700 people and generates annual sales of around €200 million.

Solution

Fleura opted for QlikView as their Business Intelligence (BI) solution. The first step in the implementation process was to streamline their data structure. They unified all the financial reports from the various countries and systems and incorporated them into a single Excel report. This data was exported to their central SQL Server database, which acts as the source for QlikView. They built a total of three applications, the first one being a financial application. The second application was an operational application for their buying subsidies. With QlikView, they could easily disclose this data, drill down to detail level, and gain new insights. Finally, they developed an ADP-based HRM application to track data such as overtime, productivity and sick leave per employee.

Impact #1	QlikView delivers major time savings. Previously, Fleura spent a lot of time collecting data, creating Excel spreadsheets, and interpreting information. Now the job is done on the fly enabling them to notice any deficiencies immediately.
Impact #2	Clear visualization helps Fleura pinpoint weaknesses and take appropriate measures quickly.
Impact #3	The solution’s speed and ease-of-use will stimulate users to work independently eliminating the need for assistance from the administration department.

Impact #1

QlikView delivers major time savings. Previously, Fleura spent a lot of time collecting data, creating Excel spreadsheets, and interpreting information. Now the job is done on the fly enabling them to notice any deficiencies immediately.

Impact #2

Clear visualization helps Fleura pinpoint weaknesses and take appropriate measures quickly.

Impact #3

The solution’s speed and ease-of-use will stimulate users to work independently eliminating the need for assistance from the administration department.

Download PDF Version

Overview

Fleura builds knowledge paradise using information from QlikView

Operational Impact