topic Re: Analysis of supplies and sales in Data Stories Gallery

Analysis of supplies and sales

technolog — Sun, 26 Jun 2022 08:56:02 GMT

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.

eyJrIjoiNGM2ZTM1ZDgtOGFiYi00NDA3LWI2YjEtMTEwMmM0OTE4MzI4IiwidCI6IjZiZTgxZjIwLWFlY2MtNGQyZC1hMTM0LWJmZWJlOTAxODE4NCIsImMiOjl9

Re: Analysis of supplies and sales

Bulko_Artem — Mon, 04 Jul 2022 12:58:32 GMT

Beautiful design!

Re: Analysis of supplies and sales

thebestcassie — Mon, 04 Jul 2022 15:04:08 GMT

When visualizing "Product sales volume in each region", it is difficult to perceive the data, there is not enough filter

Re: Analysis of supplies and sales

aanikeychik — Mon, 04 Jul 2022 17:48:38 GMT

Nice dashboard, but it's hard to read the conclusion due to picture on the background

Re: Analysis of supplies and sales

Darya_M — Mon, 04 Jul 2022 20:26:57 GMT

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!

Re: Analysis of supplies and sales

collipium — Tue, 05 Jul 2022 14:12:02 GMT

I like the color scheme, very stylish

Re: Analysis of supplies and sales

Anonymous — Tue, 05 Jul 2022 16:34:44 GMT

А very informative dashboard. Good job!!!

Re: Analysis of supplies and sales

Snezhana1903200 — Tue, 05 Jul 2022 18:25:27 GMT

Visualization colors are well chosen. And the information table is available for understanding

Re: Analysis of supplies and sales

yanayanikson — Tue, 05 Jul 2022 20:34:50 GMT

In my opinion, everything is done perfectly!

Re: Analysis of supplies and sales

KulAn — Thu, 07 Jul 2022 00:26:59 GMT

Very interesting design, it allows you to look at the problem from a different angle

Re: Analysis of supplies and sales

LidiaNechaeva26 — Thu, 07 Jul 2022 19:33:08 GMT

Imo, the color of the graphs is a little sharp, but the design is still very nice!

Re: Analysis of supplies and sales

Kluev — Fri, 08 Jul 2022 17:26:56 GMT

Interesting colors have been selected for the dashboard. But the information in the table on picture 9 is hard to read