Source end material purchasing management system based on multi-dimensional information analysis

Abstract

The invention relates to the technical field of data processing, in particular to a source-end material purchasing management system based on multi-dimensional information analysis, and the system comprises a data collection module which is connected with a multi-data-source system through an API interface, and collects multi-dimensional material data and project data in each task execution time period; the data processing module is in communication connection with the data acquisition module, and performs preprocessing, identification mapping and elimination of redundant multi-dimensional material data and project data in each task execution time period to obtain comprehensive data information of each material in the multi-dimensional material data and comprehensive data information of each project in the project data; the data analysis module is in communication connection with the data processing model and is used for generating different-dimension data charts by utilizing different-dimension data models according to the comprehensive data information of each material and the comprehensive data information of each project after the execution of the last task is finished; and the visualization module is in communication connection with the data analysis module and is used for displaying data chart results of different dimensions. The decision making scientificity and timeliness are improved.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing, and in particular to a source-end material procurement management system based on multi-dimensional information analysis. Background Art

[0002] At present, material procurement is an important part of engineering construction costs. Material procurement and its management work have the characteristics of wide-ranging fields, complex and changeable content, and complex composition of participants. With the rapid development of power engineering in Shanxi Province, large-scale material procurement activities have brought pressure to the capital operation of the province. Therefore, the implementation of effective control measures on the material procurement process will significantly improve the efficiency of the material department in fund allocation. Through statistical analysis of material procurement data, key information of core indicators such as material procurement, supply, consumption, and inventory utilization can be quickly extracted, and multi-dimensional analysis of material inventory status, material declaration process, material usage, and material backlog status can be achieved to meet the data analysis needs of different units and users, and provide strong data support for the declaration and procurement of material plans.

[0003] In the traditional material management process, material statistics, as one of the core management tasks, mainly relies on material experts to collect and summarize the procurement plans for each batch. Material experts need to analyze the material demand list of each project. However, the material demand list may need to undergo multiple adjustments before actual procurement, which leads to the timeliness of material data, thereby affecting the accuracy of expert analysis results and having an adverse impact on material procurement decisions. In addition, in the traditional material management process, a variety of systems and tools are used to collect data related to material procurement information, resulting in data scattered everywhere, making it difficult to integrate data sources, increasing the complexity of data management, and reducing the efficiency of data collection and integration, thereby reducing the efficiency of material procurement data management and analysis value. At the same time, because data is scattered in various systems and has different format standards, complex models and algorithms are needed to analyze data, and experts are relied upon to interpret data analysis results, which increases employment costs and is not conducive to ordinary employees interpreting data analysis results, reducing the efficiency of material procurement decisions, and affecting the timeliness and accuracy of material procurement decisions. Summary of the invention

[0004] To this end, the technical problem to be solved by the present invention is to overcome the problems in the prior art of poor timeliness of procurement data updating, complex data management, low data integration efficiency, and inconsistent data formats, which lead to low efficiency, timeliness and accuracy of material procurement decision-making.

[0005] In order to solve the above technical problems, the present invention provides a source-end material procurement management system based on multi-dimensional information analysis, comprising:

[0006] The data collection module is connected to different data source systems through API interfaces; it is used to use Quartz components to set scheduled data collection tasks and their execution cycles, total execution duration, the start time of the first task execution, and obtain the end time of the last task execution; during each task execution period, it uses data extraction technology to collect multi-dimensional material data and project data in real time, and transmit the multi-dimensional material data and project data to the data processing module;

[0007] The data processing module is communicatively connected with the data acquisition module; it is used to perform cleaning and standardized preprocessing operations on the multidimensional material data and project data respectively during each task execution period to obtain the preprocessed multidimensional material data and project data; read the unique identification of each material in the preprocessed multidimensional material data and the unique identification of each project in the preprocessed project data from different data source systems, and convert the unique identification of each material and the unique identification of each project into the mapping value of each material and the mapping value of each project according to the identification mapping association mechanism to obtain the integrated data information of each material and the integrated data information of each project; sort out the integrated data information of each material and the integrated data information of each project, automatically identify and eliminate the redundant information in the integrated data information of each material and the integrated data information of each project, and obtain the comprehensive data information of each material and the comprehensive data information of each project;

