BI report pushing method and device, electronic equipment and medium

By using the IMAP server to receive data, data cleaning, grouping, and chart generation tools in the BI report push system to generate reports, and send them regularly, the problems of low efficiency, poor accuracy and poor user experience of BI report push are solved, and efficient and accurate report push and improved user experience are achieved.

CN119597835APending Publication Date: 2025-03-11PICC LIFE INSURANCE CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411655767.8
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-11-19
Publication Date
2025-03-11

AI Technical Summary

Technical Problem

In the prior art, BI report push has problems such as low efficiency, poor accuracy and poor user experience.

Method used

By receiving source data asynchronously based on the IMAP server, cleaning and grouping data, using the chart generation tool to generate BI reports, and send them to the target object regularly.

Benefits of technology

It improves the efficiency and accuracy of BI report push, improves the user experience, and realizes the automatic push of BI report.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119597835A_ABST
    Figure CN119597835A_ABST
Patent Text Reader

Abstract

The invention provides a BI report pushing method and device, electronic equipment and a medium, and relates to the technical field of computers. The BI report pushing method comprises the steps that based on an IMAP server, source data of a report system are received asynchronously, and the report system supports IMAP service; based on the source data, obtaining to-be-generated data through data cleaning and grouping; according to the to-be-generated data, using a chart generation tool to generate a BI report; and periodically sending the BI report to the target object. Through the technical scheme provided by the invention, the problems of low efficiency, poor accuracy and poor user experience in BI report pushing in related technologies are solved, the pushing efficiency and accuracy are improved, and the user experience is improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present disclosure relates to the field of computer technology, and in particular to a BI report push method, device, electronic device and medium. Background Art

[0002] In the related art, the business intelligence (BI) reports of enterprises usually rely on manual collection, collation of data and manual report preparation. This process is not only time-consuming and labor-intensive, but also prone to errors and cannot meet the strict requirements of modern enterprises for data immediacy, accuracy and good user experience. In other words, in the related art, BI report push has the problems of low efficiency, poor accuracy and poor user experience. Summary of the invention

[0003] The present disclosure provides a BI report push method, device, electronic device and medium to solve the problems of low efficiency, poor accuracy and poor user experience in BI report push in related technologies. By automatically generating BI reports containing different chart information and accurately pushing BI reports to target users, the push efficiency and accuracy are improved, and the user experience is enhanced.

[0004] A first aspect of the present disclosure provides a BI report push method, the method comprising:

[0005] Based on the IMAP server, the source data of the reporting system is asynchronously received. The reporting system supports IMAP service.

[0006] Based on the source data, the data to be generated is obtained through data cleaning and grouping;

[0007] Generate BI reports using chart generation tools based on the data to be generated;

[0008] Send BI reports to target objects regularly.

[0009] In one embodiment of the present disclosure, based on source data, data to be generated is obtained by data cleaning and grouping, including:

[0010] Parse source data into data to be processed;

[0011] Performing data cleaning on the data to be processed to obtain first data;

[0012] Counting mathematical features of the first data and grouping them into second data;

[0013] The second data is aggregated into data to be generated.

[0014] In one embodiment of the present disclosure, a BI report is generated by a chart generation tool according to the data to be generated, including:

[0015] According to the preset report requirements, set the type, data source and display parameters of the target chart;

[0016] Generate target charts through chart generation tools;

[0017] Use Django's template function to embed the target chart into the web page to generate a BI report.

[0018] In one embodiment of the present disclosure, regularly sending a BI report to a target object includes:

[0019] Determine the first time and interval of message push based on the target object's active time and terminal device usage;

[0020] Send BI reports to the target object regularly, with the interval length as the cycle and the first time as the starting time point.

[0021] In one embodiment of the present disclosure, parsing source data into data to be processed includes:

[0022] Adapt the corresponding data reading interface according to the type and data format of the data source;

[0023] Based on the data reading interface, the source data is parsed into data to be processed.

[0024] In one embodiment of the present disclosure, before regularly sending a BI report to a target object, the method further includes:

[0025] Configure instant messaging software and / or email as the target communication tool, which is used to push BI reports to the target object.

[0026] The second aspect of the present disclosure provides a BI report push device, which is applied to a server. The device includes:

[0027] The data acquisition module is used to asynchronously receive the source data of the reporting system based on the IMAP server. The reporting system supports the IMAP service.

[0028] A data processing module is used to obtain the data to be generated through data cleaning and grouping based on the source data;

[0029] The report generation module is used to generate BI reports using chart generation tools based on the data to be generated;

[0030] The push module is used to send BI reports to the target objects regularly.

[0031] The third aspect embodiment of the present disclosure proposes an electronic device, comprising: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute any one of the methods in the first aspect embodiment of the present disclosure.

