#Sales data analysis excel serial number

Thanks to him, we have the opportunity to exhibit 2 (or 1-well) groups for a detailed comparison and further analysis of their dynamics: To perform a comparative analysis of goods, you must use the lower control unit - 2 drop-down lists. This block includes all dashboard controls. The following block shows the dynamics of changes in monthly sales activity for the selected year:

#Sales data analysis excel serial number

Colored columns display values for the selected month.Д®ach serial number and color of a column corresponds to the color of its group, as on the entire dashboard: And on the second histogram, the same indicator is segmented separately for all product groups. The first big one shows the total sales amount of all product groups for the current month. The first block is a combination of two columnar histograms: Structure of visual benchmarking in ExcelДЄ dashboard for an extended comparative analysis of sales of goods consists of only 3 blocks and 4 control elements. Then all the table values are read from the Processing sheet and transferred to the DASHBOARD main sheet as a visualization created using interactive charts and diagrams. Then, on the вЂњProcessingвЂќ sheet, all initial data is processed by complex formulas and prepared for visual analysis: Using this template, we will process the initial statistical information that should be filled out on the вЂњDataвЂќ sheet: For further analytical steps, we will use a dashboard template with data visualization in Excel.

Identify the strengths and weaknesses of the current situation.

Build a further trade development strategy.

Identify headliners and outsiders of products for a specific seasonality period.

Organize the necessary volumes of supplies.

Correctly determine and set prices for goods.

Thanks to the extended comparative analysis of the sale of goods, we will get the opportunity: It is necessary to analyze the dynamics of changes in the activity of monthly sales of each group, the relative indicators of other groups and the established average annual plan. Information on the history of sales of goods in 5 categories (A, B, C, D, E) was exported from the ERP system over the entire five-year accounting period (2021вЂ“2025). To illustrate the use of an example of a visual report, we first simulate the situation. Dashboard for benchmarking merchandise trading in Excel