Customers: Resident of Vyborg Contractors: Wone IT (formerly SoftwareONE Russia, SoftverUAN and Awara IT Russia, Avara Ai Ti Solutions) Product: Microsoft Power BIProject date: 2018/06 - 2018/10
|
2018: Microsoft Power BI-based reporting automation
Vyborzhets is one of the largest representatives of the agricultural business, therefore, special requirements are imposed on the preparation of operational reporting. In addition, industry features complicate the process of preparing reports - the calculation and analysis of yields is non-standard and complex. Accounting is maintained by several systems that do not automatically generate management reports without significant time investments and the risk of manual reporting errors.
That is why a tool was required that would provide flexible analytics and at the same time did not affect the operating activities of the enterprise.
The management of the holding has already worked with Microsoft products, and based on this experience, as well as the recommendations of Awara IT, it was decided to choose Power BI. The tasks of automating data collection ("plan-fact"), calculating deviations, predicting trends in development or deviation of the fact from the plan are solved.
Results
The management of the company works daily with the mobile version of Power BI to assess the current situation and promptly make decisions.
- The problem 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 is formed. Dashboards with high-level indicators, key business indicators have been prepared. Numerous reports on the quantity and quality of products produced per day, reports on the formation of reports for a certain period have been developed.
The project is developing: the formation of financial statements has been implemented, work is underway on sales analytics. Automation of procurement management reporting is planned.