[0032] The fourth aspect embodiment of the present disclosure proposes a non-transitory computer-readable storage medium storing computer instructions, characterized in that the computer instructions are used to enable a computer to execute the method in the first aspect embodiment of the present disclosure.

[0033] The fifth aspect embodiment of the present disclosure proposes a computer program product, characterized in that it includes a computer program, and when the computer program is executed by a processor, it implements any method in the first aspect embodiment of the present disclosure.

[0034] In summary, the BI report push method proposed in this disclosure achieves the following beneficial effects:

[0035] Based on the IMAP server, the source data of the report system is received asynchronously. The report system supports IMAP services and provides source data for generating BI reports. Based on the source data, the data to be generated is obtained through data cleaning and grouping, and accurate data of different groups is obtained. According to the data to be generated, the BI report is generated using the chart generation tool, the data is visualized, and the user experience is improved. The BI report is sent to the target object regularly to improve the push efficiency. The automatic push of BI reports is realized, which improves the push efficiency, accuracy and user experience.

[0036] It is to be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present disclosure. BRIEF DESCRIPTION OF THE DRAWINGS

[0037] The drawings herein are incorporated into and constitute a part of the specification, illustrate embodiments consistent with the present disclosure, and together with the description are used to explain the principles of the present disclosure, and do not constitute improper limitations on the present disclosure.

[0038] Figure 1 A flowchart of a BI report push method according to an embodiment of the present disclosure;

[0039] Figure 2 This is a flow chart of an embodiment of the present disclosure, which is based on source data and obtains data to be generated through data cleaning and grouping;

[0040] Figure 3 A flowchart of an embodiment of the present disclosure for generating a BI report using a chart generation tool according to data to be generated;

[0041] Figure 4 This is a flow chart of regularly sending BI reports to target objects according to an embodiment of the present disclosure;

[0042] Figure 5 A flowchart of parsing source data into data to be processed according to an embodiment of the present disclosure;

[0043] Figure 6 A flowchart of configuring a communication tool according to an embodiment of the present disclosure;

[0044] Figure 7 A structural diagram of a BI report push system according to an embodiment of the present disclosure;

[0045] Figure 8 This is a structural diagram of a BI report push device according to an embodiment of the present disclosure;

[0046] Fig. 9 is a block diagram of an electronic device for implementing the BI report push method disclosed in the present invention according to an exemplary embodiment;

[0047] Fig.10 It is a schematic diagram of the structure of the chip of the embodiment of the present disclosure. DETAILED DESCRIPTION

[0048] Embodiments of the present disclosure are described in detail below, and examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals throughout identify the same or similar originals or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to be used to explain the present disclosure, and should not be construed as limiting the present disclosure.

[0049] First, a brief introduction to the relevant terms in this disclosure is given:

[0050] BI report: In this disclosure, it refers to a visual report generated by BI tools to display enterprise operation data. These reports usually contain key performance indicators (KPIs), business details and trend analysis, helping management and business personnel quickly obtain the required information to support the decision-making process.

[0051] Django: In this disclosure, it refers to a high-level Python web framework that aims to simplify the development of complex database-driven websites. It follows the MTV (Model-Template-View) architectural pattern, emphasizing component reusability and rapid development. It has built-in security features such as CSRF protection and SQL injection protection to ensure the safe and stable operation of the system.

[0052] APScheduler: In this disclosure, it refers to a flexible task scheduling management library that can schedule tasks to be automatically executed at specific time points or at predetermined time intervals. It is suitable for handling periodic data updates, report generation, etc. It allows tasks to be executed asynchronously in the background without affecting the front-end user experience, ensuring the system's responsiveness and stability.

[0053] Pandas: In this disclosure, it refers to an efficient data processing library for data analysis. It provides rich functions for data cleaning, conversion, and aggregation, can efficiently process structured data, and supports complex data analysis tasks. It supports reading and writing operations in multiple data formats, such as CSV, Excel, SQL databases, etc., which facilitates data import, export, and integration.

[0054] Pyecharts: In this disclosure, it refers to a dynamic data visualization library that can be used for interactive charts. Based on ECharts, it provides a set of Python interfaces for generating interactive charts, allowing developers to easily create a variety of chart types, improve the intuitiveness of data display and user interaction experience. It can be highly customized and supports deep customization of charts, including color, style, prompt information, etc. It can be flexibly adjusted according to business needs to enhance data narrative capabilities.

[0055] Internet Message Access Protocol (IMAP) server: In this disclosure, it refers to a server for receiving and managing emails. IMAP allows users to access and operate emails directly on the server, and the IMAP server supports real-time synchronization, allowing users to access the latest email content from any device without worrying about data loss or inconsistency.

