background Layer 1

BI system of Volma company

Customer
Volma
Project manager on the customer side
Alexander Lyubimov
IT Provider
Volma
Project timeline
February, 2020 - February, 2021
Project scope
350 workstations
Goals
  • Implementation of a management decision-making system based on data from the company's information systems.

  • Increasing the speed of access to data and reducing the cost of reporting.

  • Achieving data relevance of all company executives.

The uniqueness of the project

As a result of the project, more than 6 dozen interactive reporting forms have been implemented.

Reporting forms are linked to the KPI of functional units and allow online evaluation of the performance of units and the company as a whole based on OLTP and OLAP data in the company.

Reporting forms are developed by the financial specialists of the company in the Power BI environment based on data from SAP ERP.



Used software

To implement the project, the Microsoft Power BI platform was used, which allows you to create interactive dashboards.

The data source is the SAP ERP EHP7 accounting system and the intermediate storage of SAP BI/BO cubes.

System data and data reside on Hewlett Packard storage systems.



Difficulty of implementation

The most difficult stage of the project was the design and filling of management reporting cubes with relevant data.

For this purpose, the company hired a data analyst, whose area of ​​responsibility was to control the relevance of the data developed by the reports. Those. a data quality control system was established.

In addition, the PowerBi system was developed for access by 200 field employees of the sales department, which required special measures to control and manage mobile devices in order to protect company data.



Project Description

The project was divided into several parts.

1. Software selection from multiple systems:

1.1. The Tableau system from Tableau Software provides a deep and versatile analysis of large amounts of information. Developers position it as BI with a convenient and friendly interface that is easy to learn.

1.2. Originally designed to extend the capabilities of Excel, Power BI from IT giant Microsoft is fully compatible with all Microsoft products and allows you to use third-party applications and data sources.

The choice of Power BI was made because financiers and economists know the DAX language from Microcoft and training will not take much time.

2. Training with the departure of trainers took no more than 2 weeks.

3. To increase the motivation of employees, a competition was formed, as a result of which the three best works were selected.

4. Further, the development of dashboards was carried out as planned. The development of cubes and data transfers was carried out by the company's information technology department engineers.

As a result, we have more than 60 management boards: Forecast of OPIS, Plan for the actual sale of products, Plan-fact of production in the context of plants and lines, logistics service level, IT service level, and much more.



Project geography
The Power Bo analytics corporate system implements reporting for the management of seven factories and 12 sales centers in the Russian Federation and abroad.
The international IT professionals' community has announced the 'Top 100 IT Leaders' project. It is a global initiative that allows top IT managers to share their experience, expand their professional network and showcase the best digitalization practices of their companies. Here we will answer the basic questions about the project.

April was full of new initiatives from vendors as well as some fascinating news on the technology front. With Olympics in Paris approaching, more  news will be flowing in from the capital of France.

Given the current job market situation, one may find a need to maintain a strong LinkedIn profile. AI can streamline the process and make it easier to connect with the right people and opportunities.

The integration of Artificial Intelligence (AI) into business operations marks a transformative era, enhancing efficiency and innovation across industries. From revolutionizing HR with automated recruitment to aiding early disease detection in healthcare, AI's impact is profound. It enables predictive cybersecurity, personalized customer interactions, and accelerated software development in IT. 

Lots of news from technology vendors and modern cases on how to use data analytics for operations excellence – this is what March brought us this year.

We use cookies for analytical purposes and to deliver you the best experience with our website. Continuing to the site, you agree to the Cookie Policy.