[0008] The data analysis module is connected to the data processing model in communication; after the last task is executed, according to the comprehensive data information of each project in different time periods, the unit dimension data model and the project dimension data model are used in combination with the FusionChars chart component to generate a unit dimension data chart and a project dimension data chart; according to the comprehensive data information of each material and the comprehensive data information of each project in different time periods, the material dimension data model is used in combination with the FusionChars chart component to generate a material dimension data chart;

[0009] The visualization module is connected to the data analysis module in communication; it is used to display the results of the unit dimension data chart, the project dimension data chart and the material dimension data chart.

[0010] Preferably, the use of the Quartz component to set the scheduled data collection task and its execution cycle, total execution duration, initial task execution start time, and obtain the final task execution end time includes:

[0011] The data collection task is defined in the scheduling unit of the Quartz component; the execution cycle, total execution duration, and start execution time of the data collection task are set in the trigger unit of the Quartz component; wherein, the end time of the last task execution is obtained according to the execution cycle, total execution duration, and start time of the first task execution of the data collection task.

[0012] Preferably, it also includes:

[0013] If the unique identifier of each material in the preprocessed multidimensional material data or the unique identifier of each item in the preprocessed item data cannot be read from different data source systems or does not exist, the tool library is used to automatically generate the unique identifier of the current material or the unique identifier of the current item.

[0014] Preferably, the multidimensional material data includes material demand procurement information, material inventory data, material procurement transaction records, material master data, and material technical specification data; the material demand procurement information includes the quantity requirements, specification requirements, and delivery time requirements of each material for the corresponding project; the material inventory data includes the inventory quantity, inventory location, and inventory turnover rate of each material; the material procurement record includes the procurement identification, procurement price, supply area, and procurement batch situation of each material; the material master data includes the basic attributes, coding, professional category, preferred classification attributes, and State Grid standard classification attributes of each material; the material technical specification data includes the technical specification ID of each material; the project data includes the project quantity, as well as the submitting unit, submitted material items, returned and changed material items, feasibility study estimated amount, preliminary design budget amount, solidified ID application rate, preferred material application rate, procurement batch situation, and balanced inventory situation of each project.

[0015] Preferably, the preprocessing operations of cleaning and standardizing the multi-dimensional material data and project data respectively to obtain the preprocessed multi-dimensional material data and project data include:

[0016] Respectively remove redundant data in the multidimensional material data and project data, and respectively process missing values ​​and abnormal values ​​in the multidimensional material data and project data to obtain the multidimensional material data and project data after data cleaning;

[0017] According to the preset data specification standards, standardization operations are performed on the multidimensional material data and project data after data cleaning to obtain pre-processed multidimensional material data and project data.

[0018] Preferably, according to the comprehensive data information of each project in different time periods, using the unit dimension data model and the FusionChars chart component, generating the unit dimension data chart includes:

[0019] According to the reporting unit, reported material items, returned and changed material items, feasibility study estimated amount and preliminary design budget amount corresponding to the comprehensive data information of each project, the project quantity, material items, returned and changed material quantity, feasibility study estimated amount and preliminary design budget amount of each unit in the unit dimension data model are obtained;

[0020] Using FusionChars chart components, based on the project quantities, material items, returned and changed material quantities, feasibility study estimated amounts and preliminary estimated amounts of all units, a time chart and table of the project quantities of each unit, a time chart and table of the material items of each unit, a time chart and table of the returned and changed material quantities of each unit, a time chart and table of the feasibility study estimated amounts of each unit, and a time chart and table of the preliminary estimated amounts of each unit project are generated, and all charts are used as unit dimension data charts; among them, the charts include line charts and bar charts.

[0021] Preferably, according to the comprehensive data information of each project in different time periods, using the project dimension data model and FusionChars chart component, generating the project dimension data chart includes:

[0022] According to the comprehensive data information of each project, determine the number of submitted material items, returned and changed material items, fixed ID application rate, preferred material application rate, procurement batch situation, balanced inventory situation, and feasibility study preliminary design comparison of each project;