[0056] Currently, enterprises widely adopt BI tools and Robotic Process Automation (RPA) technology as the two pillars to improve data processing efficiency and business process automation. BI tools focus on deep data mining, analysis and rich report generation functions to help enterprises gain insight into market trends; while RPA is good at imitating human operations and automating highly repetitive and rule-based tasks, such as data entry and file processing. Although these technologies have achieved remarkable results in improving work efficiency and reducing human errors, most of them are based on static rules. Faced with the complexity and variability of business logic, the surge in real-time data processing needs, and the urgent call for intelligent decision support, traditional solutions seem to be inadequate, especially in adaptive learning, active intelligent intervention, and highly personalized user experience construction. There are obvious limitations. Therefore, related technologies have problems such as inaccurate BI report push and poor user experience.

[0057] The method proposed in the present disclosure is applied to report push tasks, and its application has rich scenarios. For enterprise management, key business indicators (KPI) and financial statements are pushed regularly to help management make strategic plans and decisions. For sales and marketing, sales performance reports are sent to the sales team to keep abreast of market trends and customer needs and optimize sales strategies. For operation monitoring, in the manufacturing or service industries, operation data is pushed in real time to monitor production efficiency and service quality for timely adjustments. For project management, reports on project progress and resource usage are provided to project managers to support effective project control. For customer relationship management, customer analysis reports are pushed to help companies understand customer behavior and improve customer satisfaction. For financial analysis, financial statements are sent regularly to support budget control, cost analysis and financial auditing. For education and training, educational institutions use reports to track student performance to improve teaching methods. For medical health: patient data analysis reports are pushed to help doctors make better medical decisions. Through these applications, BI report push technology not only improves the visualization of data, but also enhances the efficiency and accuracy of information transmission, thereby significantly improving user experience. The application scenarios are not limited in the embodiments of the present disclosure.

[0058] The BI report push method provided by the present disclosure is described in detail below with reference to the accompanying drawings.

[0059] Figure 1 FIG. 1 is a flow chart of a BI report push method according to an embodiment of the present disclosure. The BI report push method is applied to a server. Figure 1 In the embodiment shown, the BI report push method includes:

[0060] Step 101: asynchronously receive source data of a report system based on an IMAP server, and the report system supports IMAP service.

[0061] Source data refers to the raw data extracted from the reporting system or other data sources, which will be used to generate BI reports after processing. In the BI report push method, source data can include various business-related data, such as sales records, customer information, financial data, etc. These data usually need to be cleaned and grouped to ensure their accuracy and availability, thereby providing a basis for subsequent data analysis and report generation. The reporting system is a software tool or platform for generating, managing and distributing business reports, supporting IMAP services.

[0062] Specifically, define an asynchronous function to connect to the IMAP server and log in to the specified mailbox account, implement the mail retrieval logic, filter mails according to preset conditions (such as mail subject, sender, time range, etc.), asynchronously download selected mail attachments, especially report files, for subsequent processing, and disconnect from the IMAP server after processing the mails. Furthermore, use the connection pool to manage IMAP connections, reduce the overhead of frequent establishment and closing of connections, introduce a cache mechanism to cache commonly used mail data, improve retrieval efficiency, set reasonable timeout and retry strategies, and ensure the reliability and stability of mail collection.

[0063] In a possible implementation of this embodiment, Django's asynchronous mail processing module is used in combination with aiohttp and asyncio libraries, and Python's imaplib module. Aiohttp is used as an asynchronous HTTP client to communicate with the IMAP server. The event loop provided by asyncio is used to implement non-blocking mail retrieval and collection. The imaplib library is used to interact with the IMAP server to perform mail retrieval and download operations. Through this implementation, the ability to fully automate data capture and send to the server is achieved.

[0064] Step 102: Based on the source data, the data to be generated is obtained by data cleaning and grouping.

[0065] The data to be generated refers to the data used to generate BI reports. After obtaining the source data, it is not possible to directly process the data due to inconsistencies in the data format and type. Data cleaning and grouping are required. After the processing is completed, the data to be generated can be obtained.

[0066] Step 103: Generate a BI report using a chart generation tool based on the data to be generated.

[0067] A chart generation tool refers to a tool or library that visualizes data. For example, the Pyecharts package supported by Python provides a variety of chart types and highly customizable options. Based on the data to be generated, a chart generation tool can be used to generate a chart, which can be used to create a BI report.

[0068] Step 104: Send BI reports to the target object regularly.

[0069] The target object refers to the recipient of the BI report. After the server completes the BI report, it sends it to the target object regularly.

