Agricultural holding uses Microsoft Power BI to prepare operational reporting

Customer

Agricultural holding “Vyborzhets” is the largest supplier of vegetables and herbs in the North-Western region. The total area of all its enterprises occupies 850 hectares. Products are presented in St. Petersburg, Moscow, Murmansk, Arkhangelsk, Petrozavodsk, Naryan-Mare and Vologda.

In 2000 “Vyborzhets” was included in top-300 best agricultural enterprises of Russia. The company is equipped with the latest technological equipment and opens new production facilities.

 

Challenges

“Vyborzhets” is one of the largest representatives of the agricultural business, so it has to meet specific reporting requirements. In addition, industry features complicate the process of reporting – calculation and analysis of yields is non-standard and complex. Accounting is conducted by several systems that do not allow to automatically generate management reports without significant time investments and the risk of errors in reports prepared manually.

To meet these requirements, our customer needed a tool that would provide flexible analytics and at the same time would not affect operational activities of the enterprise. As company’s management team was already very well familiar with Microsoft solutions, Power BI became the best candidate for this project.

 

Results

The company’s management team uses Power BI mobile daily to know the current situation and faster decision-making.

The issue of correct calculation of yield is solved. The calculations are presented in the form of dashboards and adapted for mobile devices, the design and color design of the solution is proposed.

Production analytics was formed. Dashboards with high-level indicators and key business indicators were prepared. Numerous reports on the quantity and quality of products produced per day, reports on the formation of reporting for a certain period have been developed.

The project is on-going: financial statements preparation is implemented, sales analytics is underway. Automation of management reporting is planned.