[0023] FusionChars chart components are used to generate radar charts for each project, Gantt charts and tables of the procurement batch time schedule for each project, and balanced inventory display charts for each project as project dimension data charts based on the number of submitted material items, the number of returned and changed material items, the application rate of fixed IDs, the application rate of preferred materials, the purchase batch situation, the balance inventory situation, and the feasibility study and preliminary design comparison of each project;

[0024] Among them, the radar chart of each project contains the relationship between the number of submitted material items, the number of returned and changed material items, the application rate of fixed ID, the application rate of preferred materials and time for each project; the balanced inventory display chart of each project contains the relationship between the inventory of various materials in each project and time; in the balanced inventory display chart, green indicates sufficient material inventory, yellow indicates material inventory warning, and red indicates material inventory shortage.

[0025] Preferably, the material dimension data graph is generated according to the comprehensive data information of each material and the comprehensive data information of each project in different time periods by using the material dimension data model and combining the FusionChars chart component, including:

[0026] Based on the professional categories and supply areas corresponding to the comprehensive data information of each material, combined with the source units, submitted material items and returned material items corresponding to the comprehensive data information of each project, determine the number of material items and supply areas corresponding to each type of professional in each project; among which, the professional categories of materials include primary equipment, secondary equipment, device materials, and smart substation secondary equipment;

[0027] Using the FusionChars chart component, based on the number of material items and supply areas corresponding to each type of specialty in each project, a bar comparison chart of the number of category items for each project and a category supply area distribution chart for each project are generated as material dimension data charts.

[0028] Preferably, the data acquisition module and different data source systems need to be isolated by an isolation device.

[0029] Preferably, the data source system includes an ERP system and a WWS system.

[0030] The above technical solution of the present invention has the following beneficial effects compared with the prior art:

[0031] The source-end material procurement management system based on multi-dimensional information analysis described in the present invention connects the data acquisition module with different data source systems through an API interface, and sets a scheduled data acquisition task according to the Quartz component; during the task execution period, multi-dimensional material data and project data are collected in real time using data extraction technology; different data source systems transmit data to the data acquisition module through a unified interface, fundamentally changing the scattered state of data, and using the platform interface and data interaction mechanism to orderly aggregate the data originally scattered in various systems and tools, thereby reducing the complexity of collection, improving the efficiency of data integration, enhancing the effectiveness of material procurement information management and control, and mining the richness of data. Analyze the value and provide strong support for procurement strategy planning, cost control, etc.; by setting up digital means of scheduled data collection tasks, timely summarize the data that changes at any time, ensure the timeliness and accuracy of data updates, and avoid expert analysis deviations due to data timeliness issues, thereby reducing the accuracy of procurement decisions; after the data format is unified, through the design and construction of unit dimension, project dimension data models and multi-dimensional material data models, combined with FusionChars chart components, based on actual business key indicators, generate visual charts; it is convenient for ordinary employees to understand the data and grasp the core points, effectively assist procurement decisions, and improve the scientificity and timeliness of decisions. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] In order to make the content of the present invention more clearly understood, the present invention is further described in detail below according to specific embodiments of the present invention in conjunction with the accompanying drawings, wherein:

[0033] Figure 1 It is a schematic diagram of a source-end material procurement management system based on multi-dimensional information analysis provided by the present invention;

[0034] Figure 2 It is a system logic design flow chart;

[0035] Figure 3 It is a schematic diagram of scheduled task data configuration and server action binding;

[0036] Figure 4 It is the database master table diagram;

[0037] Figure 5 It is a schematic diagram of data processing and analysis;

[0038] Figure 6 It is a schematic diagram of the data type of the unit dimension data model;

[0039] Figure 7 It is a diagram of data types of the project dimension data model;

[0040] Figure 8 It is a schematic diagram of the material dimension data model data information. DETAILED DESCRIPTION

[0041] The present invention is further described below in conjunction with the accompanying drawings and specific embodiments so that those skilled in the art can better understand the present invention and implement it, but the embodiments are not intended to limit the present invention.

