数据分析报告2：Superstore销售情况分析

原创

已于 2022-04-19 14:08:06 修改 · 2.7k 阅读

11 ·

CC 4.0 BY-SA版权

文章标签：

#数据分析

于 2022-04-15 22:42:17 首次发布

通过对Superstore销售数据的分析，发现产品可分为热销、潜力、引流、滞销和负利润产品，其中重点产品占比18.01%。地区消费贡献方面，West地区最高，Central地区年消费呈下降趋势。消费者主要偏好Office Supplies。建议店铺优化产品分类，关注Central地区消费下降，同时加强Consumer客户维护和Corporate、Home Office需求响应。

一. 提出问题

1.1 将产品进行分类：热销产品，潜力产品，引流产品，滞销产品

1.2 地区销售贡献和消费喜好

1.3 细分客户销售贡献和消费喜好

二．收集数据

2.1 项目数据来源kaggle平台，Superstore Dataset：Superstore Dataset | Kaggle，共99018条数据

2.2 数据名词解释：

Row ID => Unique ID for each row.
Order ID => Unique Order ID for each Customer.
Order Date => Order Date of the product.
Ship Date => Shipping Date of the Product.
Ship Mode=> Shipping Mode specified by the Customer.
Customer ID => Unique ID to identify each Customer.
Customer Name => Name of the Customer.
Segment => The segment where the Customer belongs.
Country => Country of residence of the Customer.
City => City of residence of of the Customer.
State => State of residence of the Customer.
Postal Code => Postal Code of every Customer.
Region => Region where the Customer belong.
Product ID => Unique ID of the Product.
Category => Category of the product ordered.
Sub-Category => Sub-Category of the product ordered.
Product Name => Name of the Product
Sales => Sales of the Product.
Quantity => Quantity of the Product.
Discount => Discount provided.
Profit => Profit/Loss incurred.