Qlik > 实例探究 > Fleura builds knowledge paradise using information from QlikView

Fleura builds knowledge paradise using information from QlikView

公司规模

Large Corporate

地区

Europe

国家

Austria
Czech Republic
Germany
Italy
Poland

产品

QlikView

技术栈

MS Excel
MS Navision/ MS Dynamics
Exact
KBT Pro
ADP
MS SQL Server 2000
Oracle 9.2

实施规模

Enterprise-wide Deployment

影响指标

Productivity Improvements
Cost Savings

技术

分析与建模 - 实时分析

适用行业

零售

适用功能

人力资源

用例

供应链可见性(SCV)
库存管理

服务

数据科学服务
系统集成

关于客户

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.

登录后查看完整内容

挑战

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.

登录后查看完整内容

解决方案

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.

登录后查看完整内容

运营影响

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.
Clear visualization helps Fleura pinpoint weaknesses and take appropriate measures quickly.
The solution’s speed and ease-of-use will stimulate users to work independently eliminating the need for assistance from the administration department.
Another key benefit is the users’ ability to organize and manage their own ‘cockpit’, adapting and expanding it as needed.

登录后查看完整内容