杭州市桐庐县建筑工程项目分析管理数据

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

Project engineering management data within the jurisdiction of Tonglu County, Hangzhou City is collected into a database via system entry and data crawling as the original data source. Finally, Business Intelligence (BI) tools are used to conduct classified statistics by regional projects, generate line charts to visualize the risk trend of project engineering management data for each region, and push the analysis results to relevant managers.
(1) Project engineering management data within the jurisdiction of Tonglu County, Hangzhou City is collected into a database via system entry and data crawling as the original data source.
(2) Data processing: First, clean the collected enterprise data by removing projects with a total count of 0 or null. Then perform aggregation at the finest granularity: group the data by enterprise along the project dimension, and group by region along the regional dimension. Calculate the following indicators for each enterprise:
- Total number of projects: denoted as X
- Total project amount: sum of the total amounts of all projects belonging to the enterprise
- Number of completed project initiation approval projects: count of projects that have finished the project initiation approval procedures, with the approval proportion being (number of completed project initiation approval projects)/X
- Number of completed bidding projects: count of projects that have finished the bidding procedures, with the bidding proportion being (number of completed bidding projects)/X
- Number of signed contract projects: count of projects that have signed formal contracts, with the proportion of signed contracts being (number of signed contract projects)/X
- Number of construction/supply phase projects: count of projects that have entered the construction or supply implementation phase, with the proportion of construction/supply being (number of construction/supply phase projects)/X
- Number of completed final acceptance projects: count of projects that have passed the final acceptance check, with the proportion of completed acceptance being (number of completed final acceptance projects)/X
- Number of warranty maintenance phase projects: count of projects that have entered the warranty and maintenance service phase, with the proportion of warranty maintenance being (number of warranty maintenance phase projects)/X
- Number of overdue project initiation approval projects: count of projects that have delayed the project initiation approval procedures, with the proportion of overdue approval being (number of overdue project initiation approval projects)/X
- Number of overdue bidding projects: count of projects that have delayed the bidding procedures, with the proportion of overdue bidding being (number of overdue bidding projects)/X
- Number of overdue signed contract projects: count of projects that have delayed the contract signing procedures, with the proportion of overdue signed contracts being (number of overdue signed contract projects)/X
- Number of overdue final acceptance projects: count of projects that have delayed the final acceptance check, with the proportion of overdue final acceptance being (number of overdue final acceptance projects)/X