[0070] In summary, according to the BI report push method proposed in the present disclosure, based on the IMAP server, the source data of the report system is asynchronously received, and the report system supports the IMAP service, which provides the source data for generating BI reports; based on the source data, the data to be generated is obtained through data cleaning and grouping, and accurate data of different groups is obtained; according to the data to be generated, a chart generation tool is used to generate a BI report, the data is visualized, and the user experience is improved; the BI report is sent to the target object regularly, and the push efficiency is improved. The automatic push of BI reports is realized, and the push efficiency, accuracy and user experience are improved.

[0071] Figure 2 This is a flow chart of an embodiment of the present disclosure for obtaining data to be generated through data cleaning and grouping based on source data. Figure 2 Yes Figure 1 Further explanation of step 102 is based on Figure 2 The embodiment shown comprises the following steps:

[0072] Step 201, parse source data into data to be processed.

[0073] The data to be processed refers to the data obtained by parsing the source data of the reporting system according to the data category, data format, etc. After obtaining various types of source data of the reporting system, it is parsed into the data to be processed.

[0074] Step 202: clean the data to be processed to obtain first data.

[0075] The first data refers to the data to be processed after data cleaning.

[0076] Specifically, common methods of data cleaning include missing value processing, outlier processing, duplicate data processing, noise data processing, format inconsistency processing, data uselessness processing, etc. Data cleaning is performed on the data to be processed to obtain first data.

[0077] Step 203: Count the mathematical features of the first data and group them into second data.

[0078] The second data refers to the data formed after the first data is grouped. The mathematical characteristic values ​​such as the average value, sum, percentage, etc. of the first data are counted, and the first data are grouped into the second data according to the mathematical characteristic values.

[0079] Step 204: Aggregate the second data into data to be generated.

[0080] Collect and merge secondary data from multiple sources into a more meaningful data set, for example, aggregate data from members of the same period or the same team as the data to be generated.

[0081] In this embodiment, the source data of the report system is processed into data to be generated that can be used to generate BI reports, and data cleaning and aggregation are completed, providing accurate data support for the generation of BI reports.

[0082] Figure 3 This is a flowchart of an embodiment of the present disclosure for generating a BI report using a chart generation tool based on data to be generated. Figure 3 Yes Figure 1 Further explanation of step 103 is based on Figure 3 The embodiment shown comprises the following steps:

[0083] Step 301, according to the preset report requirements, set the type, data source and display parameters of the target chart.

[0084] The target chart refers to the chart in the BI report. According to the set report requirements, set the type, data source and display parameters of the target chart to be generated. For example, if the target chart is a market share diagram of the company to be generated, then set the type of the target chart to a pie chart, the data source to the market share of companies in the same industry, and the display parameters include the color, font, font size, title and other information of the pie chart.

[0085] Step 302: Generate a target chart using a chart generation tool.

[0086] The data to be generated is generated into a target chart through a chart generation tool.

[0087] Step 303: embed the target chart into the web page through the template function of Django to generate a BI report.

[0088] After generating the target chart, in order to generate a standardized BI report, the target chart is embedded into the web page through Django's template function to generate a BI report with both text and chart content.

[0089] In this embodiment, various types of charts are generated according to business needs to intuitively display data, thereby improving the user experience of BI reports.

[0090] Figure 4 This is a flowchart of regularly sending BI reports to target objects according to an embodiment of the present disclosure. Figure 4 Yes Figure 1 The specific description of step 104 is based on Figure 4 The embodiment shown comprises the following steps:

[0091] Step 401, based on the active time of the target object and the usage of the terminal device, determine the first time and interval duration of message push.

[0092] The first time refers to the time when the BI report is pushed to the target object. According to the active time of the target object and the target object's use of the terminal device, determine the time when the user is most likely to read the BI report as soon as possible. At the same time, in order for the target object to continue to pay attention to the continuously updated enterprise BI report, determine the interval between two consecutive readings of the BI report by the user.

[0093] Step 402 , regularly sending BI reports to the target object with the interval duration as a period and the first time as a starting time point.

[0094] With the interval as the cycle and the first time as the starting time point, BI reports are sent to the target object regularly, meeting the target object's demand for efficient information acquisition.

[0095] In this embodiment, the target object is analyzed to achieve accurate identification of the target object, improve the message reading rate and user satisfaction, and ensure the accuracy and efficiency of BI report push.

[0096] Figure 5 The present invention is a flowchart of parsing source data into data to be processed according to an embodiment of the present invention. Figure 5 Yes Figure 2 The specific description of step 201 is based on Figure 5 The embodiment shown comprises the following steps:

[0097] Step 501, adapting the corresponding data reading interface according to the type and data format of the data source.

