CN111400367A - Business report generation method and device, computer equipment and storage medium - Google Patents
Business report generation method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN111400367A CN111400367A CN202010129337.8A CN202010129337A CN111400367A CN 111400367 A CN111400367 A CN 111400367A CN 202010129337 A CN202010129337 A CN 202010129337A CN 111400367 A CN111400367 A CN 111400367A
- Authority
- CN
- China
- Prior art keywords
- data
- service
- report
- visualization
- analysis
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 50
- 238000012800 visualization Methods 0.000 claims abstract description 68
- 238000007405 data analysis Methods 0.000 claims abstract description 54
- 230000000007 visual effect Effects 0.000 claims abstract description 50
- 238000012216 screening Methods 0.000 claims abstract description 38
- 238000004458 analytical method Methods 0.000 claims abstract description 33
- 238000012545 processing Methods 0.000 claims abstract description 17
- 238000004590 computer program Methods 0.000 claims description 13
- 238000012544 monitoring process Methods 0.000 claims description 9
- 238000013079 data visualisation Methods 0.000 claims description 6
- 238000004891 communication Methods 0.000 claims description 5
- 238000007621 cluster analysis Methods 0.000 claims description 4
- 230000001360 synchronised effect Effects 0.000 claims description 2
- 238000010586 diagram Methods 0.000 description 6
- 238000013480 data collection Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000007796 conventional method Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000000586 desensitisation Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2465—Query processing support for facilitating data mining operations in structured databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application relates to a business report generation method, a business report generation device, computer equipment and a storage medium. The method comprises the following steps: acquiring a report generation request, wherein the report generation request carries request parameters; identifying a data table corresponding to the request parameter in a data analysis base according to first preset planning data; acquiring service data corresponding to the request parameters in the data table according to a pre-configured data screening condition; performing clustering analysis on the service data according to second preset planning data to obtain various service indexes; performing visualization processing on the service index according to a preset visualization strategy to obtain visualization data; and generating a service report corresponding to the report generation request according to the visual data. By adopting the method, the generation efficiency of the service report can be improved.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a method and an apparatus for generating a service report, a computer device, and a storage medium.
Background
During the business analysis process of an enterprise, corresponding original business data needs to be collected, and a business report is generated according to the original business data. In the conventional method, when data acquisition is performed on each data table, data screening conditions need to be set repeatedly, and data acquisition is performed according to the data screening conditions. Because the data screening conditions among different data tables cannot be multiplexed, when the data size of the data table is large, great repeated workload can be caused. Therefore, how to improve the service report generation efficiency by reducing the workload of data collection becomes a technical problem to be solved at present.
Disclosure of Invention
In view of the above, it is necessary to provide a business report generation method, an apparatus, a computer device, and a storage medium capable of improving the business report generation efficiency by reducing the workload of data acquisition.
A method of traffic report generation, the method comprising:
acquiring a report generation request, wherein the report generation request carries request parameters;
identifying a data table corresponding to the request parameter in a data analysis base according to first preset planning data;
acquiring service data corresponding to the request parameters in the data table according to a pre-configured data screening condition;
performing clustering analysis on the service data according to second preset planning data to obtain various service indexes;
performing visualization processing on the service index according to a preset visualization strategy to obtain visualization data;
and generating a service report corresponding to the report generation request according to the visual data.
In one embodiment, before the obtaining report generating request, the method further includes:
acquiring report configuration data;
generating first planning data and second planning data according to the report configuration data;
and configuring corresponding data screening conditions and visualization strategies for the first planning data and the second planning data.
In one embodiment, after the visualizing the service indicator according to the preconfigured data visualization policy to obtain the visualized data, the method further includes:
updating operation of the visual data by the receiving terminal to obtain updated visual data;
and dragging operation of the receiving terminal on the visual data to obtain the dragged visual data.
In one embodiment, after the visualizing the service indicator according to the preconfigured data visualization policy to obtain the visualized data, the method further includes:
acquiring a text description uploaded by a terminal;
and adding the text description into the visualized data to generate business analysis data corresponding to the visualized data.
In one embodiment, the report generation request further carries a user identifier, and the method further includes:
establishing connection with the data analysis base according to the user identification;
and calling multithreading, and identifying a data table corresponding to the request parameter in a data analysis base according to the first planning data through the multithreading.
In one embodiment, the performing cluster analysis on the service data according to the preconfigured second planning data to obtain multiple service indexes includes:
clustering the service data according to second preset planning data to obtain multiple data categories;
inputting various data types into a data analysis model, carrying out operation analysis on each data type through the data analysis model, and outputting various service indexes.
In one embodiment, the data in the data analysis library is obtained by synchronizing the data in the source database, and the method further includes:
monitoring the source database, and transmitting a database log of the source database to the data analysis database when monitoring the data writing operation of the source database;
and analyzing the database logs through the data analysis library to obtain data written in the source database.
An apparatus for generating a business report, the apparatus comprising:
the communication module is used for acquiring a report generation request, and the report generation request carries request parameters;
the identification module is used for identifying a data table corresponding to the request parameter in a data analysis base according to first preset planning data;
the acquisition module is used for acquiring the service data corresponding to the request parameters in the data table according to the pre-configured data screening conditions;
the clustering module is used for carrying out clustering analysis on the service data according to second preset planning data to obtain various service indexes;
the visualization module is used for performing visualization processing on the service index according to a preset visualization strategy to obtain visualization data;
and the first generation module is used for generating a service report corresponding to the report generation request according to the visualization data.
A computer device comprising a memory and a processor, the memory storing a computer program operable on the processor, the processor implementing the steps in the various method embodiments described above when executing the computer program.
A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the respective method embodiment described above.
The service report generation method, the service report generation device, the computer equipment and the storage medium acquire a report generation request, and the report generation request carries request parameters. And identifying a data table corresponding to the request parameter in the data analysis base according to the pre-configured first planning data, so as to collect the service data corresponding to the request parameter in the data table according to the pre-configured data screening condition, and performing cluster analysis on the service data according to the pre-configured second planning data to obtain various service indexes. And then, performing visualization processing on the service index according to a preset visualization strategy to obtain visualization data, and generating a service report corresponding to the report generation request according to the visualization data. After the data tables are identified according to the first planning data, the service data are collected in the data tables according to the data screening conditions, and the data screening conditions are pre-configured, so that the data screening conditions do not need to be set repeatedly for each data table, the multiplexing of the data screening conditions among the data tables is realized, and the workload of data collection is effectively reduced. And clustering analysis is carried out on the service data according to the second planning data, and the change trends of various service indexes can be obtained, so that a service report is generated through visual processing, and the generation efficiency of the service report is effectively improved.
Drawings
FIG. 1 is a diagram of an application environment of a method for generating a business report in one embodiment;
FIG. 2 is a flow diagram illustrating a method for generating a business report in one embodiment;
FIG. 3 is a flow diagram illustrating steps of configuring data filtering criteria and visualization policies in one embodiment;
FIG. 4 is a block diagram of a service report generation apparatus in one embodiment;
FIG. 5 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
The service report generation method provided by the application can be applied to the application environment shown in fig. 1. Wherein the terminal 102 and the server 104 communicate via a network. The server 104 obtains a report generation request sent by the terminal 102, and the report generation request carries request parameters. The server 104 identifies a data table corresponding to the request parameter in the data analysis base according to the pre-configured first planning data. The server 104 collects the service data corresponding to the request parameters in the data table according to the pre-configured data screening conditions. The server 104 performs clustering analysis on the service data according to the second planning data configured in advance to obtain various service indexes. The server 104 performs visualization processing on the service index according to a preset visualization strategy to obtain visualization data. The server 104 generates a service report corresponding to the report generation request according to the visualization data. The terminal 102 may be, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices. The server 104 may be implemented as a stand-alone server or as a server cluster comprised of multiple servers.
In one embodiment, as shown in fig. 2, a method for generating a service report is provided, which is described by taking the method as an example applied to the server in fig. 1, and includes the following steps:
And step 204, identifying a data table corresponding to the request parameter in the data analysis base according to the first preset planning data.
And step 206, acquiring the service data corresponding to the request parameters in the data table according to the pre-configured data screening conditions.
And the server receives a report generation request sent by the terminal, and analyzes the report generation request to obtain a request parameter. The request parameters may include request fields, acquisition conditions, type of service, etc. Wherein, the collection condition may be a data time. For example, the data time may be one week. For example, the service type may be a product sale service.
The server is pre-configured with first planning data. The first planning data may be a reference policy of the data table. For example, the data table may be a sales listing. The server can identify in the data analysis base according to the first planning data, so as to obtain a data table corresponding to the request parameter. The data analysis library stores business data to be analyzed.
And after the server identifies and obtains the data table corresponding to the request parameter, data acquisition is carried out in the data table according to the data screening condition. The data screening conditions are pre-configured in the server. The data screening conditions may include product type, product sales channel, and the like. The product type may be a product type corresponding to the service type. The product sale channel may be a sale channel corresponding to a product type. And the server determines the product type and the product sale channel according to the service type in the request parameter, so that the service data corresponding to the request parameter is collected in the data table according to the determined product type and the product sale channel.
In one embodiment, after the server identifies and obtains the data table corresponding to the request parameter, the server may also invoke multithreading, and collect the service data corresponding to the request parameter in parallel in the data table according to the data screening condition through the multithreading. The server calls the multithreading parallel acquisition service data, and the data acquisition efficiency can be further improved.
In one embodiment, the server can also perform desensitization processing on the acquired service data, so that data leakage is prevented, and the safety of the service data in the acquisition process is improved.
And 208, performing clustering analysis on the service data according to the second preset planning data to obtain various service indexes.
The second planning data may be preconfigured in the server. The second planning data may include a display policy of the business indicator and an invocation policy of the data analysis model. For example, the business indicator may include a product sales achievement rate. The analytical model may include a product analytical model, a user analytical model, and the like. And the server clusters the service data according to the second planning data to obtain multiple cluster categories. And the server performs operation analysis on each cluster type through a data analysis model called by the second rule data to obtain various service indexes.
And 210, performing visualization processing on the service indexes according to a preset visualization strategy to obtain visualization data.
And 212, generating a service report corresponding to the report generation request according to the visualization data.
The server is pre-configured with a visualization strategy. The visualization policy may be a user-defined visualization policy. The visualization strategy may include the type of chart used to present each business metric. For example, the visualization strategy may be a bar graph, pie chart, line chart, or the like. And the server performs visualization processing on the service indexes according to the visualization strategy to obtain visualized data, namely a plurality of service indexes and the chart type corresponding to each service index. Each service index and the chart type corresponding to the service index may correspond to one data display frame.
After the server obtains the visual data, layout adjustment can be performed on the visual data. Specifically, the server may receive an update operation of the terminal on the visual data, and may also receive a drag operation of the terminal on the visual data. The visual data are subjected to layout adjustment, so that the visual data meeting the user requirements are obtained, and the subsequent business report meeting the user requirements can be obtained.
After the server obtains the visualization data, a service report corresponding to the report generation request can be generated according to the visualization data. The server stores the service report, and the server can also send the service report to the terminal, so that the terminal can derive the service report. The server may also modify the generated traffic report. Specifically, the server may receive a deletion operation of the terminal on the visual data in the service report, and may also receive a drag operation of the terminal on the visual data in the service report.
In this embodiment, the server obtains a report generation request, where the report generation request carries the request parameters. And identifying a data table corresponding to the request parameter in the data analysis base according to the pre-configured first planning data, so as to collect the service data corresponding to the request parameter in the data table according to the pre-configured data screening condition, and performing cluster analysis on the service data according to the pre-configured second planning data to obtain various service indexes. And then, performing visualization processing on the service index according to a preset visualization strategy to obtain visualization data, and generating a service report corresponding to the report generation request according to the visualization data. After the data tables are identified according to the first planning data, the service data are collected in the data tables according to the data screening conditions, and the data screening conditions are pre-configured, so that the data screening conditions do not need to be set repeatedly for each data table, the multiplexing of the data screening conditions among the data tables is realized, and the workload of data collection is effectively reduced. And clustering analysis is carried out on the service data according to the second planning data, and the change trends of various service indexes can be obtained, so that a service report is generated through visual processing, and the generation efficiency of the service report is effectively improved.
In one embodiment, as shown in fig. 3, before obtaining the report generation request, the method further includes: configuring a data screening condition and a visualization strategy, which specifically comprises the following steps:
And step 306, configuring corresponding data screening conditions and visualization strategies for the first planning data and the second planning data.
The server acquires the report configuration data sent by the terminal. The report configuration data is used to configure the role of the content of each part of the report in the report. The report configuration data may include report content planning data. The server generates first planning data and second planning data according to the report configuration data. Wherein the first planning data may be a reference policy of the data table. For example, the data table may be a sales listing. The server may identify a data table in the data analysis base corresponding to the request parameter based on the first planning data. The second planning data may include a display policy of the business indicator and an invocation policy of the data analysis model. For example, the business indicator may include a product sales achievement rate. The analytical model may include a product analytical model, a user analytical model, and the like. The server can perform clustering analysis on the service data according to the second planning data, so that various service indexes are obtained.
The server performs basic configuration on the first planning data and the second planning data. The base configuration may include data screening conditions and visualization strategies. The data screening conditions may include product types, product sales channels, and the like. The product type may be a product type corresponding to the service type. The product sale channel may be a sale channel corresponding to a product type. And the server collects the service data corresponding to the request parameters in the data table according to the data screening conditions. When data in a plurality of data tables are collected, data screening conditions do not need to be set repeatedly, and the server can collect the data in the data tables according to the data screening conditions configured in advance. The visualization policy may be a user-defined visualization policy. The visualization strategy may include the type of chart used to present each business metric. For example, the visualization strategy may be a bar graph, pie chart, line chart, or the like. The server can perform visualization processing on the service index according to the visualization strategy to obtain visualization data.
In this embodiment, the server acquires the report configuration data and generates the first planning data and the second planning data according to the report configuration data, so as to configure corresponding data screening conditions and visualization strategies for the first planning data and the second planning data, when a report generation request is acquired, the server can identify a data table corresponding to the request parameter according to the preconfigured first planning data, acquire service data corresponding to the request parameter in the data table according to the data screening conditions, and do not need to repeatedly set the screening conditions when data acquisition is performed. The second planning data and the visualization strategy are also pre-configured, so that the generation efficiency of the service report can be effectively improved.
In one embodiment, after performing visualization processing on the service indicator according to a preconfigured data visualization policy to obtain visualized data, the method further includes: updating operation of the receiving terminal on the visual data to obtain updated visual data; and dragging operation of the receiving terminal on the visual data to obtain the dragged visual data.
The visual data may be a plurality of business indicators and a chart type corresponding to each business indicator. Each service index and the chart type corresponding to the service index may correspond to one data display frame. After the server obtains the visual data, the server can receive the updating operation of the terminal on the visual data. The updating operation may include operations of deleting a service index, adding a service index, deleting an icon type corresponding to the service index, adding an icon type corresponding to the service index, and the like in the visual data. And the server obtains the updated visual data according to the updating operation. The server can also receive the dragging operation of the terminal on the visual data. The dragging operation may include operations such as position dragging and scale adjustment of the icon type corresponding to the service index. And the server obtains the dragged visual data through dragging operation.
In this embodiment, the server updates and drags the visual data through the receiving terminal, so as to obtain the dragged visual data, and can flexibly perform layout adjustment on the visual data.
In one embodiment, after performing visualization processing on the service indicator according to a preconfigured data visualization policy to obtain visualized data, the method further includes: acquiring a text description uploaded by a terminal; and adding the text description into the visual data to generate business analysis data corresponding to the visual data.
And after the server obtains the visual data, the server can receive the text description uploaded by the terminal. The text description can be obtained by analyzing the actual service through visual data uploaded by the terminal. And the server adds the received text description to the visual data so as to obtain business analysis data corresponding to the visual data. For example, business analysis data may be a sales target achievement of 9 months, with a 2.3% increase in the ring over the previous month.
In this embodiment, the server adds the obtained text description to the visual data to obtain business analysis data corresponding to the visual data, so as to implement business analysis on the visual data as a whole and obtain a more complete business report.
In one embodiment, the report generation request further carries a user identifier, and the method further includes: establishing connection with a data analysis base according to the user identification; and calling multithreading, and identifying a data table corresponding to the request parameter in the data analysis base according to the first planning data through multithreading.
After acquiring the report generation request, the server analyzes the report generation request to obtain the user identifier. And the server establishes connection with the data analysis base according to the user identification, so that the server calls multithreading to perform data table identification in the data analysis base according to the first planning data to obtain a data table corresponding to the request parameter. The connection is established between the user identification and the data analysis base, so that the subsequent data acquisition is facilitated. By calling the multithread to identify the data table corresponding to the request parameter in the data analysis base, the identification efficiency of the data table can be improved, so that the data acquisition efficiency is further improved, and the generation efficiency of the service report is further improved.
In one embodiment, the clustering analysis of the service data according to the preconfigured second planning data to obtain the plurality of service indexes includes: clustering the service data according to the second preset planning data to obtain various data categories; and inputting various data types into a data analysis model, performing operation analysis on each data type through the data analysis model, and outputting various service indexes.
The second planning data may include a display policy of the business indicator and an invocation policy of the data analysis model. For example, the business indicator may include a product sales achievement rate. And the server clusters the service data according to the second planning data to obtain multiple data categories. The data category may be a data category corresponding to the business indicator. The data categories may include product categories, product sales data. For example, the data category to which the product sales achievement rate corresponds may be product sales data.
The analytical model may include a product analytical model, a user analytical model, and the like. And the server calls the analysis model, and inputs various data types into the corresponding analysis model for operation, so that various service indexes are obtained. And the server analyzes the change trend of the service index corresponding to the data type through the analysis model to obtain the dynamic change trend of the service index. For example, the server compares the index values of the service index in 9 months and 8 months through the analysis model, and determines whether the service index rises or falls, so as to obtain the corresponding service index.
In this embodiment, the server clusters the service data according to the second planning data configured in advance to obtain a plurality of data categories, and performs service index analysis on each data category to improve data analysis efficiency. The server performs operation analysis on each data category through the data analysis model to obtain various service indexes, can obtain the variation trend of each service index, and is beneficial to the subsequent generation of service reports.
In one embodiment, the data in the data analysis database is obtained by synchronizing the data in the source database, and the method further includes: monitoring a source database, and transmitting a database log of the source database to a data analysis database when monitoring data writing operation of the source database; and analyzing the database logs through the data analysis library to obtain data written in the source database.
The server can monitor the source database in the process of generating the service report, and when it is monitored that data is written in the source database, the database log can be transmitted to the data analysis base through the source database in a streaming mode, wherein the database log can be WA L (Write-Ahead L logging).
After the database log is obtained by the data analysis base, the database log is analyzed to obtain data written in the source database, so that the service data are synchronized to the data analysis base from the source database, the analysis data in the data analysis base are separated from the service data in the source database, and the identification efficiency of the data table can be improved.
It should be understood that although the steps in the flowcharts of fig. 2 to 3 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least some of the steps in fig. 2-3 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performing the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternately with other steps or at least some of the sub-steps or stages of other steps.
In one embodiment, as shown in fig. 4, there is provided a service report generation apparatus, including: a communication module 402, an identification module 404, an acquisition module 406, a clustering module 408, a visualization module 410, and a first generation module 412, wherein:
the communication module 402 is configured to obtain a report generation request, where the report generation request carries a request parameter.
The identifying module 404 is configured to identify a data table corresponding to the request parameter in the data analysis base according to the preconfigured first planning data.
And the acquisition module 406 is configured to acquire service data corresponding to the request parameter in the data table according to the preconfigured data screening condition.
And the clustering module 408 is configured to perform clustering analysis on the service data according to the preconfigured second planning data to obtain multiple service indexes.
And the visualization module 410 is configured to perform visualization processing on the service indicator according to a preconfigured visualization policy to obtain visualization data.
And the first generating module 412 is configured to generate a service report corresponding to the report generating request according to the visualization data.
In one embodiment, the above apparatus further comprises: a communication module for obtaining report configuration data; the second generation module is used for generating first planning data and second planning data according to the report configuration data; and the configuration module is used for configuring corresponding data screening conditions and visualization strategies for the first planning data and the second planning data.
In one embodiment, the above apparatus further comprises: the dragging module is used for receiving the updating operation of the terminal on the visual data to obtain the updated visual data; and dragging operation of the receiving terminal on the visual data to obtain the dragged visual data.
In one embodiment, the above apparatus further comprises: the adding module is used for acquiring the text description uploaded by the terminal; and adding the text description into the visual data to generate business analysis data corresponding to the visual data.
In one embodiment, the above apparatus further comprises:
the connection module is used for establishing connection with the data analysis database according to the user identification;
the identification module is further used for calling multithreading and identifying a data table corresponding to the request parameter in the data analysis base according to the first planning data through multithreading.
In an embodiment, the clustering module 408 is further configured to cluster the service data according to the preconfigured second planning data to obtain multiple data categories; and inputting various data types into a data analysis model, performing operation analysis on each data type through the data analysis model, and outputting various service indexes.
In one embodiment, the above apparatus further comprises: the monitoring module is used for monitoring the source database and transmitting the database log of the source database to the data analysis database when monitoring the data writing operation of the source database; and analyzing the database logs through the data analysis library to obtain data written in the source database.
For specific limitations of the service report generating device, see the above limitations on the service report generating method, which are not described herein again. The modules in the service report generation device can be wholly or partially implemented by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 5. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used for storing data tables and business data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a business report generation method.
Those skilled in the art will appreciate that the architecture shown in fig. 5 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory storing a computer program and a processor implementing the steps of the various embodiments described above when the processor executes the computer program.
In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the respective embodiments described above.
It will be understood by those of ordinary skill in the art that all or a portion of the processes of the methods of the embodiments described above may be implemented by a computer program that may be stored on a non-volatile computer-readable storage medium, which when executed, may include the processes of the embodiments of the methods described above, wherein any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory.
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A method for generating a service report, the method comprising:
acquiring a report generation request, wherein the report generation request carries request parameters;
identifying a data table corresponding to the request parameter in a data analysis base according to first preset planning data;
acquiring service data corresponding to the request parameters in the data table according to a pre-configured data screening condition;
performing clustering analysis on the service data according to second preset planning data to obtain various service indexes;
performing visualization processing on the service index according to a preset visualization strategy to obtain visualization data;
and generating a service report corresponding to the report generation request according to the visual data.
2. The method of claim 1, further comprising, prior to the request for generation of the acquisition report:
acquiring report configuration data;
generating first planning data and second planning data according to the report configuration data;
and configuring corresponding data screening conditions and visualization strategies for the first planning data and the second planning data.
3. The method according to claim 1, wherein after the visualizing the service indicator according to the preconfigured data visualization policy to obtain the visualized data, the method further comprises:
updating operation of the visual data by the receiving terminal to obtain updated visual data;
and dragging operation of the receiving terminal on the visual data to obtain the dragged visual data.
4. The method according to claim 1, wherein after the visualizing the service indicator according to the preconfigured data visualization policy to obtain the visualized data, the method further comprises:
acquiring a text description uploaded by a terminal;
and adding the text description into the visualized data to generate business analysis data corresponding to the visualized data.
5. The method of claim 1, wherein the report generation request further carries a user identifier, the method further comprising:
establishing connection with the data analysis base according to the user identification;
and calling multithreading, and identifying a data table corresponding to the request parameter in a data analysis base according to the first planning data through the multithreading.
6. The method of claim 1, wherein the performing cluster analysis on the service data according to the pre-configured second planning data to obtain a plurality of service indicators comprises:
clustering the service data according to second preset planning data to obtain multiple data categories;
inputting various data types into a data analysis model, carrying out operation analysis on each data type through the data analysis model, and outputting various service indexes.
7. The method of claim 1, wherein the data in the data analysis library is synchronized with the data in the source database, and wherein the method further comprises:
monitoring the source database, and transmitting a database log of the source database to the data analysis database when monitoring the data writing operation of the source database;
and analyzing the database logs through the data analysis library to obtain data written in the source database.
8. An apparatus for generating a service report, the apparatus comprising:
the communication module is used for acquiring a report generation request, and the report generation request carries request parameters;
the identification module is used for identifying a data table corresponding to the request parameter in a data analysis base according to first preset planning data;
the acquisition module is used for acquiring the service data corresponding to the request parameters in the data table according to the pre-configured data screening conditions;
the clustering module is used for carrying out clustering analysis on the service data according to second preset planning data to obtain various service indexes;
the visualization module is used for performing visualization processing on the service index according to a preset visualization strategy to obtain visualization data;
and the first generation module is used for generating a service report corresponding to the report generation request according to the visualization data.
9. A computer device comprising a memory and a processor, the memory storing a computer program operable on the processor, wherein the processor implements the steps of the method of any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010129337.8A CN111400367B (en) | 2020-02-28 | 2020-02-28 | Service report generation method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010129337.8A CN111400367B (en) | 2020-02-28 | 2020-02-28 | Service report generation method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111400367A true CN111400367A (en) | 2020-07-10 |
| CN111400367B CN111400367B (en) | 2023-12-29 |
Family
ID=71432150
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010129337.8A Active CN111400367B (en) | 2020-02-28 | 2020-02-28 | Service report generation method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111400367B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112131837A (en) * | 2020-09-22 | 2020-12-25 | 平安证券股份有限公司 | Service report configuration method, device, computer equipment and storage medium |
| CN112215514A (en) * | 2020-10-22 | 2021-01-12 | 星云海数字科技股份有限公司 | Operation analysis report generation method and system |
| CN112395349A (en) * | 2020-11-17 | 2021-02-23 | 平安普惠企业管理有限公司 | Early warning method, device, equipment and storage medium for visual report |
| CN113297190A (en) * | 2021-05-11 | 2021-08-24 | 浪潮卓数大数据产业发展有限公司 | Visualization method, device and medium based on data comprehensive analysis |
| CN117235156A (en) * | 2023-08-04 | 2023-12-15 | 上海数禾信息科技有限公司 | Data analysis processing method, device, computer equipment and storage medium |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2009259214A (en) * | 2008-03-19 | 2009-11-05 | Nec Corp | Audit system, external audit device, external audit method, and external audit program |
| US20100318583A1 (en) * | 2009-06-16 | 2010-12-16 | Jonathan Cohen | Data-visualization system and method |
| CN102486740A (en) * | 2010-12-03 | 2012-06-06 | 中国科学院沈阳自动化研究所 | Multithreading real-time data processing device and method |
| CN103164510A (en) * | 2013-02-05 | 2013-06-19 | 广东全通教育股份有限公司 | Method and system of generating dynamic data table |
| CN103728117A (en) * | 2013-12-27 | 2014-04-16 | 国家海洋技术中心 | System for collecting and analyzing water power test data of marine monitoring instrument device model |
| US20160055594A1 (en) * | 2014-02-20 | 2016-02-25 | Buildfax, Inc. | Method of using building permits to identify underinsured properties |
| CN107391468A (en) * | 2017-06-15 | 2017-11-24 | 华为技术有限公司 | A kind of method, apparatus and equipment for adding chart |
| CN107451224A (en) * | 2017-07-17 | 2017-12-08 | 广州特道信息科技有限公司 | A kind of clustering method and system based on big data parallel computation |
| CN109739818A (en) * | 2018-12-28 | 2019-05-10 | 浪潮软件股份有限公司 | A kind of portable high-throughput big data acquisition method and system |
| CN109784721A (en) * | 2019-01-15 | 2019-05-21 | 东莞市友才网络科技有限公司 | A kind of plateform system of employment data analysis and data mining analysis |
| CN109920506A (en) * | 2019-01-23 | 2019-06-21 | 平安科技（深圳）有限公司 | Medical care statistics report-generating method, device, equipment and storage medium |
-
2020
- 2020-02-28 CN CN202010129337.8A patent/CN111400367B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2009259214A (en) * | 2008-03-19 | 2009-11-05 | Nec Corp | Audit system, external audit device, external audit method, and external audit program |
| US20100318583A1 (en) * | 2009-06-16 | 2010-12-16 | Jonathan Cohen | Data-visualization system and method |
| CN102486740A (en) * | 2010-12-03 | 2012-06-06 | 中国科学院沈阳自动化研究所 | Multithreading real-time data processing device and method |
| CN103164510A (en) * | 2013-02-05 | 2013-06-19 | 广东全通教育股份有限公司 | Method and system of generating dynamic data table |
| CN103728117A (en) * | 2013-12-27 | 2014-04-16 | 国家海洋技术中心 | System for collecting and analyzing water power test data of marine monitoring instrument device model |
| US20160055594A1 (en) * | 2014-02-20 | 2016-02-25 | Buildfax, Inc. | Method of using building permits to identify underinsured properties |
| CN107391468A (en) * | 2017-06-15 | 2017-11-24 | 华为技术有限公司 | A kind of method, apparatus and equipment for adding chart |
| CN107451224A (en) * | 2017-07-17 | 2017-12-08 | 广州特道信息科技有限公司 | A kind of clustering method and system based on big data parallel computation |
| CN109739818A (en) * | 2018-12-28 | 2019-05-10 | 浪潮软件股份有限公司 | A kind of portable high-throughput big data acquisition method and system |
| CN109784721A (en) * | 2019-01-15 | 2019-05-21 | 东莞市友才网络科技有限公司 | A kind of plateform system of employment data analysis and data mining analysis |
| CN109920506A (en) * | 2019-01-23 | 2019-06-21 | 平安科技（深圳）有限公司 | Medical care statistics report-generating method, device, equipment and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 蒋晓宇;: "基于tableau可视化业务报表设计与实现", 数字通信世界, no. 02 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112131837A (en) * | 2020-09-22 | 2020-12-25 | 平安证券股份有限公司 | Service report configuration method, device, computer equipment and storage medium |
| CN112131837B (en) * | 2020-09-22 | 2023-11-03 | 平安证券股份有限公司 | Service report configuration method, device, computer equipment and storage medium |
| CN112215514A (en) * | 2020-10-22 | 2021-01-12 | 星云海数字科技股份有限公司 | Operation analysis report generation method and system |
| CN112395349A (en) * | 2020-11-17 | 2021-02-23 | 平安普惠企业管理有限公司 | Early warning method, device, equipment and storage medium for visual report |
| CN113297190A (en) * | 2021-05-11 | 2021-08-24 | 浪潮卓数大数据产业发展有限公司 | Visualization method, device and medium based on data comprehensive analysis |
| CN113297190B (en) * | 2021-05-11 | 2022-07-12 | 浪潮卓数大数据产业发展有限公司 | Visualization method, device and medium based on data comprehensive analysis |
| CN117235156A (en) * | 2023-08-04 | 2023-12-15 | 上海数禾信息科技有限公司 | Data analysis processing method, device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111400367B (en) | 2023-12-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111400367A (en) | Business report generation method and device, computer equipment and storage medium | |
| US11258693B2 (en) | Collaborative incident management for networked computing systems | |
| US11481209B2 (en) | Intelligent software agent to facilitate software development and operations | |
| US9996409B2 (en) | Identification of distinguishable anomalies extracted from real time data streams | |
| CN107566163B (en) | Alarm method and device for user behavior analysis association | |
| US10884891B2 (en) | Interactive detection of system anomalies | |
| US9590880B2 (en) | Dynamic collection analysis and reporting of telemetry data | |
| CN111294217B (en) | Alarm analysis method, device, system and storage medium | |
| CN109284251A (en) | Blog management method, device, computer equipment and storage medium | |
| US11502930B2 (en) | Method and system for generating alerts using parameter based network monitoring for alert conditions | |
| CN111694718A (en) | Method and device for identifying abnormal behavior of intranet user, computer equipment and readable storage medium | |
| CN107566172B (en) | Active management method and system based on storage system | |
| US20100186004A1 (en) | Data analysis system and method | |
| CN110704095A (en) | Workflow-based configuration processing method and device, computer equipment and storage medium | |
| US20190303112A1 (en) | Replacement algorithm selection platform | |
| CN114218309A (en) | Data processing method, system and computer equipment | |
| CN112783720A (en) | Topological structure diagram generation method and device, computer equipment and display system | |
| CN114185750A (en) | Process monitoring method, device, equipment and storage medium | |
| CN112596723B (en) | Database script generation method, device, equipment and medium | |
| CN113821254A (en) | Interface data processing method, device, storage medium and equipment | |
| CN113836237A (en) | Method and device for auditing data operation of database | |
| CN109726231A (en) | Work order data display method, device, computer equipment and storage medium | |
| CN113419935A (en) | Mobile terminal performance monitoring method, device, equipment and storage medium | |
| CN111857920A (en) | Popup window processing method and device, computer equipment and storage medium | |
| CN113672449A (en) | Intelligent operation and maintenance abnormity monitoring method and device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |