Report generation method, report generation apparatus, electronic device, and storage medium

Abstract

The present application discloses a report generation method, a report generation apparatus, an electronic device, and a computer-readable storage medium. The method comprises: in response to information of an application scenario input by a user, generating a scenario indicator set adaptive to the application scenario, wherein the scenario indicator set comprises at least one indicator for data analysis; determining a report template on the basis of each indicator in the scenario indicator set; and on the basis of the scenario indicator set, performing data analysis on a database, and writing a data analysis result into the report template, so as to obtain a data analysis report. By means of the solution of the present application, the indicator set can be adaptively generated on the basis of the application scenario, thereby quickly and efficiently obtaining the data analysis report.

Description

Report generation method, report generation device, electronic equipment and storage medium

[0001] This application claims priority to Chinese Patent Application No. 202410497006.8, filed on April 23, 2024, entitled “Report Generation Method, Report Generation Apparatus, Electronic Device and Storage Medium”, the entire contents of which are incorporated herein by reference. Technical Field

[0002] This application belongs to the field of data processing technology, and in particular relates to a report generation method, a report generation device, an electronic device, and a computer-readable storage medium. Background Technology

[0003] Databases typically store large amounts of data of various types. Currently, to obtain data analysis results based on databases, users usually need to manually create corresponding indicator sets according to their data analysis objectives. Obviously, when the objectives of data analysis change, it is often necessary to manually create the corresponding indicator sets again, resulting in time-consuming and inefficient data analysis.

[0004] Application content

[0005] This application provides a report generation method, a report generation device, an electronic device, and a computer-readable storage medium, which can adaptively generate indicator sets based on application scenarios, thereby quickly and efficiently obtaining data analysis reports.

[0006] Firstly, this application provides a report generation method, including:

[0007] In response to user input about the application scenario, a scenario indicator set adapted to the application scenario is generated. The scenario indicator set includes at least one indicator for data analysis.

[0008] Based on the various indicators in the scenario indicator set, determine the report template;

[0009] Data analysis is performed on the database based on the scenario indicator set, and the results of the data analysis are written into a report template to obtain a data analysis report.

[0010] In the above implementation, users no longer need to create their own data analysis indicator sets; they only need to input information about the application scenario. Based on this information, the electronic device can generate a scenario indicator set adapted to that application scenario. After obtaining the scenario indicator set, the electronic device can determine the corresponding report template and automatically write the final data analysis results into that report template. This process significantly simplifies user operations, avoids human error, and helps reduce the time spent on data analysis, thus improving its efficiency.

[0011] In one implementation, the step of generating a set of scenario metrics adapted to the application scenario in response to user input about the application scenario may include:

[0012] Based on the preset scenario-field correspondence, determine the target fields corresponding to the application scenarios under each preset dimension;

[0013] Based on the target fields and the preset field-index correspondence, a set of scenario indices that adapts to the application scenario is generated.

[0014] In the above implementation method, the scenario-field correspondence and the field-metric correspondence can be established in advance. Subsequently, during the data analysis process, by looking up these two correspondences, the electronic device can quickly generate a scenario metric set adapted to the current application scenario based on the information of the input application scenario.

[0015] In one implementation, the predefined field-metric correspondence can be determined in the following way:

[0016] Establish multiple field sets, each belonging to a different preset dimension, and each field set includes at least one field;

[0017] Extract no more than a preset number of fields from each field set to form a field combination;

[0018] By using association algorithms, we can perform association analysis on data under different field combinations in the database.

[0019] If the results of the association analysis indicate that there is an association between the field combinations, an indicator is generated based on the field combinations, and a correspondence is established between the indicator and the field combinations.

[0020] In the above implementation method, users do not need to manually establish the correspondence between fields and indicators. Instead, the electronic device actively analyzes the correlation between fields, filters out fields with correlations, and then establishes indicators describing these correlations and their correspondence with the fields. This avoids generating invalid indicators and also avoids missing valid indicators.

[0021] In one implementation, the step of determining the report template based on the various metrics in the scenario metric set may include:

[0022] For each metric in the scenario metric set, determine the metric type to which the metric belongs;

[0023] Determine the corresponding indicator text template based on the indicator type;

[0024] A report template is generated based on the indicator text template corresponding to each indicator.

[0025] In the above implementation method, corresponding indicator types are pre-defined for different indicators, and the same indicator type can correspond to the same indicator text template. This simplifies the report template generation process and makes the generated report templates more uniform in format, making them easier for users to view.

[0026] In one implementation, the step of determining the indicator text template corresponding to the indicator based on the indicator type may include:

[0027] Determine the indicator text template corresponding to the indicator type;

[0028] When there are two or more indicator text templates corresponding to an indicator type, the first target template is determined from the indicator text templates corresponding to the indicator type based on the user's user profile.

[0029] The first target template is determined as the indicator text template corresponding to the indicator.

