Business data analysis method, device, computer equipment and storage medium

Abstract

The embodiment of the present application belongs to the field of big data, and discloses a business data analysis method, device, computer equipment and storage medium. The method includes obtaining the data to be analyzed and parsing it to obtain at least one field for business data analysis; converting the field into field information in an SQL statement, using the indicator field in the field information as the parent indicator, and matching the corresponding indicator hierarchy relationship table and indicator algorithm relationship table; obtaining the child indicators from the lower layer based on the indicator hierarchy relationship table until the bottom-level endpoint indicator is obtained; when performing data analysis, obtaining the data value of each endpoint indicator from the database, and calculating the data value of the upper-level indicator layer by layer according to the indicator algorithm relationship table until the data value of the indicator field is obtained to complete the business data analysis. The present application can automatically configure the indicators and perform process-based calculations, thereby improving the efficiency of business data analysis for the indicators.

Description

Technical Field

[0001] The present application relates to the field of big data technology, and in particular to a business data analysis method, apparatus, computer equipment, and storage medium. Background Art

[0002] Statistical indicators are concepts and numerical values ​​that reflect the overall performance characteristics of business data. Hundreds of indicators, such as the proportion of interest-earning assets and net assets per share, make up a company's financial indicator system, reflecting various aspects of the company's assets, debt ratio, profitability, and so on. Therefore, how to view and analyze each indicator has become one of the key points of corporate business data analysis.

[0003] Currently, in the business of major enterprises, various indicators usually exist in the form of offline manual tables. Enterprise departments have to spend a lot of manpower to collect them every month, which easily leads to management chaos and inconsistent data collection methods. It is also difficult to conduct further analysis on Excel tables.

[0004] Existing online BI tools (Business Intelligence, Business Intelligence analysis tools), such as Haizhi BDP and Tableau, mostly use indicators as fields. Users need to manually configure the drill-down path, otherwise they will not be able to perform operations such as drill-down or roll-up. Due to the large number of indicators in the company's financial system, individual configuration will result in a huge amount of operations and a long configuration time, resulting in low business data analysis efficiency. Summary of the Invention

[0005] The purpose of the embodiments of the present application is to provide a business data analysis method, apparatus, computer equipment and storage medium that improve the efficiency of business data analysis.

[0006] In order to solve the above technical problems, the present application provides a business data analysis method, which adopts the following technical solutions:

[0007] A business data analysis method includes the following steps:

[0008] Obtaining data to be analyzed input by a user, and parsing the data to be analyzed to obtain at least one field for business data analysis;

[0009] Convert the field into field information in an SQL statement, wherein the field information includes at least one indicator field, and use the indicator field as a parent indicator, and match a pre-created indicator hierarchy relationship table and an indicator algorithm relationship table according to the parent indicator;

[0010] Acquire all child indicators corresponding to the parent indicator based on the indicator hierarchical relationship table;

[0011] The obtained child indicator is used as a new parent indicator, and the process of obtaining child indicators based on the indicator hierarchical relationship table is repeated until no new child indicators can be obtained, and all indicators that cannot obtain child indicators are used as end indicators;

[0012] Based on the SQL statement, the database is accessed, the data value of each endpoint indicator is obtained from the database, and the data value of the upper-level indicator is calculated layer by layer according to the data value of each endpoint indicator and the indicator algorithm relationship table, until the data value of the indicator field is obtained, thereby completing the business data analysis.

[0013] In order to solve the above technical problems, the embodiment of the present application further provides a business data analysis device, which adopts the following technical solution:

[0014] A business data analysis device, comprising:

[0015] A field acquisition module is used to obtain the data to be analyzed input by the user, and parse the data to be analyzed to obtain at least one field for business data analysis;

[0016] A parent indicator obtaining module is used to convert the field into field information in an SQL statement, wherein the field information includes at least one indicator field, and use the indicator field as a parent indicator, and match the pre-created indicator hierarchy relationship table and indicator algorithm relationship table according to the parent indicator;

[0017] A sub-level indicator obtaining module is used to obtain all sub-level indicators corresponding to the parent-level indicator based on the indicator hierarchical relationship table;

[0018] An endpoint indicator obtaining module is used to use the obtained child indicators as new parent indicators, repeat the process of obtaining child indicators based on the indicator hierarchical relationship table, until no new child indicators can be obtained, and use all indicators that cannot obtain child indicators as endpoint indicators;

[0019] The data analysis module is used to access the database based on the SQL statement, obtain the data value of each endpoint indicator from the database, and calculate the data value of the upper-level indicator layer by layer according to the data value of each endpoint indicator and the indicator algorithm relationship table until the data value of the indicator field is obtained to complete the business data analysis.

[0020] In order to solve the above technical problems, an embodiment of the present application also provides a computer device, including a memory and a processor, wherein a computer program is stored in the memory, and when the processor executes the computer program, the steps of the business data analysis method described above are implemented.

[0021] In order to solve the above technical problems, an embodiment of the present application further provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of the business data analysis method described above are implemented.

[0022] The above-mentioned business data analysis method, device, computer equipment and storage medium obtain fields for business data analysis by acquiring and parsing the data to be analyzed input by the user, and extracting the indicator field to obtain the parent indicator, thereby realizing automatic extraction of the parent indicator from the data to be analyzed; according to the parent indicator, the pre-created indicator hierarchy relationship table and indicator algorithm relationship table are matched to obtain all child indicators corresponding to the parent indicator; then the obtained child indicator is used as the new parent indicator to obtain the child indicator, until no new child indicator can be obtained, and multiple end point indicators are obtained, thereby realizing automatic configuration of the indicator and improving configuration efficiency; when performing data analysis, the data value of each end point indicator is obtained from the database, and then the data value of the indicator of the upper level is calculated layer by layer in combination with the indicator algorithm relationship table. When the data value of the indicator field is obtained, the business data analysis can be completed, and the efficiency of business data analysis is improved through process-based calculation. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] In order to more clearly illustrate the solutions in this application, a brief introduction will be given below to the drawings required for use in the description of the embodiments of this application. Obviously, the drawings described below are some embodiments of this application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without any creative work.

