Cost analysis management system and method based on power grid project big data

Abstract

The invention provides a power grid project big data-based cost analysis management system and method, and relates to the technical field of power transmission and transformation projects. The power grid project big data-based cost analysis and management method comprises the following steps of 1, applying transmission and transformation project historical data capture software; 2, sorting and analyzing transmission and transformation project data; 3, researching a power transmission and transformation project cost analysis index system; 4, researching a cost analysis data processing key technology; and step 5, research of a power transmission and transformation project cost analysis model, wherein power transmission and transformation project historical data capturing software application in the step 1 is to capture and sort power transmission and transformation cost data of branch construction companies through software and fill specifications. By constructing a cost analysis data management platform based on big data, technical and economic experts can be assisted to carry out preprocessing, storage and statistical analysis work of project cost data, and the pressure of cost managers on data processing can be relieved.

Description

Technical Field

[0001] The present invention relates to the technical field of power transmission and transformation engineering, and in particular to a cost analysis management system and method based on power grid engineering big data. Background Art

[0002] Power transmission and transformation projects are important carriers of power supply and basic public services that support national economic and social development. They are related to national economy, people's livelihood and social stability. With the rapid development of my country's national economy and urban construction, the country's reliance on and attention to power transmission and transformation projects are increasing. In the past, we did not pay enough attention to the cost management of power transmission and transformation projects during the operation of the power grid, which led to frequent improper capital operation and control, which had a great impact on the normal operation of the power grid project.

[0003] Cost analysis of power transmission and transformation projects is of great significance for controlling project costs, improving investment benefits, and strengthening the cost management of power grid enterprises. However, since 2005, the scale of investment in the construction of the national power grid has increased year by year. The average growth rate of my country's power grid investment from 2005 to 2011 was as high as 15.8%. The construction cost has also continued to increase, and the amount of data that needs to be processed for the corresponding cost statistics and analysis has increased dramatically. This big data environment has undoubtedly brought greater data processing pressure to cost management personnel. In view of this situation, construction companies are in urgent need of building a cost analysis data management platform based on big data to assist technical and economic experts in preprocessing, storage, and statistical analysis of engineering cost data to meet the construction company's needs for power transmission and transformation project cost data management. Summary of the invention

[0004] 1. Technical issues to be solved

[0005] In view of the deficiencies in the prior art, the present invention provides a cost analysis management system and method based on big data of power grid projects, which solves the problem that as construction costs continue to increase, the amount of data that needs to be processed for corresponding cost statistical analysis increases sharply, resulting in greater data processing pressure on cost management personnel.

[0006] (II) Technical solution

[0007] To achieve the above objectives, the present invention is implemented through the following technical solutions: a cost analysis and management method based on power grid engineering big data, comprising the following steps:

[0008] Step 1: Application of software for capturing historical data of power transmission and transformation projects;

[0009] Step 2: Sorting and analyzing the power transmission and transformation project data;

[0010] Step 3: Research on the cost analysis index system of power transmission and transformation projects;

[0011] Step 4: Study the key technologies of cost analysis data processing;

[0012] Step 5: Research on cost analysis model of power transmission and transformation project.

[0013] Preferably, the power transmission and transformation project historical data capture software application in the step 1 is to capture and sort out the power transmission and transformation cost data of the construction branch company, fill in the specifications, study the equipment technical parameters, cost composition, and deeply mine the infrastructure cost analysis big data, and provide a big data analysis basis for the analysis of power transmission and transformation project data, the research on the power transmission and transformation project cost analysis indicator system, the research on the key technology of cost analysis data processing, and the research on the power transmission and transformation project cost analysis model, which has helped Anhui Construction Branch to improve investment returns, control project costs, and strengthen the project cost management of power grid enterprises. The power transmission and transformation project historical data capture software includes the following functions:

[0014] Function 1: Intelligent matching of technical and economic data. According to the bill of lading pricing specifications and pre-regulations, the difference between bill of lading pricing and quota pricing is analyzed, and the scope and reuse rules of the two-stage data of control price and construction drawing budget are determined to realize the intelligent conversion of technical and economic parameters and engineering quantities. The scope of data for intelligent conversion includes basic engineering information, engineering project division and engineering quantity information;

