Softline implemented BI in Noveks network

2020: Implementation of an analytical system

On May 6, 2020 the Softline company announced implementation of an analytical system on the Microsoft SQL Server platform and Microsoft Power BI in one of large sellers of cosmetics and household chemicals in Siberia – Noveks company. Now top management of the retailer will be able to receive reports for work of outlets in a few minutes and quickly to reveal the indicators which are not corresponding planned, so – to increase efficiency of network.

The company management of "Noveks" was in search of the solution which would allow to automate process of creation of business reports. The retail chain stores daily are faced the need of consolidation and the analysis of a huge number of information from different information systems, "manually" this process takes away a large number of time and can lead to emergence of errors or incorrect interpretation of the received results. It was necessary to automate and accelerate process of preparation of analytics for top management of the company; give the chance to users independently to build reports on the basis of previously prepared data; exempt IT department from the routine work connected with permanent unloading of data from the existing bases and also lead the main reporting of the company to a uniform sample.

Softline suggested retail chain stores to use complex software the business analysis (BI) the companies Microsoft are the Microsoft SQL Server and Power BI. The solution allows to analyze work of the separate business directions (marketing management of warehouse stocks, budgeting, work with partners, category management and many other things), making the plan-fact analysis, ABC and FRM the analysis, the analysis of shelf space. Within the project in the company it is created the centralized data warehouse, integrating data SAP ERP SAP CRM 1C, Excel and a cash system SET RETAIL. The multidimensional analytical cube processes information arriving in the automatic mode and allows to output all data in a uniform array. All outlets of network, for May 6, 2020 their more than 300 are connected to service. The reporting of the company is implemented on cloud service Power BI therefore it is possible to be connected to a system, using any device with an exit of century internet.

the Retailer can daily monitor key indicators of the work, reveal the "sinking-down" indicators and quickly make management decisions for correction of a situation. Important advantages of Power BI are the flexibility and a possibility of further independent work with the tool and scalings on again opened platforms. – the manager on development of Microsoft services in the SFD and DVFO Pavel Fedyaev commented.

Until recently in network there were no tools for the comprehensive analysis of business processes allowing to compare data from the different systems. At the same time, a system was very simple and convenient in use, we even had not to provide specialized training for employees as externally we will almost not distinguish the interface from business applications already familiar to them. We expect that use of BI will allow to increase efficiency of network, for example, we had an opportunity to glubinno analyze the trade contract and ROMI on the carried-out marketing activities. We plan further development of the solution: deepening of schemes of automation and implementation of BI in all again implemented information systems, – the chief financial officer of Noveks LLC Svetlana Horoshilova shared.