[0030] In the above implementation method, considering that different users have different preferences, multiple indicator text templates can be pre-set for certain indicator types. For an indicator type with multiple indicator text templates, the electronic device can determine the indicator text template that matches the user's preferences (i.e., the first target template) from these multiple indicator text templates based on the user's user profile.

[0031] In one implementation, the above report generation method further includes:

[0032] If the indicator text template corresponding to the indicator type is empty, or if a template creation instruction is received from the user, the template creation interface will be displayed.

[0033] In response to the template text information received from the template creation interface, a second target template is generated;

[0034] The second target template is defined as the indicator text template corresponding to the indicator.

[0035] In the above implementation method, users can also create a second target template according to their actual situation for the indicator type, so as to realize the personalized customization of the indicator text template when the indicator text template corresponding to the indicator does not meet their own needs.

[0036] In one implementation, before determining the report template based on the various metrics in the scenario metric set, the above report generation method further includes:

[0037] Based on the data filtering conditions input by the user and / or the user profile, the scenario indicator set is filtered to obtain the filtered indicator set;

[0038] Accordingly, based on the various metrics in the scenario metric set, a report template is determined, including:

[0039] Determine the report template based on the various indicators in the filter indicator set.

[0040] In the above implementation, the electronic device can filter its adaptively generated set of scene indicators. On the one hand, the filtering conditions can be data filtering conditions input by the user, thereby avoiding the appearance of indicators that the user does not need in the filtered indicator set; on the other hand, the filtering conditions can also be the user's user profile, thereby making the filtered indicator set more in line with the user's expectations.

[0041] Secondly, this application provides a report generation apparatus, comprising:

[0042] The generation module is used to generate a set of scenario indicators that are adapted to the application scenario in response to the application scenario information input by the user. The set of scenario indicators includes at least one indicator for data analysis.

[0043] The determination module is used to determine the report template based on the various indicators in the scenario indicator set;

[0044] The analysis module is used to perform data analysis on the database based on the scenario indicator set, and write the results of the data analysis into a report template to obtain a data analysis report.

[0045] Thirdly, this application provides an electronic device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, it implements the steps of the method described in the first aspect.

[0046] Fourthly, this application provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the steps of the method described in the first aspect above.

[0047] Fifthly, this application provides a computer program product comprising a computer program that, when executed by one or more processors, implements the steps of the method described in the first aspect.

[0048] It is understood that the beneficial effects of the second to fifth aspects mentioned above can be found in the relevant descriptions in the first aspect mentioned above, and will not be repeated here. Attached Figure Description

[0049] To more clearly illustrate the technical solutions in the embodiments of this application, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0050] Figure 1 is a schematic diagram of the implementation flow of the report generation method provided in the embodiments of this application;

[0051] Figure 2 is a schematic diagram of the implementation flow of step 101 in the report generation method provided in the embodiment of this application;

[0052] Figure 3 is a schematic diagram of the implementation flow of step 102 in the report generation method provided in the embodiment of this application;

[0053] Figure 4 is a schematic diagram of the report generation device provided in an embodiment of this application;

[0054] Figure 5 is a schematic diagram of the structure of the electronic device provided in an embodiment of this application. Detailed Implementation

[0055] The embodiments of the technical solution of this application will now be described in detail with reference to the accompanying drawings. These embodiments are only used to more clearly illustrate the technical solution of this application and are therefore merely examples, and should not be used to limit the scope of protection of this application.

[0056] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application pertains; the terminology used herein is for the purpose of describing particular embodiments only and is not intended to limit the application; the terms “comprising” and “having”, and any variations thereof, in the specification, claims, and foregoing description of the drawings are intended to cover non-exclusive inclusion.

[0057] In the description of the embodiments of this application, technical terms such as "first" and "second" are used only to distinguish different objects and should not be construed as indicating or implying relative importance or implicitly indicating the number, specific order, or primary and secondary relationship of the indicated technical features.

[0058] In this document, the term "embodiment" means that a particular feature, structure, or characteristic described in connection with an embodiment may be included in at least one embodiment of this application. The appearance of this phrase in various places throughout the specification does not necessarily refer to the same embodiment, nor is it a separate or alternative embodiment mutually exclusive with other embodiments. It will be explicitly and implicitly understood by those skilled in the art that the embodiments described herein can be combined with other embodiments.

[0059] In the description of the embodiments in this application, the term "and / or" is merely a description of the relationship between related objects, indicating that three relationships can exist. For example, A and / or B can represent: A existing alone, A and B existing simultaneously, and B existing alone. Additionally, the character " / " in this document generally indicates that the preceding and following related objects have an "or" relationship.

[0060] In the description of the embodiments of this application, the term "multiple" refers to two or more (including two), unless otherwise expressly and specifically defined.

[0061] As businesses grow, the amount of data they need to manage also increases. Currently, databases are commonly used to store data related to various products. In subsequent product management, this database data can be used for analysis to quickly understand the product's strengths, weaknesses, and other performance aspects, helping the company to continuously optimize its products.

