CN112070364A - Data analysis early warning method, system, computing device and computer readable storage medium - Google Patents

Abstract

The invention discloses a data analysis and early warning method, a system, a computing device and a computer-readable storage medium. The method includes: setting a data set and first and second thresholds of each data subset belonging to the data set; determining whether input data corresponding to each data subset exceeds the first threshold of its corresponding data subset Threshold value, determine whether the sum of the input data exceeds the first threshold value of the data set, and determine whether the excess value of the input data corresponding to each data subset exceeding the first threshold value of its corresponding data subset is greater than its corresponding data subset. a second threshold of the set, and determining whether the excess of the sum of the input data exceeds the first threshold of the data set is greater than the second threshold of the data set; and for input data or input data whose excess is greater than the corresponding second threshold Sum, output warning information. The present invention can assist users to quickly discover data non-compliance problems and improve work efficiency.

Description

Data analysis and early warning method, system, computing device and computer-readable storage medium

technical field

The present invention relates to the field of computer technology, and in particular, to a data analysis and early warning method, system, computing device and computer-readable storage medium.

Background technique

A budget is a systematic method used by an organization, such as a business, to reasonably allocate financial, physical, human and other resources to achieve set goals. Businesses can use budgets to monitor progress toward goals, help control expenses, and forecast business cash flow and profits.

Comprehensive budget management is the main method of enterprise internal management control. Enterprises use the informationized comprehensive budget management system to improve work efficiency, and achieve this through key steps such as budget preparation, budget control, and budget analysis.

The traditional budget analysis method needs to collect a lot of information, and then compile many analysis reports and then calculate the difference between the actual amount and the budget, which is time-consuming and labor-intensive. Find problems in the analysis results.

SUMMARY OF THE INVENTION

The present invention provides a data analysis and early warning method, comprising: setting a data set and a first threshold value and a second threshold value of each data subset belonging to the data set; determining whether the input data corresponding to each data subset exceeds the threshold The first threshold value of the corresponding data subset, determining whether the sum of the input data exceeds the first threshold value of the data set, determining the excess amount of the input data corresponding to each data subset exceeding the first threshold value of its corresponding data subset whether the value is greater than a second threshold for its corresponding subset of data, and determining whether the sum of the input data exceeds the first threshold of the dataset by an excess greater than the second threshold of the dataset; and for the excess greater than the corresponding first threshold Input data of two thresholds or the sum of input data, output warning information.

In an embodiment of the present invention, the first threshold is a predetermined value, and the second threshold is a predetermined percentage.

In an embodiment of the present invention, the first threshold of the data set is determined by the sum of the first thresholds of the respective data subsets.

In an embodiment of the present invention, at least one of the first threshold and the second threshold is resettable.

In an embodiment of the present invention, the outputting the warning information includes displaying it on the screen of the electronic device in the form of a pop-up frame.

In an embodiment of the present invention, the data analysis and early warning method includes displaying the data analysis result on the screen of the electronic device in the form of an analysis chart.

In an embodiment of the present invention, the data set is a budget application form, and the data subset is each individual budget application item in the budget application form.

The present invention also provides a data analysis and early warning system, comprising: a threshold setting module for setting a first threshold and a second threshold for a data set and each data subset belonging to the data set; a data analysis module for determine whether the input data corresponding to each data subset exceeds the first threshold of its corresponding data subset, determine whether the sum of the input data exceeds the first threshold of the data set, determine whether the input data corresponding to each data subset exceeds the Whether the excess value of the first threshold value of its corresponding data subset is greater than the second threshold value of its corresponding data subset, and determining whether the excess value of the sum of the input data exceeds the first threshold value of the data set is greater than the data set and an early warning module for outputting early warning information for the input data or the sum of the input data whose exceeding value is greater than the corresponding second threshold.

The present invention also provides a computing device, comprising a memory and a processor, wherein the memory stores a program, and the processor implements the above-mentioned data analysis and early warning method when the program is executed.

The present invention also provides a computer-readable storage medium on which a program is stored, and when the program is executed by a processor, the above-mentioned data analysis and early warning method is implemented.

The present invention can assist users to quickly discover data non-compliance problems and improve work efficiency.

