Automobile manufacturing industry data index disassembling method and system

Abstract

The invention discloses an automobile manufacturing industry data index disassembling method and system, and the method comprises the following steps: collecting data indexes of an automobile manufacturing industry, collecting a data set, and completing the filling of the data indexes; if the data index is a composite index, disassembling the composite index into independent derivative indexes; comparing a derivative index of the data index with a preset statistical dimension, and if it is found that the derivative index name contains statistical dimension information, automatically stripping the statistical dimension information to obtain an atomic index; and searching a specific fact table and a field bound with the atomic index in the database, calculating a derivative index through the atomic index, creating a composite index, and outputting the disassembled atomic index, the derivative index and the composite index. By adopting the technical scheme, the data indexes of the automobile manufacturing industry are disassembled, the definition and range of the indexes are clarified, the logic and meaning behind the indexes can be understood, and the accuracy and efficiency of data analysis are improved.

Description

Technical Field

[0001] The present invention belongs to the technical field of data disassembly, and relates to a method and system for disassembling data indicators in the automobile manufacturing industry. Background Art

[0002] With the rapid development of the modern automobile manufacturing industry, data analysis has become the key to optimizing production, improving efficiency and reducing costs in the industry. The analysis, disassembly and interpretation of various data indicators in the automobile manufacturing industry are receiving more and more attention.

[0003] The background of the indicator decomposition method can be traced back to the fields of performance management and data analysis, which helps organizations better understand and analyze performance indicators, identify key factors, and support data-driven decision-making and business optimization. This method is applicable to the automotive industry and organizations, helping them to more accurately measure, evaluate and improve performance.

[0004] Currently, most data indicator decomposition methods are based on statistics, machine learning or other data science methods, which often require complex models, long-term training and expert intervention, and are all managed manually. It takes a lot of time and resources to process data and train models, and the interpretation and decomposition of specific indicators are not intuitive enough. At the same time, they are not friendly to non-technical personnel and require professional knowledge to operate. Summary of the invention

[0005] The purpose of the present invention is to provide a method for disassembling data indicators of the automobile manufacturing industry to solve the problem of disassembling data indicators of the automobile manufacturing industry for non-technical personnel.

[0006] In order to achieve the above object, the basic scheme of the present invention is: a method for disassembling data indicators of the automobile manufacturing industry, comprising the following steps:

[0007] Collect data indicators of the automobile manufacturing industry, collect data sets and complete data indicator filling;

[0008] Identify the data indicator content through data indicator definition and identification. If the data indicator contains an operator, it is a composite indicator. Then, the composite indicator is decomposed into independent derivative indicators according to the preset identification. The derivative indicator and the composite indicator are two different indicators, which are used to express different business attribute requirements.

[0009] Compare the derived indicators of the data indicators with the preset statistical dimensions. If it is found that the derived indicator name contains statistical dimension information, the statistical dimension information is automatically stripped to obtain the atomic indicator.

[0010] Find the specific fact table and field bound to the atomic indicator in the database, calculate the derived indicator through the atomic indicator, and create a composite indicator using the derived indicator. The calculation script of the composite indicator can be written by the user.

[0011] The output displays the decomposed atomic indicators, derived indicators and composite indicators. Users can operate the indicators to explore the specific data corresponding to the indicators.

[0012] The working principle and beneficial effects of this basic solution are as follows: This technical solution provides a simple, intuitive, and non-technical method for disassembling data indicators in the automotive manufacturing industry. Starting from basic data, it gradually builds and reviews atomic indicators, derived indicators, and composite indicators, and ultimately achieves automation and precision of complex business insights. This process not only improves the efficiency and accuracy of data analysis, but also provides a more scientific and comprehensive basis for corporate decision-making.

[0013] Furthermore, data indicators of the automobile manufacturing industry are collected, specifically:

[0014] Collect a list of indicators by integrating the actual needs of the business side, past experience accumulation, and industry-recognized key performance indicators and standards;

[0015] Based on the business model, management model and manufacturing model of the automobile manufacturing industry, the indicators in the indicator list are screened to select indicators that reflect the company's operating conditions, production efficiency, product quality, cost control and market responsiveness;

[0016] Obtain the business module affiliation, Chinese name, English name and abbreviation, system to which it belongs, setting purpose, specific definition, calculation formula, statistical period and statistical dimension information of the filtered indicators, and enter them into the database.

[0017] Collect data indicators of the automobile manufacturing industry for subsequent use.