[0015] Function 2: Power transmission and transformation project management function, mainly realizes the creation, maintenance and deletion of power transmission and transformation projects. Among them, power transmission and transformation projects provide the creation and maintenance of their individual projects. Single project creation can be done manually or by batch importing data. For batch imported project data, the system automatically creates individual projects and associates projects at various stages according to project codes. If they cannot be associated, a manual connection function is provided;

[0016] Function 3: Data viewing function, which realizes unified data query on basic information of the project, cost structure, data report information, and project parameter content. The cost structure is displayed in the form of a chart to distinguish the cost composition, and the data report is displayed in each table according to the standard table structure;

[0017] Function 4: Statistical analysis function, organizes valuable cost data information and stores it in different versions, such as the submission, closing and approval versions of feasibility study and preliminary design. According to actual work requirements, output cost data version difference comparison analysis, engineering quantity statistics, engineering cost statistics, and statistical table output reports.

[0018] Preferably, the data combing and analysis of the power transmission and transformation project in step 2 is carried out after investigation and analysis. According to the various stages of the power transmission and transformation project construction, the power transmission and transformation project data are divided into feasibility study stage data, preliminary design stage data, construction stage data, and completion stage data. Each stage covers different categories of data content, and they are combed and analyzed, and historical data are classified according to statistical theory, which specifically includes the following steps:

[0019] Step 1: Study the standard index calculation technology for power transmission and transformation project cost, analyze the index data in the field of power transmission and transformation project cost, design a reasonable standard index calculation algorithm, form a power transmission and transformation project cost data index database, and provide a basis for the benchmark analysis of power transmission and transformation project cost;

[0020] Step 2: Study the data extraction technology of key indicators of power transmission and transformation project cost, analyze the indicator data in the field of power transmission and transformation project cost, design the key indicator extraction algorithm of cost data, and realize the automatic extraction and screening of cost indicators;

[0021] Step 3: Study the matching technology between standard indicators and actual project indicators of power transmission and transformation project cost, select appropriate intelligent indicator matching algorithm, dynamically match standard indicators with actual project indicators, and obtain the indicator comparison and analysis results required by users;

[0022] Step 4: Study the data analysis model of power transmission and transformation project cost indicators, analyze the planning and design departments' demand for cost data, establish a data analysis model of power transmission and transformation project cost indicators, and support auxiliary decision-making.

[0023] Preferably, the research on the power transmission and transformation project cost analysis index system in step three is mainly divided into three aspects: first, a standard index library is established based on historical power transmission and transformation project cost data, and the standard library includes estimated cost, budget cost, budget cost and settlement cost; second, key cost indicator data extraction and matching technology is established; third, a cost indicator data analysis model is established.

[0024] Preferably, the key technology of cost analysis data processing in step 4 is to investigate the major big data intelligent analysis technologies at home and abroad, combine the cost analysis needs of power transmission and transformation projects in Anhui Province over the years, and propose an intelligent analysis method for power transmission and transformation project cost analysis indicators suitable for business application scenarios. The research is mainly carried out from three aspects: data collection, data storage, and data reuse, and includes the following steps:

[0025] Step (1): Research data preprocessing technology based on big data. By studying and analyzing historical power transmission and transformation project data, for the case of a large number of samples, samples > 1,000 are defined as big data. Such data will be processed using big data technology. After cleaning, integration, streamlining, and conversion, the input data will meet the standard requirements.

[0026] Step (2): Research data storage technology based on big data. The topic will be combined with actual business application scenarios, mainly studying the classic big data technology Hadoop technology to achieve data storage under the Hadoop platform;

[0027] Step (3): Research on intelligent retrieval technology based on big data. In the process of power transmission and transformation project cost analysis, the data used can be divided into structured and unstructured data. Therefore, it is necessary to use certain digital standards and XML data conversion technology to complete information processing. Intelligent retrieval technology for multi-source heterogeneous documents can ensure that users can quickly and easily browse interrelated data and perform related business processing.

[0028] Preferably, the research on the cost analysis model of power transmission and transformation engineering in step 5, wherein the research on the intelligent prediction technology of power transmission and transformation engineering cost level indicators, is mainly divided into three aspects: first, based on the historical power transmission and transformation engineering cost data, the power transmission and transformation engineering cost level indicators are proposed; second, combining big data technology, establishing a power transmission and transformation engineering cost level intelligent prediction model based on big data, and using historical data to verify the prediction model; third, establishing a power transmission and transformation engineering cost analysis intelligent prediction model based on big data, and using historical data to verify the prediction model, and including the following steps:

