Case Study

Service Aggregator

An online aggregator of farm products with home delivery.

400+ measures | 15 reports | 6 months

A data warehouse was created on Google BigQuery.
Automated data export to Power BI was set up.
Visualized reports on products were developed, utilizing cohort and ABC analysis.
For the planning department, a warehouse matrix report was created, updating every 2 hours.
For the quality department, visualized reports on claims were implemented. These reports allow the department to monitor the quality of supplied and sold products.

By the end of 2021, the client’s revenue increased by 7%, and margins grew by 9%. Based on the reports, the focus was placed on retaining existing customers rather than acquiring new ones. As a result, revenue from existing customers grew by 18%, the number of orders increased by 13%, and the average order value per customer rose by 3%.
The implementation of BI accelerated the company’s growth, even during the pandemic.
Currently, the data infrastructure for the partner has been established, and the developed reports are updated daily under support.

Explore More Case Studies