[0062] In practical applications, staff from different business departments typically have different desired application scenarios when conducting data analysis on products, and these scenarios are often strongly correlated with the analysis objectives. Currently, staff usually first manually create a set of indicators for data analysis based on the specific application scenario (equivalent to the analysis objective) and actual needs. Then, electronic devices use this indicator set to analyze the database and obtain the results. Finally, a data analysis report is manually written based on the results. On the one hand, since the indicator set is created manually, errors and omissions are unavoidable. On the other hand, this indicator set is only valid for the current data analysis, requiring the indicator set to be recreated for each analysis. Furthermore, the data analysis results need to be manually compiled into a report. All of these factors contribute to the current time-consuming and inefficient data analysis process.

[0063] Based on the above considerations, this application proposes a report generation method that can adaptively generate indicator sets based on application scenarios, thereby quickly and efficiently obtaining data analysis reports. To illustrate the technical solution proposed in this application, specific embodiments are described below.

[0064] The following describes a report generation method provided by an embodiment of this application. This report generation method can be applied to electronic devices with data management functions (i.e., equipped with a data management system), including but not limited to computers. Referring to Figure 1, the report generation method in this embodiment includes:

[0065] Step 101: In response to the application scenario information input by the user, generate a scenario indicator set that is adaptive to the application scenario.

[0066] After receiving a report generation command from a user, the electronic device can display a report generation interface. This interface initially displays an input box. Users can input information about the application scenario they wish to analyze using methods such as mouse, keyboard, voice, or touch.

[0067] In some embodiments, considering that the application scenarios corresponding to data analysis in real life are limited, electronic devices can be pre-configured with multiple application scenarios for users to choose from; that is, the staff of the data management system (including development and maintenance personnel) can pre-exhaustively list all application scenarios and configure the electronic device. In this case, the input box may include a selection box, thereby displaying information of multiple pre-configured application scenarios for the user to select from. Of course, the input box may also include a text box. If the application scenario desired by the user is not among the pre-configured application scenarios, the user can directly enter text information describing the application scenario through the text box; this is not limited here.

[0068] After obtaining information about the application scenario, the electronic device can generate a set of scenario indicators based on that information. This set of scenario indicators refers to a collection of indicators that are adaptive to the application scenario, and this set is generally not empty; that is, the set of scenario indicators typically includes at least one indicator used for data analysis. In some embodiments, the set of scenario indicators can be generated by an artificial intelligence model mounted on the electronic device based on the application scenario; alternatively, the set of scenario indicators can also be generated by searching within a pre-defined correspondence based on the application scenario. The method of generating the set of scenario indicators is not limited here.

[0069] Step 102: Determine the report template based on the various indicators in the scenario indicator set.

[0070] Each indicator can correspond to an indicator text template. An indicator text template refers to a text template used to describe the analysis results of that indicator. The portion of the text template to be filled with the analysis results can be represented by placeholders or other methods. In this embodiment, the electronic device can sequentially determine the corresponding indicator text templates for each indicator in the scene indicator set, and then arrange the determined indicator text templates in a specified order to determine the report template. This specified order can be determined based on a sorting command input by the user; alternatively, it can be the default order of the electronic device, which is not limited here.

[0071] Step 103: Perform data analysis on the database based on the scenario indicator set, and write the results of the data analysis into the report template to obtain a data analysis report.

[0072] After obtaining the scene indicator set, the electronic device can perform corresponding data analysis operations on each indicator in the database. These data analysis operations include, but are not limited to, searching, statistical analysis, and other operations. The results of the data analysis for each indicator can be written to the corresponding indicator text template in the report template. Finally, after all indicator text templates in the report template have been filled with the corresponding data analysis results, a data analysis report can be output.

[0073] In some embodiments, to improve the efficiency of generating the scenario indicator set, please refer to Figure 2. Step 101 may include:

[0074] A1. Based on the preset scenario-field correspondence, determine the target fields corresponding to the application scenarios under each preset dimension.

[0075] Data management system staff can pre-establish the correspondence between application scenarios and fields. The fields referred to in this embodiment are specifically fields in the database. Obviously, the fields in the database are known and limited. Staff can categorize the fields in the database into corresponding preset dimensions based on their attributes and meanings. These preset dimensions are defined by the staff based on the product type. In some examples, preset dimensions may include, but are not limited to: production dimensions, usage dimensions, status dimensions, and statistical dimensions. Furthermore, as mentioned above, application scenarios are limited, and an exhaustive list of these scenarios can be created. Based on this, for each exhaustively listed application scenario, the electronic device can determine some basic fields that should be focused on in that application scenario based on the attention instructions input by the staff, thereby establishing the correspondence between the application scenario and the fields. This correspondence can be stored in storage space, which includes, but is not limited to, local storage space and cloud storage space.