Description of drawings

FIG. 1 is a flowchart of a data analysis and early warning method according to an embodiment of the present invention.

FIG. 2 is a structural diagram of a data analysis and early warning system according to an embodiment of the present invention.

FIG. 3 is an internal structural diagram of a computing device according to an embodiment of the present invention.

Detailed ways

In the budget management system, budget analysis is the key. This function mainly analyzes and processes the data according to the business application scenarios. At the same time, it can warn the excess of the budget application form in combination with the budget analysis rules. The embodiments of the present invention provide a data analysis and early warning method, which can provide budget analysis and early warning functions based on a budget management system when the method is applied to budget management.

Referring to FIG. 1, a data analysis and early warning method according to an embodiment of the present invention includes: 1) setting a data set and a first threshold and a second threshold of each data subset belonging to the data set; Whether the input data of the data subset exceeds the first threshold of its corresponding data subset, determine whether the sum of the input data exceeds the first threshold of the data set, determine whether the input data corresponding to each data subset exceeds its corresponding data whether the excess of the first threshold of the subset is greater than the second threshold of its corresponding data subset, and determining whether the sum of the input data exceeds the first threshold of the dataset by greater than the second threshold of the dataset ; and 3) output warning information for input data or the sum of input data whose exceeding magnitude is greater than the corresponding second threshold.

In an embodiment of the present invention, the first threshold may be a predetermined value, such as a natural number. The second threshold may be a predetermined percentage. In an embodiment of the present invention, the first threshold of the data set may be determined by the sum of the first thresholds of the respective data subsets. That is, the first threshold value of each data subset can be directly set, and the first threshold value of the data set can be obtained by calculating the sum of the first threshold value of each data subset without direct setting.

In an embodiment of the present invention, at least one of the first threshold and the second threshold is resettable. According to actual needs, the first threshold value and the second threshold value can be one of them, or both can be reset, so as to ensure continuous updating to meet the actual needs.

When applied to budget management, the data analysis and early warning method and system according to the embodiments of the present invention can quickly perform budget analysis on the budget application form and ensure the accuracy of the analysis results. It supports independent establishment of budget analysis rules. The rule analyzes the budget application form submitted by the user, displays the analysis results in the form of graphs, and at the same time warns the non-compliance analysis results and displays the detailed warning information, so as to assist the audit user to quickly find and locate the problem. When applied to budget management, the data analysis and early warning method and system of the embodiment of the present invention specifically includes the following steps:

Establishment of budget analysis rules;

budget analysis;

Excess warning.

In the establishment of budget analysis rules in step 1, the system can support manual setting of budget analysis rules, and users can set them according to their needs. For example, it can be set as follows: for the submitted budget application, the application amount of a single budget application item should not exceed 20% of the project amount set in the system, and the total budget requirement of the budget application should not exceed 15% of the total budget calculated by the system. %, of which 20% and 15% can be changed. Among them, the budget application form is the data set, each individual budget application item is the data subset, the project amount set in the system is the first threshold of each data subset, and the total budget calculated by the system is the first threshold of the data set. The application amount of a single budget application item does not exceed the percentage (20%) of the project amount that has been set in the system, which is the second threshold of each data subset, and the total budget of the budget application does not exceed the percentage of the total budget calculated by the system (15%). %) is the second threshold of the dataset.

In the budget analysis in step 2, the system can analyze the submitted budget application according to the budget rules set in step 1, and generate a corresponding chart for displaying the analysis results.

In the above steps, when analyzing the budget application, the system first analyzes the individual budget application items, and then analyzes the total budget of the budget application. For example, the existing budget application form 1 contains three budget application items A, B, and C. The number of applications is 1, the application amount is 150, 100, 235, and the total application amount is 485. These data are the input data for each data subset, and the sum of the input data.

According to the project budget amount that has been set in the system described in step 1, the individual budget amounts of application items A, B and C are 146,112,190 respectively, that is, the preset first thresholds of each data subset A, B and C are respectively 146,112,190.

