CN112541693A - Performance data generation method, system, electronic device and storage medium - Google Patents
Performance data generation method, system, electronic device and storage medium Download PDFInfo
- Publication number
- CN112541693A CN112541693A CN202011521743.5A CN202011521743A CN112541693A CN 112541693 A CN112541693 A CN 112541693A CN 202011521743 A CN202011521743 A CN 202011521743A CN 112541693 A CN112541693 A CN 112541693A
- Authority
- CN
- China
- Prior art keywords
- performance data
- performance
- generation method
- data generation
- user
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 54
- 238000013075 data extraction Methods 0.000 claims abstract description 41
- 238000004364 calculation method Methods 0.000 claims abstract description 23
- 238000001914 filtration Methods 0.000 claims abstract description 20
- 230000002776 aggregation Effects 0.000 claims abstract description 12
- 238000004220 aggregation Methods 0.000 claims abstract description 12
- 238000013507 mapping Methods 0.000 claims description 23
- 230000006870 function Effects 0.000 claims description 22
- 230000003993 interaction Effects 0.000 claims description 11
- 238000012800 visualization Methods 0.000 claims description 9
- 238000009795 derivation Methods 0.000 claims description 4
- 230000004931 aggregating effect Effects 0.000 claims description 2
- 230000000737 periodic effect Effects 0.000 abstract description 5
- 230000008569 process Effects 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 13
- 238000012545 processing Methods 0.000 description 8
- 230000002452 interceptive effect Effects 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 239000013307 optical fiber Substances 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 238000012958 reprocessing Methods 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000004904 shortening Methods 0.000 description 1
- 230000004936 stimulating effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- 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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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/26—Visual data mining; Browsing structured data
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Educational Administration (AREA)
- Development Economics (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Game Theory and Decision Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a performance data generation method, a system, an electronic device and a storage medium, wherein the performance data generation method comprises the following steps: establishing a performance data extraction rule; acquiring performance metadata; and performing filtering and/or aggregation calculation on the performance metadata according to the performance data extraction rule to generate performance data. The performance data generating method automatically generates the performance data in a certain period including the configured indexes by flexibly creating the performance data extraction rules, reduces the technical threshold of a data set, and improves the accuracy and timeliness of the data without human intervention from the original manual calculation of the performance of the staff at the end of the month to the realization of the automatic periodic real-time update of the whole process, thereby reducing the labor cost and effectively improving the efficiency of the internal management of the company and reducing the management cost of the company by taking the performance data obtained by the method as the basis for exciting the staff to adjust the working state or the basis for checking.
Description
Technical Field
The invention relates to the field of internet, in particular to a performance data generation method, a system, electronic equipment and a storage medium.
Background
In the system engineering with the ever-complex performance calculation of the staff in the large-scale service contact center, 700 indexes such as telephone quantity, call duration, commenting number and the like are collected from each business system, and then the data are processed and calculated for many times, weight conversion is carried out, and finally the data are presented to the staff or input of subsequent bonus calculation is carried out.
The original performance calculation is manually completed by a performance specialist, is limited by manpower, and is usually performed once a month by taking a month as a dimension. The data group completes data reprocessing by compiling SQL sentences, and the SQL sentences need to be revised again when business changes happen, so that the efficiency is low.
Meanwhile, each department hopes to play a role of motivating the staff by shortening the performance presentation period, namely, the staff can timely adjust the self state according to the current performance data in a single performance period instead of presenting the result at the end of the month. In addition, due to privacy concerns, the administrator needs to split individual employee performance calculations from the summary sheet to send to the individual. The technical scheme capable of generating flexible and timely performance data can greatly reduce the management cost of enterprises.
It is to be noted that the information disclosed in the above background section is only for enhancement of understanding of the background of the present invention and therefore may include information that does not constitute prior art known to a person of ordinary skill in the art.
Disclosure of Invention
In view of the problems in the prior art, an object of the present invention is to provide a performance data generating method, system, electronic device, and storage medium, which automatically generate performance data in a certain period including configured indicators by creating performance data extraction rules flexibly, and improve data processing efficiency.
Some embodiments of the present invention provide a performance data generation method, comprising the steps of:
establishing a performance data extraction rule;
acquiring performance metadata;
and performing filtering and/or aggregation calculation on the performance metadata according to the performance data extraction rule to generate performance data.
According to some examples of this invention, the establishing performance data extraction rules comprises the steps of:
pushing an interaction page created by a performance data extraction rule to a user, wherein the interaction page created by the performance data extraction rule comprises a plurality of indexes, and each index comprises at least one standard field and at least one mapping function;
acquiring the selection of a standard field and a mapping function by a user and the relation between the standard field selected by the user and the mapping function;
and combining the standard field selected by the user with the corresponding mapping function to establish a performance data extraction rule.
According to some examples of this disclosure, the mapping function includes at least one of a multiplication of the plurality of standard fields, a division of the plurality of standard fields, an addition of the plurality of standard fields, and a subtraction of the plurality of standard fields.
According to some examples of the invention, the filtering and/or aggregating calculations of the performance metadata according to the performance data extraction rules, generating performance data comprises the steps of:
filtering the performance metadata according to a standard field selected by a user, and extracting to-be-processed data including the standard field in the performance metadata;
and performing aggregation calculation on the data to be processed including the standard field according to the mapping function corresponding to the standard field selected by the user to obtain performance data.
According to some examples of this invention, the performance data extraction rules include time intervals of performance data;
the step of filtering the performance metadata according to the standard field selected by the user and extracting the data to be processed in the performance metadata, which comprises the standard field, comprises the following steps:
and filtering the performance metadata according to the standard field selected by the user, and extracting the data to be processed in the performance metadata in the time interval, wherein the data to be processed comprises the standard field.
According to some examples of this invention, the method further comprises the steps of:
configuring a performance data generation period;
and configuring a timing task according to the performance data generation period, wherein the timing task is configured to acquire performance metadata at fixed time according to the performance data generation period and generate performance data of the current performance data period.
According to some examples of this invention, the method further comprises the steps of:
establishing a plurality of chart generation rules, wherein each chart generation rule corresponds to a visualization type;
and converting the performance data into a plurality of charts according to a plurality of chart generation rules.
According to some examples of this invention, the method further comprises the steps of:
pushing a plurality of visualization types to a user through a user interface;
and displaying the corresponding chart according to the visualization type selected by the user.
According to some examples of the invention, the performance metadata is obtained from a HIVE data repository.
Still other embodiments of the present invention provide a performance data generation system for implementing the performance data generation method, including a data acquisition module, a rule module, and a data derivation module, wherein:
the data acquisition module is used for acquiring performance metadata;
the rule module is used for establishing a performance data extraction rule;
and the data export module is used for filtering and/or performing aggregation calculation on the performance metadata according to the performance data extraction rule to generate performance data.
An embodiment of the present invention further provides an electronic device, including:
a processor;
a memory having stored therein executable instructions of the processor;
wherein the processor is configured to perform the steps of the performance data generation method via execution of the executable instructions.
An embodiment of the present invention also provides a computer-readable storage medium storing a program characterized in that the program realizes the steps of the performance data generation method when executed.
The performance data generating method automatically generates the performance data including the configured indexes within a certain period by flexibly creating the performance data extraction rules, reduces the technical threshold of a data set, does not need human intervention from the original manual calculation of the performance of the staff at the end of the month to the realization of the automatic periodic real-time updating of the whole process, reduces the labor cost and simultaneously improves the accuracy and timeliness of the data, and can effectively improve the efficiency of the internal management of a company and reduce the management cost of the company by taking the performance data obtained by the method as the basis for exciting the staff to adjust the working state or the basis for checking.
Drawings
Other features, objects, and advantages of the invention will be apparent from the following detailed description of non-limiting embodiments, which proceeds with reference to the accompanying drawings and which is incorporated in and constitutes a part of this specification, illustrating embodiments consistent with the present application and together with the description serve to explain the principles of the application. It is obvious that the drawings in the following description are only some embodiments of the invention, and that for a person skilled in the art, other drawings can be derived from them without inventive effort.
FIG. 1 is a flow chart of a performance data generation method of an embodiment of the present invention;
FIG. 2 is an exemplary diagram of an interaction page created by performance data extraction rules in accordance with one embodiment of the present invention;
FIG. 3 is an exemplary diagram of an interaction page with set criteria fields and mapping functions according to one embodiment of the invention;
FIG. 4 is an exemplary diagram of an interaction page setting time intervals for performance data in accordance with one embodiment of the present invention;
FIG. 5 is an exemplary diagram of a performance data chart in accordance with an embodiment of the present invention;
FIG. 6 is an exemplary diagram of a performance data chart of yet another embodiment of the present invention;
fig. 7 is a schematic structural diagram of a performance data generation system according to an embodiment of the present invention;
fig. 8 is a schematic structural diagram of an electronic device according to an embodiment of the invention;
fig. 9 is a schematic structural diagram of a computer-readable storage medium according to an embodiment of the present invention.
Detailed Description
Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many different forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.
Furthermore, the drawings are merely schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus their repetitive description will be omitted. Some of the block diagrams shown in the figures are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities may be implemented in the form of software, or in one or more hardware modules or integrated circuits, or in different networks and/or processor devices and/or microcontroller devices.
Fig. 1 is a flowchart of a performance data generation method according to an embodiment of the present invention, and specifically, the performance data generation method includes the following steps:
s100: establishing a performance data extraction rule;
s200: acquiring performance metadata; according to some examples of the invention, the performance metadata is obtained from a HIVE data warehouse, which may store, query, and analyze large-scale data stored in Hadoop. It should be noted that, for the acquisition of the performance metadata, a specific time period (e.g., 24: 00 per day) can be set for the background to automatically complete the acquisition and calculation.
S300: and performing filtering and/or aggregation calculation on the performance metadata according to the performance data extraction rule to generate performance data.
The original performance data taking the month as the dimension is compiled into SQL sentences by a data group every month to complete data reprocessing, and when business changes happen and the SQL sentences need to be revised again, namely, if performance data in different dimensions, such as different time intervals and containing different indexes, need to rewrite a large amount of SQL sentences.
In the present invention, the step S100 of establishing the performance data extraction rule includes:
s110: pushing an interaction page created by a performance data extraction rule to a user, wherein the interaction page created by the performance data extraction rule comprises a plurality of indexes, and each index comprises at least one standard field and at least one mapping function;
s120: acquiring the selection of a standard field and a mapping function by a user and the relation between the standard field selected by the user and the mapping function;
s130: and combining the standard field selected by the user with the corresponding mapping function to establish a performance data extraction rule.
FIG. 2 is an exemplary diagram of an interaction page created by performance data extraction rules in accordance with one embodiment of the present invention; in the invention, a large amount of SQL work of the data set is abstractly abstracted and abstracted into flexible configuration items of the system, and the flexible configuration items are matched with the background automatic calculation. The user may configure the indicators through the interactive page, for example, the indicators selected by the user in fig. 2 include "telephone volume", "unit staff utilization rate", "new goodness rate", "genre", "complaint quality", and the like, each indicator may include a key field of the performance metadata acquired from the HIVE data warehouse, and for the indicators of the "telephone volume", the indicators of the "telephone volume" type are directly selected from the "telephone volume" of the performance metadata, but for the indicators of the "telephone volume efficiency" type, the indicators of the "telephone volume efficiency" type may be obtained by performing operations on the performance metadata, that is, the indicators of the type are obtained by mapping the key fields in the performance metadata in a certain relationship. The "call volume efficiency" may be obtained by dividing the "call volume" by the "work duration" in the performance metadata. The mapping function herein includes at least one of multiplication of a plurality of the standard fields, division of a plurality of the standard fields, addition of a plurality of the standard fields, and subtraction of a plurality of the standard fields.
In the embodiment of fig. 2, after the user adds the index, the mapping relationship corresponding to the index may be further configured, for example, by clicking an "edit" button, the interactive page for setting the standard field and the mapping function as shown in fig. 3 is obtained, and when the "telephone volume efficiency" index is edited in the above embodiment, the interactive page is selected from a first custom relationship, where a in the custom relationship is "telephone volume" and B is "working duration".
The method abstractly extracts a large amount of SQL work of the data group into flexible configuration items of the system, and can promote the technical work ratio from the original 40% to 90% by matching with the automatic calculation of the background, thereby realizing timely obtaining performance data configured by different indexes and improving the efficiency of the internal management of the company.
Further, in S300 of the present invention, the step of filtering and/or performing aggregation calculation on the performance metadata according to the performance data extraction rule to generate performance data includes:
s310: filtering the performance metadata according to a standard field selected by a user, and extracting to-be-processed data including the standard field in the performance metadata;
s320: and performing aggregation calculation on the data to be processed including the standard field according to the mapping function corresponding to the standard field selected by the user to obtain performance data.
For a scene needing to obtain performance data in different time intervals, the performance data extraction rule can comprise the time intervals of the performance data;
at this time, in S310, the step of filtering the performance metadata according to the standard field selected by the user, and extracting the to-be-processed data including the standard field in the performance metadata is:
and filtering the performance metadata according to the standard field selected by the user, and extracting the data to be processed in the performance metadata in the time interval, wherein the data to be processed comprises the standard field. Fig. 4 is an exemplary view of an interaction page for setting a time interval of performance data through which a user can select a time interval of generated performance data according to an embodiment of the present invention.
Of course, the performance data extraction rule may be added with an index of "work category", and the performance metadata may be filtered according to the "work category" selected by the user in step S310, and the performance metadata may be extracted from the to-be-processed data including the "work category" and then the step S320 may be executed to obtain the performance data within a certain time interval of the work category. The performance data generation method of the invention obtains flexible and changeable performance data through flexible combination and mapping of metadata indexes.
Meanwhile, the performance data generation method of the invention can also realize the periodic acquisition of the performance data through the following steps, which specifically comprise:
s400: configuring a performance data generation period;
s500: and configuring a timing task according to the performance data generation period, wherein the timing task is configured to acquire performance metadata at fixed time according to the performance data generation period and generate performance data of the current performance data period. The user can set a performance data generation period, which is different for each department and does not correspond to the start/end time of the natural month even in the monthly performance data generation period, for example, the period from the last month 20 to the last month 19. The periodic performance data can be conveniently obtained according to the setting of the specific period of the invention.
In order to more straightly and variously display the performance data to a system user, the performance data generation method of the invention further comprises the following steps:
establishing a plurality of chart generation rules, wherein each chart generation rule corresponds to a visualization type;
and converting the performance data into a plurality of charts according to a plurality of chart generation rules. The performance data is displayed to the user after being graphed, so that the display mode of the data is enriched and the readability of the data is improved.
The performance data generation method of the present invention further includes providing the user's own preference of the types of charts, and therefore, the method of the present invention further includes the steps of:
pushing a plurality of visualization types to a user through a user interface;
and displaying the corresponding chart according to the visualization type selected by the user.
FIG. 5 is an exemplary diagram of a performance data chart in accordance with an embodiment of the present invention; the performance data shows daily performance of the telephone volume in the form of a bar chart, and the team can obtain daily change trend of the telephone volume through the icon. Fig. 6 is an exemplary diagram of a performance data chart of yet another embodiment of the present invention in which the accumulated performance of an individual of an employee over a time interval may be ranked.
The performance data obtained by the method can be disclosed to personnel at different levels of a company by a method for setting authority, for example, the personnel can obtain the self accumulated performance, monthly performance, daily performance and the like.
Through the steps, the performance data obtained by the method has the advantages of diversified display forms, high real-time performance and strong interactivity. The data with high real-time performance is beneficial to timely feeding back the working state of the staff, and the data is used as the basis for stimulating the staff to adjust the working state or the check, so that the internal management efficiency of the company can be effectively improved, and the management cost of the company is reduced.
Still other embodiments of the present invention provide a performance data generation system, configured to implement the performance data generation method, and fig. 7 is a schematic structural diagram of the performance data generation system according to an embodiment of the present invention, and specifically includes a data acquisition module M100, a rule module M200, and a data derivation module M300, where:
the data acquisition module M100 is used for acquiring performance metadata;
the rule module M200 is used for establishing a performance data extraction rule;
the data export module M300 is configured to perform filtering and/or aggregation calculation on the performance metadata according to the performance data extraction rule, so as to generate performance data.
The functional implementation manner of each functional module in the performance data generation system of the embodiment can be implemented by adopting the specific implementation manner of each step in the performance data generation method. For example, the data acquisition module M100, the rule module M200, and the data derivation module M3000 may respectively implement the functions thereof by using the specific implementation manners of the steps S100 to S300, which are not described herein again.
After the performance data generation system is on line in the service contact center, the system can be popularized to a plurality of departments to cover a plurality of work types, more than 700 configurable indexes are achieved, and the coverage of employees is not limited. The staff can inquire the performance of the staff in time through the system, and effectively play a role in feeding back the working state, so that the staff is intervened or stimulated, the internal management efficiency of the company is improved, and the management cost of the company is reduced.
An electronic device 600 according to this embodiment of the invention is described below with reference to fig. 8. The electronic device 600 shown in fig. 8 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present invention.
As shown in fig. 8, the electronic device 600 is embodied in the form of a general purpose computing device. The components of the electronic device 600 may include, but are not limited to: at least one processing unit 610, at least one memory unit 620, a bus 630 connecting the different platform components (including the memory unit 620 and the processing unit 610), a display unit 640, etc.
Wherein the storage unit stores program code which can be executed by the processing unit 610 such that the processing unit 610 performs the steps according to various exemplary embodiments of the present invention as described in the above-mentioned method section of the present specification. For example, processing unit 610 may perform the steps as shown in fig. 1.
The storage unit 620 may include readable media in the form of volatile memory units, such as a random access memory unit (RAM)6201 and/or a cache memory unit 6202, and may further include a read-only memory unit (ROM) 6203.
The memory unit 620 may also include a program/utility 6204 having a set (at least one) of program modules 6205, such program modules 6205 including, but not limited to: an operating system, one or more application programs, other program modules, and program data, each of which, or some combination thereof, may comprise an implementation of a network environment.
The electronic device 600 may also communicate with one or more external devices 700 (e.g., keyboard, pointing device, bluetooth device, etc.), with one or more devices that enable a user to interact with the electronic device 600, and/or with any devices (e.g., router, modem, etc.) that enable the electronic device 600 to communicate with one or more other computing devices. Such communication may occur via an input/output (I/O) interface 650. Also, the electronic device 600 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network such as the Internet) via the network adapter 660. The network adapter 660 may communicate with other modules of the electronic device 600 via the bus 630. It should be appreciated that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the electronic device 600, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage platforms, to name a few.
Embodiments of the present invention also provide a computer-readable storage medium for storing a program, which is executed to implement the steps of the performance data generation method. In some possible embodiments, the various aspects of the invention may also be implemented in the form of a program product comprising program code means for causing a terminal device to carry out the steps according to the various exemplary embodiments of the invention described in the method part above of this description when said program product is run on the terminal device.
Referring to fig. 9, a program product 800 for implementing the above method according to an embodiment of the present invention is described, which may employ a portable compact disc read only memory (CD-ROM) and include program code, and may be run on a terminal device, such as a personal computer. However, the program product of the present invention is not limited in this regard and, in the present document, a readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium include: an electrical connection having one or more wires, a portable disk, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
A computer readable storage medium may include a propagated data signal with readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A readable storage medium may also be any readable medium that is not a readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a readable storage medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device and partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., through the internet using an internet service provider).
In summary, the present invention provides a performance data generation method, a system, an electronic device, and a storage medium, where the performance data generation method includes the following steps: establishing a performance data extraction rule; acquiring performance metadata; and performing filtering and/or aggregation calculation on the performance metadata according to the performance data extraction rule to generate performance data. The performance data generating method automatically generates the performance data in a certain period including the configured indexes by flexibly creating the performance data extraction rules, reduces the technical threshold of a data set, and improves the accuracy and timeliness of the data without human intervention from the original manual calculation of the performance of the staff at the end of the month to the realization of the automatic periodic real-time update of the whole process, thereby reducing the labor cost and effectively improving the efficiency of the internal management of the company and reducing the management cost of the company by taking the performance data obtained by the method as the basis for exciting the staff to adjust the working state or the basis for checking.
The foregoing is a more detailed description of the invention in connection with specific preferred embodiments and it is not intended that the invention be limited to these specific details. It will be evident to those skilled in the art that the present application is not limited to the details of the foregoing illustrative embodiments, and that the present application may be embodied in other specific forms without departing from the spirit or essential attributes thereof. The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the application being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference sign in a claim should not be construed as limiting the claim concerned. Furthermore, it is obvious that the word "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. A plurality of units or means recited in the apparatus claims may also be implemented by one unit or means in software or hardware. The terms first, second, etc. are used to denote names, but not any particular order.
Claims (12)
1. A performance data generation method, characterized by comprising the steps of:
establishing a performance data extraction rule;
acquiring performance metadata;
and performing filtering and/or aggregation calculation on the performance metadata according to the performance data extraction rule to generate performance data.
2. The performance data generation method of claim 1, wherein said establishing performance data extraction rules includes the steps of:
pushing an interaction page created by a performance data extraction rule to a user, wherein the interaction page created by the performance data extraction rule comprises a plurality of indexes, and each index comprises at least one standard field and at least one mapping function;
acquiring the selection of a standard field and a mapping function by a user and the relation between the standard field selected by the user and the mapping function;
and combining the standard field selected by the user with the corresponding mapping function to establish a performance data extraction rule.
3. The performance data generation method of claim 2, wherein the mapping function includes at least one of a multiplication of the plurality of standard fields, a division of the plurality of standard fields, an addition of the plurality of standard fields, and a subtraction of the plurality of standard fields.
4. The performance data generation method of claim 2, wherein said filtering and/or aggregating the performance metadata according to the performance data extraction rules, generating performance data comprises the steps of:
filtering the performance metadata according to a standard field selected by a user, and extracting to-be-processed data including the standard field in the performance metadata;
and performing aggregation calculation on the data to be processed including the standard field according to the mapping function corresponding to the standard field selected by the user to obtain performance data.
5. The performance data generation method of claim 4, wherein the performance data extraction rules include time intervals of performance data;
the step of filtering the performance metadata according to the standard field selected by the user and extracting the data to be processed in the performance metadata, which comprises the standard field, comprises the following steps:
and filtering the performance metadata according to the standard field selected by the user, and extracting the data to be processed in the performance metadata in the time interval, wherein the data to be processed comprises the standard field.
6. The performance data generation method of claim 1, further comprising the steps of:
configuring a performance data generation period;
and configuring a timing task according to the performance data generation period, wherein the timing task is configured to acquire performance metadata at fixed time according to the performance data generation period and generate performance data of the current performance data period.
7. The performance data generation method of claim 1, further comprising the steps of:
establishing a plurality of chart generation rules, wherein each chart generation rule corresponds to a visualization type;
and converting the performance data into a plurality of performance data charts according to a plurality of chart generation rules.
8. The performance data generation method of claim 7, further comprising the steps of:
pushing a plurality of visualization types to a user through a user interface;
and displaying the corresponding performance data chart according to the visualization type selected by the user.
9. The performance data generation method of claim 1, wherein the performance metadata is obtained from a HIVE data repository.
10. A performance data generation system for implementing the performance data generation method of any one of claims 1 to 9, characterized by comprising a data acquisition module, a rule module, and a data derivation module, wherein:
the data acquisition module is used for acquiring performance metadata;
the rule module is used for establishing a performance data extraction rule;
and the data export module is used for filtering and/or performing aggregation calculation on the performance metadata according to the performance data extraction rule to generate performance data.
11. A performance data generation device characterized by comprising:
a processor;
a memory having stored therein executable instructions of the processor;
wherein the processor is configured to perform the steps of the performance data generation method of any of claims 1 to 9 via execution of the executable instructions.
12. A computer-readable storage medium storing a program for implementing the steps of the performance data generation method of any one of claims 1 through 9 when the program is executed by a processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011521743.5A CN112541693A (en) | 2020-12-21 | 2020-12-21 | Performance data generation method, system, electronic device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011521743.5A CN112541693A (en) | 2020-12-21 | 2020-12-21 | Performance data generation method, system, electronic device and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112541693A true CN112541693A (en) | 2021-03-23 |
Family
ID=75019452
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011521743.5A Pending CN112541693A (en) | 2020-12-21 | 2020-12-21 | Performance data generation method, system, electronic device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112541693A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113283863A (en) * | 2021-05-21 | 2021-08-20 | 北京京东振世信息技术有限公司 | Performance distribution method, performance distribution device and electronic equipment |
| CN117150215A (en) * | 2023-10-30 | 2023-12-01 | 太平金融科技服务（上海）有限公司 | Assessment result determining method and device, electronic equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101916422A (en) * | 2010-09-01 | 2010-12-15 | 中国建设银行股份有限公司 | Multi-dimensional performance evaluation system and method for banks |
| CN109800265A (en) * | 2018-12-28 | 2019-05-24 | 平安科技（深圳）有限公司 | Data load method, device, equipment and computer readable storage medium |
| CN110210840A (en) * | 2019-06-14 | 2019-09-06 | 言图科技有限公司 | A kind of method and system for realizing business administration based on instant chat |
| CN112015764A (en) * | 2020-08-13 | 2020-12-01 | 仁励家网络科技(杭州)有限公司 | Data processing method and device of business system, electronic equipment and storage medium |
-
2020
- 2020-12-21 CN CN202011521743.5A patent/CN112541693A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101916422A (en) * | 2010-09-01 | 2010-12-15 | 中国建设银行股份有限公司 | Multi-dimensional performance evaluation system and method for banks |
| CN109800265A (en) * | 2018-12-28 | 2019-05-24 | 平安科技（深圳）有限公司 | Data load method, device, equipment and computer readable storage medium |
| CN110210840A (en) * | 2019-06-14 | 2019-09-06 | 言图科技有限公司 | A kind of method and system for realizing business administration based on instant chat |
| CN112015764A (en) * | 2020-08-13 | 2020-12-01 | 仁励家网络科技(杭州)有限公司 | Data processing method and device of business system, electronic equipment and storage medium |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113283863A (en) * | 2021-05-21 | 2021-08-20 | 北京京东振世信息技术有限公司 | Performance distribution method, performance distribution device and electronic equipment |
| CN117150215A (en) * | 2023-10-30 | 2023-12-01 | 太平金融科技服务（上海）有限公司 | Assessment result determining method and device, electronic equipment and storage medium |
| CN117150215B (en) * | 2023-10-30 | 2024-02-02 | 太平金融科技服务（上海）有限公司 | Assessment result determining method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110795509B (en) | Method and device for constructing index blood-margin relation graph of data warehouse and electronic equipment | |
| WO2019095424A1 (en) | Data acquisition method and device, storage medium and terminal | |
| CN110287200B (en) | Account checking method, account checking system, computer equipment and storage medium | |
| CN112541693A (en) | Performance data generation method, system, electronic device and storage medium | |
| CN105144155B (en) | Visually indicate the inquiry of multi-source data | |
| CN103729796A (en) | Method and system for sample survey | |
| CN109766373A (en) | Electric network data methods of exhibiting and computer readable storage medium | |
| CN111159429B (en) | Knowledge graph-based data analysis method and device, equipment and storage medium | |
| CN106844669A (en) | Big data visual analyzing display frame construction method and visual analyzing display frame | |
| CN109493928B (en) | Patient data screening method, system, equipment and storage medium based on condition tree | |
| CN110309239B (en) | Visual map editing method and device | |
| CN113704288A (en) | Data display method and device, computer readable medium and electronic equipment | |
| CN109376148B (en) | Data processing method and device for slow change dimension table and electronic equipment | |
| CN114580676A (en) | Operation and maintenance data processing method and device, electronic equipment and storage medium | |
| CN115905371A (en) | Data trend analysis method, device and equipment and computer readable storage medium | |
| CN114580675A (en) | Operation and maintenance data processing method, device, equipment and medium based on tree structure | |
| CN112465363B (en) | Task management platform and method | |
| CN114936242A (en) | Data report customization application system | |
| Pritychenko et al. | National Nuclear Data Center: a worldwide user facility | |
| CN114239532A (en) | Report generation method and device | |
| CN114282005A (en) | Government affair knowledge map construction method and device and computer readable medium | |
| CN109582650B (en) | Module calling amount processing method and device, electronic equipment and storage medium | |
| CN112819602A (en) | Piece wage calculation method and device, terminal equipment and readable storage medium thereof | |
| CN113296656B (en) | Information processing method, system, device and medium | |
| CN111046020A (en) | Information processing method and device, storage medium and electronic equipment |
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 |