[0018] Furthermore, the specific method of decomposing the composite indicator into independent derivative indicators according to the preset identifier is as follows:

[0019] Get data indicator content;

[0020] Identify whether the data indicator content contains a composite indicator identifier;

[0021] If there is a composite indicator mark, determine whether there is a disassembly mark in the data indicator content after the composite indicator mark;

[0022] If there is a disassembly mark, the text content of the data indicator after the composite indicator mark will be split based on the disassembly mark;

[0023] Each segment of data indicator after splitting is a derived indicator.

[0024] Disassembling composite indicator symbols will help to better understand the indicator structure.

[0025] Further, the specific fact table and field bound to the atomic indicator in the database are found, the derived indicator is calculated through the atomic indicator, and the steps of creating a composite indicator using the derived indicator are as follows:

[0026] Create atomic indicators and the required fact tables and field information based on business needs;

[0027] Reference atomic indicators and combine dimension information, and create new derived indicators through the combination of atomic indicators + dimensions + time. The dimension information is determined according to the definition of derived indicators.

[0028] The composite index is calculated using multiple derived indexes according to the formula defined in the index document, such as: (derivative index 1 + derivative index 2)*100 = composite index.

[0029] In this way, derived indicators and composite indicators can be calculated based on atomic indicators, which will help to deeply understand the business, discover problems, formulate strategies and improve efficiency.

[0030] The present invention also provides a data index disassembly system for the automobile manufacturing industry, comprising a data acquisition module and a processing module, wherein the data acquisition module is used to collect data indexes of the automobile manufacturing industry, and the output end of the data acquisition module is connected to the input end of the processing module;

[0031] The processing module executes the method of the present invention to disassemble the data indicators of the automobile manufacturing industry.

[0032] This system uses data acquisition modules and processing modules to break down data indicators in the automotive manufacturing industry, clarify the definition and scope of the indicators, and help understand the logic and meaning behind them.

[0033] Furthermore, it also includes a display module, the input end of the display module is connected to the output end of the processing module.

[0034] The processing module outputs the disassembled atomic indicators, derived indicators, composite indicators and other information to the display module, which is more intuitive and easy to view. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] Figure 1 It is a flow chart of the method for disassembling data indicators of the automobile manufacturing industry of the present invention. DETAILED DESCRIPTION

[0036] Embodiments of the present invention are described in detail below, examples of which are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the present invention, and cannot be understood as limiting the present invention.

[0037] In the description of the present invention, it is necessary to understand that the terms "longitudinal", "lateral", "up", "down", "front", "back", "left", "right", "vertical", "horizontal", "top", "bottom", "inside", "outside", etc., indicating the orientation or position relationship, are based on the orientation or position relationship shown in the accompanying drawings, and are only for the convenience of describing the present invention and simplifying the description, rather than indicating or implying that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and therefore cannot be understood as a limitation on the present invention.

[0038] In the description of the present invention, unless otherwise specified and limited, it should be noted that the terms "installed", "connected" and "connected" should be understood in a broad sense. For example, it can be a mechanical connection or an electrical connection, or it can be the internal connection between two components. It can be a direct connection or an indirect connection through an intermediate medium. For ordinary technicians in this field, the specific meanings of the above terms can be understood according to the specific circumstances.

[0039] The present invention discloses a method for disassembling data indicators of the automobile manufacturing industry, which is suitable for non-technical personnel and is easy to operate. Figure 1 As shown in the figure, the method for disassembling data indicators of the automobile manufacturing industry includes the following steps:

[0040] Collect data indicators of the automobile manufacturing industry, collect data sets and complete data indicator filling;

[0041] Identify the data indicator content through data indicator definition and identification. If the data indicator contains operators (such as "+", "-", "*", " / ", etc.), it is a composite indicator. Then, the composite indicator is disassembled into independent derivative indicators according to the preset identifier. The derivative indicator and the composite indicator are two different indicators, which are used to express different business attribute requirements;

[0042] Based on the indicator algorithm defined by intelligent matching, the derived indicators of the data indicators are compared with the preset statistical dimensions. If it is found that the name of the derived indicator contains statistical dimension information (such as "supplier"), this part of the statistical dimension information is automatically stripped off to obtain the atomic indicator; for example, "actual delivery quantity" is refined from "actual delivery quantity of the supplier".

[0043] Find the specific fact table and field bound to the atomic indicator in the database, calculate the derived indicator (i.e., atomic indicator + dimension + time) through the atomic indicator, and use the derived indicator to create a composite indicator. The calculation script of the composite indicator can be written by the user;