[0029] Step ①: Analyze historical power transmission and transformation project cost data, analyze and sort out the data in the field of power transmission and transformation project cost, including estimated cost, budget cost, budget cost and settlement cost, to provide a data basis for the establishment of cost level indicators and the verification of the intelligent prediction model of power transmission and transformation project cost level;

[0030] Step ②: Propose cost level indicators for power transmission and transformation projects. Based on historical power transmission and transformation project cost data and combined with different application scenarios of the feasibility study estimation stage, preliminary design budget stage, construction drawing budget stage and completion settlement stage of power transmission and transformation project construction, propose corresponding cost level indicators for power transmission and transformation projects;

[0031] Step ③: Establish an intelligent prediction model for the cost level of power transmission and transformation projects based on small sample data, and verify the model. Research data clustering technology and support vector machine intelligent learning technology. Combined with the classic intelligent prediction model for the cost level of power transmission and transformation projects, propose an intelligent prediction model based on small sample data according to different application scenarios, and use historical power transmission and transformation project cost data to verify the prediction model.

[0032] Step ④: Establish an intelligent prediction model for the cost level of power transmission and transformation projects based on big data technology, and verify the model, study mainstream big data technology, study the intelligent prediction model for the cost level of classic power transmission and transformation projects, and propose an intelligent prediction model based on big data technology according to different application scenarios, and use historical power transmission and transformation project cost data to verify the prediction model.

[0033] A cost analysis and management system based on power grid engineering big data, including data analysis, key technology research and cost data application, the data analysis includes feasibility study stage, preliminary design stage, construction stage and completion stage, the key technology research includes data preprocessing, distributed storage and full-text intelligent retrieval, the cost data application includes a cost analysis index library based on historical data, a cost analysis prediction model and a cost analysis data management platform, the power transmission and transformation engineering data in the feasibility study stage consists of basic engineering information, special reports, three-dimensional models, design drawings, feasibility study estimates, geographic information, basis documents and approval documents.

[0034] Preferably, the power transmission and transformation project data in the initial design stage consists of basic project information, special reports, three-dimensional models, design drawings, project budget estimates, geographic information, basis documents and approval documents.

[0035] Preferably, the installation stage is composed of the power transmission and transformation project data of the basic project information, which is composed of the basic project information, special reports, three-dimensional model construction drawings, budgets and geographic information.

[0036] Preferably, the power transmission and transformation project information at the completion stage is composed of basic project information, special reports, three-dimensional models, completion drawings, equipment categories, completion settlement statements, geographic information and completion acceptance records.

[0037] (III) Beneficial effects

[0038] The present invention provides a cost analysis management system and method based on power grid engineering big data. It has the following beneficial effects:

[0039] By building a cost analysis data management platform based on big data, technical and economic experts can be assisted in the preprocessing, storage and statistical analysis of engineering cost data, which helps to reduce the pressure of data processing on cost management personnel. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] Figure 1 This is a flow chart of a cost analysis and management system based on power grid engineering big data proposed by the present invention;

[0041] Figure 2 This is a flowchart of a cost analysis and management method based on power grid engineering big data proposed by the present invention;

[0042] Figure 3 This is a functional schematic diagram of a power transmission and transformation project historical data capture software based on a power grid project big data cost analysis and management method proposed by the present invention;

[0043] Figure 4This is a research block diagram of a power transmission and transformation project cost analysis index system based on a power grid project big data cost analysis management method proposed by the present invention;

[0044] Figure 5 This is a block diagram of key technologies for cost analysis data processing based on a cost analysis management method for power grid engineering big data proposed by the present invention;

[0045] Figure 6 This is a research block diagram of a power transmission and transformation project cost analysis model based on a power grid project big data cost analysis management method proposed by the present invention;

[0046] Figure 7 This is a schematic diagram of power transmission and transformation project data based on a power grid project big data cost analysis management method proposed in the present invention. DETAILED DESCRIPTION

[0047] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0048] Embodiment 1:

[0049] like Figure 1-7 As shown, an embodiment of the present invention provides a cost analysis and management method based on power grid engineering big data, comprising the following steps:

[0050] Step 1: Application of software for capturing historical data of power transmission and transformation projects;

[0051] Step 2: Sorting and analyzing the power transmission and transformation project data;