[0076] When a set of scenario metrics needs to be generated, the electronic device can read a preset scenario-field mapping relationship from its storage space. Then, based on the application scenario information input by the current user, the electronic device can search within this scenario-field mapping relationship to obtain the field corresponding to that application scenario. This field is the target field, and there is no limit to the number of target fields. That is, the number of target fields can be more than one, specifically determined by the scenario-field mapping relationship.

[0077] A2. Based on the target field and the preset field-indicator correspondence, generate a set of scenario indicators that are adaptive to the application scenario.

[0078] The data management system can also pre-establish the correspondence between fields and indicators through intelligent analysis. The process of establishing this correspondence is explained below:

[0079] First, the electronic device can establish multiple field sets. As described earlier, based on the attributes and meaning of a field, it can be categorized into a corresponding preset dimension. If a preset dimension has no fields, it indicates that the preset dimension is currently invalid and can be directly deleted, thus ensuring that each preset dimension has at least one field. Therefore, for any given preset dimension, all fields under that preset dimension constitute a field set. In this way, based on N valid preset dimensions, the electronic device establishes N field sets, each belonging to a different preset dimension, and each field set includes at least one field.

[0080] Then, the electronic device can extract no more than a preset number of fields from each field set to form field combinations. Specifically, in this process, the electronic device can consider all possible extractions and combinations based on the idea of ​​permutation and combination, and each resulting field combination should include at least two fields.

[0081] In some examples, to avoid overly complex data analysis that consumes too much computing power of electronic devices, the preset quantity can be 1. The step can be illustrated as follows: Assume there are three preset dimensions: preset dimension A, preset dimension B, and preset dimension C. Preset dimension A has fields A1 and A2; preset dimension B has field B1; and preset dimension C has fields C1 and C2. The following field combinations can then be formed:

[0082] Field combination 1: A1-B1

[0083] Field combination 2: A1-C1

[0084] Field combination 3: A1-C2

[0085] Field combination 4: A2-B1

[0086] Field combination 5: A2-C1

[0087] Field combination 6: A2-C2

[0088] Field combination 7: B1-C1

[0089] Field combination 8: B1-C2

[0090] Field combination 9: A1-B1-C1

[0091] Field combination 10: A1-B1-C2

[0092] Field combination 11: A2-B1-C1

[0093] Field combination 12: A2-B1-C2

[0094] Next, for each field combination, the electronic device can perform correlation analysis on the data under that field combination in the database using a correlation algorithm. The analysis methods for this correlation analysis may include, but are not limited to, linear analysis, normal distribution analysis, forward analysis, backward analysis, and data table analysis, etc., which will not be elaborated here. Of course, if the field combination also includes statistically related fields (i.e., fields belonging to statistical dimensions), data querying and statistical operations can be performed based on these fields before data analysis; this embodiment of the application does not limit this.

[0095] Finally, for each field combination, if the association analysis results indicate that a relationship exists between the field combinations, the electronic device can generate an indicator based on that field combination and establish a correspondence between the indicator and the field combination. The indicator indicates that the fields contained in the corresponding field combination have a relationship, and the name of the indicator is specifically generated by that field combination. In some examples, assuming that field combination 1: A1-B1 has a relationship, a corresponding indicator can be established, and the indicator name can be "A1B1 Analysis Indicator"; subsequently, the electronic device can establish a correspondence between the A1B1 Analysis Indicator and fields A1 and B1, which will not be elaborated further here.

[0096] By using the above methods, we can avoid missing any generated indicators, thereby establishing a comprehensive and complete field-indicator correspondence.

[0097] After obtaining the target field, the electronic device can search for it in the field-index correspondence. It can be understood that each target field may correspond to multiple indices, so the final number of indices related to each target field may also be multiple, and no limit is placed on their number here. These searched indices can constitute the scene index set.

[0098] In some embodiments, to ensure a relatively uniform format for the report template, enhance readability, and simplify the report template generation process, please refer to Figure 3. Step 102 may include:

[0099] B1. For each indicator in the scenario indicator set, determine the indicator type to which the indicator belongs.

[0100] The data management system can pre-create multiple indicator types based on user manual configuration. During the data management system initialization, once the indicators have been generated, it can respond to the user's input of indicator classification instructions and assign the indicator to a specific indicator type. In this way, each generated indicator has its own associated indicator type. Based on this, for each indicator in the scenario indicator set, the electronic device can read and extract its indicator type for subsequent use.

[0101] B2. Determine the corresponding indicator text template based on the indicator type.

[0102] To avoid redundancy in indicator text templates, data management systems no longer need to set a specific text template for each individual indicator. Instead, they can set a text template for each indicator type. That is, multiple different indicators belonging to the same indicator type actually correspond to the same text template. This significantly reduces the number of indicator text templates stored in the data management system and also helps to standardize report text formats. Electronic devices can thus determine the corresponding text template for each indicator based on its indicator type within the scenario indicator set.