[0024] Figure 1 is an exemplary system architecture diagram to which the present application may be applied;

[0025] Figure 2 A flowchart according to an embodiment of a business data analysis method of the present application;

[0026] Figure 3 yes Figure 2 A flowchart of a specific implementation method before step S202;

[0027] Figure 4 is a schematic diagram of an indicator hierarchical relationship table in an embodiment;

[0028] Figure 5 yes Figure 2 A flowchart of a specific implementation of step S202;

[0029] Figure 6 yes Figure 2 A flowchart of a specific implementation method after step S205;

[0030] Figure 7 is a schematic diagram of data analysis according to this application;

[0031] Figure 8 is a structural diagram of an embodiment of a business data analysis device according to the present application;

[0032] Figure 9 It is a structural diagram of an embodiment of a computer device according to the present application.

[0033] Reference numerals: 401 field obtaining module; 402 parent index obtaining module; 403 child index obtaining module; 404 endpoint index obtaining module; 405 data analysis module. DETAILED DESCRIPTION

[0034] Unless otherwise defined, all technical and scientific terms used herein have the same meanings as commonly understood by those skilled in the art to which this application belongs. The terms used in the specification of the application are for the purpose of describing specific embodiments only and are not intended to limit this application. The terms "including" and "having" and any variations thereof in the specification and claims of this application and the above-mentioned drawings are intended to cover non-exclusive inclusions. The terms "first", "second", etc. in the specification and claims of this application or the above-mentioned drawings are used to distinguish different objects, not to describe a specific order.

[0035] References herein to "embodiments" mean that a particular feature, structure, or characteristic described in connection with the embodiments may be included in at least one embodiment of the present application. The appearance of this phrase in various places in the specification does not necessarily refer to the same embodiment, nor does it constitute an independent or alternative embodiment that is mutually exclusive of other embodiments. It is understood, both explicitly and implicitly, by those skilled in the art that the embodiments described herein may be combined with other embodiments.

[0036] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the accompanying drawings.

[0037] like Figure 1 As shown, system architecture 100 may include terminal devices 101, 102, 103, a network 104, and a server 105. Network 104 is a medium for providing communication links between terminal devices 101, 102, 103 and server 105. Network 104 may include various connection types, such as wired or wireless communication links or fiber optic cables.

[0038] Users can use terminal devices 101, 102, and 103 to interact with server 105 via network 104 to receive or send messages, etc. Various communication client applications can be installed on terminal devices 101, 102, and 103, such as web browser applications, shopping applications, search applications, instant messaging tools, email clients, social platform software, etc.

[0039] Terminal devices 101, 102, and 103 can be various electronic devices with display screens and support web browsing, including but not limited to smartphones, tablet computers, e-book readers, MP3 players (Moving Picture Experts Group Audio Layer III), MP4 (Moving Picture Experts Group Audio Layer IV), laptop computers, desktop computers, etc.

[0040] The server 105 may be a server that provides various services, such as a background server that provides support for web pages displayed on the terminal devices 101 , 102 , and 103 .

[0041] It should be noted that the business data analysis method provided in the embodiment of the present application is generally executed by a server, and accordingly, the business data analysis device is generally set in the server.

[0042] It should be understood that Figure 1 The number of terminal devices, networks and servers in the embodiment is merely illustrative. Any number of terminal devices, networks and servers may be provided as required.

[0043] Continue to refer Figure 2 , shows a flow chart of an embodiment of a business data analysis method according to the present application. The business data analysis method comprises the following steps:

[0044] Step S201: obtaining the data to be analyzed input by the user, and parsing the data to be analyzed to obtain at least one field for business data analysis.

[0045] The data to be analyzed may be text data input by a user through a terminal device.

[0046] Specifically, a user inputs data to be analyzed on a terminal device. The server receives the data to be analyzed from the terminal device via network 104. The server can parse the data to be analyzed by methods such as word segmentation, part-of-speech tagging, and named entity recognition to obtain at least one field for business data analysis.

[0047] In one embodiment, the server can process the text data based on StanfordNLP and split the nouns, adjectives and verbs in the text data. StanfordNLP is a natural language processing (NLP) toolkit released by the StanfordNLP team that contains pre-trained models for multiple languages. The toolkit supports a complete text analysis pipeline for multiple languages, including word segmentation, part-of-speech tagging, word form merging and dependency parsing. The server performs part-of-speech tagging on adjectives and verbs, and then identifies the structure of sentences in the text data; wherein the sentence structure can be at least one of a subject-verb-object structure, a verb-object structure and a subject-verb structure. The server performs named entity recognition on nouns to determine whether the nouns are specific identifiers such as some time, place names or names.

[0048] In one embodiment, the server can use the BERT model to split and annotate sentence entities in the data to be analyzed, thereby identifying the fields of the data to be analyzed. The BERT model (Bidirectional Encoder Representation from Transformers) is a natural language processing model released by Google that has high accuracy in NLP applications.

[0049] In one embodiment, the steps of parsing the data to be analyzed and obtaining at least one field for business data analysis specifically include: segmenting the data to be analyzed to obtain multiple fields; semantically annotating the multiple fields according to a semantic knowledge base to generate semantic annotation results; determining the dependency relationship of the multiple fields based on the semantic annotation results; and determining at least one field among the multiple fields for business data analysis based on the dependency relationship.

[0050] Specifically, the server performs word segmentation on the data to be analyzed, obtaining multiple fields. The server then searches the semantic knowledge base for the fields obtained through word segmentation and performs semantic annotation to obtain semantic annotation results. The semantic annotation results may include the meaning and part of speech of the fields, and can determine the dependencies between the fields, thereby determining at least one field from the multiple fields for business data analysis.

[0051] Among them, the semantic knowledge base can be a lexical set generated based on habitual expressions in natural language; the semantic knowledge base can help the computer quickly locate the content corresponding to the information input by the user.