[0052] Step 3: Research on the cost analysis index system of power transmission and transformation projects;

[0053] Step 4: Study the key technologies of cost analysis data processing;

[0054] Step 5: Research on cost analysis model of power transmission and transformation project.

[0055] The application of the power transmission and transformation project historical data capture software in step 1 is to use the software to capture and sort out the power transmission and transformation cost data of the construction branch, fill in the specifications, study the equipment technical parameters and cost structure, and deeply mine the infrastructure cost analysis big data. It provides a big data analysis basis for the analysis of power transmission and transformation project data, the research of the power transmission and transformation project cost analysis indicator system, the research of the key technology of cost analysis data processing, and the research of the power transmission and transformation project cost analysis model. It has helped Anhui Construction Branch to improve investment returns, control project costs, and strengthen the project cost management of power grid enterprises. The power transmission and transformation project historical data capture software includes the following functions:

[0056] Function 1: Intelligent matching of technical and economic data. According to the bill of lading pricing specifications and pre-regulations, the difference between bill of lading pricing and quota pricing is analyzed, and the scope and reuse rules of the two-stage data of control price and construction drawing budget are determined to realize the intelligent conversion of technical and economic parameters and engineering quantities. The scope of data for intelligent conversion includes basic engineering information, engineering project division and engineering quantity information;

[0057] Function 2: Power transmission and transformation project management function, mainly realizes the creation, maintenance and deletion of power transmission and transformation projects. Among them, power transmission and transformation projects provide the creation and maintenance of their individual projects. Single project creation can be done manually or by batch importing data. For batch imported project data, the system automatically creates individual projects and associates projects at various stages according to project codes. If they cannot be associated, a manual connection function is provided;

[0058] Function 3: Data viewing function, which realizes unified data query on basic information of the project, cost structure, data report information, and project parameter content. The cost structure is displayed in the form of a chart to distinguish the cost composition, and the data report is displayed in each table according to the standard table structure;

[0059] Function 4: Statistical analysis function, organizes valuable cost data information and stores it in different versions, such as the submission, closing and approval versions of feasibility study and preliminary design. According to actual work requirements, output cost data version difference comparison analysis, engineering quantity statistics, engineering cost statistics, and statistical table output reports.

[0060] The data sorting and analysis of the power transmission and transformation project in step 2 is based on research and analysis. According to the various stages of power transmission and transformation project construction, the power transmission and transformation project data is divided into feasibility study stage data, preliminary design stage data, construction stage data, and completion stage data. Each stage covers different categories of data content, which are sorted and analyzed, and historical data are classified according to statistical theory. The specific steps include:

[0061] Step 1: Study the standard index calculation technology for power transmission and transformation project cost, analyze the index data in the field of power transmission and transformation project cost, design a reasonable standard index calculation algorithm, form a power transmission and transformation project cost data index database, and provide a basis for the benchmark analysis of power transmission and transformation project cost;

[0062] Step 2: Study the data extraction technology of key indicators of power transmission and transformation project cost, analyze the indicator data in the field of power transmission and transformation project cost, design the key indicator extraction algorithm of cost data, and realize the automatic extraction and screening of cost indicators;

[0063] Step 3: Study the matching technology between standard indicators and actual project indicators of power transmission and transformation project cost, select appropriate intelligent indicator matching algorithm, dynamically match standard indicators with actual project indicators, and obtain the indicator comparison and analysis results required by users;

[0064] Step 4: Study the data analysis model of power transmission and transformation project cost indicators, analyze the planning and design departments' demand for cost data, establish a data analysis model of power transmission and transformation project cost indicators, and support auxiliary decision-making.

[0065] The research on the cost analysis index system of power transmission and transformation project in step three is mainly divided into three aspects: first, a standard index library is established based on the historical power transmission and transformation project cost data. The standard library includes estimated cost, budget cost, budget cost and settlement cost; second, key cost index data extraction and matching technology is established; third, a cost index data analysis model is established.

[0066] The key technology of cost analysis data processing in step 4 is to investigate the main big data intelligent analysis technologies at home and abroad, and propose an intelligent analysis method for cost analysis indicators of power transmission and transformation projects suitable for business application scenarios based on the cost analysis needs of power transmission and transformation projects in Anhui Province over the years. The research is mainly carried out from three aspects: data collection, data storage, and data reuse, and includes the following steps:

