陕西省西安市客户售卖手机及周边产品销售数据

通过收集和分析陕西省西安地区客户通过博远销售软件,售卖手机及手机周边产品一些销售数据进分析，了解客户每个月销售数据情况，总销售额，及销售利润，各门店对基于大数据分析管理软件的了解客户购买力水平和消费偏好，从而制定进货计划，减小库存压力，减小资金积压。1.通过收集到陕西省西安地区客户的基础数据，分析销售情况， 2.数据处理：销售额/销量=平均价，通过利润/销量=平均利润，利用单价大于1000元的销量/销量=单价大于1000元的销量占比，利用单价大于1000的销售额/销售额=单价大于1000元的销售额占比,如果单价大于1000元的销量占比超过60%，主营业务标记为手机，否则标记为手机周边产品。如果单价大于1000元的销售额占比超过90%销售额支撑标记为手机，否则标记为非手机。

This dataset is constructed by collecting and analyzing sales data of mobile phones and their peripheral products from customers in Xi'an, Shaanxi Province, via the BoYuan Sales Software. The analysis aims to figure out the monthly sales performance, total sales revenue and sales profit of the business, and help each store grasp customers' purchasing power and consumption preferences through big data analysis and management software, so as to formulate inventory procurement plans, reduce inventory pressure and alleviate capital tied up.
1. Sales situation analysis based on collected basic customer data from Xi'an, Shaanxi Province: Collect basic customer data from Xi'an, Shaanxi Province and conduct sales situation analysis.
2. Data processing:
- Calculate the average selling price: total sales revenue divided by total sales volume
- Calculate the average unit profit: total profit divided by total sales volume
- Calculate the proportion of sales volume of products with unit price exceeding 1000 yuan: (sales volume of products with unit price > 1000 yuan) / total sales volume
- Calculate the proportion of sales revenue of products with unit price exceeding 1000 yuan: (sales revenue of products with unit price > 1000 yuan) / total sales revenue
- Main business labeling: If the proportion of sales volume of products with unit price > 1000 yuan exceeds 60%, label the main business as "mobile phones"; otherwise, label it as "mobile phone peripheral products".
- Sales revenue support labeling: If the proportion of sales revenue of products with unit price > 1000 yuan exceeds 90%, label the sales revenue support as "mobile phones"; otherwise, label it as "non-mobile phones".

搜集汇总

背景与挑战

背景概述

该数据集记录了陕西省西安市客户通过销售软件售卖手机及周边产品的销售数据，涵盖客户代码、年月、销量、销售额、利润等关键字段，数据以Excel格式存储，每年更新一次。数据集通过分析销售情况、计算平均售价和利润占比等指标，帮助了解客户购买力水平和消费偏好，支持制定进货计划以减少库存压力和资金积压，适用于批发和零售业的企业数据应用场景。