瓯海区互联网+废旧物资回收市场决策数据

通过采集分析瓯海区不同品类回收物品的销售重量，销售金额数据，分析各个品类的销售价格。能直观反应不同时段各个回收品类的价格走势，为垃圾回收市场，二次销售和采购提供可靠的分析指导依据。（1）数据采集：线下通过设备和手动录入的方式采集销售数据到数据库作为原始数据源。（2）数据处理：首先对采集销售数据进行清洗，包括销售金额为0的或者为null的。然后对销售数据在时间维度按日，品类维度按品类，小类维度按小类，进行最细级别粒度的聚合。（3）数据分析：按照公式：p = sum(O)/sum(w)；其中o为每日小类销售金额；w为每日小类销售重量；p为销售均价；每天每个小类总销售金额，通过将每个订单的销售金额相加来实现；每天每个小类总销售重量，即该天内的订单总重量；使用上述公式，按照销售均价=每日销售小类销售金额/每日销售小类销售重量的算法进行统计分析。（4）数据应用：最后通过BI工具，按品类进行分类统计，利用折线图体现每个品类的历史价格走势情况。

By collecting and analyzing the sales weight and sales amount data of recycled items across different categories in Ouhai District, this dataset analyzes the sales prices of various recycled categories. It can intuitively reflect the price trends of different recycled categories across different time periods, providing reliable analytical guidance for the waste recycling market, secondary sales and procurement activities.

(1) Data Collection: Sales data is collected offline through both equipment and manual entry, and stored in a database as the original data source.

(2) Data Processing: First, clean the collected sales data, eliminating entries with a sales amount of 0 or null. Next, aggregate the sales data at the finest granularity: by day in the time dimension, by main category in the category dimension, and by sub-category in the sub-category dimension.

(3) Data Analysis: Calculate according to the formula: p = sum(O)/sum(w), where o represents the daily sales amount of a sub-category, w represents the daily sales weight of the same sub-category, and p represents the average sales price. The total daily sales amount for each sub-category is calculated by summing the sales amounts of all associated orders; the total daily sales weight for each sub-category refers to the total weight of all orders on that day. Statistical analysis is then performed using the aforementioned formula, where the average sales price is computed as (total daily sales amount of the sub-category) divided by (total daily sales weight of the sub-category).

(4) Data Application: Finally, utilize BI tools to conduct category-based statistical analysis, and employ line charts to visualize the historical price trends of each recycled category.

搜集汇总

数据集介绍

特点

该数据集记录了瓯海区废旧物资回收市场的销售数据，包括销售重量、金额和均价等信息，用于分析不同品类的价格走势，支持市场决策。数据实时更新，历史数据永久保存，并通过BI工具进行可视化分析。