[0067] Step (1): Research data preprocessing technology based on big data. By studying and analyzing historical power transmission and transformation project data, for the case of a large number of samples, samples > 1,000 are defined as big data. Such data will be processed using big data technology. After cleaning, integration, streamlining, and conversion, the input data will meet the standard requirements.

[0068] Step (2): Research data storage technology based on big data. The topic will be combined with actual business application scenarios, mainly studying the classic big data technology Hadoop technology to achieve data storage under the Hadoop platform;

[0069] Step (3): Research on intelligent retrieval technology based on big data. In the process of power transmission and transformation project cost analysis, the data used can be divided into structured and unstructured data. Therefore, it is necessary to use certain digital standards and XML data conversion technology to complete information processing. Intelligent retrieval technology for multi-source heterogeneous documents can ensure that users can quickly and easily browse interrelated data and perform related business processing.

[0070] The research on the cost analysis model of power transmission and transformation project in step 5, including the research on the intelligent prediction technology of power transmission and transformation project cost level indicators, is mainly divided into three aspects: first, based on the historical power transmission and transformation project cost data, the power transmission and transformation project cost level indicators are proposed; second, combining big data technology, an intelligent prediction model of power transmission and transformation project cost level based on big data is established, and the prediction model is verified by using historical data; third, an intelligent prediction model of power transmission and transformation project cost analysis based on big data is established, and the prediction model is verified by using historical data, and the following steps are included:

[0071] Step ①: Analyze historical power transmission and transformation project cost data, analyze and sort out the data in the field of power transmission and transformation project cost, including estimated cost, budget cost, budget cost and settlement cost, to provide a data basis for the establishment of cost level indicators and the verification of the intelligent prediction model of power transmission and transformation project cost level;

[0072] Step ②: Propose cost level indicators for power transmission and transformation projects. Based on historical power transmission and transformation project cost data and combined with different application scenarios of the feasibility study estimation stage, preliminary design budget stage, construction drawing budget stage and completion settlement stage of power transmission and transformation project construction, propose corresponding cost level indicators for power transmission and transformation projects;

[0073] Step ③: Establish an intelligent prediction model for the cost level of power transmission and transformation projects based on small sample data, and verify the model. Research data clustering technology and support vector machine intelligent learning technology. Combined with the classic intelligent prediction model for the cost level of power transmission and transformation projects, propose an intelligent prediction model based on small sample data according to different application scenarios, and use historical power transmission and transformation project cost data to verify the prediction model.

[0074] Step ④: Establish an intelligent prediction model for the cost level of power transmission and transformation projects based on big data technology, and verify the model. Research mainstream big data technologies, which are Hadoop technology. Research the intelligent prediction model for the cost level of classic power transmission and transformation projects. According to different application scenarios, propose an intelligent prediction model based on big data technology, and use historical power transmission and transformation project cost data to verify the prediction model.

[0075] A cost analysis and management system based on power grid engineering big data includes data analysis, key technology research and cost data application. The data analysis includes the feasibility study stage, preliminary design stage, construction stage and completion stage. The key technology research includes data preprocessing, distributed storage and full-text intelligent retrieval. The cost data application includes a cost analysis index library based on historical data, a cost analysis prediction model and a cost analysis data management platform. The power transmission and transformation engineering data in the feasibility study stage consists of basic engineering information, special reports, three-dimensional models, design drawings, feasibility study estimates, geographic information, basis documents and approval documents.

[0076] The data of power transmission and transformation projects in the preliminary design stage are composed of basic project information, special reports, three-dimensional models, design drawings, project budget estimates, geographic information, basis documents and approval documents.

[0077] The installation stage is composed of the power transmission and transformation project data, which are composed of basic project information, special reports, three-dimensional model construction drawings, budgets and geographic information.

[0078] The power transmission and transformation project information at the completion stage consists of basic project information, special reports, three-dimensional models, completion drawings, equipment categories, completion settlement statements, geographic information and completion acceptance records.

[0079] Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and variations may be made to the embodiments without departing from the principles and spirit of the present invention, and that the scope of the present invention is defined by the appended claims and their equivalents.

Claims

1. A cost analysis and management method based on power grid engineering big data, characterized by: The following steps are involved: Step 1: Application of software for capturing historical data of power transmission and transformation projects; Step 2: Sorting and analyzing the power transmission and transformation project data; Step 3: Research on the cost analysis index system of power transmission and transformation projects; Step 4: Study the key technologies of cost analysis data processing; Step 5: Research on cost analysis model of power transmission and transformation project.