[0103] B3. Generate a report template based on the indicator text template corresponding to each indicator.

[0104] Electronic devices can arrange the indicator text templates corresponding to each indicator in a specified order to generate the final report template. In some examples, each indicator can be pre-set with an indicator priority, in which case the specified order can be: indicator priority from high to low.

[0105] In some embodiments, to cater to the preferences and needs of different users as much as possible, there may be more than two indicator text templates corresponding to certain indicator types. These two or more indicator text templates may differ in their expression logic, expression language, and / or expression form. However, for any indicator in the scenario indicator set, only one corresponding indicator text template can ultimately be determined. Based on this, if there are more than two indicator text templates corresponding to an indicator type in the scenario indicator set, the electronic device can determine a first target template from the two or more indicator text templates based on the user's user profile, and designate the first target template as the indicator text template corresponding to that indicator. The user profile records, but is not limited to, all of the user's historical operations and all report templates previously generated for that user by the electronic device.

[0106] In some embodiments, considering that the indicator text templates corresponding to indicator types are manually configured, and errors may occur during manual configuration, it is possible that the indicator text template corresponding to an indicator type belonging to a certain indicator in the scenario indicator set may be empty. Furthermore, even if there are multiple indicator text templates corresponding to an indicator type belonging to a certain indicator in the scenario indicator set, it is still possible that none of these multiple indicator text templates meet the user's needs, leading the user to input a template creation command into the electronic device. Therefore, when the indicator text template corresponding to an indicator type is empty, or when a template creation command is received from the user, the electronic device can display a template creation interface. The user can input the desired template text information in this interface. In this way, the electronic device can respond to the template text information, generate a second target template, and determine this second target template as the indicator text template corresponding to the indicator. In this way, personalized customization of indicator text templates can be achieved. Of course, the newly added second target template can also be updated to the indicator text template corresponding to the indicator type to which the indicator belongs, for use by subsequent users or other users; in addition, the new second target template can also be recorded in the user's user profile, so that when the electronic device generates a data analysis report for the user next time, if it still needs to use the indicator text template corresponding to the indicator type, it can give priority to recommending the second target template.

[0107] In some embodiments, as the database operates, the amount of data stored in the database typically increases. However, in real-world scenarios, users may prefer targeted analysis, such as analyzing data within a specific time period and / or data within a certain value range. Therefore, the input boxes initially displayed on the report generation interface can be used not only to input application scenario information but also to input data filtering conditions. These filtering conditions include, but are not limited to, time conditions, data type conditions, user permission conditions, and value conditions, etc., which are not specified here. In this way, after obtaining the scenario dataset but before determining the report template, the electronic device can also filter the currently obtained scenario indicator set based on the user-input data filtering conditions and / or user profile. Specifically, it filters indicators in the scenario indicator set that do not match the user profile (i.e., the matching degree is lower than a preset matching degree threshold), and / or filters indicators in the scenario indicator set that do not meet the data filtering conditions, thus obtaining a filtered indicator set. Subsequently, when determining the report template, it is no longer based on the scenario dataset but on the filtered dataset, making the report template more concise.

[0108] Of course, manual filtering of the scene indicator set is also possible. This involves receiving a deletion command from the user and removing the specified indicator from the scene indicator set. There are no limitations on this approach. It's important to note that this manual filtering operation can be recorded in the user's profile, ensuring that subsequent scene indicator sets are generated in a way that better reflects the user's preferences.

[0109] It is understandable that user profiling can continuously improve the accuracy of data analysis reports generated by electronic devices for users; after a period of time, users can directly use the system-recommended set of scenario indicators and report templates, etc., without user modification or with only minor modifications, thereby further helping to improve report generation efficiency.

[0110] To understand the report generation method proposed in the embodiments of this application, the following specific examples will be used for illustration:

[0111] Assume the user's desired application scenario for data analysis is: analyzing low-capacity battery packs.

[0112] First, through the preset scenario-field correspondence, the electronic device determines the target fields corresponding to the application scenario as follows: battery health (State of Health, SOH) and SOH degradation rate.

[0113] Subsequently, through the preset field-index correspondence, the electronic device determines that the target field corresponds to the following indices: Indicator A, used to indicate the correlation between SOH attenuation rate and heat dissipation mode; Indicator B, ...; These will not be elaborated upon here. Based on this, a scenario index set is established: {Indicator A, Indicator B, ...}.

[0114] Next, for indicator A, the electronic device is identified as belonging to the comparison type indicator. The corresponding indicator text template can be exemplified as follows: Under the analysis based on {indicator}, the mean difference of the {compared field} between the battery packs of {type A} and {type B} is {difference value}. It can be seen that the {compared field} of the {type A / B} battery pack performs best, while the {compared field} of the {type A / B} battery pack performs poorly. Indicator B will not be elaborated upon here.