[0098] Since the data source includes various types of data, such as Excel tables, txt text, or database files, in order to read all types of data as data that can be directly processed by the server, it is necessary to adapt the corresponding data reading interface for reading according to the type and data format of the data source.

[0099] Step 502: Based on the data reading interface, parse the source data into data to be processed.

[0100] According to the data reading interface, the source data is parsed into the data to be processed. In other words, based on different file categories, the data is parsed into the data to be processed that can be directly processed using the reading interface adapted thereto.

[0101] In this embodiment, by parsing the source data, data that can be cleaned and aggregated by the server is obtained, so that the source data can be directly analyzed, which provides data preparation for obtaining the data to be generated for generating BI reports.

[0102] Figure 6 The present invention is a flowchart of configuring a communication tool according to an embodiment of the present invention. Figure 6 Yes Figure 4 and Figure 1 The specific description before step 104 is based on Figure 6 The embodiment shown comprises the following steps:

[0103] Step 601, configure instant messaging software and / or mailbox as a target communication tool, and the target communication tool is used to push BI reports to the target object.

[0104] Before sending BI reports to the target object regularly, you also need to configure the communication tools that the server uses to communicate with the target object through the network, including instant messaging software such as DingTalk, WeChat, and Lanxin. Email can also be included.

[0105] Specifically, the message is pushed through the pre-created communication application using apikey and appsecret. Or for BlueMessage, the message is pushed through the pre-created group chat URL and secret combined with the signature algorithm.

[0106] In a possible implementation of this embodiment, AsyncIOScheduler is used to configure a scheduled task and set the frequency and time of push messages. Call Django's mail processing, data processing and other interfaces in the scheduled task. For DingTalk message push, identity authentication is performed through the apikey and appsecret of the DingTalk API, build the message content containing the report and chart download links, call the send message interface of the DingTalk API, and push the message to the specified user or group. For Lanxin message push, a signature is generated based on the pre-created group chat URL and secret. Construct the message content containing the report and chart download links, and process it according to the format requirements of Lanxin. Call the send message interface of the Lanxin API to push the message to the specified group chat.

[0107] In this embodiment, by configuring the communication tool, reliable data communication support is provided for regularly pushing BI reports to the target objects.

[0108] In one embodiment of the present disclosure, Figure 7 FIG. 1 is a structural diagram of a BI report push system according to an embodiment of the present disclosure. Figure 7As shown, the BI report push system includes a resource layer, a service layer, an interface layer, a Web layer, and an access layer. In order to obtain data from the resource layer, source data is captured from the report system and the file storage system, and sent from the report system to the service layer of the server through service communications such as http, imap, and REST. After data cleaning, the imap protocol is used to receive the data to be generated by email. Through the data processing module, including using Pandas to generate charts, using static to store the charts and generate BI reports, and then setting a scheduled task through APScheduler to push the BI report. In the business service module of the service layer, REST API, API service, data display, data download, message push and other services are generated based on the basic service components. The basic service components composed of email collection, data processing, data storage and scheduled tasks are made into the API of the business service module through the service registration discovery, log management, monitoring alarm and configuration management sub-modules of the service management module. The API of the service layer can be sorted by the API and gateway Gateway from the interface layer to provide it to the platform site of the web layer, instant messaging software such as Lanxin or DingTalk, and other platform applications for calling. Then, the data communication function of the web layer is used to push the BI report to the PC, mobile device or other terminals of the access layer, thus realizing the push of BI reports to the target objects.

[0109] The disclosed embodiment proposes a BI report push method, which is based on an IMAP server, asynchronously receives source data of a report system, and the report system supports IMAP service, providing source data for generating BI reports; based on the source data, the data to be generated is obtained through data cleaning and grouping, and accurate data of different groups is obtained; according to the data to be generated, a chart generation tool is used to generate a BI report, the data is visualized, and the user experience is improved; the BI report is sent to the target object regularly, and the push efficiency is improved. Automatic push of BI reports is realized, and the push efficiency, accuracy and user experience are improved.

[0110] Corresponding to the methods provided in the above-mentioned embodiments, the present disclosure also provides a BI report pushing device. Since the device provided in the embodiments of the present disclosure corresponds to the methods provided in the above-mentioned embodiments, the implementation method of the method is also applicable to the device provided in this embodiment and will not be described in detail in this embodiment.

[0111] Figure 8 FIG. 8 is a schematic diagram of the structure of a BI report push device 800 according to an embodiment of the present disclosure. Figure 8 As shown, the BI report push device includes:

[0112] The data acquisition module 810 is used to asynchronously receive source data of the report system based on the IMAP server, and the report system supports the IMAP service;

[0113] The data processing module 820 is used to obtain the data to be generated by data cleaning and grouping based on the source data;

