You are provided with 10 screens for analyzing the turnover of Assol products. In the analysis, the following goals were pursued: a general visual assessment of the company's activities, including: the number of deliveries of goods, the rentability of products, the amount of profit from sales in various regions. The goals were also set to determine the ways of the company's future development based on the presented data.
This dashboard is compiled within the framework of the curriculum for general information and does not include confidential information.
The dashboard was compiled by Ekaterina Magadieva, a student of St. Petersburg State Technological University, Faculty of Economics and Management, Business Informatics.
The analysis of the company's activities is very important for the successful existence of the business. Therefore, we have tried to provide all the necessary information for its qualitative assessment.
The following points were presented in the analysis:
- The number of batches for each product name, the total number of batches of products, the average number of batches of products.
- The number of shipments of batches of goods for each region.
- The number of shipments of batches of products for each product category.
- The number of shipments of batches of products by year.
- The amount of product sales for each product name and product group. The total amount from sales.
- The amount of product sales in each region.
- The percentage of profit from each product name and from each sales region.
- The percentage of profit from each product in a certain region.
With the help of data analysis and visualization, the quantities of deliveries and sales of the company's food products in several regions of the Russian Federation were compared: Moscow, Moscow Region, St. Petersburg, Smolensk, Dmitrov, Balashikha.
Based on the analysis, it can be concluded that the largest deliveries and the largest amount from the sale of goods fall on the city of Dmitrov.
A greater number of deliveries are made for the spaghetti product, but the amount from its sale is lower than the average value for sales of product names. The most profitable category of goods by the number of sales is baking, and the best-selling product is bagels. The highest value for sales of sheep was recorded in Balashikha.
The largest profit comes from the sale of mango (71.43%), and the most profitable region is the city of Moscow (55.56%).
Thus, the company can make a choice in favor of increasing the supply of pastries and mangoes, as well as expanding its activities in the cities of Dmitrov, Balashikha and Moscow.
