Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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:
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.
eyJrIjoiNGM2ZTM1ZDgtOGFiYi00NDA3LWI2YjEtMTEwMmM0OTE4MzI4IiwidCI6IjZiZTgxZjIwLWFlY2MtNGQyZC1hMTM0LWJmZWJlOTAxODE4NCIsImMiOjl9
Interesting colors have been selected for the dashboard. But the information in the table on picture 9 is hard to read
Imo, the color of the graphs is a little sharp, but the design is still very nice!
Very interesting design, it allows you to look at the problem from a different angle
In my opinion, everything is done perfectly!
Visualization colors are well chosen. And the information table is available for understanding
А very informative dashboard. Good job!!!
I like the color scheme, very stylish
Such a view is not focused on immediate action. Its main purpose is to help users better understand data, analyze trends and make decisions. Good job!
Nice dashboard, but it's hard to read the conclusion due to picture on the background
When visualizing "Product sales volume in each region", it is difficult to perceive the data, there is not enough filter
Beautiful design!