Baltika transferred the regular reporting to a single digital system on the basis of the solution Microsoft Power BI

2019: The translation of the regular reporting in a single digital system on the basis of the solution Microsoft Power BI

On October 10, 2019 the Baltika company reported that it transferred the regular reporting to a single digital system on the basis of the solution Microsoft Power BI.

According to the company, Baltika actively implements the project on a didzhitalization analysts and the reporting in Customer Supply Chain. Microsoft BI The solution developed on the basis of Power turns diverse analytical data, collected earlier in Excel, into evident interactive reports and dashborda. All important performance indicators are available to employees in real time from any mobile device in Microsoft application of Power BI now.

The group on development of the business analysis and reporting of the region Eastern Europe is engaged in implementation of this large-scale project. A main goal of the project is creation of the automated tools for monitoring of key performance indicators of processes of a supply chain of products to the customer. The solution allowed to transfer from Microsoft Excel to Microsoft Power BI all regular reporting under transport, a fold, distributive to functions and monitoring of execution of quality of service for our clients.

The employees who are responsible for all links of a supply chain of products to clients address every day different analytical data, online access to which is extremely important for understanding of what aspects of work require improvements. Automation of collecting of these data allowed to reduce time for preparation of the reporting several times. So, reports on complex indicators of customer service, warehouse or transport functions for which preparation it was spent up to several days form in 15-20 minutes now and are available to monitoring in convenient detailing and simple visualization on mobile devices. As a result we managed to reduce considerably time of acceptance of the management decisions directly influencing development of our business. Sergey Suchkov, the senior director on region logistics Eastern Europe told

The Microsoft Power BI tool collects analytical data from numerous internal sources, the received array is processed, and results are visualized in a schedule type, tables and charts, access to which can be got on a single cloud platform. Employees can browse different statistics on key performance indicators of processes from computers, tablets, phones and to react quickly in case of a rejection of actual data from effective objectives. Necessary data integrate in one report or a dashborda according to the level of management that allows to see a necessary cut of KPI on the area of responsibility and to quickly make management decision, without addressing several documents.

One of key advantages of a system — various data visualization which allows to select top trends, correlations and deviations from normative indicators. Besides, a system gives the chance to detail indicators, to select those which are necessary at present and at the specific managerial level from the general data array. Thanks to opportunities of Power BI all managed to configure automatic daily mailing of results of monitoring of service indicators to the interested staff of the company that allowed to refuse completely Excel reports, created earlier manually. The Microsoft Power BI tool helps to configure automatic indication of indicators which advance or lag behind target value, thus focusing attention of the employee or department on what needs to be corrected.

Effective work with data — an important element of ensuring the competitive advantage necessary for success of business. Industrial revolution 4.0. and development of digital economy is demanded from business of quick reaction on any slightest changes, both internal, and external. Increase in supply chain performance due to consolidation of the reporting on the basis of Power BI which is implemented by Baltika company. Anna Kulashova, the director of the department of work with big customers of Microsoft in Russia told

For transfer of a business intelligence of a supply chain of products to the customer on a single platform of Power BI complete diagnostics of initial data in information systems of the company was carried out, all method of calculation of key indicators are described, target values are counted, necessary technical completions for minimization of use of Excel reporting are created and implemented. As a result of preliminary work, Power BI practically does not require regular manual management of indicators that eliminates a possibility of a human error by preparation of reports.

Updates concern work of the services which are responsible for the operational and effective product delivery to clients: warehouse economy, transport, distribution and customer service. The project work is continued — services of forecasting and planning are connected to a system. The command regularly collects a feedback at users of a system of dashbord and reports, makes necessary corrections, creates additional formats of data view which help employees of a miscellaneous to equal to obtain up-to-date information by the current efficiency of the processes.