Case "Visualization. What is the benefit for a retailer? ”
Every day, the retailer operates with information about sales in stores, product categories, prices. And it seems that this data is enough to be aware of what is happening in the store or network. Is it so?
Analyzing large data arrays is difficult for a retailer. Large tables do not show dynamics and dependencies. Visualization on the contrary - allows you to immediately see the dynamics of processes, the relationship between them. Several indicators can be compared at the same time, immediately determine how they affect each other, for example, how the price change affects the turnover and the number of sales, how the change in the average bill varies with the number of checks and turnover, and so on.
To apply analytics, you need to make your perception of indicators as easy, fast and comprehensive as possible. Visualization of information will help to get such a stereo effect on the indicators.
')
Visualization is:
In short, visualization is awesome!
And now closer to retail.
To illustrate this, we, Datawiz.io , will give an example.
We used visualization to evaluate the effectiveness of the action held in the store - “Discount for chicken and soft drinks”. Using visualizations, it was determined how the price change influenced the turnover and the number of sales of several categories.
Step one. Tracked changes in turnover and the number of store sales in the pre-auction period (one month before the action). And then built a graph for such indicators:
Change in turnover (horizontal), Change in sales (vertical) and Percent of turnover (bubble diameter) by store categories for one month.
From the graph it is clear that in almost all categories there is a drop in the number of sales and turnover.
Step two - we built a similar schedule for the stock period to visualize how sales of promotional categories and all categories of the store have changed.
The graph clearly shows that in general, almost all categories of growth occurred. Most in terms of turnover and sales, categories such as Soft Drinks, Meat, Alcohol, and others increased.
The third step - to determine the percentage of growth categories Meat, Non-alcoholic beverages and other categories, we analyze them in more detail, taking into account the price and its changes for the month.
To do this, visualize the following indicators:
Change in the number of sales (horizontal), Price change in% (vertical), Percentage of turnover (bubble diameter).
Determine the relationship between price and quantity of sales for goods of each category. Then, we compare prices and quantities of sales for the pre-stock and promotional periods.
Sales of meat in the pre-period: turnover fell by 37 thousand UAH., The number of sales - by 615.
Let's see how the price and sales of goods in this category.
As can be seen on the chart, the price of chicken fillet rose by 0.5%, the number of sales increased by 35.
The price for a quarter decreased by 1.26%, the number of sales increased by 812.
For other goods, the price only increased.
During the promotional period, sales of meat increased: the turnover increased by UAH 1035728, the number of sales - by 28 915.
We carry out a more in-depth analysis of products from the Meat category, taking into account price changes.
We observe that the price of chicken fillet has decreased by 6%, the number of sales has increased by 6,765.
The price of chicken thigh decreased by 6%, the number of sales increased by 3 380
The price for a quarter chicken has decreased by 1.5%, the number of sales has increased by 6045.
Thus, already at this stage of the analysis, it is possible to make an interim conclusion that as a result of the conducted marketing activity and discounts, the turnover of meat increased by 1 million UAH.
Visualization clearly shows these changes and the dynamics of the goods depending on changes in value.
Let's analyze
Sales of non-alcoholic beverages fell in the pre-intervention period: the turnover decreased by 113,893 UAH, and the number of sales - by 9357.
Let us analyze the change in sales of goods from the category of Non-alcoholic beverages, given the change in price.
The most significant price reduction - 8% - occurred at Znamenovskaya Non-Aerated, the number of sales increased by 112.
The price reduction of 6% for Znamenovskaya highly carbonated led to an increase in its sales by 1009 units.
Sales of non-alcoholic beverages during the promotion: turnover increased by 198 334 UAH, and the number of sales - by 20 857.
After analyzing sales from this category with regard to price changes, we see that:
the cost of “Caravan strongly carbonated” decreased by 20%, while the number of sales increased by 10,485;
the value of “Biola taste of orange” decreased by 23%, while the number of sales increased by 1,583;
the cost of Kvass Arsenyevsky decreased by 28%, the number of sales increased by 769.
Dynamics of change in the number of sales from the category of soft drinks
Tracking the dynamics of sales of individual commodity items is also useful, it gives you the opportunity to choose the goods giving the greatest increase in turnover in the right period.
The considered example of data visualization allows the marketer to significantly save time when planning stocks simply by defining the products and categories that need to be promoted. After all, the formation of the necessary indicators for the stock is achieved not only by reducing the price, but also by choosing the right product for a discount. Evaluation of the results of marketing activity also does not require significant efforts to select the necessary data from reports on an individual store or network as a whole, it is useful to be able to view the sales dynamics of both individual products and whole categories.
Let's remember how often, having received information, we perceive it as a regular report. Processing these reports, we spend an important resource - our time. But can we be sure that we used all the possibilities of the analysis, that the data are not dead weight?
Visualization makes it easy to determine the desired indicators without “zagrulyaya” perception of many dry numbers.
Our BI Datawiz.io service allows you to apply visualization capabilities to all main reports for retail.
Analyzing large data arrays is difficult for a retailer. Large tables do not show dynamics and dependencies. Visualization on the contrary - allows you to immediately see the dynamics of processes, the relationship between them. Several indicators can be compared at the same time, immediately determine how they affect each other, for example, how the price change affects the turnover and the number of sales, how the change in the average bill varies with the number of checks and turnover, and so on.
To apply analytics, you need to make your perception of indicators as easy, fast and comprehensive as possible. Visualization of information will help to get such a stereo effect on the indicators.
')
Visualization is:
- simplicity of perception of information. Your brain can not be equal to the computer for the processing speed of large volumes of information.
- visibility. Information in charts, graphs, diagrams is perceived better than the traditional - linear, at times.
- getting a holistic picture of what's going on. As already said, a stereo effect is being created - what had to be sorted out for some time, is perceived in a few seconds by one glance.
- gaining more room for ideas.
In short, visualization is awesome!
And now closer to retail.
To illustrate this, we, Datawiz.io , will give an example.
We used visualization to evaluate the effectiveness of the action held in the store - “Discount for chicken and soft drinks”. Using visualizations, it was determined how the price change influenced the turnover and the number of sales of several categories.
Step one. Tracked changes in turnover and the number of store sales in the pre-auction period (one month before the action). And then built a graph for such indicators:
Change in turnover (horizontal), Change in sales (vertical) and Percent of turnover (bubble diameter) by store categories for one month.
From the graph it is clear that in almost all categories there is a drop in the number of sales and turnover.
Step two - we built a similar schedule for the stock period to visualize how sales of promotional categories and all categories of the store have changed.
The graph clearly shows that in general, almost all categories of growth occurred. Most in terms of turnover and sales, categories such as Soft Drinks, Meat, Alcohol, and others increased.
The third step - to determine the percentage of growth categories Meat, Non-alcoholic beverages and other categories, we analyze them in more detail, taking into account the price and its changes for the month.
To do this, visualize the following indicators:
Change in the number of sales (horizontal), Price change in% (vertical), Percentage of turnover (bubble diameter).
Determine the relationship between price and quantity of sales for goods of each category. Then, we compare prices and quantities of sales for the pre-stock and promotional periods.
Meat category
Sales of meat in the pre-period: turnover fell by 37 thousand UAH., The number of sales - by 615.
Let's see how the price and sales of goods in this category.
As can be seen on the chart, the price of chicken fillet rose by 0.5%, the number of sales increased by 35.
The price for a quarter decreased by 1.26%, the number of sales increased by 812.
For other goods, the price only increased.
During the promotional period, sales of meat increased: the turnover increased by UAH 1035728, the number of sales - by 28 915.
We carry out a more in-depth analysis of products from the Meat category, taking into account price changes.
We observe that the price of chicken fillet has decreased by 6%, the number of sales has increased by 6,765.
The price of chicken thigh decreased by 6%, the number of sales increased by 3 380
The price for a quarter chicken has decreased by 1.5%, the number of sales has increased by 6045.
Thus, already at this stage of the analysis, it is possible to make an interim conclusion that as a result of the conducted marketing activity and discounts, the turnover of meat increased by 1 million UAH.
Visualization clearly shows these changes and the dynamics of the goods depending on changes in value.
Let's analyze
category soft drinks
Sales of non-alcoholic beverages fell in the pre-intervention period: the turnover decreased by 113,893 UAH, and the number of sales - by 9357.
Let us analyze the change in sales of goods from the category of Non-alcoholic beverages, given the change in price.
The most significant price reduction - 8% - occurred at Znamenovskaya Non-Aerated, the number of sales increased by 112.
The price reduction of 6% for Znamenovskaya highly carbonated led to an increase in its sales by 1009 units.
Sales of non-alcoholic beverages during the promotion: turnover increased by 198 334 UAH, and the number of sales - by 20 857.
After analyzing sales from this category with regard to price changes, we see that:
the cost of “Caravan strongly carbonated” decreased by 20%, while the number of sales increased by 10,485;
the value of “Biola taste of orange” decreased by 23%, while the number of sales increased by 1,583;
the cost of Kvass Arsenyevsky decreased by 28%, the number of sales increased by 769.
Dynamics of change in the number of sales from the category of soft drinks
Tracking the dynamics of sales of individual commodity items is also useful, it gives you the opportunity to choose the goods giving the greatest increase in turnover in the right period.
The considered example of data visualization allows the marketer to significantly save time when planning stocks simply by defining the products and categories that need to be promoted. After all, the formation of the necessary indicators for the stock is achieved not only by reducing the price, but also by choosing the right product for a discount. Evaluation of the results of marketing activity also does not require significant efforts to select the necessary data from reports on an individual store or network as a whole, it is useful to be able to view the sales dynamics of both individual products and whole categories.
Let's remember how often, having received information, we perceive it as a regular report. Processing these reports, we spend an important resource - our time. But can we be sure that we used all the possibilities of the analysis, that the data are not dead weight?
Visualization makes it easy to determine the desired indicators without “zagrulyaya” perception of many dry numbers.
Our BI Datawiz.io service allows you to apply visualization capabilities to all main reports for retail.
Source: https://habr.com/ru/post/265651/
All Articles