[0042] Reference Figure 1 As shown, Figure 1 A schematic diagram of a source-side material procurement management system based on multi-dimensional information analysis provided by the present invention; specifically comprising:

[0043] The data collection module is connected to different data source systems through API interfaces; it is used to use Quartz components to set scheduled data collection tasks and their execution cycles, total execution duration, the start time of the first task execution, and obtain the end time of the last task execution; during each task execution period, it uses data extraction technology to collect multi-dimensional material data and project data in real time, and transmit the multi-dimensional material data and project data to the data processing module;

[0044] Wherein, the data source system includes an ERP system and a WWS system; the data acquisition module and different data source systems need to be isolated by an isolation device;

[0045] The data collection task is defined in the scheduling unit of the Quartz component; the execution cycle, total execution duration, and start execution time of the data collection task are set in the trigger unit of the Quartz component; the end time of the last task execution is obtained according to the execution cycle, total execution duration, and start time of the first task execution of the data collection task;

[0046] Among them, the multidimensional material data includes material demand procurement information, material inventory data, material procurement transaction records, material master data, and material technical specification data; the material demand procurement information includes the quantity demand, specification demand, and delivery time demand of each material; the material inventory data includes the inventory quantity, inventory location, and inventory turnover rate of each material; the material procurement record includes the procurement identification, procurement price, supply area, and procurement batch of each material; the material master data includes the basic attributes, coding, professional category, preferred classification attributes, and national grid standard classification attributes of each material; the material technical specification data includes the technical specification ID of each material; the project data includes the number of projects, as well as the reporting unit, reported material items, returned and changed material items, feasibility study estimated amount, preliminary design budget amount, solidification ID application rate, preferred material application rate, procurement batch situation, and balanced inventory situation of each project;

[0047] The data processing module is communicatively connected with the data acquisition module; it is used to perform cleaning and standardized preprocessing operations on the multidimensional material data and project data respectively during each task execution period to obtain the preprocessed multidimensional material data and project data; read the unique identification of each material in the preprocessed multidimensional material data and the unique identification of each project in the preprocessed project data from different data source systems, and convert the unique identification of each material and the unique identification of each project into the mapping value of each material and the mapping value of each project according to the identification mapping association mechanism to obtain the integrated data information of each material and the integrated data information of each project; sort out the integrated data information of each material and the integrated data information of each project, automatically identify and eliminate the redundant information in the integrated data information of each material and the integrated data information of each project, and obtain the comprehensive data information of each material and the comprehensive data information of each project;

[0048] Among them, the multi-dimensional material data and project data are cleaned and standardized respectively, and the pre-processed multi-dimensional material data and project data include:

[0049] Respectively remove redundant data in the multidimensional material data and project data, and respectively process missing values ​​and abnormal values ​​in the multidimensional material data and project data to obtain the multidimensional material data and project data after data cleaning;

[0050] According to the preset data specification standards, standardization operations are performed on the multi-dimensional material data and project data after data cleaning to obtain pre-processed multi-dimensional material data and project data;

[0051] If the unique identifier of each material in the preprocessed multidimensional material data or the unique identifier of each item in the preprocessed item data cannot be read from different data source systems or does not exist, the tool library is used to automatically generate the unique identifier of the current material or the unique identifier of the current item;

[0052] The data analysis module is connected to the data processing model in communication; after the last task is executed, according to the comprehensive data information of each project in different time periods, the unit dimension data model and the project dimension data model are used in combination with the FusionChars chart component to generate a unit dimension data chart and a project dimension data chart; according to the comprehensive data information of each material and the comprehensive data information of each project in different time periods, the material dimension data model is used in combination with the FusionChars chart component to generate a material dimension data chart;

[0053] Among them, according to the comprehensive data information of each project in different time periods, the unit dimension data model and FusionChars chart component are used to generate unit dimension data charts including:

[0054] According to the reporting unit, reported material items, returned and changed material items, feasibility study estimated amount and preliminary design budget amount corresponding to the comprehensive data information of each project, the project quantity, material items, returned and changed material quantity, feasibility study estimated amount and preliminary design budget amount of each unit in the unit dimension data model are obtained;