[0114] A report generation module 830 is used to generate a BI report using a chart generation tool according to the data to be generated;

[0115] The push module 840 is used to periodically send BI reports to target objects.

[0116] In some embodiments, the data processing module 820 is used to:

[0117] Parse source data into data to be processed;

[0118] Performing data cleaning on the data to be processed to obtain first data;

[0119] Counting mathematical features of the first data and grouping them into second data;

[0120] The second data is aggregated into data to be generated.

[0121] In some embodiments, the report generation module 830 is used to:

[0122] According to the preset report requirements, set the type, data source and display parameters of the target chart;

[0123] Generate target charts through chart generation tools;

[0124] Use Django's template function to embed the target chart into the web page to generate a BI report.

[0125] In some embodiments, the push module 840 is used to:

[0126] Determine the first time and interval of message push based on the target object's active time and terminal device usage;

[0127] Send BI reports to the target object regularly, with the interval length as the cycle and the first time as the starting time point.

[0128] In some embodiments, the data processing module 820 parses the source data into data to be processed in the following manner:

[0129] Adapt the corresponding data reading interface according to the type and data format of the data source;

[0130] Based on the data reading interface, the source data is parsed into data to be processed.

[0131] In some embodiments, before periodically sending the BI report to the target object, the push module 840 is further configured to:

[0132] Configure instant messaging software and / or email as the target communication tool, which is used to push BI reports to the target object.

[0133] In summary, through the BI report push device, based on the IMAP server, the source data of the report system is asynchronously received, and the report system supports the IMAP service; based on the source data, the data to be generated is obtained through data cleaning and grouping; according to the data to be generated, the BI report is generated using a chart generation tool; and the BI report is sent to the target object regularly. This device solves the problems of low efficiency, poor accuracy, and poor user experience in BI report push in related technologies, improves push efficiency and accuracy, and enhances user experience.

[0134] In the above embodiments provided by the present disclosure, the methods and devices provided by the embodiments of the present disclosure are introduced. In order to implement the functions in the methods provided by the above embodiments of the present disclosure, the electronic device may include a hardware structure and a software module, and implement the above functions in the form of a hardware structure, a software module, or a hardware structure plus a software module. One of the above functions may be executed in the form of a hardware structure, a software module, or a hardware structure plus a software module.

[0135] Fig. 9 It is a block diagram of an electronic device 900 for implementing the above-mentioned BI report pushing method according to an exemplary embodiment.

[0136] For example, the electronic device 900 may be a mobile phone, a computer, a messaging device, a game console, a tablet device, a medical device, a fitness device, a personal digital assistant, etc.

[0137] Reference Fig. 9 , the electronic device 900 may include one or more of the following components: a processing component 902 , a memory 904 , a power component 906 , a multimedia component 908 , an audio component 910 , an input / output (I / O) interface 912 , a sensor component 914 , and a communication component 916 .

[0138] The processing component 902 generally controls the overall operation of the electronic device 900, such as operations associated with display, phone calls, data communications, camera operations, and recording operations. The processing component 902 may include one or more processors 920 to execute instructions to complete all or part of the steps of the above-mentioned method. In addition, the processing component 902 may include one or more modules to facilitate the interaction between the processing component 902 and other components. For example, the processing component 902 may include a multimedia module to facilitate the interaction between the multimedia component 908 and the processing component 902.

[0139] The memory 904 is configured to store various types of data to support operations on the electronic device 600. Examples of such data include instructions for any application or method operating on the electronic device 900, contact data, phone book data, messages, pictures, videos, etc. The memory 904 may be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic disk or optical disk.

[0140] The power supply component 906 provides power to the various components of the electronic device 900. The power supply component 906 may include a power management system, one or more power supplies, and other components associated with generating, managing, and distributing power to the electronic device 900.

[0141] The multimedia component 908 includes a screen that provides an output interface between the electronic device 900 and the user. In some embodiments, the screen may include a liquid crystal display (LCD) and a touch panel (TP). If the screen includes a touch panel, the screen may be implemented as a touch screen to receive input signals from the user. The touch panel includes one or more touch sensors to sense touch, slide, and gestures on the touch panel. The touch sensor may not only sense the boundaries of the touch or slide action, but also detect the duration and pressure associated with the touch or slide operation. In some embodiments, the multimedia component 908 includes a front camera and / or a rear camera. When the electronic device 900 is in an operating mode, such as a shooting mode or a video mode, the front camera and / or the rear camera may receive external multimedia data. Each front camera and rear camera may be a fixed optical lens system or have a focal length and optical zoom capability.