[0115] Finally, the data analysis results of each indicator in the scenario dataset are populated into the corresponding indicator text template. The resulting data analysis report can be exemplified as follows:

[0116] Based on the analysis of index A, the average difference in SOH degradation rate between water-cooled and air-cooled battery packs is 2%. This shows that the water-cooled battery pack has the best SOH degradation rate, while the air-cooled battery pack has a poor SOH degradation rate.

[0117] Based on the analysis of indicator B, ...

[0118] As can be seen from the above, in this embodiment, the user no longer needs to create a set of data analysis indicators themselves, but only needs to input information about the application scenario. Based on this information, the electronic device can generate a set of scenario indicators that adapts to the application scenario. After obtaining the set of scenario indicators, the electronic device can determine the corresponding report template and automatically write the final data analysis results into the report template. The above process significantly simplifies user operations, avoids human error, and helps reduce the time spent on data analysis, thereby improving the efficiency of data analysis.

[0119] It should be understood that the sequence number of each step in the above embodiments does not imply the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of this application.

[0120] Corresponding to the report generation method provided above, this application embodiment also provides a report generation apparatus. Referring to Figure 4, the report generation apparatus 4 in this application embodiment includes:

[0121] The indicator set generation module 401 is used to generate a scenario indicator set that is adaptive to the application scenario in response to the application scenario information input by the user. The scenario indicator set includes at least one indicator for data analysis.

[0122] Template determination module 402 is used to determine the report template based on the various indicators in the scenario indicator set;

[0123] Data analysis module 403 is used to perform data analysis on the database based on a set of scenario indicators;

[0124] The results writing module 404 is used to write the results of data analysis into a report template to obtain a data analysis report.

[0125] In some embodiments, the indicator set generation module 401 includes:

[0126] The first determining unit is used to determine the target fields corresponding to the application scenarios under each preset dimension based on the preset scenario-field correspondence relationship;

[0127] The first generation unit is used to generate a set of scenario indicators that are adaptive to the application scenario, based on the target field and the preset field-indicator correspondence.

[0128] In some embodiments, the report generation apparatus 4 further includes a relationship determination module for determining field-index correspondences, the relationship determination module including:

[0129] The creation unit is used to create multiple field sets, each belonging to a different preset dimension, and each field set includes at least one field;

[0130] The extraction unit is used to extract no more than a preset number of fields from each field set to form a field combination;

[0131] The analysis unit is used to perform correlation analysis on data under a combination of fields in the database using correlation algorithms;

[0132] A unit is created to generate an indicator based on the field combination when the results of the association analysis indicate that there is an association relationship between the field combination, and to establish the correspondence between the indicator and the field combination.

[0133] In some embodiments, the template determining module 402 includes:

[0134] The second determining unit is used to determine the indicator type to which each indicator belongs for each indicator in the scenario indicator set;

[0135] The third determining unit is used to determine the indicator text template corresponding to the indicator based on the indicator type.

[0136] The second generation unit is used to generate a report template based on the indicator text template corresponding to each indicator.

[0137] In some embodiments, the third determining unit includes:

[0138] The first determining sub-unit is used to determine the indicator text template corresponding to the indicator type;

[0139] The second determining subunit is used to determine the first target template from the indicator text templates corresponding to the indicator type, based on the user's user profile, when there are two or more indicator text templates corresponding to the indicator type.

[0140] The third determining subunit is used to determine the first target template as the indicator text template corresponding to the indicator.

[0141] In some embodiments, the third determining unit further includes:

[0142] The display sub-unit is used to display the template creation interface when the indicator text template corresponding to the indicator type is empty, or when a template creation instruction is received from the user.

[0143] A sub-unit is generated in response to the template text information received from the template creation interface to generate a second target template;

[0144] The fourth determining sub-unit is used to determine the second target template as the indicator text template corresponding to the indicator.

[0145] In some embodiments, the report generation device 4 further includes:

[0146] The indicator set filtering module is used to filter the scenario indicator set based on the data filtering conditions input by the user and / or the user profile of the user, so as to obtain the filtered indicator set.

[0147] Accordingly, the template determination module 402 is specifically used to determine the report template based on each indicator in the filter indicator set.

[0148] As can be seen from the above, in this embodiment, users no longer need to create their own data analysis indicator set, but only need to input information about the application scenario. Based on this information, the report generation device can generate a scenario indicator set adapted to the application scenario. After obtaining the scenario indicator set, the report generation device can determine the corresponding report template and automatically write the final data analysis results into the report template. This process significantly simplifies user operations, avoids human error, and helps reduce the time spent on data analysis, thereby improving the efficiency of data analysis.

[0149] Corresponding to the report generation method provided above, this application embodiment also provides an electronic device. Referring to FIG5, the electronic device 5 in this application embodiment includes: a memory 501, one or more processors 502 (only one is shown in FIG5), and a computer program stored in the memory 501 and executable on the processor. The memory 501 stores software programs and modules, and the processor 502 executes various functional applications and data processing by running the software programs and units stored in the memory 501 to obtain resources corresponding to the aforementioned preset events. Specifically, the processor 502 implements the following steps by running the aforementioned computer program stored in the memory 501:

