北京市惠普打印机销售分析数据

分析惠普打印机在北京市的销售情况，具体包括分类（激光、喷墨）、分型（普通、二合一、三合一和四合一）占比，筛选出各类、型的优势产品，帮助打印机销售企业制定、优化营销、仓储、物流和供应链方案。①整理数据，删除老旧分类型号； ②通过“数量”，计算“惠普打印机销售总量a”； ③筛选“商品名称”中带“激光”字段，通过“数量”，计算“惠普各激光打印机销售总量b”，惠普各激光打印机销售占比M=b÷a×100％； ④同理，计算c，N； ⑤比较M和N，较大的对应类别为优势产品； ⑥筛选“商品名称”中“惠普激光打印机”“惠普喷墨打印机”，通过“数量”，计算“惠普各普通打印机销售总量d”，惠普各普通打印机销售占比W=d÷a×100％； ⑦筛选“商品名称”中“惠普喷墨一体机”，通过“数量”，计算“惠普各二合一打印机销售总量e”，惠普各二合一打印机销售占比X=e÷a×100％； ⑧筛选“商品名称”中带“三合一”字段，通过“数量”，计算“惠普各三合一销售总量f”，惠普各三合一打印机销售占比Y=f÷a×100％； ⑨同理，计算g，Z； ⑩比较X、Y和Z，最大的对应类别为优势产品。 说明：①普通打印机仅有打印功能，二合一增加复印功能，三合一增加扫描功能，四合一增加传真功能。 ②M、N、X、Y和Z，均精确到小数点后2位。This dataset analyzes the sales performance of HP printers in Beijing, covering the sales proportions of two classifications (laser, inkjet) and four types (single-function, 2-in-1, 3-in-1, 4-in-1). It aims to screen out the dominant products of each category and type, so as to help printer sales enterprises formulate and optimize their marketing, warehousing, logistics and supply chain solutions. 1. Organize the data and delete outdated categorized models; 2. Calculate the "total HP printer sales volume a" based on the "quantity" field; 3. Filter products whose "product name" contains the keyword "laser", then calculate the "total sales volume of each HP laser printer b" based on the "quantity" field, and the sales proportion M of HP laser printers = b ÷ a × 100%; 4. Similarly, calculate c and N; 5. Compare M and N, the corresponding category with the larger value is the dominant product; 6. Filter products whose "product name" contains "HP Laser Printer" and "HP Inkjet Printer", then calculate the "total sales volume of each HP single-function printer d" based on the "quantity" field, and the sales proportion W of HP single-function printers = d ÷ a × 100%; 7. Filter products whose "product name" contains "HP Inkjet All-in-One Printer", then calculate the "total sales volume of each HP 2-in-1 printer e" based on the "quantity" field, and the sales proportion X of HP 2-in-1 printers = e ÷ a × 100%; 8. Filter products whose "product name" contains the keyword "3-in-1", then calculate the "total sales volume of each HP 3-in-1 printer f" based on the "quantity" field, and the sales proportion Y of HP 3-in-1 printers = f ÷ a × 100%; 9. Similarly, calculate g and Z; 10. Compare X, Y and Z, the corresponding category with the maximum value is the dominant product. Notes: 1. Single-function printers only have the printing function; 2-in-1 models add the copying function, 3-in-1 models add the scanning function, and 4-in-1 models add the fax function. 2. All values of M, N, X, Y and Z shall be accurate to 2 decimal places.

搜集汇总

数据集介绍

特点

该数据集提供了北京市惠普打印机的销售分析数据，包括各类打印机的销售总量和占比，帮助识别优势产品，适用于销售企业的策略优化。