[0142] The audio component 910 is configured to output and / or input audio signals. For example, the audio component 910 includes a microphone (MIC), and when the electronic device 900 is in an operating mode, such as a call mode, a recording mode, and a voice recognition mode, the microphone is configured to receive an external audio signal. The received audio signal can be further stored in the memory 904 or sent via the communication component 916. In some embodiments, the audio component 910 also includes a speaker for outputting audio signals.

[0143] I / O interface 912 provides an interface between processing component 902 and peripheral interface modules, such as keyboards, click wheels, buttons, etc. These buttons may include but are not limited to: a home button, a volume button, a start button, and a lock button.

[0144] The sensor assembly 914 includes one or more sensors for providing various aspects of status assessment for the electronic device 900. For example, the sensor assembly 914 can detect the open / closed state of the electronic device 900, the relative positioning of components, such as the display and keypad of the electronic device 900, and the sensor assembly 914 can also detect the position change of the electronic device 900 or a component of the electronic device 900, the presence or absence of user contact with the electronic device 900, the orientation or acceleration / deceleration of the electronic device 900, and the temperature change of the electronic device 900. The sensor assembly 914 may include a proximity sensor configured to detect the presence of nearby objects without any physical contact. The sensor assembly 914 may also include an optical sensor, such as a CMOS or CCD image sensor, for use in imaging applications. In some embodiments, the sensor assembly 914 may also include an acceleration sensor, a gyroscope sensor, a magnetic sensor, a pressure sensor, or a temperature sensor.

[0145] The communication component 916 is configured to facilitate wired or wireless communication between the electronic device 900 and other devices. The electronic device 900 can access a wireless network based on a communication standard, such as WiFi, 2G or 3G, 4G LTE, 5G NR (NewRadio) or a combination thereof. In an exemplary embodiment, the communication component 916 receives a broadcast signal or broadcast-related information from an external broadcast management system via a broadcast channel. In an exemplary embodiment, the communication component 916 also includes a near field communication (NFC) module to facilitate short-range communication. For example, the NFC module can be implemented based on radio frequency identification (RFID) technology, infrared data association (IrDA) technology, ultra-wideband (UWB) technology, Bluetooth (BT) technology and other technologies.

[0146] In an exemplary embodiment, the electronic device 900 may be implemented by one or more application-specific integrated circuits (ASICs), digital signal processors (DSPs), digital signal processing devices (DSPDs), programmable logic devices (PLDs), field programmable gate arrays (FPGAs), controllers, microcontrollers, microprocessors, or other electronic components to perform the above methods.

[0147] In an exemplary embodiment, a non-transitory computer-readable storage medium including instructions is also provided, such as a memory 904 including instructions, and the instructions can be executed by the processor 920 of the electronic device 900 to complete the above method. For example, the non-transitory computer-readable storage medium can be a ROM, a random access memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, etc.

[0148] The embodiments of the present disclosure further provide a non-transitory computer-readable storage medium storing computer instructions, wherein the computer instructions are used to enable a computer to execute the BI report push method described in the above embodiments of the present disclosure.

[0149] The embodiments of the present disclosure further provide a computer program product, including a computer program, which executes the BI report pushing method described in the above embodiments of the present disclosure when a processor is used.

[0150] Fig.10 It is a schematic diagram of the structure of a chip 1000 for implementing the above-mentioned BI report push method according to an exemplary embodiment.

[0151] Reference Fig.10 The chip 1000 includes at least one communication interface 1001 and a processor 1002; the communication interface 1001 is used to receive a signal input to the chip 1000 or a signal output from the chip 1000, and the processor 1002 communicates with the communication interface 1001 and implements the BI report push method described in the above embodiment through a logic circuit or executing code instructions.

[0152] It should be noted that the terms "first", "second", etc. in the specification and claims of the present disclosure and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present disclosure described herein can be implemented in an order other than those illustrated or described herein. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present disclosure. Instead, they are merely examples of devices and methods consistent with some aspects of the present disclosure as detailed in the appended claims.

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

[0154] Any process or method description in a flowchart or otherwise described herein may be understood to represent a module, segment or portion of code that includes one or more executable instructions for implementing the steps of a specific logical function or process, and the scope of the preferred embodiments of the present disclosure includes alternative implementations in which functions may not be performed in the order shown or discussed, including performing functions in a substantially simultaneous manner or in the reverse order depending on the functions involved, which should be understood by those skilled in the art to which the embodiments of the present disclosure belong.

