Melon Fashion Group ускорила аналитику в сотни раз с помощью DataLens
Background
The Melon Fashion Group is one of the largest fashion retailers in Russia. The company owns the ZARINA, Befree, LOVE REPUBLIC, sela, and IDOL brands, and develops more than 930 stores in five countries. In 2021, it was included in the RBC 500 rating.
The company decided to create an analytical system to help employees quickly understand data and improve work efficiency. In two months, the team combined disparate old reports into a single dataset, and then launched a service for business unit analysts. This service is also used by specialists from the legal team and departments responsible for creating collections. Employees started generating reports ten times faster, and the quality of data increased, and analysts had more time to work on strategic tasks. The service is used by about 130 employees.
Quick analysis of large amounts of data
The Melon Fashion Group uses an ERP system, but it does not allow the generation of the analytical reports that business units need. By the end of 2025, the internal database had accumulated 200 GB of data about nomenclature, sales in various channels, inventory balances, and returns. Teams manually uploaded data to Excel and gathering reports, which took large amounts of time. Employees tried to fine their own solution to a problem using the Tableau® BI system, but there were issues with licenses. As a result, Melon Fashion Group began looking for a complete solution available on the Russian market, that works fast and helps analyze business data without extra effort and costs.
The team tested ten products on the Russian market and settled on Yandex DataLens. Thanks to its intuitive interface, employees quickly started working with it in the cloud. The service does not limit the number of users and requests, supports different data sources and is well suited for analytics tasks.
In this article:
Deploying an analytical solution based on Yandex DataLens
The basis of the Melon Fashion Group digital platform is the 1C:Enterprise ERP system and corporate data warehouse. 1C generates information about sales and stock balances. Microsoft Axapta contains data from marketplaces and online stores. The platform was hosted on our their servers, and part of the ecommerce infrastructure and some online services were hosted on an external cloud platform.
A team of five Melon Fashion Group specialists, using Yandex Cloud technical support, connected Yandex DataLens in two months, assembled the first dataset, configured dashboards, roles, and access rights. Yandex Managed Service for ClickHouse® was connected to prepare showcases with data for commodity turnover reports. The data is updated using the Yandex Managed Service for Apache Airflow® orchestrator.
At the first stage, they set up analytics for the two largest data sets: sales and stock balances. This allowed brand analysts to work independently with all the information needed. The team then started processing other data as well.
Yandex DataLens helps monitor and analyze all management accounting indicators in real time. Melon Fashion Group specialists control sales, margins, margins and discounts, balances and reservations, product turnover, defect parameters, cash flows, purchase budget, and the number of claims. In addition, they analyze customer complaints and feedback about the product by brand, line, and collection.
Implementing analytics and accelerating report development
New analytics tools have significantly increased the transparency of operations and the speed of decision-making. Currently, more than 130 people use the system, and 50 of them generate reports daily. A turnover report for all brands is built in less than a minute — by comparison, before deploying the system, an analyst would spend several hours reporting on one brand. The preparation of standard operational reports for management was 10 times faster. At the same time, over the past five years, the volume of data has increased and new tasks have appeared, and in-house analysts are coping with the volume of work using new tools.
DataLens’s simplicity has attracted employees from other departments. The legal team uses the service to prepare responses to claims. Using the same analytical system, they began evaluating the performance of the IT team. Moreover, some employees have begun to develop additional reports on their own.
Now the company continues to create new dashboards and connect new datasets. The Melon Fashion Group’s legal department plans to use the YandexGPT model (part of Yandex AI Studio) to prepare responses to court decisions and claims.
Opinion
