Brief Summary
“Lavena” AD is implementing the cloud-based BI solution with Qlik in collaboration with Balkan Services to enable faster and easier access to information and more effective data analysis. The project provides predefined reports and analyses, as well as the ability for users to create their own reports according to their needs. Thanks to the system, the “Lavena” team works with up-to-date data, which facilitates sales analysis and supports timely management decision-making.
About the Company
Lavena AD is a leading manufacturer of cosmetic products and lavender oil in Bulgaria. Over the past 60 years, the company has established its brands across 5 continents and in over 40 countries. In addition to the popular “Bochko” products for children and babies, the company also owns the brands “My Nature,” “Bebble,” “Maternea,” “My Rose,” “Kiki,” “Hard-Working Hands,” “Hands@Work,” “Footness,” and “Sport Ready.”
The company produces 50 tons of lavender oil annually, which ranks it among the world’s leading lavender oil producers.
The Need for a New System
As Lavena AD’s business and data volume grew, quick access to accurate and timely information began to pose a challenge. Generating the necessary reports takes more and more time, the scope of the reports is insufficient, and every additional breakdown requires extra time.
Project Goals
- Faster and easier access to information;
- More effective data analysis;
- Automation of data processing and analysis;
- Working with up-to-date data in real time;
- Facilitating sales analysis;
- Ability to create personalized reports and statements;
- Supporting timely management decisions.
The Solution
The joint BI project between “Lavena” and Balkan Services streamline and automates business analysis processes in the sales sector. The developed BI application includes a central company-level dashboard, customizable reports tailored to specific business needs, as well as analysis of products, customers, discount analysis, geofencing, and receivables.
Results
- A single source of information: an effective tool for analysis and decision-making, providing all users with access to consistent data on key business metrics;
- A streamlined and accelerated process for processing and analyzing sales data;
- Faster identification of problem areas and timely decision-making;
- Streamlined and accelerated process for analyzing various sales discounts – monthly, quarterly, annual – and their impact on sales;
- Faster and easier access to predefined reports and analyses;
- Ability to generate customized reports with just a few clicks;
- Increased accuracy of sales data and quick access to up-to-date information;
- Timeliness and convenience in using available information;
- Significant time savings for key employees.
