Brief Summary
Balkan Services implemented the Qlik BI software at Axxon Bulgaria AD to optimise analysis and reporting processes amid rapidly growing data volumes.
As a result, the company has significantly accelerated and streamlined reporting, increased data reliability, improved operational control, and enabled timely management decisions based on up-to-date, reliable information.
About the Company
Axxon Bulgaria is a trusted partner for distribution, logistics, and marketing services within the fast-moving consumer goods sector, with over 30 years of experience. The company operates across diverse distribution channels, including international and local retail chains, independent grocery stores, pharmacies, drugstores, gas stations, home improvement and maintenance stores, and other retail outlets serving end customers.
The Need for a new system
Over the past 30 years, Axxon Bulgaria’s data has grown to over 150 million records. Business expansion, combined with the nature of the company’s operations, has created a need for additional reporting that is accessible to all employees.
Due to the enormous volume of data, before the BI software was implemented, requests had to be sent to the IT department to generate specific reports, and receiving them could take an entire day. Following the project, such reports can be generated by any authorised employee with just a few clicks.
Project Objectives
- Providing additional and more diverse reporting capabilities driven by business growth and the large volume of data;
- Providing access to reports for all employees, independent of the IT department;
- Ensuring timely and reliable reports to support operational work;
- Automating the reporting process, starting with the sales department;
- Building a comprehensive BI software covering key business areas – sales, finance, logistics, and marketing;
- Creating a corporate dashboard for strategic goals that consolidates key metrics from various areas;
- Implementation of functionalities for generating annual financial statements in accordance with Bulgarian standards, a functional P&L and cash flow statement, as well as brand-new accounting reports – general ledger, trial balance, account history, balance sheet, and income statement (IS).
The Solution
To meet the need for timely and accurate reports, Balkan Services implemented the Qlik Sense BI software at Axxon Bulgaria AD. The business analytics solution covers all reports in the ”Sales”,”Finance”,”Logistics” and “Marketing” sections, as well as a separate dashboard designed for strategic purposes that covers key indicators from various departments within a unified corporate dashboard.
The BI software implementation project began with a detailed business analysis of sales and the subsequent automation of sales reporting.
Subsequently, functionalities were created to generate annual financial statements in accordance with Bulgarian standards, a functional P&L and cash flow statement, and entirely new accounting reports – general ledger, trial balance, account history, balance sheet, and income statement (P&L).
In the next phase of the project, a company-wide dashboard was created, enabling management to track over 100 key performance indicators daily.
Results
- Automated and significantly accelerated reporting process;
- Simplified and accelerated creation of customised reports across various dimensions and visualisations;
- Guaranteed accuracy and reliability of company data;
- Employee time is saved by eliminating daily manual report generation.
- Faster access to up-to-date data supports timely, informed decisions and market insight.
- Increased organisational efficiency, with simplified and accelerated daily monitoring of over 100 key performance indicators;
- Simplified access to historical data from 2002 to the present.
- Track discount impacts and report average discounts per customer daily.
- Inventory, turnover, lot, and expiration tracking are streamlined across locations and customers.
- Inventory control has improved, reducing waste and supporting timely action.
- Instant access to the trial balance and general ledger;
- Planning and comparisons with past data are now simplified.
Integrations
- ERP system of the company – QAD;
- Logistics software.