[0055] Using FusionChars chart components, based on the project quantity, material items, material quantity refunded and changed, feasibility study estimated amount and preliminary estimated amount of all units, a time chart and table of project quantity for each unit, a time chart and table of material item refunded and changed for each unit, a time chart and table of feasibility study estimated amount for each unit, and a time chart and table of preliminary estimated amount for each unit are generated, and all charts are used as unit dimension data charts; the charts include line charts and bar charts;

[0056] Among them, according to the comprehensive data information of each project in different time periods, the project dimension data model and FusionChars chart component are used to generate project dimension data charts including:

[0057] According to the comprehensive data information of each project, determine the number of submitted material items, returned and changed material items, fixed ID application rate, preferred material application rate, procurement batch situation, balanced inventory situation, and feasibility study preliminary design comparison of each project;

[0058] FusionChars chart components are used to generate radar charts for each project, Gantt charts and tables of the time schedule of procurement batches for each project, and balanced inventory display charts for each project as project dimension data charts based on the number of submitted material items, the number of returned and changed material items, the application rate of fixed IDs, the application rate of preferred materials, the purchase batch situation, the balanced inventory situation, and the feasibility study preliminary design comparison of each project; the radar chart of each project contains the relationship between the number of submitted material items, the number of returned and changed material items, the application rate of fixed IDs, the application rate of preferred materials, and time of each project; the balanced inventory display chart of each project contains the relationship between the inventory of various materials in each project and time; in the balanced inventory display chart, green indicates sufficient material inventory, yellow indicates material inventory warning, and red indicates material inventory shortage;

[0059] Among them, according to the comprehensive data information of each material and each project in different time periods, the material dimension data model is used in combination with the FusionChars chart component to generate the material dimension data chart including:

[0060] Based on the professional categories and supply areas corresponding to the comprehensive data information of each material, combined with the source units, submitted material items and returned material items corresponding to the comprehensive data information of each project, determine the number of material items and supply areas corresponding to each type of professional in each project; among which, the professional categories of materials include primary equipment, secondary equipment, device materials, and smart substation secondary equipment;

[0061] Using FusionChars chart components, based on the quantity of material items and supply areas corresponding to each type of specialty in each project, a bar chart of the number of category items for each project and a distribution chart of the category supply areas for each project are generated as material dimension data charts;

[0062] The visualization module is connected to the data analysis module in communication; it is used to display the results of the unit dimension data chart, the project dimension data chart and the material dimension data chart.

[0063] Based on the source-end material procurement management system provided by the present invention for analyzing multi-dimensional information, the system logic design is as follows: Figure 2 Shown; including:

[0064] (1) Define relevant variables of project data (material code, technical specification ID, etc.);

[0065] (2) Use the Quartz component to define the scheduled task configuration data, bind the corresponding server action, and implement the scheduled data update function, such as Figure 3 As shown; after obtaining the execution time of the last scheduled task, query the project data with variable changes during this time period;

[0066] (3) For the queried project data, secondary query the corresponding material demand list data;

[0067] (4) Group according to the table field [Phase Type] identification mapping (feasibility study phase, preliminary design phase); query the material item data with material attributes;

[0068] (5) Traverse the project data set according to the established key indicator calculation method for material management;

[0069] State Grid preferred materials: refers to the high-quality power equipment and related materials purchased and managed by State Grid Corporation. In order to ensure the stability and safety of the power system, State Grid Corporation will select high-quality, standard-compliant materials to meet its construction and maintenance needs; the preferred material application rate indicator needs to obtain the inventory data of all project materials required in the corresponding time period according to the current query conditions, and then map the preferred classification attributes of the material master data in the resource library through the material items, that is, the attribute of [preferred or not], and support the procurement and control of preferred materials by calculating the proportion of the number of items with the attribute [preferred] to the total number of items.