[0052] For example, if the data to be analyzed is "I want to query yesterday's data," the server can use the Stanford NLP tool to break it down into "I," "want," "query," "yesterday's," and "data." According to the semantic knowledge base, "I" and "data" are nouns, "want" and "query" are verbs, and "yesterday's" is an adjective. "Query" is followed by the purpose of the query, and "query" and "data" are interdependent. Fields following "query" include, but are not limited to, "data," "page," "score," and "price." These words represent both specific content and the desired results. Based on the semantics of the fields, the server identifies three fields for business data analysis: "query," "yesterday's," and "data."

[0053] In this embodiment, by performing word segmentation and semantic annotation on the data to be analyzed, the purpose of the business data analysis can be determined, thereby ensuring the normal progress of the business data analysis.

[0054] In one embodiment, multiple fields are divided into indicator fields and range fields based on semantic annotation results; the indicator field is the target of business data analysis, and the range field is used to instruct the server to obtain data values ​​from the database for business data analysis.

[0055] The step of obtaining the data value of each endpoint indicator from the database includes: reading the data value of each endpoint indicator that meets the range field from the database according to the range field.

[0056] Specifically, semantic annotation results include the semantics of the fields. The server can use this semantics to determine the purpose of the user's input data for analysis and categorize the fields into indicator fields and scope fields based on the semantics. Indicator fields are fields identified through semantic analysis as requiring business data analysis. Scope fields define the scope in terms of time, region, or organization. When conducting specific business data analysis, the indicator field acts as a parent indicator and can drill down to at least one endpoint indicator. The server then reads the data values ​​of each endpoint indicator that satisfies the scope field from the database based on the scope field and performs analysis and calculations.

[0057] For example, if the data to be analyzed is "Bank's savings business flow information for the first half of 2019," four fields can be generated: "2019," "First Half of the Year," "Savings Business," and "Flow Information." "2019" and "First Half of the Year" are range fields. When the server performs business data analysis, it only needs to obtain data values ​​for the first half of 2019 based on the range fields, without having to obtain data values ​​for other times. "Savings Business" and "Flow Information" are indicator fields, which are the targets of business data analysis. In this embodiment, the indicator field is divided into an indicator field and a range field, so that business data analysis can be performed on the indicator field based on the range field, thereby improving the accuracy of business data analysis.

[0058] Step S202: convert the field into field information in the SQL statement. The field information includes at least one indicator field. The indicator field is used as the parent indicator. The pre-created indicator hierarchy relationship table and indicator algorithm relationship table are matched according to the parent indicator.

[0059] SQL (Structured Query Language) is a database query and programming language used to access data and query, update, and manage relational database systems. The indicator hierarchy relationship table can be derived from the indicator algorithm relationship table, recording the relationships between different indicators. The indicator algorithm relationship table can also be a table that records the computational relationships between indicators.

[0060] Specifically, the server converts the parsed field information into SQL statement code according to the syntax of the SQL statement, that is, the field information in the SQL statement, which includes at least one indicator field. The server uses the indicator field as the parent indicator.

[0061] The database stores the created indicator hierarchy relationship table and indicator algorithm relationship table, and the server queries the indicator hierarchy relationship table and indicator algorithm relationship table that match the parent indicator.

[0062] For example, let's say the data to be analyzed is "Bank savings transaction flow information for the first half of 2019." After parsing it, the server obtains the fields "2019," "First Half of the Year," "Savings Business," and "Transaction Information." Through semantic analysis, the server determines that the intent of the data to be analyzed is to query the bank's savings transaction flow from January 1, 2019, to June 30, 2019, where transaction (B) = deposits minus withdrawals.

[0063] The server converts the data to be processed into SQL statements, uses the time period as the query condition, and flow B as the query result value to obtain the field information:

[0064] select B from tb_a where time between 20190101 and 20190630.

[0065] Among them, B represents transaction flow, tb_a represents savings business record data, time represents time, and 20190101 and 20190630 represent two time nodes.

[0066] Step S203: Acquire all child indicators corresponding to the parent indicator based on the indicator hierarchical relationship table.

[0067] Specifically, the indicator hierarchy table records the relationships between different indicators. The server queries the indicator hierarchy table for a parent indicator and extracts all child indicators corresponding to the queried parent indicator. The parent indicator is obtained by calculating the child indicators.

[0068] For example, the data to be analyzed is "the bank's savings business flow information in the first half of 2019". The server uses "savings business" and "flow information" as the first parent indicators. According to the indicator hierarchical relationship table, the flow information (B) in the bank's savings business = deposit-withdrawal. The flow information B is used as the parent indicator, and its child indicators are deposit amount and withdrawal amount.

[0069] Step S204: Use the obtained child indicator as a new parent indicator, and repeat the process of obtaining child indicators based on the indicator hierarchy relationship table until no new child indicators can be obtained, and use all indicators that cannot obtain child indicators as end indicators.

[0070] Specifically, for each child indicator obtained, the server uses the child indicator as the new parent indicator, obtains the child indicators of the new parent indicator based on the indicator hierarchy relationship table, and repeats the above operation until no new child indicators can be obtained. The server will no longer be able to obtain the indicators of the child indicators as the end indicators.

[0071] For example, if the remaining quantity of a certain item = deposited quantity - shipped quantity + original quantity, then the remaining quantity is the parent indicator, and the deposited quantity, shipped quantity, and original quantity are child indicators. Alternatively, if deposited quantity = X-indicator deposited quantity + Y-indicator deposited quantity, then the child indicator deposited quantity (X-indicator deposited quantity and Y-indicator deposited quantity) is used as the parent indicator, and new child indicators (X-indicator deposited quantity and Y-indicator deposited quantity) are obtained. These new child indicators (X-indicator deposited quantity and Y-indicator deposited quantity) can no longer be used as parents to obtain the next level of indicators. The obtained child indicators (X-indicator deposited quantity and Y-indicator deposited quantity) are the end indicators.

