Lamoda (Lamoda) (iT Pro: BI.Qube)

2019: How LaModa boosted the performance of its analytics system with BI.Qube and the Azure cloud

LaModa online store clothes-,, footwear accessories cosmetics Russia and in, CIS offering more than 10 million goods and 4,000 international and local brands. The company has large amount of data information about trade, to analyze these data it uses a corporate system, analytical which should be fast, reliable and relevant. However, with the growth of data, a performance problem began to arise, and the system could not process requests in real time. time Metacomponents and helped BI.Qube technologies Azure LaModa cope with this task.

What was done

To improve the performance of the analytical system, LaModa turned cloudy to team technology experts. IT Pro Experts conducted audit the current situation, put forward hypotheses and tested them in practice (proof of concept). With the help of. BI Qube, Pro's own product IT , specialists were able to quickly optimize the existing analytical solution and deploy it in the Azure cloud. They also moved - OLAP cubes to Azure Analysis Services and made an analytical (AHD data stores) migration to the cloud. Adjusted solution architecture for Azure capabilities and requirements. information security During the implementation of the project, IT Pro experts used the following capabilities:

• Azure SSAS Tabular Model for deploying OLAP cubes in the cloud;
• SQL Server for working with ACH;
• Power BI for visual data analysis.

Monitoring was also configured and statistics were collected, performance counters of the applied IT infrastructure were tracked.

What results have been achieved

Thanks to the BI.Qube solution, LaModa has the following advantages:

• Increase the speed of processing requests by 10 times;
• Reduce maintenance and support costs for the analytical system;
• Increase the relevance of data in analytics by automatically updating;
• Improve system resiliency and scalability;
• The ability to use Power BI visual analysis tools to create interactive reports and dashboards.

The project was carried out in one stage with a total duration of two months. At the pilot stage, experts checked the performance of the Azure platform and confirmed the effectiveness of their solution. In the future, it is planned to develop the analytical solution of LaModa using the new capabilities of the Azure cloud and the meta-components of BI.Qube.