[0070] According to the ID name in the business form, multiple form data are aggregated to generate a general table containing all project data, such as Figure 4 As shown, data processing and analysis are carried out based on the data in the master table; the master table data includes multi-dimensional material data and project data; through meticulous business research and in-depth analysis, the multi-dimensional information involved in the material procurement process is comprehensively and systematically classified and sorted, including but not limited to material demand procurement information, material inventory data, material procurement transaction records, material master data, and material technical specification data; data governance measures are used, namely data cleaning, data standardization, identification mapping association mechanism and elimination of redundant information, to process all data and obtain all processed data, namely, comprehensive data information of each material and comprehensive data information of each project; different dimensional mathematical models are used to analyze and process all processed data and obtain data charts of different dimensions; specifically, Figure 5 shown.

[0071] In order to ensure the uniqueness of the same material on different data source systems and reduce the workload of processing complex material data, the present invention designs an identification mapping association mechanism, which enables the system to automatically identify and match material information, avoid manual duplication of work, improve efficiency, reduce the risk of data inconsistency, ensure the accuracy and consistency of data, and ensure efficient management of data, thereby improving the overall operational effectiveness and supply chain management level. Among them, the identification mapping association mechanism is to read the unique identification of each data on different data source systems, establish material mapping associations through manually configured mapping methods, and ensure that the same materials on different data source systems are accurately corresponding. Examples are shown in Table 1; for data that lacks a unique identification, a UUID (unique identification) will be automatically generated and the data source will be recorded.

[0072] Table 1 Identity mapping association example table

[0073] Data Source Unique ID Mapping Values ERP Technical software number serial number WMS ID Inventory ID …… …… ……

[0074] In order to ensure the integrity and consistency of the data, it is necessary to formulate the same data specifications, including field length, text type and required information, as the preset data specification standard, as shown in Table 2; the preset data specification standard clearly defines the field character limit and format requirements, such as date, number or string, and ensures that key data items are fully filled in, which helps to ensure data integrity and improve processing efficiency and accuracy.

[0075] Table 2 Data specification standard table

[0076] Field Description Field Name Type(Length) inventoryId Primary key for inventory data varchar(40) materialCode Material Code varchar(40) solidifyId Technical Specification ID varchar(50) factoryCode Factory No. varchar(40) inventoryAge Storage age int(8) inventoryNumber Stock quantity decimal(13,3) inventoryUnit Stock keeping unit varchar(40) invNoTaxPrice Inventory value (excluding tax) decimal(13,2)

[0077] Through the identification mapping association mechanism, the data of multiple data source systems are sorted out, and the redundant information of the same data in multiple data source systems is identified. By configuring the data source of such redundant information, the incidence of matching errors caused by manual verification is greatly reduced.

[0078] Through multi-dimensional information, a unit dimension data model is built, that is, the data model is built based on the unit assessment dimension, which mainly includes the number of projects, material items, the number of returned and changed materials, the feasibility study estimated amount, and the initial budget amount, such as Figure 6 As shown; using information such as project quantity, material items, quantity of returned and changed materials, feasibility study estimated amount and initial budget amount, help provincial companies and material management units to comprehensively analyze material procurement needs. For example, if the monthly milestone plan completes 10 project engineering material submissions, but the actual completion is less than 10, it is necessary to conduct root cause analysis in reverse order of ranking; evaluate the quality of each unit's material procurement plan through the number of projects, material items, and the number of returned and changed materials, and conduct an assessment. For example, if the number of returned and changed items in the monthly reported procurement plan exceeds 30% of the total material items, a performance assessment is required.

[0079] Through multi-dimensional information, a project dimension data model is built, that is, the indicators with clear requirements in the business are analyzed in the project dimension, mainly including the number of submitted material items, returned and changed material items, fixed ID application rate, preferred material application rate, procurement batch situation, balanced inventory situation, and feasibility study preliminary design comparison, such as Figure 7 As shown;

[0080] Through multi-dimensional information, a material dimension data model is built, and its corresponding data information, such as Figure 8 shown.

