Introduction to common data analysis in retail industry

Introduction to common data analysis in retail industry

1. Financial Analysis

1) Analyze the financial situation of enterprises, understand the liquidity of enterprise assets, cash flow, debt level and the ability of enterprises to repay long-term debt, so as to evaluate the financial situation and risk of enterprises.

2) analyze the asset management level of the enterprise, understand the management status of the assets, the capital turnover situation.

3) Analyze the profitability of the enterprise.

4) Analysis of the development trend of enterprises, predict the business prospects.

At the same time, the system should be in accordance with departments, personnel, commodities, suppliers, time and other dimensions of the comprehensive analysis of financial indicators, such as: cost, gross profit, profits, inventory, settlement, Breakeven Point, sales volume, sales amount, market share and so on.

2. Sales Analysis

The main analysis of sales indicators, such as gross profit, gross profit margin, ping efficiency, cross-ratio, sales, profitability, turnover rate, year-over, chain, and so on; the analytic dimension can be viewed from the view of management structure, category brand, date, time period, and so on, these analytic dimensions use multistage drilling to obtain quite thorough analysis thought At the same time, according to mass data to generate predictive information, alarm information and other analytical data, but also based on a variety of sales indicators to generate new perspectives, such as the most common ABC classification table, Commodity sensitive classification table, commodity profit classification table.

These complex indicators in the original database is difficult to achieve, although the bosses know that they are very useful, but because they can not be obtained, so that the status of these indicators is also RUOYOURUOWU. Until the advent of BI technology, these indicators have been re-approved by managers and analysts.

3. Commodity analysis

The main data of commodity analysis comes from sales data and commodity base data, which leads to the analysis thinking of analyzing structure as a main line. The main analysis data have commodity category structure, brand structure, price structure, gross profit structure, settlement style structure, origin structure and so on, resulting in product breadth, commodity depth, commodity elimination rate, commodity introduction rate, commodity replacement rate, key commodities, best-selling goods, slow-moving goods, seasonal commodities and other indicators. Through the analysis of these indicators to guide the adjustment of the enterprise's commodity structure, to strengthen the competitive ability of the goods and reasonable allocation.

4. Customer Analysis

Customer analysis mainly refers to the customer group purchase behavior analysis. For example, if the customer is simply divided into the rich and the poor, then who is the rich, who is the poor? The implementation of membership card-making enterprises can be distinguished by the monthly income registered by members, there is no implementation of membership card, can be the small ticket per single amount to assume. For example, more than 100 yuan we think is rich, less than 100 yuan we think is poor. Well, now mister need to know a lot of things, such as the rich and poor people like what kind of goods, the rich and the poor of the time when the shopping, the rich or poor in their own business district, the contribution of the rich to the mall is the poor make a big contribution, the rich and poor people like to use the way to pay and so on. In addition, there are customer orders in the business district, shopping peak time and holiday economy impact on the enterprise analysis.

5. Supplier Analysis

Through the supplier in a specific time period of the indicators, including order quantity, order amount, quantity of goods, purchase amount, arrival time, stock, inventory amount, returns, returns, sales volume, sales, the gross profit margin, turnover rate, cross ratio, etc. for the supplier's introduction, reserve, To eliminate (or eliminate some of its varieties) and supplier inventory of goods processing to provide a basis. The main topics of analysis are the composition of suppliers, delivery, payment, and the situation of goods, such as sales contribution, profit contribution. Through analysis, we may find that some suppliers have been providing a good sale of goods, it is a certain period of time the knot is also very stable, and this vendor's settlement method is sold. Well, the analysis shows that the supplier is less risky for the sale of goods, if the funds are not tight, why not consider to change them to purchase and sale it? This can reduce the cost of UH.

6. Personnel Analysis

Through the analysis of the company's personnel indicators, especially the sales personnel indicators (mainly sales indicators, margin indicators supplemented) and the buyer's indicators (sales, gross profit, supplier replacement, purchase and sale of goods, consignment of goods, capital occupation, capital turnover, etc.) analysis, in order to achieve the assessment of staff performance, improve staff enthusiasm, For the rational use of human resources to provide scientific basis for the purpose. The main analysis topics are: Staff composition, sales per capita sales, for the individual sales of the sales performance, the management structure of the per capita sales, gross contribution, procurement personnel in charge of the purchase of goods, the proportion of sale and distribution, the introduction of the sales of goods and so on.

Via: Data Mining and data analysis

(Editor: China Statistics Network)

Introduction to common data analysis in retail industry