[0072] Step S205, access the database based on the SQL statement, obtain the data value of each endpoint indicator from the database, and calculate the data value of the upper level indicator layer by layer according to the data value of each endpoint indicator and the indicator algorithm relationship table, until the data value of the indicator field is obtained, completing the business data analysis.

[0073] Specifically, the server retrieves the data values ​​of each endpoint indicator from the database, uses the endpoint indicator as the starting point, and the parent indicator in the indicator field as the endpoint. Based on the indicator algorithm relationship, the server calculates the upper-level indicators one level at a time until the data value of the parent indicator in the indicator field is obtained, completing the business data analysis. When the server needs to access the database during the calculation process, it can do so based on SQL statements.

[0074] In one embodiment, the server sends the data value of the parent indicator to a designated terminal for display.

[0075] In this embodiment, by acquiring and parsing the data to be analyzed input by the user, fields for business data analysis are obtained, and the indicator fields are extracted to obtain the parent indicators, thereby realizing automatic extraction of the parent indicators from the data to be analyzed; matching the pre-created indicator hierarchy relationship table and indicator algorithm relationship table according to the parent indicators, all child indicators corresponding to the parent indicators are obtained; then the obtained child indicators are used as new parent indicators to obtain child indicators, until no new child indicators can be obtained, and multiple end-point indicators are obtained, thereby realizing automatic configuration of indicators and improving configuration efficiency; when performing data analysis, the data values ​​of each end-point indicator are obtained from the database, and then the data values ​​of the indicators of the upper level are calculated layer by layer in combination with the indicator algorithm relationship table. When the data values ​​of the indicator fields are obtained, the business data analysis can be completed, and the efficiency of business data analysis is improved through process-based calculations.

[0076] See Figure 3 In some optional implementations of this embodiment, after step 201 and before step 202, the server may further perform the following steps:

[0077] Step S301, obtaining an indicator identifier.

[0078] The indicator identifier may be an identifier of the indicator, such as the name of the indicator.

[0079] Specifically, the server may obtain the indicator identifier from a database or a terminal device, and the indicator identifier may include identifiers of various indicators.

[0080] Step S302: Receive an algorithmic relationship for the indicator identifier.

[0081] The algorithmic relationship can be a calculation method between indicator identifiers, and the algorithmic relationship can be presented in the form of a formula. Users can customize the algorithmic relationship between indicator identifiers on the visual configuration page and send the algorithmic relationship to the server. The server receives the algorithmic relationship for the indicator identifier.

[0082] Step S303: Create an indicator algorithm relationship table based on the algorithm relationship.

[0083] Specifically, the server creates an indicator algorithm relationship table for storing all received algorithm relationships.

[0084] Step S304: Create an indicator hierarchical relationship table based on the indicator algorithm relationship table.

[0085] Specifically, the server may determine the hierarchical relationship between indicators corresponding to the indicator identifiers according to the indicator algorithm relationship table, and create an indicator hierarchical relationship table for storing the determined hierarchical relationship between indicators.

[0086] In one embodiment, creating an indicator hierarchical relationship table based on an indicator algorithm relationship table includes: obtaining algorithm relationship information in the indicator algorithm relationship table; identifying the first indicator and the second indicator in the obtained algorithm relationship information; the first indicator is obtained by calculation from the second indicator; determining the parent-child relationship information of the first indicator and the second indicator; in the parent-child relationship information, the first indicator is the parent indicator of the second indicator, and the second indicator is the child indicator of the first indicator; and obtaining the indicator hierarchical relationship table based on the determined parent-child relationship information.

[0087] Specifically, the indicator algorithm relationship table can be composed of individual algorithm relationship information, which records the computational relationship between indicators. The server identifies the first indicator and the second indicator in the algorithm relationship information, where the first indicator is an indicator obtained by computing other indicators, and the second indicator is an indicator participating in the computation, that is, the first indicator is obtained by computing the second indicator. In one piece of algorithm relationship information, there can be more than one first indicator and second indicator.

[0088] The server determines the parent-child relationship information between the first indicator and the second indicator, wherein the first indicator is the parent indicator of the second indicator and the second indicator is the child indicator of the first indicator. The server can obtain the indicator hierarchical relationship table based on all the parent-child relationship information.

[0089] In this embodiment, the parent-child relationship information between indicators is determined based on the algorithm relationship table, and the indicator hierarchical relationship table is obtained based on the parent-child relationship information, thereby ensuring the accuracy of the generated indicator hierarchical relationship table.

[0090] In one embodiment, when a new indicator algorithm relationship is added, deleted, or updated, the indicator hierarchical relationship table needs to be updated accordingly. When a specific algorithm relationship is deleted, the hierarchical relationship under that algorithm relationship no longer exists, and the indicators associated with that algorithm relationship in the hierarchical relationship table are deleted. When a new specific algorithm relationship is added, a new hierarchical relationship is generated for that algorithm relationship, and the indicators associated with that algorithm relationship are written to the hierarchical relationship table based on the hierarchical relationship.

[0091] For example, there are three indicators: shipment volume, inventory volume and remaining volume. Then the user defines formula (1):

[0092] Remaining quantity = deposited quantity - shipped quantity + original quantity

[0093] Then formula (1) is an indicator algorithm relationship, and the server stores formula (1) in the indicator algorithm relationship table. It can be seen that the indicator algorithm relationship table represents a series of indicator algorithm relationship sets. Table 1 can be an indicator algorithm relationship table in an embodiment:

[0094]

[0095] According to the indicator algorithm relationship table 1, the indicator hierarchical relationship table is created as follows Figure 4 As shown in the figure. An example of creating or updating an indicator hierarchy based on the indicator algorithm relationship table is as follows: As can be seen from formula (1), the remaining quantity is calculated from the deposited quantity, shipped quantity, and original quantity. Therefore, the remaining quantity is the upper-level indicator in the indicator hierarchy relationship table, and the deposited quantity, shipped quantity, and original quantity are the lower-level indicators of the remaining quantity in the indicator hierarchy relationship table.