[0081] In summary, the present invention obtains multidimensional data in a multi-data source system through a data interface; constructs a procurement batch model based on the preprocessed multidimensional data, so that the design unit can track and analyze the reasons for deviations in the preparation results; at the same time, implements a balanced inventory strategy, gives priority to the use of inventory materials, and then submits a procurement application, which can improve inventory utilization efficiency and reduce procurement costs; the present invention constructs a balanced inventory suggestion visualization card to intuitively display the material inventory situation; in addition, the comparison between feasibility study and preliminary design is an important link in project management, and the material data model of the present invention can automatically generate the comparison situation and conclusion of the feasibility study and preliminary design, assist the project management unit to clearly display the project progress and changes, improve the level of preparation results of the design unit, and ensure the smooth progress and successful implementation of the project.

[0082] Obviously, the above embodiments are merely examples for the purpose of clear explanation and are not intended to limit the implementation methods. For those skilled in the art, other different forms of changes or modifications can be made based on the above description. It is not necessary and impossible to list all the implementation methods here. The obvious changes or modifications derived therefrom are still within the scope of protection of the present invention.

Claims

1. A source-end material procurement management system based on multi-dimensional information analysis, characterized in that: include: Data collection module, connected with different data source systems through API interface; Used to use Quartz components to set scheduled data collection tasks and their execution cycles, total execution duration, the start time of the first task execution, and obtain the end time of the last task execution; During each task execution period, data extraction technology is used to collect multi-dimensional material data and project data in real time, and the multi-dimensional material data and project data are transmitted to the data processing module; The data processing module is in communication connection with the data acquisition module; it is used to perform cleaning and standardized preprocessing operations on the multi-dimensional material data and the project data respectively in each task execution period to obtain the preprocessed multi-dimensional material data and the project data; it reads the unique identification of each material in the preprocessed multi-dimensional material data and the unique identification of each project in the preprocessed project data from different data source systems, and according to the identification mapping association mechanism, it converts the unique identification of each material and the unique identification of each project into the mapping value of each material and the mapping value of each project to obtain the integrated data information of each material and the integrated data information of each project; Sort out the integrated data information of each material and each project, automatically identify and eliminate redundant information in the integrated data information of each material and each project, and obtain the comprehensive data information of each material and each project; The data analysis module is connected to the data processing model in communication; after the last task is executed, according to the comprehensive data information of each project in different time periods, the unit dimension data model and the project dimension data model are used in combination with the FusionChars chart component to generate a unit dimension data chart and a project dimension data chart; according to the comprehensive data information of each material and the comprehensive data information of each project in different time periods, the material dimension data model is used in combination with the FusionChars chart component to generate a material dimension data chart; A visualization module is connected to the data analysis module in communication; Used to display the results of unit dimension data charts, project dimension data charts, and material dimension data charts.

2. According to claim 1, a source-end material procurement management system based on multidimensional information analysis is characterized in that: The use of the Quartz component to set the scheduled data collection task and its execution cycle, total execution time, the start time of the first task execution, and obtain the end time of the last task execution includes: The data collection task is defined in the scheduling unit of the Quartz component; the execution cycle, total execution duration, and start execution time of the data collection task are set in the trigger unit of the Quartz component; wherein, the end time of the last task execution is obtained according to the execution cycle, total execution duration, and start time of the first task execution of the data collection task.

3. According to the source-end material procurement management system based on multidimensional information analysis according to claim 1, it is characterized in that: Also includes: If the unique identifier of each material in the preprocessed multidimensional material data or the unique identifier of each item in the preprocessed item data cannot be read from different data source systems or does not exist, the tool library is used to automatically generate the unique identifier of the current material or the unique identifier of the current item.

4. According to the source-end material procurement management system based on multidimensional information analysis according to claim 1, it is characterized in that: The multidimensional material data includes material demand procurement information, material inventory data, material procurement transaction records, material master data, and material technical specification data; the material demand procurement information includes the quantity requirements, specification requirements, and delivery time requirements of each material for the corresponding project; the material inventory data includes the inventory quantity, inventory location, and inventory turnover rate of each material; the material procurement records include the procurement identification, procurement price, supply area, and procurement batch situation of each material; the material master data includes the basic attributes, coding, professional category, preferred classification attributes, and State Grid standard classification attributes of each material; the material technical specification data includes the technical specification ID of each material; the project data includes the project quantity, as well as the submitting unit, submitted material items, returned and changed material items, feasibility study estimated amount, preliminary design budget amount, solidified ID application rate, preferred material application rate, procurement batch situation, and balanced inventory situation of each project.