[0155] The logic and / or steps represented in the flowchart or otherwise described herein, for example, can be considered as an ordered list of executable instructions for implementing logical functions, and can be embodied in any computer-readable medium for use by an instruction execution system, device or apparatus (such as a computer-based system, a system including a processing module, or other system that can fetch instructions from an instruction execution system, device or apparatus and execute instructions), or in combination with these instruction execution systems, devices or apparatuses. For the purposes of this specification, "computer-readable medium" can be any device that can contain, store, communicate, propagate or transmit a program for use by an instruction execution system, device or apparatus, or in combination with these instruction execution systems, devices or apparatuses. More specific examples of computer-readable media (a non-exhaustive list) include the following: an electrical connection with one or more wires (control method), a portable computer disk box (magnetic device), a random access memory (RAM), a read-only memory (ROM), an erasable and programmable read-only memory (EPROM or flash memory), a fiber optic device, and a portable compact disk read-only memory (CDROM). In addition, the computer-readable medium may even be paper or other suitable medium on which the program is printed, since the program may be obtained electronically, for example, by optically scanning the paper or other medium and then editing, interpreting or otherwise processing in a suitable manner if necessary, and then stored in a computer memory.

[0156] It should be understood that the various parts of the embodiments of the present disclosure can be implemented by hardware, software, firmware or a combination thereof. In the above embodiments, multiple steps or methods can be implemented by software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented by hardware, as in another embodiment, it can be implemented by any one of the following technologies known in the art or their combination: a discrete logic circuit having a logic gate circuit for implementing a logic function for a data signal, a dedicated integrated circuit having a suitable combination of logic gate circuits, a programmable gate array (PGA), a field programmable gate array (FPGA), etc.

[0157] A person skilled in the art may understand that all or part of the steps in the method for implementing the above-mentioned embodiment may be completed by instructing related hardware through a program, and the program may be stored in a computer-readable storage medium, which, when executed, includes one or a combination of the steps of the method embodiment.

[0158] In addition, each functional unit in each embodiment of the present disclosure may be integrated into a processing module, or each unit may exist physically separately, or two or more units may be integrated into one module. The above-mentioned integrated module may be implemented in the form of hardware or in the form of a software functional module. If the integrated module is implemented in the form of a software functional module and sold or used as an independent product, it may also be stored in a computer-readable storage medium. The above-mentioned storage medium may be a read-only memory, a disk or an optical disk, etc.

[0159] Although the embodiments of the present disclosure have been shown and described above, it is to be understood that the above embodiments are exemplary and are not to be construed as limitations of the present disclosure. A person skilled in the art may make changes, modifications, substitutions and variations to the above embodiments within the scope of the present disclosure.

Claims

1. A BI report push method, characterized in that: Applied to a server, the method comprises: Based on the IMAP server, asynchronously receiving source data of the reporting system, the reporting system supports the IMAP service; Based on the source data, obtaining the data to be generated by data cleaning and grouping; Generate a BI report using a chart generation tool based on the data to be generated; The BI report is sent to the target object regularly.

2. The method according to claim 1, characterized in that: The step of obtaining the data to be generated by cleaning and grouping the source data includes: Parsing the source data into data to be processed; Performing data cleaning on the data to be processed to obtain first data; Counting mathematical features of the first data and grouping them into second data; The second data is aggregated into the data to be generated.

3. The method according to claim 1, characterized in that Generating a BI report using a chart generation tool according to the data to be generated includes: According to the preset report requirements, set the type, data source and display parameters of the target chart; Generate the target chart by using the chart generation tool; The target chart is embedded into the web page through the template function of Django to generate the BI report.

4. The method according to claim 1, characterized in that: The periodically sending the BI report to the target object includes: Determine the first time and interval of message push based on the target object's active time and terminal device usage; The BI report is sent to the target object regularly with the interval duration as a period and the first time as a starting time point.

5. The method according to claim 2, characterized in that: The parsing the source data into data to be processed includes: Adapt the corresponding data reading interface according to the type and data format of the data source; Based on the data reading interface, the source data is parsed into data to be processed.

6. The method according to claim 1 or 4, characterized in that: Before the BI report is sent to the target object on a regular basis, the method further includes: Instant messaging software and / or mailbox are configured as target communication tools, and the target communication tools are used to push the BI report to the target object.

7. A BI report push device, characterized in that: Applied to a server, the device comprises: A data acquisition module is used to asynchronously receive source data of a reporting system based on an IMAP server, wherein the reporting system supports an IMAP service; A data processing module, used to obtain the data to be generated by data cleaning and grouping based on the source data; A report generation module, used to generate a BI report using a chart generation tool according to the data to be generated; The push module is used to periodically send the BI report to the target object.

8. An electronic device, characterized in that: include: at least one processor; as well as a memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the method according to any one of claims 1 to 6.

9. A non-transitory computer-readable storage medium storing computer instructions, characterized in that: The computer instructions are used to cause the computer to execute the method according to any one of claims 1-6.

10. A computer program product, characterized in that The invention comprises a computer program which, when executed by a processor, implements the method according to any one of claims 1 to 6.