[0096] If the algorithm relationship (1) is deleted, the formula (1) corresponding to the indicator algorithm relationship is meaningless, and there is no relationship between the upper-level indicator and the lower-level indicator between the remaining quantity, the deposited quantity and the original quantity of shipments; if the hierarchical relationship already exists in the hierarchical relationship table, the indicator contained in formula (1) will be deleted.

[0097] If the indicator in the algorithm relationship (1) is updated to: turnover = deposit - shipment, then a new indicator is added to the upper-level indicators of deposit and shipment, and the indicator "turnover" is written into the indicator hierarchy relationship table, and the level is above the deposit and shipment.

[0098] At the same time, the algorithm relationship is: Remaining Amount = Turnover Amount + Original Amount. Therefore, a new hierarchical relationship should be created: Remaining Amount is Level 1, Turnover Amount and Original Amount are Level 2, and Incoming Amount and Outgoing Amount are Level 3.

[0099] The hierarchical relationship table represents the hierarchical relationship between various indicators, but the hierarchy of each indicator is not fixed. The hierarchy is continuously created or updated based on the update of the indicator algorithm relationship.

[0100] In this embodiment, an indicator algorithm relationship table is created according to the algorithmic relationship between indicators, and then an indicator hierarchical relationship table is created according to the indicator algorithm relationship table, thereby ensuring the speed and accuracy of creating the indicator hierarchical relationship table.

[0101] See Figure 5 In some optional implementations of this embodiment, step S202: matching the pre-created indicator hierarchy relationship table and indicator algorithm relationship table according to the parent indicator includes:

[0102] Step S2021: Match the first algorithm corresponding to the parent indicator from the indicator algorithm relationship table.

[0103] Specifically, after determining the parent indicator, the server reads the indicator algorithm relationship table, queries the parent indicator from the indicator algorithm relationship table, and extracts the first algorithm related to the parent indicator.

[0104] In one embodiment, the server matches the first algorithm corresponding to the parent indicator from the indicator algorithm relationship table based on text matching.

[0105] Step S2022: According to the first algorithm, match the indicator hierarchical relationship table corresponding to the parent indicator.

[0106] Specifically, the server obtains the child indicators of the parent indicator according to the first algorithm, thereby obtaining an indicator hierarchical relationship table corresponding to the parent indicator.

[0107] In this embodiment, the first algorithm corresponding to the parent indicator is matched from the indicator algorithm relationship table, and then the indicator hierarchical relationship table corresponding to the parent indicator is matched, thereby ensuring the matching speed.

[0108] See Figure 6 In some optional implementations of this embodiment, after the step of calculating the data value of the indicator of the previous level layer by layer according to the data value of each endpoint indicator and the indicator algorithm relationship table in step 205, the following steps are further included:

[0109] Step S206: After each calculation is performed according to the indicator algorithm relationship table, it is determined whether the data value corresponding to the current indicator obtained by calculation is within a preset indicator value range.

[0110] Specifically, each indicator has a preset indicator value interval, which records the range of data values ​​corresponding to the indicator. After the server completes the calculation of an indicator according to the indicator algorithm relationship table, it compares the calculated data value corresponding to the current indicator with the indicator value interval to determine whether the calculated data value falls within the indicator value interval.

[0111] In one embodiment, the indicator value interval is set by the user according to the expected value of the indicator.

[0112] Step S207: If not, mark the current indicator as an abnormal indicator and display the current indicator after the data analysis is completed.

[0113] Specifically, if the calculated data value corresponding to the current indicator is outside the indicator value range, the server marks the current indicator as an abnormal indicator. After completing the business data analysis, the server counts all indicators marked as abnormal, generates an abnormal indicator table based on the indicator value and indicator value range of the abnormal indicators, and sends the abnormal indicator table to the designated terminal device for display, allowing users to perform data analysis, drill-down analysis, etc. If the calculated data value corresponding to the current indicator is within the indicator value range, it indicates that the current indicator is within the preset expected range and is normal, and no special labeling or feedback is required.

[0114] Based on the parent indicator, the child indicators of each indicator are continuously obtained, and all indicators can be stored in the form of an indicator tree. When the server calculates the parent indicator in the indicator field from the end indicator, it counts all the indicators involved in the calculation and displays the indicator tree in a visual manner on the terminal device, highlighting the indicators involved in the calculation to show the path of data analysis.

[0115] Figure 7 A schematic diagram of displaying data analysis through a terminal device in one embodiment, specifically, referring to Figure 7 July's ROE (Return on Equity) is the final calculated indicator. ROE is the parent indicator of ROA (Return on Assets) and Assets / Equity. ROA is also the parent indicator of Net Interest Income / Assets, Non-Interest Income Ratio, and Cost-to-Income Ratio. The server calculates July's ROA based on the non-interest income ratio and the cost-to-income ratio, and then calculates July's ROE based on the ROA. Indicators involved in this calculation are displayed in darker colors. In actual applications, abnormal indicators can be displayed in different colors.

[0116] In this embodiment, the server determines whether the calculated data value of the current indicator meets expectations. If not, the current indicator is marked as an abnormal indicator and displayed for further analysis, thereby improving the accuracy of data analysis.

[0117] Those skilled in the art will appreciate that all or part of the processes in the above-described method embodiments can be implemented by instructing the relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium. When executed, the program can include the processes in the above-described method embodiments. The aforementioned storage medium can be a non-volatile storage medium such as a magnetic disk, an optical disk, a read-only memory (ROM), or a random access memory (RAM).

[0118] It should be understood that although the steps in the flowcharts of the accompanying drawings are shown in sequence as indicated by the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless otherwise specified herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some of the steps in the flowcharts of the accompanying drawings may include multiple sub-steps or multiple stages, and these sub-steps or stages are not necessarily executed at the same time, but can be executed at different times, and their execution order is not necessarily sequential, but can be executed in turn or alternately with other steps or at least a portion of the sub-steps or stages of other steps.