In the above embodiment, the system first analyzes the individual budget application items included in the budget application form 1. The application amounts of A and C both exceed the budget amount set by the system, and the proportions of the excess parts are 2.74% and 23.68%, respectively. , the application amount for item B is lower than the budget amount set by the system. Then analyze the total budget of the budget application. After calculation by the system, the total budget of the budget application 1 should be 146+112+190=448, while the actual application total of the budget application is 485, exceeding 8.26%. It can be seen that the application amount of item C exceeds the budget amount set by the system by 23.68%, which is greater than the 20% set in the budget analysis rule described in step 1, that is, the excess amount of data subset C is greater than its corresponding second threshold value . The application amount of item A exceeds the budget amount set by the system by 2.74%, which is less than 20% set in the budget analysis rule described in step 1, that is, the excess amount value of data subset A is smaller than its corresponding second threshold. Data subset B does not exceed its corresponding first threshold value, there is no excess value, and thus the step of determining whether the excess value is greater than the second threshold value is not required. The actual total budget of the budget application exceeds 8.26% of the total calculated by the system, which is less than 15% of the total budget, that is, the excess value of the data set is less than its corresponding second threshold.

It should be noted that when analyzing the budget application form in the above step 2, it includes but is not limited to comparing the application quota with the quota set by the system, and it can also compare and analyze the historical project budget amount, and generate quota analysis. Statistical charts, etc.

In the excess warning in step 3, after the system analyzes the submitted budget application form in step 2, for the excess budget document, the system can issue an excess warning in the form of a pop-up box, and list the detailed excess information, including: excess application items Name, number of application items, application quota, quota set by the system, excess percentage, etc. Therefore, when the reviewer opens the budget application form 1 for review, the data non-compliance problem can be quickly found. Taking the budget application form 1 in step 2 as an example, the application amount of item C exceeds the budget amount set by the system by 23.68%, which is larger than the 20% set in the budget analysis rule in step 1, so it is necessary to output early warning information. The application amount for item B does not exceed the budget set by the system. The application amount of item A exceeds the budget amount set by the system by 2.74%, which is less than the 20% set in the budget analysis rule described in step 1. The actual total budget of the budget requisition exceeds the total calculated by the system by 8.26%, and is less than 15% of the total budget. Therefore, there is no need to output early warning information for items B, A, and the total budget.

The data analysis and early warning method and system of the embodiments of the present invention support independent establishment of budget analysis rules, the system application flexibility is high, and the established budget analysis rules can help users to quickly perform budget analysis, realizing the timeliness of budget analysis. It supports early warning of non-compliant analysis results, which can assist audit users to quickly find problems and improve work efficiency.

Referring to FIG. 2 , the data analysis early warning system according to the embodiment of the present invention includes: a threshold setting module for setting a first threshold and a second threshold of a data set and each data subset belonging to the data set; a data analysis module, For determining whether the input data corresponding to each data subset exceeds the first threshold value of its corresponding data subset, determining whether the sum of the input data exceeds the first threshold value of the data set, determining whether the input corresponding to each data subset Whether the excess value of the data exceeding the first threshold value of its corresponding data subset is greater than the second threshold value of its corresponding data subset, and determining whether the excess value of the sum of the input data exceeds the first threshold value of the data set is greater than a second threshold of the data set; and an early warning module, configured to output early warning information for input data or the sum of input data whose magnitude is greater than the corresponding second threshold.

The data analysis and early warning method according to the embodiment of the present invention may be implemented in a computing device. An exemplary internal structure diagram of a computing device may be shown in FIG. 3 , and the computing device may include a processor, a memory, an external interface, a display, and an input device connected through a system bus. Among them, the processor is used to provide computing and control capabilities. The memory includes non-volatile storage media, internal memory. The non-volatile storage medium stores an operating system, an application program, a database, and the like. The internal memory provides an environment for the operation of the operating system and programs in the non-volatile storage medium. The external interface includes, for example, a network interface for communicating with an external terminal through a network connection. The external interface may also include a USB interface and the like. The display of the computing device may be a liquid crystal display screen or an electronic ink display screen, and the input device may be a touch layer covered on the display screen, or may be, for example, a button, a trackball or a touchpad set on the casing of the computing device, or a An external keyboard, trackpad, or mouse, etc.