[0150] In response to user input about the application scenario, a scenario indicator set adapted to the application scenario is generated. The scenario indicator set includes at least one indicator for data analysis.

[0151] Based on the various indicators in the scenario indicator set, determine the report template;

[0152] Data analysis is performed on the database based on the scenario indicator set, and the results of the data analysis are written into a report template to obtain a data analysis report.

[0153] Assuming the above is the first possible implementation, then in the second possible implementation, which is based on the first possible implementation, in response to user input of application scenario information, a scenario indicator set adapted to the application scenario is generated, including:

[0154] Based on the preset scenario-field correspondence, determine the target fields corresponding to the application scenarios under each preset dimension;

[0155] Based on the target fields and the preset field-index correspondence, a set of scenario indices that adapts to the application scenario is generated.

[0156] In the third possible implementation based on the second possible implementation described above, the preset field-index correspondence is determined in the following way:

[0157] Establish multiple field sets, each belonging to a different preset dimension, and each field set includes at least one field;

[0158] Extract no more than a preset number of fields from each field set to form a field combination;

[0159] By using association algorithms, we can perform association analysis on data under different field combinations in the database.

[0160] If the results of the association analysis indicate that there is an association between the field combinations, an indicator is generated based on the field combinations, and a correspondence is established between the indicator and the field combinations.

[0161] In the fourth possible implementation provided based on the first possible implementation described above, a report template is determined according to each indicator in the scenario indicator set, including:

[0162] For each metric in the scenario metric set, determine the metric type to which the metric belongs;

[0163] Determine the corresponding indicator text template based on the indicator type;

[0164] A report template is generated based on the indicator text template corresponding to each indicator.

[0165] In the fifth possible implementation provided based on the fourth possible implementation described above, the indicator text template corresponding to the indicator is determined according to the indicator type, including:

[0166] Determine the indicator text template corresponding to the indicator type;

[0167] When there are two or more indicator text templates corresponding to an indicator type, the first target template is determined from the indicator text templates corresponding to the indicator type based on the user's user profile.

[0168] The first target template is determined as the indicator text template corresponding to the indicator.

[0169] In a sixth possible implementation based on the fifth possible implementation described above, the processor 502 performs the following steps when running the computer program stored in the memory 501:

[0170] If the indicator text template corresponding to the indicator type is empty, or if a template creation instruction is received from the user, the template creation interface will be displayed.

[0171] In response to the template text information received from the template creation interface, a second target template is generated;

[0172] The second target template is defined as the indicator text template corresponding to the indicator.

[0173] In a seventh possible implementation provided based on the first, second, third, fourth, fifth, or sixth possible implementations described above, before determining the report template according to the various indicators in the scenario indicator set, the processor 502 performs the following steps by running the computer program stored in the memory 501:

[0174] Based on the data filtering conditions input by the user and / or the user profile, the scenario indicator set is filtered to obtain the filtered indicator set;

[0175] Accordingly, based on the various metrics in the scenario metric set, a report template is determined, including:

[0176] Determine the report template based on the various indicators in the filter indicator set.

[0177] It should be understood that, in the embodiments of this application, the processor 502 may be a central processing unit (CPU), but it may also be other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or any conventional processor.

[0178] Memory 501 may include read-only memory and random access memory, and provides instructions and data to processor 502. Some or all of memory 501 may also include non-volatile random access memory. For example, memory 501 may also store device type information.

[0179] As can be seen from the above, in this embodiment, the user no longer needs to create a set of data analysis indicators themselves, but only needs to input information about the application scenario. Based on this information, the electronic device can generate a set of scenario indicators that adapts to the application scenario. After obtaining the set of scenario indicators, the electronic device can determine the corresponding report template and automatically write the final data analysis results into the report template. The above process significantly simplifies user operations, avoids human error, and helps reduce the time spent on data analysis, thereby improving the efficiency of data analysis.

[0180] Those skilled in the art will clearly understand that, for the sake of convenience and brevity, the above-described division of functional units and modules is merely an example. In practical applications, the above functions can be assigned to different functional units and modules as needed, that is, the internal structure of the above device can be divided into different functional units or modules to complete all or part of the functions described above. The functional units and modules in the embodiments can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit. The integrated unit can be implemented in hardware or as a software functional unit. Furthermore, the specific names of the functional units and modules are only for easy differentiation and are not intended to limit the scope of protection of this application. The specific working process of the units and modules in the above system can be referred to the corresponding process in the foregoing method embodiments, and will not be repeated here.

[0181] In the above embodiments, the descriptions of each embodiment have different focuses. For parts that are not described in detail or recorded in a certain embodiment, please refer to the relevant descriptions of other embodiments.