2. A cost analysis and management method based on power grid engineering big data according to claim 1, characterized in that: The application of the power transmission and transformation project historical data capture software in step 1 is to capture and sort out the power transmission and transformation cost data and reporting specifications of the construction branch through software, study the technical parameters of equipment and the cost composition, and deeply mine the big data of infrastructure cost analysis, and provide a big data analysis basis for the analysis of power transmission and transformation project data, the research on the power transmission and transformation project cost analysis index system, the research on the key technology of cost analysis data processing, and the research on the power transmission and transformation project cost analysis model, which has helped Anhui Construction Branch to improve investment returns, control project costs, and strengthen the project cost management of power grid enterprises. The power transmission and transformation project historical data capture software includes the following functions: Function 1: Intelligent matching of technical and economic data. According to the bill of lading pricing specifications and pre-regulations, the difference between bill of lading pricing and quota pricing is analyzed, and the scope and reuse rules of the two-stage data of control price and construction drawing budget are determined to realize the intelligent conversion of technical and economic parameters and engineering quantities. The scope of intelligent conversion data includes basic engineering information, engineering project division and engineering quantity information; Function 2: Power transmission and transformation project management function, mainly realizes the creation, maintenance and deletion of power transmission and transformation projects. Among them, power transmission and transformation projects provide the creation and maintenance of their individual projects. Single project creation can be done manually or by batch importing data. For batch imported project data, the system automatically creates individual projects and associates projects at various stages according to project codes. If they cannot be associated, a manual connection function is provided; Function 3: Data viewing function, which realizes unified data query on basic information of the project, cost structure, data report information, and project parameter content. The cost structure is displayed in the form of a chart to distinguish the cost composition, and the data report is displayed in each table according to the standard table structure; Function 4: Statistical analysis function, organizes valuable cost data information and stores it in versions, such as the review, closing and approval versions of the feasibility study and preliminary design stages. According to actual work requirements, output cost data version difference comparison analysis, project quantity statistics, project expense statistics, and statistical table output reports.

3. The method for cost analysis and management based on power grid engineering big data according to claim 1 is characterized by: The data combing and analysis of the power transmission and transformation project in step 2 is carried out after investigation and analysis. According to the various stages of the power transmission and transformation project construction, the power transmission and transformation project data is divided into feasibility study stage data, preliminary design stage data, construction stage data, and completion stage data. Each stage covers different categories of data content, which are combed and analyzed, and the historical data are classified according to statistical theory. Specifically, the following steps are included: Step 1: Study the standard index calculation technology for power transmission and transformation project cost, analyze the index data in the field of power transmission and transformation project cost, design a reasonable standard index calculation algorithm, form a power transmission and transformation project cost data index database, and provide a basis for the benchmark analysis of power transmission and transformation project cost; Step 2: Study the data extraction technology of key indicators of power transmission and transformation project cost, analyze the indicator data in the field of power transmission and transformation project cost, design the key indicator extraction algorithm of cost data, and realize the automatic extraction and screening of cost indicators; Step 3: Study the matching technology between standard indicators and actual project indicators of power transmission and transformation project cost, select appropriate intelligent indicator matching algorithm, dynamically match standard indicators with actual project indicators, and obtain the indicator comparison and analysis results required by users; Step 4: Study the data analysis model of power transmission and transformation project cost indicators, analyze the planning and design departments' demand for cost data, establish a data analysis model of power transmission and transformation project cost indicators, and support auxiliary decision-making.

4. The method for cost analysis and management based on power grid engineering big data according to claim 1 is characterized by: The research on the power transmission and transformation project cost analysis index system in step three is mainly divided into three aspects: first, a standard index library is established based on historical power transmission and transformation project cost data, and the standard library includes estimated cost, budget cost, budget cost and settlement cost; second, key cost index data extraction and matching technology is established; third, a cost index data analysis model is established.

