Brief Summary
A decade ago, the company began using the QlikView business analytics software. The solution implemented by Balkan Services enabled rapid generation of analyses across multiple dimensions and provided daily access to up-to-date data on the company’s performance.
Years later, the organisation transitioned to the newer, more modern BI solution, Qlik Sense, which better aligns with TESY’s vision as an innovative company.
The new BI software provides enhanced reporting capabilities. A feature for analysing order fulfilment, known as the “Execution Tracking Report,” has been developed. With the new project, a direct link has been established between the BI software and data from the SAP system, allowing for the analysis of additional data that had not previously been analysed in QlikView.
Functionality for ABC analysis has been implemented, aiding product lifecycle planning.
The applications for cash flow and inventory turnover have been enhanced.
About the Company
TESY is a leading Bulgarian and European manufacturer of electric water heaters, indirect water heaters, and home heating appliances. The company operates four factories and has a production capacity of 1.2 million electric water heaters per year. Currently, TESY sells its products in 65 countries across 4 continents.
The Need for a New System
TESY needs to modernise its existing BI environment to overcome the limitations of QlikView and gain more flexible and advanced analytical capabilities. The company is seeking better visualisation, easier access to data, better integration with SAP, and more efficient use of up-to-date information to support business decisions.
The Solution
Qlik Sense compares TESY’s actual data with its sales plans. This allows the company to assess the accuracy of its forecasts and plans, enabling it to respond in a timely manner.
The Qlik Sense BI system allows the TESY team to view the fulfilment status of every order—from receipt, through shipment, to payment receipt.
In Qlik Sense, there are several distinct analysis groups—for the company, for customers (by channel, country, and region), and by product (product code and name). All reports throughout the project can be recalculated in BGN and EUR with a single click. They can be presented as consolidated or unconsolidated sales, which is important for sales by country.
One of the latest developments by Balkan Services consultants in Qlik Sense concerns the so-called “ABC” analysis.
Project goals
- Migration from QlikView to Qlik Sense as a more modern BI platform
- Ensuring a smooth transition without disrupting workflow
- Preserving and enhancing existing reports and models
- Improving visualisation and the user experience
- Enabling more flexible and in-depth analytics
- Integration with SAP and working with up-to-date data in real time
- Centralising information for better decision-making
- Increasing the efficiency and speed of business analysis
Results
- Accelerated generation of a variety of reports across different dimensions;
- Quick access to the latest versions of business data;
- Improved and expanded capabilities for data visualisation and reporting;
- Ability to add new data and definitions by implementing direct data extraction from the company’s main database in SAP;
- Easier comparison between actual data and sales plans, enabling assessment of forecast accuracy and timely response;
- Quick overview of the fulfilment status of each order—from receipt, through shipment, to delivery to the customer and payment.
- Quick analysis of sales data at the company, customer, channel, country, and product levels;
- Simplified analysis of the company’s financial status in terms of inventory turnover, receivables, and payables.
Integrations
- SAP BW;
- SAP;
- Excel files.