[0182] Those skilled in the art will recognize that the units and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of external device software and electronic hardware. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementation should not be considered beyond the scope of this application.

[0183] In the embodiments provided in this application, it should be understood that the disclosed apparatus and methods can be implemented in other ways. For example, the system embodiments described above are merely illustrative. For instance, the division of modules or units described above is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple units or components may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be an indirect coupling or communication connection between devices or units through some interfaces, and may be electrical, mechanical, or other forms.

[0184] The units described above as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed across multiple network units. Some or all of these units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0185] If the integrated units described above are implemented as software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, all or part of the processes in the methods of the above embodiments can also be implemented by a computer program instructing associated hardware. The computer program can be stored in a computer-readable storage medium, and when executed by a processor, it can implement the steps of the various method embodiments described above. The computer program includes computer program code, which can be in the form of source code, object code, executable files, or certain intermediate forms. The computer-readable storage medium can include: any entity or device capable of carrying the computer program code, a recording medium, a USB flash drive, a portable hard drive, a magnetic disk, an optical disk, a computer-readable storage device, a read-only memory (ROM), a random access memory (RAM), an electrical carrier signal, a telecommunication signal, and a software distribution medium, etc. It should be noted that the contents of the aforementioned computer-readable storage media may be appropriately added to or subtracted from the contents according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, computer-readable storage media may not include electrical carrier signals and telecommunication signals.

[0186] The above embodiments are only used to illustrate the technical solutions of this application, and are not intended to limit them. Although this application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of this application, and should all be included within the protection scope of this application.

Claims

1. A report generation method, characterized in that, include: In response to user input about the application scenario, a set of scenario metrics adapted to the application scenario is generated, the set of scenario metrics including at least one metric for data analysis. Based on the various indicators in the aforementioned scenario indicator set, determine the report template; The database is analyzed based on the scenario indicator set, and the results of the data analysis are written into the report template to obtain a data analysis report.

2. The report generation method as described in claim 1, characterized in that, The information of the application scenario in response to user input generates a set of scenario metrics adapted to the application scenario, including: Based on the preset scenario-field correspondence, the target fields corresponding to the application scenario under each preset dimension are determined; Based on the target field and the preset field-index correspondence, a set of scenario indices that are adapted to the application scenario is generated.

3. The report generation method as described in claim 2, characterized in that, The preset field-index correspondence is determined in the following way: Multiple field sets are established, each field set belonging to a different preset dimension, and each field set includes at least one field; Extract no more than a preset number of fields from each of the aforementioned field sets to form a field combination; The association algorithm is used to perform association analysis on the data under the field combination in the database; If the results of the association analysis indicate that there is an association relationship between the field combination, an indicator is generated based on the field combination, and a correspondence is established between the indicator and the field combination.

4. The report generation method as described in claim 1, characterized in that, The step of determining the report template based on each indicator in the scenario indicator set includes: For each indicator in the scenario indicator set, determine the indicator type to which the indicator belongs; Based on the indicator type, determine the corresponding indicator text template; The report template is generated based on the indicator text template corresponding to each indicator.

5. The report generation method as described in claim 4, characterized in that, The step of determining the indicator text template corresponding to the indicator based on the indicator type includes: Determine the indicator text template corresponding to the indicator type; If there are two or more indicator text templates corresponding to the indicator type, a first target template is determined from the indicator text templates corresponding to the indicator type based on the user's user profile. The first target template is determined as the indicator text template corresponding to the indicator.

6. The report generation method as described in claim 5, characterized in that, The report generation method also includes: If the indicator text template corresponding to the indicator type is empty, or if a template creation instruction is received from the user, the template creation interface will be displayed. In response to the template text information received through the template creation interface, a second target template is generated; The second target template is determined as the indicator text template corresponding to the indicator.

7. The report generation method according to any one of claims 1 to 6, characterized in that, Before determining the report template based on each indicator in the scenario indicator set, the report generation method further includes: Based on the data filtering conditions input by the user and / or the user profile of the user, the scene indicator set is filtered to obtain a filtered indicator set. Accordingly, determining the report template based on each indicator in the scenario indicator set includes: The report template is determined based on each indicator in the set of filtering indicators.

8. A report generation device, characterized in that, include: The indicator set generation module is used to generate a scenario indicator set that is adapted to the application scenario in response to the application scenario information input by the user. The scenario indicator set includes at least one indicator for data analysis. The template determination module is used to determine the report template based on each indicator in the scenario indicator set; The data analysis module is used to perform data analysis on the database based on the scenario indicator set; The results writing module is used to write the results of data analysis into the report template to obtain a data analysis report.

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the computer program, it implements the method as described in any one of claims 1 to 7.

10. A computer-readable storage medium storing a computer program, characterized in that, When the computer program is executed by a processor, it implements the method as described in any one of claims 1 to 7.

Images