5. The method for cost analysis and management based on power grid engineering big data according to claim 1 is characterized by: The key technology of cost analysis data processing in step 4 is to investigate the major big data intelligent analysis technologies at home and abroad, and propose an intelligent analysis method for cost analysis indicators of power transmission and transformation projects suitable for business application scenarios based on the cost analysis needs of power transmission and transformation projects in Anhui Province over the years. The research is mainly carried out from three aspects: data collection, data storage, and data reuse, and includes the following steps: Step (1): Research data preprocessing technology based on big data. By studying and analyzing historical power transmission and transformation project data, for the case of a large number of samples, samples > 1,000 are defined as big data. Such data will be processed using big data technology. After cleaning, integration, streamlining, and conversion, the input data will meet the standard requirements. Step (2): Research data storage technology based on big data. The topic will be combined with actual business application scenarios, mainly studying the classic big data technology Hadoop technology to achieve data storage under the Hadoop platform; Step (3): Research on intelligent retrieval technology based on big data. In the cost analysis process of power transmission and transformation projects, the data used can be divided into structured and unstructured data. Therefore, it is necessary to use certain digital standards and XML data conversion technology to complete information processing. Intelligent retrieval technology for multi-source heterogeneous documents can ensure that users can quickly and easily browse interrelated data and perform related business processing.

6. The method for cost analysis and management based on power grid engineering big data according to claim 1 is characterized by: The research on the cost analysis model of power transmission and transformation project in step 5, including the research on the intelligent prediction technology of power transmission and transformation project cost level indicators, is mainly divided into three aspects: first, based on the historical power transmission and transformation project cost data, the power transmission and transformation project cost level indicators are proposed; second, in combination with big data technology, an intelligent prediction model for the power transmission and transformation project cost level based on big data is established, and the prediction model is verified by using historical data; third, an intelligent prediction model for power transmission and transformation project cost analysis based on big data is established, and the prediction model is verified by using historical data, and the following steps are included: Step ①: Analyze historical power transmission and transformation project cost data, analyze and sort out the data in the field of power transmission and transformation project cost, including estimated cost, budget cost, budget cost and settlement cost, to provide a data basis for the establishment of cost level indicators and the verification of the intelligent prediction model of power transmission and transformation project cost level; Step ②: Propose cost level indicators for power transmission and transformation projects. Based on historical power transmission and transformation project cost data and combined with different application scenarios of the feasibility study estimation stage, preliminary design budget stage, construction drawing budget stage and completion settlement stage of power transmission and transformation project construction, propose corresponding cost level indicators for power transmission and transformation projects; Step ③: Establish an intelligent prediction model for the cost level of power transmission and transformation projects based on small sample data, and verify the model. Research data clustering technology and support vector machine intelligent learning technology. Combined with the classic intelligent prediction model for the cost level of power transmission and transformation projects, propose an intelligent prediction model based on small sample data according to different application scenarios, and use historical power transmission and transformation project cost data to verify the prediction model. Step ④: Establish an intelligent prediction model for the cost level of power transmission and transformation projects based on big data technology, and verify the model, study mainstream big data technology, study the intelligent prediction model for the cost level of classic power transmission and transformation projects, and propose an intelligent prediction model based on big data technology according to different application scenarios, and use historical power transmission and transformation project cost data to verify the prediction model.

7. A cost analysis and management system based on power grid engineering big data, characterized by: It includes data analysis, key technology research and cost data application. The data analysis includes the feasibility study stage, preliminary design stage, construction stage and completion stage. The key technology research includes data preprocessing, distributed storage and full-text intelligent retrieval. The cost data application includes a cost analysis index library based on historical data, a cost analysis prediction model and a cost analysis data management platform. The power transmission and transformation project data in the feasibility study stage consists of basic project information, special reports, three-dimensional models, design drawings, feasibility study estimates, geographic information, basis documents and approval documents.

8. The cost analysis and management system based on power grid engineering big data according to claim 7 is characterized by: The power transmission and transformation project data in the preliminary design stage is composed of basic project information, special reports, three-dimensional models, design drawings, project budget estimates, geographic information, basis documents and approval documents.

9. The cost analysis and management system based on power grid engineering big data according to claim 7 is characterized by: The installation stage is composed of the power transmission and transformation project data of the basic project information, which is composed of the basic project information, special reports, three-dimensional model construction drawings, budgets and geographic information.

10. The cost analysis and management system based on power grid engineering big data according to claim 7 is characterized by: The power transmission and transformation project information at the completion stage is composed of basic project information, special reports, three-dimensional models, completion drawings, equipment categories, completion settlement statements, geographic information and completion acceptance records.

Images