苏州相城区建筑工程项目分析管理数据

采集苏州相城区范围内项目工程管理数据通过系统录入和数据抓取的方式采集数据到数据库作为原始数据源。最后通过BI工具，按区域项目进行分类统计，利用折线图体现每个地区的项目工程管理数据风险走势情况。推送给管理人员。（1）采集苏州相城区范围内项目工程管理数据通过系统录入和数据抓取的方式采集数据到数据库作为原始数据源。 （2）数据处理：首先对采集的企业数据进行清洗，包括项目总数量为0的或者为null的。然后对数据在项目维度按企业，区域维度按区域，进行最细级别粒度的聚合。计算得到各企业的项目总数量为X，项目总额为所有项目总金额，立项审批数为已立项审批数量，立项审批占比为立项审批数/X；招投标数为已招投标项目数量，招投标占比为招投标数/X；签署合同数为已签署合同项目数量，签署合同占比为签署合同数/X；施工/供货数为已施工/供货数项目数量，施工/供货占比为施工/供货数/X；竣工验收数为已竣工验收项目数量，竣工验收占比为竣工验收数/X；质保维护数为已质保维护项目数量，质保维护占比为质保维护数/X；立项超时数为已立项超时项目数量，立项超时占比为立项超时数/X；招投标超时数为已招投标超时项目数量，招投标超时占比为招投标超时数/X；签署合同超时数为已签署合同超时项目数量，签署合同超时占比为签署合同超时数/X；竣工验收超时数为已竣工验收超时项目数量，竣工验收超时占比为竣工验收超时数/X；

Project engineering management data within Xiangcheng District, Suzhou are collected via system input and web scraping, and stored in a database as the original data source. Finally, classified statistics are performed based on regional projects using Business Intelligence (BI) tools, line charts are used to visualize the risk trend of project engineering management data for each region, and the results are pushed to management personnel. (1) Project engineering management data within Xiangcheng District, Suzhou are collected via system input and web scraping, and stored in a database as the original data source. (2) Data processing: Firstly, clean the collected enterprise data, including entries where the total number of projects is 0 or null. Then, perform the finest-grained aggregation on the data: aggregate by enterprise at the project dimension, and by region at the regional dimension. Calculate the following indicators for each enterprise: Total number of projects: X; Total project amount: sum of the amounts of all projects; Number of initiated and approved projects: count of projects that have completed initiation and approval procedures, with the proportion being (number of initiated and approved projects)/X; Number of bidding and tendering projects: count of projects that have completed bidding and tendering procedures, with the proportion being (number of bidding and tendering projects)/X; Number of signed contract projects: count of projects that have completed contract signing procedures, with the proportion being (number of signed contract projects)/X; Number of construction/supply projects: count of projects that have entered the construction/supply stage, with the proportion being (number of construction/supply projects)/X; Number of completed and accepted projects: count of projects that have completed completion acceptance procedures, with the proportion being (number of completed and accepted projects)/X; Number of quality warranty and maintenance projects: count of projects that have entered the quality warranty and maintenance stage, with the proportion being (number of quality warranty and maintenance projects)/X; Number of overdue initiation projects: count of projects that have delayed initiation approval procedures, with the proportion being (number of overdue initiation projects)/X; Number of overdue bidding and tendering projects: count of projects that have delayed bidding and tendering procedures, with the proportion being (number of overdue bidding and tendering projects)/X; Number of overdue contract signing projects: count of projects that have delayed contract signing procedures, with the proportion being (number of overdue contract signing projects)/X; Number of overdue completion acceptance projects: count of projects that have delayed completion acceptance procedures, with the proportion being (number of overdue completion acceptance projects)/X;

搜集汇总

数据集介绍

特点

该数据集涵盖了苏州相城区建筑工程项目管理的详细数据，包括项目各环节的数量、占比及超时情况，数据规模为67条，每月更新，适用于区域项目管理和风险分析。