Conteq has developed a report on key indicators for Krasleninvest

2023: Developing a report on key indicators

On June 16, 2023, Conteq announced the development of a report on key indicators for Krasleninvest.

Production performance

According to the company, in 2022, Kraslesinvest turned to the system integrator Conteq with a request for development of the "Key Indicators" report in Power BI.

The main objectives of the project:

• develop a convenient report that will allow management to assess the state of affairs at the enterprise;
• Provide management access to up-to-date information on the status of key processes at any time.

General indicators

During the pilot phase, the data source was an Excel file. In the process of the study, operational information was received that from all forest plots, from woodworking production and from the main office it is transferred to the finance department, where it is reduced by persistent financiers into one large Excel file. A total of 40 sheets.

The company has already assembled its own "dashboard" in Excel with key production indicators. All of this formula and calculation checking work was manually supported every weekday, which could lead to errors. One weekday = one Excel file.

General indicators

In addition, the previous solution was completely static and did not allow:

• see the change in the indicator over time;
• compare the value of the current period with the previous year, month, or other arbitrary period;
• See the value of the previous month
• to assess the current position since the beginning of the year (YTD).
• employees from another city could only access information on request by mail.

First step:

• As part of the first step, the working group revised the list of key indicators and divided them into four blocks:
• logging;
• woodworking;
• sales;
• finance.

Each indicator has:

• Target value - scheduled once a year and never adjusted
• planned value - planned before the beginning of the month taking into account external factors;
• actual value.

Logging

After defining the list of indicators, it was necessary to design the source. The internal processes of the finance department, requirements for the pilot project were taken into account and as a result, a table was designed inside the customer Excel file. Thus, business process the collection data underwent minor changes. Additionally, formulas and have been added algorithms to reduce the number of errors.

After the list of indicators and the source structure were approved, the stage of developing the report began. The number of indicators was quite large in order to place them on one sheet at once, so that without additional manipulation it was possible to cover the entire "picture." At the same time, some indicators had to be displayed in dynamics by month.

The main page contains 4 matrices, which by default display data for the MTD (Month-to-Date) period. Thus, when the user opens the report, he receives information about the results of the current month. At the same time, the user has the opportunity to choose another period:

• MOM (Month-over-Month);
• YTD (Year-to-Date);
• PYTD (Previous Year to Date);
• POP (Period-over-period).

For example, when the user selects YTD (Year-to-Date), the headers of all 4 matrices are renamed.

An internal page has been developed for each of the four blocks. Access to internal pages is carried out through the navigation panel. The internal page contains 2 graphs that display the values ​ ​ of the indicators in progress. In addition, it was added the ability to switch graphs to histograms, which allow you to see the difference between the value of the indicator in the last year, in the current year and with the plan.

Orders were issued on the Customer's side, securing those responsible for timely provision of reliable data. Certain employees place an Excel file with up-to-date operational data in a network folder. Power BI checks for up-to-date data every 15 minutes during business hours. If you want to comment on the value of a key figure, the specialist fills in a special field in the Excel table. The specialist's comments are uploaded to the report, where they can be read by the guide.

After the introduction of the updated dashboard, users noted the convenience of working with the report and the ability to quickly analyze information.

As a result, the developed Excel-Power BI bundle allowed:

• Optimize the accuracy and availability of information
• reduce labor costs for reporting preparation.

The result of the work was a report that allows users to track key indicators.