[0119] Further references Figure 8 , as a response to the above Figure 2 The present application provides an embodiment of a business data analysis device, which is similar to the embodiment of the present invention. Figure 2 Corresponding to the method embodiment shown, the device can be specifically applied to various electronic devices.

[0120] like Figure 7 As shown, the business data analysis device 400 of this embodiment includes: a field obtaining module 401, a parent index obtaining module 402, a child index obtaining module 403, an end index obtaining module 404 and a data analysis module 405. Among them:

[0121] The field obtaining module 401 is used to obtain the data to be analyzed input by the user, and parse the data to be analyzed to obtain at least one field for business data analysis.

[0122] The parent indicator obtaining module 402 is used to convert the field into field information in the SQL statement. The field information includes at least one indicator field. The indicator field is used as the parent indicator, and the pre-created indicator hierarchy relationship table and indicator algorithm relationship table are matched according to the parent indicator.

[0123] The sub-level indicator obtaining module 403 is used to obtain all sub-level indicators corresponding to the parent-level indicator based on the indicator hierarchical relationship table.

[0124] The end indicator obtaining module 404 is used to use the obtained child indicators as new parent indicators, repeat the process of obtaining child indicators based on the indicator hierarchy relationship table, until no new child indicators can be obtained, and use all indicators that cannot obtain child indicators as end indicators.

[0125] The data analysis module 405 is used to access the database based on SQL statements, obtain the data value of each endpoint indicator from the database, and calculate the data value of the upper-level indicator layer by layer according to the data value of each endpoint indicator and the indicator algorithm relationship table until the data value of the indicator field is obtained to complete the business data analysis.

[0126] In this embodiment, by acquiring and parsing the data to be analyzed input by the user, fields for business data analysis are obtained, and the indicator fields are extracted to obtain the parent indicators, thereby realizing automatic extraction of the parent indicators from the data to be analyzed; matching the pre-created indicator hierarchy relationship table and indicator algorithm relationship table according to the parent indicators, all child indicators corresponding to the parent indicators are obtained; then the obtained child indicators are used as new parent indicators to obtain child indicators, until no new child indicators can be obtained, and multiple end-point indicators are obtained, thereby realizing automatic configuration of indicators and improving configuration efficiency; when performing data analysis, the data values ​​of each end-point indicator are obtained from the database, and then the data values ​​of the indicators of the upper level are calculated layer by layer in combination with the indicator algorithm relationship table. When the data values ​​of the indicator fields are obtained, the business data analysis can be completed, and the efficiency of business data analysis is improved through process-based calculations.

[0127] In some optional implementations of this embodiment, the above-mentioned field acquisition module 401 is further used to segment the data to be analyzed to obtain multiple fields; semantically annotate the multiple fields according to the semantic knowledge base to generate semantic annotation results; determine the dependency relationship of the multiple fields based on the semantic annotation results; and determine at least one field among the multiple fields for business data analysis based on the dependency relationship.

[0128] In this embodiment, by performing word segmentation and semantic annotation on the data to be analyzed, the purpose of the business data analysis can be determined, thereby ensuring the normal progress of the business data analysis.

[0129] In some optional implementations of this embodiment, the field acquisition module 401 is further configured to divide the multiple fields into indicator fields and range fields based on the semantic annotation results; the indicator fields are the targets of business data analysis, and the range fields are used to instruct the server to obtain data values ​​from the database for business data analysis. The step of obtaining the data values ​​of each endpoint indicator from the database includes: reading the data values ​​of each endpoint indicator that meet the range field from the database based on the range field.

[0130] In this embodiment, the indicator field is divided into an indicator field and a range field, so that business data analysis is performed on the indicator field based on the range field, thereby improving the accuracy of the business data analysis.

[0131] In some optional implementations of this embodiment, the business data analysis device 400 further includes: an identification acquisition module, an algorithm receiving module, an algorithm relationship creation module, and a hierarchical relationship creation module, wherein:

[0132] The identification acquisition module is used to obtain the indicator identification.

[0133] The algorithm receiving module is used to receive the algorithm relationship for the indicator identification.

[0134] The algorithm relationship creation module is used to create an indicator algorithm relationship table based on the algorithm relationship.

[0135] The hierarchical relationship creation module is used to create an indicator hierarchical relationship table based on the indicator algorithm relationship table.

[0136] In this embodiment, an indicator algorithm relationship table is created according to the algorithmic relationship between indicators, and then an indicator hierarchical relationship table is created according to the indicator algorithm relationship table, thereby ensuring the speed and accuracy of creating the indicator hierarchical relationship table.

[0137] In some optional implementations of this embodiment, the hierarchical relationship creation module is also used to obtain algorithm relationship information in the indicator algorithm relationship table; identify the first indicator and the second indicator in the obtained algorithm relationship information; the first indicator is obtained by calculation from the second indicator; determine the parent-child relationship information of the first indicator and the second indicator; in the parent-child relationship information, the first indicator is the parent indicator of the second indicator, and the second indicator is the child indicator of the first indicator; obtain the indicator hierarchical relationship table based on the determined parent-child relationship information.

[0138] In this embodiment, the parent-child relationship information between indicators is determined based on the algorithm relationship table, and the indicator hierarchical relationship table is obtained based on the parent-child relationship information, thereby ensuring the accuracy of the generated indicator hierarchical relationship table.

[0139] In some optional implementations of this embodiment, the parent indicator obtaining module 402 is further used to match a first algorithm corresponding to the parent indicator from the indicator algorithm relationship table; and according to the first algorithm, match an indicator hierarchical relationship table corresponding to the parent indicator.

[0140] In this embodiment, the first algorithm corresponding to the parent indicator is matched from the indicator algorithm relationship table, and then the indicator hierarchical relationship table corresponding to the parent indicator is matched, thereby ensuring the matching speed.

[0141] In some optional implementations of this embodiment, the business data analysis device 400 further includes: a data judgment module and an indicator display module, wherein:

[0142] The data judgment module is used to judge whether the data value corresponding to the current indicator obtained by calculation is within the preset indicator value range after each calculation according to the indicator algorithm relationship table.