5. A source-end material procurement management system based on multi-dimensional information analysis according to claim 4, characterized in that: The preprocessing operations of cleaning and standardizing the multi-dimensional material data and project data respectively to obtain the preprocessed multi-dimensional material data and project data include: Respectively remove redundant data in the multidimensional material data and project data, and respectively process missing values ​​and abnormal values ​​in the multidimensional material data and project data to obtain the multidimensional material data and project data after data cleaning; According to the preset data specification standards, standardization operations are performed on the multidimensional material data and project data after data cleaning to obtain pre-processed multidimensional material data and project data.

6. A source-end material procurement management system based on multi-dimensional information analysis according to claim 4, characterized in that: According to the comprehensive data information of each project in different time periods, the unit dimension data model and FusionChars chart components are used to generate unit dimension data charts including: According to the reporting unit, reported material items, returned and changed material items, feasibility study estimated amount and preliminary design budget amount corresponding to the comprehensive data information of each project, the project quantity, material items, returned and changed material quantity, feasibility study estimated amount and preliminary design budget amount of each unit in the unit dimension data model are obtained; Using FusionChars chart components, based on the project quantities, material items, returned and changed material quantities, feasibility study estimated amounts and preliminary estimated amounts of all units, a time chart and table of the project quantities of each unit, a time chart and table of the material items of each unit, a time chart and table of the returned and changed material quantities of each unit, a time chart and table of the feasibility study estimated amounts of each unit, and a time chart and table of the preliminary estimated amounts of each unit project are generated, and all charts are used as unit dimension data charts; among them, the charts include line charts and bar charts.

7. A source-end material procurement management system based on multi-dimensional information analysis according to claim 4, characterized in that: According to the comprehensive data information of each project in different time periods, the project dimension data charts are generated by using the project dimension data model and FusionChars chart components, including: According to the comprehensive data information of each project, determine the number of submitted material items, returned and changed material items, fixed ID application rate, preferred material application rate, procurement batch situation, balanced inventory situation, and feasibility study preliminary design comparison of each project; FusionChars chart components are used to generate radar charts for each project, Gantt charts and tables of the procurement batch time schedule for each project, and balanced inventory display charts for each project as project dimension data charts based on the number of submitted material items, the number of returned and changed material items, the application rate of fixed IDs, the application rate of preferred materials, the purchase batch situation, the balance inventory situation, and the feasibility study and preliminary design comparison of each project; Among them, the radar chart of each project contains the relationship between the number of submitted material items, the number of returned and changed material items, the application rate of fixed ID, the application rate of preferred materials and time for each project; the balanced inventory display chart of each project contains the relationship between the inventory of various materials in each project and time; in the balanced inventory display chart, green indicates sufficient material inventory, yellow indicates material inventory warning, and red indicates material inventory shortage.

8. A source-end material procurement management system based on multi-dimensional information analysis according to claim 4, characterized in that: According to the comprehensive data information of each material and the comprehensive data information of each project in the different time periods, the material dimension data model is used in combination with the FusionChars chart component to generate the material dimension data graph including: Based on the professional categories and supply areas corresponding to the comprehensive data information of each material, combined with the source units, submitted material items and returned material items corresponding to the comprehensive data information of each project, determine the number of material items and supply areas corresponding to each type of professional in each project; among which, the professional categories of materials include primary equipment, secondary equipment, device materials, and smart substation secondary equipment; Using the FusionChars chart component, based on the number of material items and supply areas corresponding to each type of specialty in each project, a bar comparison chart of the number of category items for each project and a category supply area distribution chart for each project are generated as material dimension data charts.

9. The source-end material procurement management system based on multi-dimensional information analysis according to claim 1 is characterized in that: The data acquisition module and different data source systems need to be isolated through an isolation device.

10. The source-end material procurement management system based on multi-dimensional information analysis according to claim 1, characterized in that: The data source systems include an ERP system and a WWS system.

Images