Brief Summary
FICOSOTA, an international fast-moving consumer goods company with a presence in over 70 markets, is implementing a comprehensive Qlik BI platform to address the growing need for centralised data management and analysis. The solution consolidates information from multiple systems and covers key business processes – sales, finance, logistics, and market analysis – providing reliable data, automated calculations, and a detailed view of the company’s performance.
As a result, the business gains a single version of the truth, faster access to analytics, and improved planning, forecasting, and decision-making capabilities.
About the company
Ficosota is one of Bulgaria’s largest fast-moving consumer goods companies. It operates in the following sectors: food, hygiene and sanitary products, cleaning and laundry detergents. Its portfolio includes the following brands: Savex, Milde, Emeka, Teo, Puffies, Maretti, Livity, and My Motto.
Ficosota was founded in 1994 and currently operates in over 70 markets across 6 continents, with 6 factories in Shumen and offices in Bulgaria, Romania, Ukraine, and New York.
The Need for a New Software
As the business grows, there is a need for a comprehensive and scalable BI environment that covers the analysis of: the company’s sales in all countries; P&L; receivables analysis; payables analysis; expense analysis; Sales from distributors in Bulgaria and abroad (SalesOut); Deliveries and Logistics; Analysis of market conditions and competitors.
Additionally, the business requires automated calculations and ready-made analytical models to support daily decision-making on various issues. The need for more in-depth analyses in specific areas, such as merchandising, sales team performance, laboratory testing, and project management, also requires the implementation of a flexible BI platform.
Project Objectives
- Accurate data and automatic updates
- An overview of the business in the dashboard and detailed reporting
- Optimisation of human resources
- Reliable and complete historical data
- Forecast analysis
- Optimal use of data
The Solution
The BI applications developed cover the processes for analysing the company’s sales in all countries; P&L; receivables analysis; payables analysis; expense analysis; sales from distributors in Bulgaria and abroad (SalesOut); deliveries and Logistics; and market and Competitor Analysis. Data is loaded from the lowest level of various transactional systems, and users can access the source data with just a few clicks, starting from the Dashboard or a company-wide report. The multi-layered architecture incorporates algorithms for calculation and distribution that provide users with daily ready-made analyses for various business scenarios. Additional applications have been developed for analysing laboratory tests, merchandising and sales staff performance, project management, and more.
Results
- A comprehensive overview of the company’s status;
- Collection, consolidation, and analysis of data from all core systems in one place;
- Ready-to-use financial and other management reports from the highest to the lowest level;
- A unified approach and a single source of truth for all key performance indicators (KPIs);
- Fast performance and a flexible interface for a customised view of the information;
- Simplified and accelerated comparison of forecast and actual data;
- Ability to analyse the company’s profitability based on key indicators;
- Simplified and accelerated analysis of the performance of various products;
- Easy and quick access to information on warehouse inventory.
Integrations
- SAP S/4HANA,
- NetSuite ERP,
- Integra ERP,
- Cubit,
- Senior ERP,
- DSX, EDGAR,
- Excel files,
- XML files,
- TXT files,
- websites,
- Web APIs, etc.