[0143] The indicator display module is used to mark the current indicator as an abnormal indicator when the data value corresponding to the current indicator is not within the preset indicator value range, and to display the current indicator after the data analysis is completed.

[0144] In this embodiment, the server determines whether the calculated data value of the current indicator meets expectations. If not, the current indicator is marked as an abnormal indicator and displayed for further analysis, thereby improving the accuracy of data analysis.

[0145] To solve the above technical problems, the present application also provides a computer device. Figure 8 , Figure 8 This is a basic structural block diagram of the computer device in this embodiment.

[0146] The computer device 9 includes a memory 51, a processor 52, and a network interface 53 that are interconnected through a system bus. It should be noted that the figure only shows a computer device 5 having components 51-53, but it should be understood that it is not required to implement all the components shown, and more or fewer components can be implemented instead. Among them, those skilled in the art can understand that the computer device here is a device that can automatically perform numerical calculations and / or information processing according to pre-set or stored instructions, and its hardware includes but is not limited to a microprocessor, an application-specific integrated circuit (ASIC), a field-programmable gate array (FPGA), a digital signal processor (DSP), an embedded device, etc.

[0147] The computer device may be a desktop computer, notebook computer, PDA, cloud server, etc. The computer device may interact with the user via a keyboard, mouse, remote control, touchpad, or voice control device.

[0148] The memory 51 includes at least one type of readable storage medium, including flash memory, hard disk, multimedia card, card-type memory (e.g., SD or DX memory), random access memory (RAM), static random access memory (SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), programmable read-only memory (PROM), magnetic memory, magnetic disk, optical disk, etc. In some embodiments, the memory 51 can be an internal storage unit of the computer device 5, such as the hard disk or memory of the computer device 5. In other embodiments, the memory 51 can also be an external storage device of the computer device 5, such as a plug-in hard disk equipped on the computer device 5, a smart memory card (SMC), a secure digital (SD) card, a flash memory card, etc. Of course, the memory 51 can also include both the internal storage unit of the computer device 5 and its external storage device. In this embodiment, the memory 51 is generally used to store the operating system and various application software installed on the computer device 5, such as the program code of the business data analysis method. In addition, the memory 51 can also be used to temporarily store various types of data that have been output or are to be output.

[0149] In some embodiments, the processor 52 may be a central processing unit (CPU), a controller, a microcontroller, a microprocessor, or other data processing chip. The processor 52 is generally used to control the overall operation of the computer device 5. In this embodiment, the processor 52 is used to execute program code stored in the memory 51 or process data, such as executing the program code of the method X.

[0150] The network interface 53 may include a wireless network interface or a wired network interface. The network interface 53 is generally used to establish a communication connection between the computer device 5 and other electronic devices.

[0151] The computer device provided in this embodiment can execute the steps of the business data analysis method as described above, by obtaining and parsing the data to be analyzed input by the user, obtaining the fields used for business data analysis, and extracting the indicator fields to obtain the parent indicators, thereby realizing automatic extraction of the parent indicators from the data to be analyzed; matching the pre-created indicator hierarchy relationship table and indicator algorithm relationship table according to the parent indicators, obtaining all child indicators corresponding to the parent indicators; then using the obtained child indicators as new parent indicators to obtain child indicators, until no new child indicators can be obtained, obtaining multiple end point indicators, realizing automatic configuration of indicators, and improving configuration efficiency; when performing data analysis, obtaining the data values ​​of each end point indicator from the database, and then combining the indicator algorithm relationship table to calculate the data values ​​of the indicators of the previous level layer by layer, when the data values ​​of the indicator fields are obtained, the business data analysis can be completed, and the efficiency of business data analysis is improved through process-based calculation.

[0152] The present application also provides another embodiment, namely, providing a computer-readable storage medium, which stores a data analysis program, and the data analysis program can be executed by at least one processor to enable the at least one processor to perform the steps of the business data analysis method as described above.

[0153] In this embodiment, by acquiring and parsing the data to be analyzed input by the user, fields for business data analysis are obtained, and the indicator fields are extracted to obtain the parent indicators, thereby realizing automatic extraction of the parent indicators from the data to be analyzed; matching the pre-created indicator hierarchy relationship table and indicator algorithm relationship table according to the parent indicators, all child indicators corresponding to the parent indicators are obtained; then the obtained child indicators are used as new parent indicators to obtain child indicators, until no new child indicators can be obtained, and multiple end-point indicators are obtained, thereby realizing automatic configuration of indicators and improving configuration efficiency; when performing data analysis, the data values ​​of each end-point indicator are obtained from the database, and then the data values ​​of the indicators of the upper level are calculated layer by layer in combination with the indicator algorithm relationship table. When the data values ​​of the indicator fields are obtained, the business data analysis can be completed, and the efficiency of business data analysis is improved through process-based calculations.

[0154] Through the description of the above implementation methods, those skilled in the art can clearly understand that the above-mentioned embodiment methods can be implemented by means of software plus the necessary general hardware platform, and of course can also be implemented by hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art, can be embodied in the form of a software product, which is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk), and includes a number of instructions for enabling a terminal device (which can be a mobile phone, computer, server, air conditioner, or network device, etc.) to execute the methods described in each embodiment of the present application.

[0155] Obviously, the embodiments described above are only some of the embodiments of the present application, rather than all of the embodiments. The preferred embodiments of the present application are given in the accompanying drawings, but they do not limit the patent scope of the present application. The present application can be implemented in many different forms. On the contrary, the purpose of providing these embodiments is to make the understanding of the disclosure of the present application more thorough and comprehensive. Although the present application has been described in detail with reference to the aforementioned embodiments, for those skilled in the art, it is still possible to modify the technical solutions described in the aforementioned specific embodiments, or to make equivalent replacements for some of the technical features therein. Any equivalent structure made using the contents of the present application specification and the accompanying drawings, directly or indirectly used in other related technical fields, is also within the scope of patent protection of the present application.

Claims

