With the advent of the era of big data, data description has become a very important part of the retail industry and the foundation of elegant operation. Retail data description includes:

With the advent of the era of big data, data description has become a very important part of the retail industry and the foundation of elegant operation. Retail data description includes:

This paper will interpret these six aspects one by one.

1 financial statements

1) Explain the financial status of the enterprise, understand the activities of enterprise assets, cash flow, debt degree and the means of issuing bonds or not, so as to evaluate the financial status and risks of the enterprise;

2) Explain the asset management level of the enterprise, and understand the asset management status and capital turnover environment of the enterprise;

3) explain the profit-making means of the enterprise;

4) explain the growth trend of the enterprise and guess the planning prospect of the enterprise;

At the same time, the system should also comprehensively explain various financial indicators, such as cost, gross profit, profit, inventory, settlement, break-even point, sales quantity, sales amount, market share and so on, from the aspects of vouchers, personnel, goods, suppliers and time.

2 sales description

First of all, explain various sales indicators, such as gross profit, gross profit margin and floor efficiency (floor efficiency is often used to calculate the planning benefit of the market in Taiwan Province Province, which refers to how much business can be generated by each floor area (business amount-the total number of floors occupied by counters). Take department stores as an example. Different locations of stores attract different numbers of customers. The entrance to the first floor is usually the most attractive place. In such a prime location, it is necessary to arrange counters that can make the most profit, so you will find that the first floor of department stores is usually clothing counters, including staggered ratio, purchase-sales ratio, bonus means, turnover rate, year-on-year ratio, chain ratio and so on.

Interpretation dimensions can be investigated from the perspectives of point structure, brand, date, time period, etc. These interpretation dimensions can be circulated and drilled at multiple levels, thus obtaining the same thorough interpretation ideas;

At the same time, explanatory data such as guess information and alarm information are generated according to massive data;

You can also generate a new pivot table according to various traffic indicators, and you can compare the most common ABC classification table, commodity sensitivity classification table, commodity dividend classification table and so on.

These great indicators are difficult to achieve in the original database. Although bosses know they are effective, they don't, which makes the position of these indicators seem to be different. It was not until BI skills were put forward that these indicators won the favor of managers and interpreters from the beginning.

3 commodity description

The original data of commodity description comes from the sales data and basic data of commodities, which leads to the interpretation idea with description layout as the main line. This paper mainly explains the data including commodity types, brands, values, gross profit, settlement methods, places of origin, etc., and leads to various indicators such as commodity breadth, commodity depth, commodity price reduction rate, commodity introduction rate, commodity substitution rate, key commodities, out-of-stock commodities, unsalable commodities, seasonal commodities, etc. Through the explanation of these indicators, we can guide and mediate the commodity layout of enterprises, and enhance the competitive means and fair setting of the commodities we operate.

4 employer's explanation

The explanation of owners mainly refers to the explanation of the purchase behavior of owners. For example, if employers are simply divided into rich and poor, who is rich and who is poor? Enterprises that implement the membership card system can be distinguished by the monthly income of registered members. If there is no membership card, you can bear the amount of each receipt. For example, we think that people above 100 yuan are rich, and people below 100 yuan are poor. Well, now the boss must know a lot of jobs, such as what kind of goods the rich and the poor like; When is the shopping time for the rich and the poor? Whether there are more rich people or poor people in your own business circle; The filial piety of the rich is still greater than that of the poor; How do the rich and the poor like to pay, and so on. In addition, there are explanations about the influence of the number of customers, shopping time and Muri economy on the enterprise.

5 supplier's explanation

Through the description of various indicators of suppliers in a specific period of time, including order quantity, order quantity, purchase quantity, purchase quantity, arrival time, inventory quantity, inventory quantity, return quantity, sales quantity, gross profit margin, turnover rate, mismatch rate and so on. To provide a basis for suppliers to introduce, save, reduce (or reduce the variety of their departments) and deal with the rewards and punishments of suppliers' inventory goods. The main topics are the composition and layout of suppliers, the delivery environment, the settlement environment, and the commodity environment provided, such as filial piety in selling and filial piety in profit. Through explanation, we may find that some suppliers have always been good at selling goods, and their settlement in a certain period of time is also very constant, and the settlement method of this supplier is consignment. Well, it shows that the risk of selling the goods provided by this supplier is small. If the fund does not ask for help, why not consider buying and selling? This can reduce the cost.

6 employee description

By explaining the company's personnel indicators, especially the sales personnel indicators (mainly sales indicators, supplemented by gross profit indicators) and the buyer indicators (sales volume, gross profit, supplier changes, the number of goods purchased and sold, the number of goods sold on commission, capital occupation, capital turnover, etc.). ), can achieve the property performance goals of auditors, improve the enthusiasm of employees, and provide scientific basis for the fair operation of human resources. The main topics to be explained are: the composition of employees, the per capita sales amount of sales staff, the comparison of individual sales performance and billing sales, the per capita sales amount of each branch structure, the filial piety of gross profit, the proportion of purchasing personnel sharing the purchase, the proportion of consignment sales, and the sales volume of imported goods.

The above is the related content of the application case of retail big data shared by Bian Xiao. For more information, you can pay attention to the global ivy and share more dry goods.