Qlever Solutions has completed a project to implement a data warehouse and BI system for Azbuka Food, a supplier for the HoReCa sector. The company manages over 2,500 SKUs and serves more than 2,000 clients across six Russian regions.
Previously, the distributor relied on manual Excel reporting exported from 1C. The new DWH integrates data from 1C:Enterprise 8.3 and Excel, featuring eight analytical storefronts covering sales, inventory, and pricing.
The BI application enables sales representatives to identify growth potential by comparing a client's purchasing profile with similar businesses. This functionality allows staff to suggest relevant products, increasing cross-selling opportunities.
The project resulted in a 30% increase in the share of additional sales among existing clients relative to the planned potential. The system also includes access control, restricting representatives to their own client base.
The architecture of the solution is designed to be platform-independent. By separating data processing in the DWH from the visualization layer, the company can switch BI platforms in the future without rebuilding its data logic.