1. A business data analysis method, characterized in that: The steps include: Obtaining data to be analyzed input by a user, and parsing the data to be analyzed to obtain at least one field for business data analysis; Convert the field into field information in an SQL statement, wherein the field information includes at least one indicator field, and use the indicator field as a parent indicator, and match a pre-created indicator hierarchy relationship table and an indicator algorithm relationship table according to the parent indicator; Acquire all child indicators corresponding to the parent indicator based on the indicator hierarchical relationship table; The obtained child indicator is used as a new parent indicator, and the process of obtaining child indicators based on the indicator hierarchical relationship table is repeated until no new child indicators can be obtained, and all indicators that cannot obtain child indicators are used as end indicators; Accessing a database based on the SQL statement, obtaining the data value of each endpoint indicator from the database, and calculating the data value of the indicator at the previous level layer by layer according to the data value of each endpoint indicator and the indicator algorithm relationship table, until the data value of the indicator field is obtained, thereby completing the business data analysis; Wherein, before the step of converting the field into field information in an SQL statement, the field information includes at least one indicator field, taking the indicator field as a parent indicator, and matching a pre-created indicator hierarchical relationship table and an indicator algorithm relationship table according to the parent indicator, the step further includes: Get indicator ID; receiving an algorithmic relationship identified for the indicator; Creating an indicator algorithm relationship table according to the algorithm relationship; Create an indicator hierarchical relationship table according to the indicator algorithm relationship table; Among them, according to the indicator algorithm relationship table, the hierarchical relationship between indicators corresponding to the indicator identifiers is determined, and an indicator hierarchical relationship table is created.

2. The business data analysis method according to claim 1, characterized in that: The step of parsing the data to be analyzed to obtain at least one field for business data analysis specifically includes: Segmenting the data to be analyzed to obtain multiple fields; Performing semantic annotation on the multiple fields according to the semantic knowledge base to generate semantic annotation results; Determining the dependency relationship of the multiple fields based on the semantic annotation result; At least one field among the multiple fields is determined to be used for business data analysis according to the dependency relationship.

3. The business data analysis method according to claim 2, characterized in that: After the step of semantically annotating the multiple fields according to the semantic knowledge base to generate semantic annotation results, the following step is further included: Dividing the multiple fields into an indicator field and a range field based on the semantic annotation results; the indicator field is a target for business data analysis, and the range field is used to instruct the server to obtain data values ​​from the database for business data analysis; The step of obtaining the data value of each endpoint indicator from the database includes: The data values ​​of the endpoint indicators that meet the range field are read from the database according to the range field.

4. The business data analysis method according to claim 1, characterized in that: The step of creating an indicator hierarchy relationship table according to the indicator algorithm relationship table specifically includes: Obtaining algorithm relationship information in the indicator algorithm relationship table; Identifying a first indicator and a second indicator in the acquired algorithm relationship information; the first indicator is obtained by calculating the second indicator; Determining parent-child relationship information between the first indicator and the second indicator; in the parent-child relationship information, the first indicator is the parent indicator of the second indicator, and the second indicator is the child indicator of the first indicator; The indicator hierarchical relationship table is obtained according to the determined parent-child relationship information.

5. The business data analysis method according to claim 1, characterized in that: The specific steps of matching the pre-created indicator hierarchy relationship table and indicator algorithm relationship table according to the parent indicator include: Matching a first algorithm corresponding to the parent indicator from the indicator algorithm relationship table; According to the first algorithm, an indicator hierarchical relationship table corresponding to the parent indicator is matched.

6. The business data analysis method according to claim 1, characterized in that: After the step of calculating the data value of the indicator of the upper level layer by layer according to the data value of each endpoint indicator and the indicator algorithm relationship table, the method further includes: After each calculation according to the indicator algorithm relationship table, it is determined whether the data value corresponding to the current indicator obtained by calculation is within the preset indicator value range; If not, the current indicator is marked as an abnormal indicator and displayed after the business data analysis is completed.

7. A business data analysis device, characterized in that: include: A field acquisition module is used to obtain the data to be analyzed input by the user, and parse the data to be analyzed to obtain at least one field for business data analysis; A parent indicator obtaining module is used to convert the field into field information in an SQL statement, wherein the field information includes at least one indicator field, and use the indicator field as a parent indicator, and match the pre-created indicator hierarchy relationship table and indicator algorithm relationship table according to the parent indicator; A sub-level indicator obtaining module is used to obtain all sub-level indicators corresponding to the parent-level indicator based on the indicator hierarchical relationship table; An endpoint indicator obtaining module is used to use the obtained child indicators as new parent indicators, repeat the process of obtaining child indicators based on the indicator hierarchical relationship table, until no new child indicators can be obtained, and use all indicators that cannot obtain child indicators as endpoint indicators; A data analysis module is configured to access a database based on the SQL statement, obtain the data value of each endpoint indicator from the database, and calculate the data value of the indicator at the next higher level layer by layer according to the data value of each endpoint indicator and the indicator algorithm relationship table, until the data value of the indicator field is obtained, thereby completing the business data analysis; The business data analysis device further includes: an identification acquisition module, an algorithm receiving module, an algorithm relationship creation module, and a hierarchical relationship creation module, wherein: An identification acquisition module is used to obtain indicator identification; An algorithm receiving module, used for receiving an algorithm relationship for an indicator identifier; Algorithm relationship creation module, used to create indicator algorithm relationship table based on algorithm relationship; A hierarchical relationship creation module is used to create an indicator hierarchical relationship table based on the indicator algorithm relationship table; Among them, according to the indicator algorithm relationship table, the hierarchical relationship between indicators corresponding to the indicator identifiers is determined, and an indicator hierarchical relationship table is created.

8. A computer device comprising a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of the business data analysis method according to any one of claims 1 to 6 when executing the computer program.

9. A computer-readable storage medium, characterized in that The computer-readable storage medium stores a computer program, which, when executed by a processor, implements the steps of the business data analysis method according to any one of claims 1 to 6.

Images