'National Lottery 'builds target data warehouse architecture using Arenadata products

2024: Data Storage Construction Results

Brand "" National Lottery summed up the project on. to construction data stores Within its framework, he uses the Group's products - Arenadata analytical MPP -Arenadata DB DBMS (ADB) and enterprise data management system (Arenadata Catalog ADC). Arenadata announced this on January 22, 2025.

The National Lottery historically used several databases and had many different sources that were not combined into a single repository, which made it difficult to accumulate and obtain business-valuable analytical conclusions. Business users needed detailed analytics and prompt reporting. To meet the emerging needs of the business, it was decided to create a single Data Lakehouse, including the use of Arenadata DB to launch analytical CRM. This simultaneously increased the stability of data acquisition, the quality of storage and accumulation, reduced the time for data analysts and business to receive it.

We have already implemented, configured and completed the business glossary, metrics and metrics catalogs. All our metrics are maintained in Arenadata Catalog. With the introduction of the product, we were able to design and build a hierarchy of connections, implemented pyramids of metrics and ensured their visualization. Now we see all dashboards, their relationships with data, associate data lineage with metrics in one place. Plus, they were able to connect a BI tool, and Arenadata Catalog still acts as a centralized catalog of dashboards. The "National Lottery" team uses ADC as a complete single source of business knowledge about their data. Also, its implementation accelerated the onboarding of new and improved the quality of work of existing employees, - said Evgeny Zhilov, CDO of the National Lottery company.

The implementation of the project to build a targeted data warehouse architecture allowed the National Lottery team to improve the quality of data in the company and storage performance. As a result, it was possible:

• Reduce the average query execution time by 75 times
• Reduce query errors by 7.5 times
• Reduce memory overflow errors by 2 times
• Reduce data download times by up to 6 times
• set up the ability to receive an update of analytical reporting every 20 minutes;
• reduce the calculation time of nRT-indicators by 15 times.

In addition, the performance of the data analytics team increased 6 times over the year, and the reporting T2Data decreased to 5-10 minutes and data analytics to 1 days in base scenarios.

With the transition to Data Lakehouse and the introduction of Arenadata products, we have fully automated seven key reports for the company that were previously prepared manually and can develop Data Governance approaches. We also further neutralized the impact of key risks, including risks of alert and monitoring systems. Key teams of the company work with the storage and business glossary, for example, business unit, finance, strategists, products. It is important that our data office consists of only a few data engineers who support the maintenance of more than 100 regular reports and dashboards, "added Evgeny Zhilov.

The project implemented by the National Lottery clearly demonstrates the trend gaining relevance: before implementing data solutions and building large storage facilities, it is necessary to ensure the quality of the company's data. This approach allows you to effectively approach the further implementation of digitalization tasks, - said Yulia Ilyina, director of the department for work with the financial sector and international business Arenadata.

Arenadata DB is designed to work with large analytical queries and is capable of containing tens of terabytes of data in corporate storage. With the product it is possible to:

• reduce Time to Market for new developments;
• Optimize storage TCO
• Accelerate business processes without significantly rewriting code.