[0044] The output displays the decomposed atomic indicators, derived indicators and composite indicators. Users can operate the indicators to explore the specific data corresponding to the indicators.

[0045] In a preferred embodiment of the present invention, data indicators of the automobile manufacturing industry are collected, specifically:

[0046] Collect a list of indicators by integrating the actual needs of the business side, past experience accumulation, and industry-recognized key performance indicators (KPIs) and standards;

[0047] Based on the business model (such as order-driven production, modular design, etc.), operation and management model (such as supply chain management, cost control, quality management, etc.) and manufacturing model (such as lean production, automated production, etc.) of the automobile manufacturing industry, the indicators in the indicator list are screened to select the core indicators that reflect the company's operating conditions, production efficiency, product quality, cost control and market responsiveness;

[0048] Obtain the business module affiliation, Chinese name, English name and abbreviation, system (such as ERP, MES, etc.), setting purpose, specific definition, calculation formula, statistical period (such as day, week, month, year) and statistical dimension information (such as product line, factory, department, etc.) of the screened indicators, and enter them into the database.

[0049] In a preferred embodiment of the present invention, the specific method of decomposing the composite index into independent derivative indexes according to the preset identifier is:

[0050] Get data indicator content;

[0051] Identify whether the data indicator content contains a composite indicator identifier;

[0052] If there is a composite indicator mark, determine whether there is a disassembly mark in the data indicator content after the composite indicator mark;

[0053] If there is a disassembly mark, the text content of the data indicator after the composite indicator mark will be split based on the disassembly mark;

[0054] Each segment of data indicator after splitting is a derived indicator.

[0055] For example, supplier order completion rate = supplier actual delivery quantity / order arrangement quantity*100%. The system uses a built-in algorithm to identify " / " as a separator, and breaks down the composite indicator "supplier order completion rate" into independent derivative indicators "supplier actual delivery quantity" and "order arrangement quantity". At the same time, it cleverly ignores the constant "100%" in the calculation to ensure the purity of the analysis.

[0056] In a preferred solution of the present invention, the steps of searching the specific fact table and field bound to the atomic indicator in the database, calculating the derived indicator through the atomic indicator, and creating the composite indicator using the derived indicator are as follows:

[0057] Create atomic indicators (i.e. the most basic, indivisible metrics) and the required fact tables (tables storing business data) and field information (specific data columns in the table) according to business needs;

[0058] Reference atomic indicators and combine them with dimensional information. Create new derived indicators by combining atomic indicators + dimensions (regions) + time. The dimensional information is determined according to the definition of derived indicators. For example, output is used as an atomic indicator, the dimension is a welding workshop, and the time is one day. The specific derived indicator of the combination is the output of the welding workshop in one day.

[0059] According to the formula defined in the indicator document, multiple derived indicators are used to calculate the composite indicator (arbitrarily combined according to actual business needs), such as (derivative indicator 1 + derivative indicator 2) * 100 = composite indicator.

[0060] Derived indicators can be broken down into more basic atomic indicators, such as "delivery quantity" and "order arrangement quantity". Atomic indicators are the smallest data units that constitute the entire indicator system, and they directly correspond to specific tables and fields in the database. By confirming the data sources of these atomic indicators and refining them to specific database tables and fields, the accuracy and accessibility of the data can be ensured. This process of disassembly and refinement also helps technical personnel quickly understand and implement the logical calculation of indicators, while non-technical personnel can also more easily understand the meaning and data source behind each indicator.

[0061] The present invention also provides a data index disassembly system for the automobile manufacturing industry, including a data acquisition module and a processing module, wherein the data acquisition module is used to collect data indexes of the automobile manufacturing industry, and the output end of the data acquisition module is electrically connected to the input end of the processing module. The data acquisition module can use intelligent devices such as computers, and based on algorithms and visual interfaces, allows users to directly input or import data indexes of the automobile manufacturing industry.

[0062] The processing module executes the method of the present invention to disassemble the data indicators of the automobile manufacturing industry. The system uses the data acquisition module and the processing module to disassemble the data indicators of the automobile manufacturing industry, clarify the definition and scope of the indicators, and help understand the logic and meaning behind them.

[0063] In a preferred embodiment of the present invention, a display module is further included, and the input end of the display module is electrically connected to the output end of the processing module. The display module can also be directly set on the data acquisition module, and the processing module outputs information such as the atomic index, derived index and composite index after disassembly to the display module, and displays the full picture of the atomic index, derived index and composite index after disassembly to the user with an intuitive and clear interface, providing strong support for the user's data analysis work.