When the program stored in the non-volatile storage medium in the computing device is executed by the processor, the above-mentioned data analysis and early warning method can be implemented. In addition, the non-volatile storage medium can also exist in a separate physical form, such as a U disk, when it is connected to a processor, the program stored on the U disk is executed to implement the above data analysis and early warning method. The method of the present invention can also be implemented as an APP (application program) in the Apple or Android application market for users to download and run on their respective mobile terminals.

Those skilled in the art can understand that the structure shown in FIG. 3 is only a block diagram of a partial structure related to the solution of the present application, and does not constitute a limitation on the computing device to which the solution of the present application is applied. The specific computing device may be Include more or fewer components than shown in the figures, or combine certain components, or have a different arrangement of components.

As described above, those of ordinary skill in the art can understand that all or part of the process in the method of the above-mentioned embodiments can be implemented by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer. In the readable storage medium, when executed, the computer program may include the processes of the above-mentioned method embodiments. Wherein, any reference to memory, storage, database or other medium used in the various embodiments provided in this application may include non-volatile and/or volatile memory. Nonvolatile memory may include read only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory. Volatile memory may include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in various forms such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous chain Road (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.

The technical features of the above embodiments can be combined arbitrarily. In order to make the description simple, all possible combinations of the technical features in the above embodiments are not described. However, as long as there is no contradiction in the combination of these technical features It is considered to be the range described in this specification.

The computer described in the present invention is a computing device in a broad sense that can automatically perform numerical calculation and/or information processing according to pre-set or stored instructions, and its hardware may include at least one memory, at least one processor, and at least one communication bus. Wherein, the communication bus is used to realize the connection communication between these elements. A processor may include, but is not limited to, a microprocessor. The computer hardware may also include an Application Specific Integrated Circuit (ASIC), a Field-Programmable Gate Array (FPGA), a Digital Signal Processor (DSP), an embedded device, and the like. The computer may also include network equipment and/or user equipment. Wherein, the network device includes but is not limited to a single network server, a server group composed of multiple network servers, or a cloud composed of a large number of hosts or network servers based on cloud computing, wherein cloud computing is distributed computing A super virtual computer consisting of a group of loosely coupled sets of computers.

The computing device may be, but is not limited to, any terminal such as a personal computer, a server, etc., which can perform human-computer interaction with the user through a keyboard, a touchpad, or a voice-activated device. The computing device herein may also include a mobile terminal, which may be, but is not limited to, any electronic device that can perform human-computer interaction with the user through a keyboard, a touchpad, or a voice-activated device, for example, a tablet computer, a smart phone, Personal digital assistant (Personal Digital Assistant, PDA), smart wearable devices and other terminals. The network where the computing device is located includes, but is not limited to, the Internet, a wide area network, a metropolitan area network, a local area network, a virtual private network (Virtual Private Network, VPN), and the like.

The memory is used to store program codes. The memory may be a circuit with a storage function that does not have a physical form in an integrated circuit, such as RAM (Random-Access Memory, random access memory), FIFO (First InFirst Out), and the like. Alternatively, the memory may also be a memory in a physical form, such as a memory stick, a TF card (Trans-flash Card), a smart media card (smart media card), a secure digital card, a flash memory card ( flash card) and other storage devices, etc.

The processor may include one or more microprocessors, digital processors. The processor may invoke program code stored in the memory to perform the associated functions. For example, each module described in FIG. 3 is a program code stored in the memory and executed by the processor to implement the above method. The processor is also called a central processing unit (CPU, Central Processing Unit), which may be a large-scale integrated circuit, and is a computing core (Core) and a control core (Control Unit).

It should be noted that, for the sake of simple description, the foregoing method embodiments are all expressed as a series of action combinations, but those skilled in the art should know that the present invention is not limited by the described action sequence. As in accordance with the present invention, certain steps may be performed in other orders or simultaneously. Secondly, those skilled in the art should also know that the embodiments described in the specification are all preferred embodiments, and the actions and modules involved are not necessarily required by the present invention.

In the above-mentioned embodiments, the description of each embodiment has its own emphasis. For parts that are not described in detail in a certain embodiment, reference may be made to the relevant descriptions of other embodiments.

In the several embodiments provided in this application, it should be understood that the disclosed apparatus may be implemented in other manners. For example, the device embodiments described above are only illustrative, for example, the division of the units is only a logical function division, and there may be other division methods in actual implementation, for example, multiple units or elements may be combined or Integration into another system, or some features can be ignored, or not implemented. On the other hand, the shown or discussed mutual coupling or direct coupling or communication connection may be through some interfaces, indirect coupling or communication connection of devices or units, and may be in electrical or other forms.

The units described as separate components may or may not be physically separated, and components displayed as units may or may not be physical units, that is, may be located in one place, or may be distributed to multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution in this embodiment.

In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically alone, or two or more units may be integrated into one unit. The above-mentioned integrated units may be implemented in the form of hardware, or may be implemented in the form of software functional units.

The integrated unit, if implemented in the form of a software functional unit and sold or used as an independent product, may be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium , including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present invention. The aforementioned storage medium includes: U disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, magnetic disk or optical disk and other media that can store program codes .

The above embodiments are only used to illustrate the technical solutions of the present invention, but not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that: The recorded technical solutions are modified, or some technical features thereof are equivalently replaced; and these modifications or replacements do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.

The above-mentioned embodiments only represent several embodiments of the present application, and the descriptions thereof are relatively specific and detailed, but should not be construed as a limitation on the scope of the patent application. It should be noted that, for those skilled in the art, without departing from the concept of the present application, several modifications and improvements can be made, which all belong to the protection scope of the present application. Therefore, the scope of protection of the patent of the present application shall be subject to the appended claims.

Claims (10)

1. a data analysis early warning method, is characterized in that, comprises: setting a first threshold and a second threshold for a data set and each data subset belonging to the data set; determine whether the input data corresponding to each data subset exceeds the first threshold of its corresponding data subset, determine whether the sum of the input data exceeds the first threshold of the data set, determine whether the input data corresponding to each data subset exceeds the Whether the excess value of the first threshold value of its corresponding data subset is greater than the second threshold value of its corresponding data subset, and determining whether the excess value of the sum of the input data exceeds the first threshold value of the data set is greater than the data set the second threshold of ; and For the input data or the sum of the input data whose exceeding magnitude is greater than the corresponding second threshold, an early warning message is output. 2 . The data analysis and early warning method according to claim 1 , wherein the first threshold is a predetermined value, and the second threshold is a predetermined percentage. 3 . 3 . The data analysis and early warning method according to claim 2 , wherein the first threshold of the data set is determined by the sum of the first thresholds of each data subset. 4 . 4 . The data analysis and early warning method according to claim 1 , wherein at least one of the first threshold and the second threshold is resettable. 5 . 5 . The data analysis and early warning method according to claim 1 , wherein the outputting early warning information comprises displaying it on a screen of an electronic device in the form of a pop-up frame. 6 . 6 . The data analysis and early warning method according to claim 1 , wherein the data analysis result is displayed on the screen of the electronic device in the form of an analysis chart. 7 . 7 . The data analysis and early warning method according to claim 1 , wherein the data set is a budget application form, and the data subset is each individual budget application item in the budget application form. 8 . 8. A data analysis early warning system, comprising: a threshold setting module for setting a first threshold and a second threshold of a data set and each data subset belonging to the data set; The data analysis module is used to determine whether the input data corresponding to each data subset exceeds the first threshold value of its corresponding data subset, determine whether the sum of the input data exceeds the first threshold value of the data set, and determine whether the input data corresponding to each data subset exceeds the first threshold value of the data set. Whether the input data of the subset exceeds the first threshold of its corresponding data subset by a magnitude greater than the second threshold of its corresponding data subset, and determine the excess of the sum of the input data exceeding the first threshold of the data set whether the magnitude is greater than a second threshold for the dataset; and The early warning module is used for outputting early warning information for the input data or the sum of the input data whose exceeding value is greater than the corresponding second threshold. 9. A computing device, comprising a memory and a processor, wherein the memory stores a program, wherein the processor implements the method of any one of claims 1-7 when the processor executes the program. 10. A computer-readable storage medium on which a program is stored, characterized in that, when the program is executed by a processor, the method of any one of claims 1-7 is implemented.

Images