住宅设计服务优势套餐识别数据

根据住宅设计服务在市场的销售情况，计算出基于设计风格特征（现代简约、新中式）和面积特征（90平米、120平米）的各种套餐的销售占比，识别出优势套餐，有助于本公司及同行业内其他提供住宅设计服务的企业制定、优化营销、服务和供应链方案。1.数据收集和预处理：（1）数据收集：收集公司住宅设计服务订单信息，包括服务类目、统计日期、服务名称、销售渠道/平台、销售次数（次）、设计风格特征、面积特征。（2）数据预处理：对收集的原始数据进行清洗。 2.计算销售次数（次）：利用SUM函数将历史采集的购买数量累加计算出住宅设计服务销售次数。 3.基于设计风格特征识别优势套餐：（1）筛选设计风格特征为现代简约的订单，利用SUM函数将购买数量累加计算出现代简约设计销售次数，并计算出销售占比=现代简约设计销售次数/住宅设计服务销售次数100%。同理，计算新中式设计销售次数及占比。（2）比较两种设计风格的销售占比，较大的为基于设计风格特征的优势套餐。 4.基于面积特征识别优势套餐：（1）筛选面积特征为90平米设计的订单，利用SUM函数将购买数量累加计算出90平米设计销售次数，并计算出销售占比=90平米设计销售次数/住宅设计服务销售次数100%。同理，计算120平米设计销售次数及占比。（2）比较两种面积特征的销售占比，较大的为基于面积特征的优势套餐。

Based on the market sales performance of residential design services, this dataset calculates the sales proportions of various service packages based on two types of characteristics: design style (modern minimalist, new Chinese style) and area (90 ㎡, 120 ㎡), and identifies advantageous packages. This helps both our company and other peer enterprises providing residential design services to formulate and optimize their marketing, service, and supply chain strategies.

1. Data Collection and Preprocessing:
(1) Data Collection: Collect order information of the company's residential design services, including service category, statistical date, service name, sales channel/platform, sales frequency (times), design style characteristics, and area characteristics.
(2) Data Preprocessing: Clean the collected raw data.

2. Calculation of Total Sales Frequency: Use the SUM function to accumulate the historically collected purchase quantities to calculate the total sales frequency of residential design services.

3. Identification of Advantageous Packages Based on Design Style Characteristics:
(1) Filter orders with modern minimalist design style characteristics, use the SUM function to accumulate the purchase quantities to calculate the sales frequency of modern minimalist design, and calculate its sales proportion as (sales frequency of modern minimalist design / total sales frequency of residential design services) * 100%. Similarly, calculate the sales frequency and proportion of new Chinese style design.
(2) Compare the sales proportions of the two design styles, and the one with the higher proportion is the advantageous package based on design style characteristics.

4. Identification of Advantageous Packages Based on Area Characteristics:
(1) Filter orders with 90 ㎡ area design characteristics, use the SUM function to accumulate the purchase quantities to calculate the sales frequency of 90 ㎡ design, and calculate its sales proportion as (sales frequency of 90 ㎡ design / total sales frequency of residential design services) * 100%. Similarly, calculate the sales frequency and proportion of 120 ㎡ design.
(2) Compare the sales proportions of the two area characteristics, and the one with the higher proportion is the advantageous package based on area characteristics.

搜集汇总

背景与挑战

背景概述

该数据集包含520条住宅设计服务销售记录，每月更新，通过分析设计风格（如现代简约、新中式）和面积特征（如90平米、120平米）的销售次数与占比，识别优势套餐，旨在帮助企业优化营销策略和供应链管理。