[0064] The indicator decomposition method of the present invention can help automobile companies understand and identify the relationship between various key indicators, so as to deeply understand the performance and business status of the company. By decomposing indicators, companies can understand the contribution of different indicators to the overall performance, find the driving factors of performance, quickly locate problems and bottlenecks in the business, and find potential improvement opportunities.

[0065] At the same time, it provides a basis and reference for corporate decision-making, more accurately evaluates the impact of decisions on various key indicators, predicts the results of different decision-making plans, and selects decisions that have a positive impact on overall performance, helping companies establish more effective performance management and incentive mechanisms. By disassembling indicators, the overall performance is broken down into the performance of each department or individual, providing a basis for performance evaluation, goal setting and incentive mechanisms, thereby promoting performance improvement and enhancing employee motivation.

[0066] By tracking changes and trends in key indicators and continuously breaking down and analyzing indicators, companies can promptly identify problems and improvement opportunities and formulate corresponding improvement measures, thereby promoting continuous improvement and development of the overall business.

[0067] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "examples", "specific examples", or "some examples" means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representation of the above terms does not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner.

[0068] Although the 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 claims and their equivalents.

Claims

1. A method for disassembling data indicators in the automobile manufacturing industry, characterized in that: The steps include: Collect data indicators of the automobile manufacturing industry, collect data sets and complete data indicator filling; Identify the content of data indicators through data indicator definitions and identifiers. If the data indicator contains an operator, it is a composite indicator. In this case, the composite indicator is decomposed into independent derivative indicators according to the preset identifiers. Compare the derived indicators of the data indicators with the preset statistical dimensions. If it is found that the derived indicator name contains statistical dimension information, the statistical dimension information is automatically stripped to obtain the atomic indicator. Find the specific fact table and field bound to the atomic indicator in the database, calculate the derived indicator through the atomic indicator, and create a composite indicator using the derived indicator. The calculation script of the composite indicator can be written by the user. The output displays the decomposed atomic indicators, derived indicators and composite indicators. Users can operate the indicators to explore the specific data corresponding to the indicators.

2. The method for disassembling data indicators of the automobile manufacturing industry according to claim 1, characterized in that: Collect data indicators of the automobile manufacturing industry, specifically: Collect a list of indicators by integrating the actual needs of the business side, past experience accumulation, and industry-recognized key performance indicators and standards; Based on the business model, management model and manufacturing model of the automobile manufacturing industry, the indicators in the indicator list are screened to select indicators that reflect the company's operating conditions, production efficiency, product quality, cost control and market responsiveness; Obtain the business module affiliation, Chinese name, English name and abbreviation, system to which it belongs, setting purpose, specific definition, calculation formula, statistical period and statistical dimension information of the filtered indicators, and enter them into the database.

3. The method for disassembling data indicators of the automobile manufacturing industry according to claim 1, characterized in that: The specific method of decomposing the composite indicator into independent derivative indicators according to the preset identification is: Get data indicator content; Identify whether the data indicator content contains a composite indicator identifier; If there is a composite indicator mark, determine whether there is a disassembly mark in the data indicator content after the composite indicator mark; If there is a disassembly mark, the text content of the data indicator after the composite indicator mark will be split based on the disassembly mark; Each segment of data indicator after splitting is a derived indicator.

4. The method for disassembling data indicators of the automobile manufacturing industry according to claim 1, characterized in that: Find the specific fact table and field in the database that is bound to the atomic indicator, calculate the derived indicator through the atomic indicator, and use the derived indicator to create a composite indicator as follows: Create atomic indicators and the required fact tables and field information based on business needs; Reference atomic indicators and combine dimension information, and create new derived indicators through the combination of atomic indicators + dimensions + time. The dimension information is determined according to the definition of derived indicators. Calculates a composite indicator using multiple derived indicators according to the formula defined in the indicator document.

5. A data indicator disassembly system for the automobile manufacturing industry, characterized in that: It includes a data acquisition module and a processing module, wherein the data acquisition module is used to collect data indicators of the automobile manufacturing industry, and the output end of the data acquisition module is connected to the input end of the processing module; The processing module executes the method described in any one of claims 1-4 to disassemble the data indicators of the automobile manufacturing industry.

6. The automobile manufacturing industry data indicator disassembly system according to claim 5, characterized in that: It also includes a display module, the input end of the display module is connected to the output end of the processing module.

Images