Visualization method, device, computer equipment and storage medium for employee evaluation information
By obtaining a joint table and using the visualization method of Tableau and Druid engines, the problems of low efficiency and high cost in the visualization process of employee evaluation information in the financial field are solved, and efficient and flexible employee evaluation information display and analysis are achieved.
Patent Information
- Application Number
- CN202310715367.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2023-06-15
- Publication Date
- 2025-09-16
- Estimated Expiration
- 2043-06-15
AI Technical Summary
In the financial sector, existing technologies for visualizing employee evaluation information suffer from problems such as delayed development, inconsistent data synchronization, long processing time, and inflexibility, resulting in low efficiency and high costs.
By obtaining the joint table, the employee evaluation information within different time ranges is counted, and the distribution of employee numbers is displayed using a visual interface. The target time range and employees are determined based on user operations, and the distribution of their evaluation information is displayed. Tableau software and the Druid computing engine are used for data processing and visualization.
It improves the processing efficiency of employee evaluation information, ensures the consistency of data caliber, reduces development time and cost, and users can instantly obtain the latest visualization results through refresh operations.
Smart Images

Figure CN116662438B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of data visualization in the financial field, and in particular to a method, apparatus, computer equipment, and storage medium for visualizing employee evaluation information. Background Art
[0002] In the financial sector, the performance evaluation information of employees such as securities practitioners, bank staff, and insurance practitioners often fluctuates over time. For example, employees may be divided into different levels such as Grade A, Grade B, Grade C, Grade D, and Grade E based on their monthly performance. By visualizing the corresponding employee details for managers, it is very important to facilitate their decision-making on operational strategies.
[0003] In related technologies, developers each use scripts to process employee work evaluation information and other data. If downstream development requires secondary development, a new development script will be generated, which may not be synchronized to upstream development in a timely manner. Similarly, the updated script logic of upstream development may not be notified to downstream development in a timely manner, which can easily lead to unclear caliber. Financial institutions such as securities, banks or insurance companies need to spend a lot of time sorting out the script logic, which reduces the efficiency of visualizing employee evaluation information.
[0004] In some financial technologies, the principle for visualizing employee evaluation information is as follows: code is written to create two fact tables. The first serves as the primary table, selecting the desired time slice (for example, the month an employee achieved a grade of B or higher). The second serves as a secondary table, displaying performance facts for other time dimensions associated with that time slice (e.g., data for a longer time dimension, such as 24 months). Common database backends for data analysis are Linux (a Unix-like operating system) or Zeppelin (a web-based notebook that provides interactive data analysis and visualization). The frontend displays data as Excel files. After the backend data analysis is completed, the data must be exported to Excel files, and managers must perform secondary processing in Excel to visualize the data, such as creating pivot tables or other visual dashboards for management. In some real-world operations, fact tables contain data in the billions. Creating, modifying, and refreshing time slices through code can take hours. Furthermore, if managers need to add new performance fields or change business logic, they must repeat the above process. With each data change, managers must also export the data to the Excel dashboard and update it, resulting in high overall time consumption and inflexibility. Summary of the Invention
[0005] The embodiments of the present application provide a method, apparatus, computer equipment, and storage medium for visualizing employee evaluation information, which can improve the processing efficiency of financial institutions such as securities, banks, or insurance companies in determining the distribution of work evaluation information of target employees and displaying it; it can ensure the consistency of the data caliber of employee evaluation information and greatly save the time and cost of developing the visualization results of employee evaluation information.
[0006] In a first aspect, the present application provides a method for visualizing employee evaluation information, the method comprising:
[0007] Obtaining a joint table, the joint table including work evaluation information of multiple employees within different time ranges;
[0008] performing statistics on the work evaluation information in the combined table according to the multiple time ranges, and determining the number of employees with different work evaluation information in each of the time ranges;
[0009] Displaying the multiple time ranges and the number of employees with different work evaluation information within each time range through a visual interface;
[0010] determining a target time range and target work evaluation information within the plurality of time ranges according to a target determination operation of the user in the visual interface;
[0011] Determining a target employee in the joint table according to the target time range and the target work evaluation information, the target employee being an employee whose work evaluation information in the target time range is the target work evaluation information;
[0012] In the combined table, determining the distribution of the work evaluation information of the target employee in each time range after the target time range;
[0013] The distribution situation is displayed through the visualization interface.
[0014] In a second aspect, the present application provides a device for visualizing employee evaluation information, comprising:
[0015] A joint table acquisition module, configured to acquire a joint table including work evaluation information of multiple employees within different time ranges;
[0016] A statistics module, configured to collect statistics on the work evaluation information in the combined table according to the multiple time ranges, and determine the number of employees with different work evaluation information in each time range;
[0017] A first display module is configured to display the multiple time ranges and the number of employees with different work evaluation information within each time range through a visual interface;
[0018] an operation determination module, configured to determine a target time range and target work evaluation information according to a target determination operation of the user in the visual interface;
[0019] A target determination module is configured to determine a target employee in the joint table according to the target time range and the target work evaluation information, the target employee being an employee whose work evaluation information within the target time range is the target work evaluation information;
[0020] a distribution determination module, configured to determine, in the joint table, the distribution of the work evaluation information of the target employee in each time range after the target time range;
[0021] The second display module is used to display the distribution status through the visual interface.
[0022] In a third aspect, the present application provides a computer device comprising a memory and a processor; the memory is used to store a computer program; the processor is used to execute the computer program and implement the steps of the above-mentioned employee evaluation information visualization method when executing the computer program.
[0023] In a fourth aspect, the present application provides a computer-readable storage medium storing a computer program. When the computer program is executed by a processor, the steps of the above-mentioned method for visualizing employee evaluation information are implemented.
[0024] The present application discloses a method, apparatus, device, and storage medium for visualizing employee evaluation information. The method comprises: obtaining a joint table, the joint table including work evaluation information of multiple employees within different time ranges; performing statistics on the work evaluation information in the joint table according to the multiple time ranges to determine the number of employees with different work evaluation information within each of the time ranges; displaying the multiple time ranges and the number of employees with different work evaluation information within each of the time ranges through a visualization interface; determining a target time range and target work evaluation information within the multiple time ranges according to a target determination operation performed by a user on the visualization interface; determining a target employee in the joint table based on the target time range and the target work evaluation information, the target employee being an employee whose work evaluation information within the target time range is the target work evaluation information; determining the distribution of the work evaluation information of the target employee in each time range after the target time range in the joint table; and displaying the distribution through the visualization interface. The method can improve the processing efficiency of financial institutions such as securities, banks, or insurance companies in determining the distribution of work evaluation information of target employees and displaying it. In some implementations, the consistency of employee evaluation information data can be guaranteed, greatly saving the time and cost of developing visualization results of employee evaluation information; for example, users can obtain the latest visualization dashboard through refresh operations, without having to manually export data to create business dashboards, achieving zero time cost in using data. BRIEF DESCRIPTION OF THE DRAWINGS
[0025] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without any creative work.
[0026] Figure 1 A flowchart of a method for visualizing employee evaluation information according to an embodiment of the present application is shown;
[0027] Figure 2 Schematic diagram of an application scenario of a method for visualizing employee evaluation information in one embodiment;
[0028] Figure 3 is a schematic diagram of the distribution of work evaluation information of target employees in one embodiment;
[0029] Figure 4 A schematic diagram of the structure of a device for visualizing employee evaluation information provided in an embodiment of the present application;
[0030] Figure 5A schematic diagram of the structure of a computer device provided in one embodiment of the present application. DETAILED DESCRIPTION
[0031] The following will be combined with the drawings in the embodiments of this application to clearly and completely describe the technical solutions in the embodiments of this application. Obviously, the embodiments described are part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of this application.
[0032] The flowcharts shown in the accompanying drawings are illustrative only and do not necessarily include all content and operations / steps, nor do they necessarily need to be executed in the order described. For example, some operations / steps may be decomposed, combined, or partially merged, so the actual order of execution may vary depending on the actual situation. In addition, although the functional modules are divided in the device schematics, in some cases, the module division may be different from that shown in the device schematics.
[0033] Embodiments of the present application provide a method, apparatus, device, and storage medium for visualizing employee evaluation information. Figure 1 This is a flow chart of a method for visualizing employee evaluation information provided by an embodiment of the present application. Figure 2 2 is a schematic diagram of an application scenario of a method for visualizing employee evaluation information in one embodiment.
[0034] The following describes some embodiments of the present application in detail with reference to the accompanying drawings. In the absence of conflict, the following embodiments and features therein may be combined with each other.
[0035] The employee evaluation information visualization method is used to efficiently determine and display the distribution of work evaluation information of target employees of financial institutions such as securities, banks, or insurance companies, but is certainly not limited thereto.
[0036] For example, the visualization method of employee evaluation information is used for servers, and of course it can also be used for terminal devices. The server can be an independent server, a server cluster, or a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, content delivery networks (CDNs), and big data and / or artificial intelligence platforms; for example, the server is a web server (or it can be called a website server). The terminal device can be an electronic device such as a mobile phone, a tablet computer, a laptop computer, a desktop computer, a personal digital assistant, and a wearable device. However, for ease of understanding, the following embodiments will mainly introduce in detail the visualization method of employee evaluation information applied to the server.
[0037] The principle of visualizing employee evaluation information in related technologies in the financial field is as follows: write code to create two fact tables, of which the first one is the main table and selects the required time slice (for example, the month when an employee reaches level B or above), and the other one is a secondary table that displays the fact performance of other time dimensions associated with the time slice (such as fact data of a longer time dimension such as 24 months). Common database data backend products are Linux (Linux is a Unix-like operating system) or Zeppelin (Zeppelin is a web-based notebook that provides interactive data analysis and visualization), and the front end is displayed as an Excel file. After the backend data is run, the data needs to be exported to an Excel file, and managers need to perform secondary processing in Excel software to realize data visualization, such as creating a pivot table or other visual dashboard for management to use. The inventors of this application have found that in some practical business operations, the data level of fact tables is in the billions. Creating, modifying, and refreshing time slices through code all takes hours. Moreover, if managers need to add new performance fields or change business logic, they need to run the above process again. Every time the data changes, managers also need to export the data to the Excel dashboard to update the data. The overall time cost is high, time-consuming, and inflexible.
[0038] In response to this discovery, the inventors of this application have improved a method for visualizing employee evaluation information in the financial sector to increase the efficiency of determining the distribution of target employee work evaluation information and displaying it. For example, the employees may be securities practitioners, bank staff, or insurance practitioners, and the work evaluation information may be, for example, sales data for these employees, but this is not limited to these.
[0039] See also Figure 1 The method for visualizing employee evaluation information according to an embodiment of the present application includes the following steps S110 to S170.
[0040] Step S110: Obtain a joint table, where the joint table includes work evaluation information of multiple employees within different time ranges.
[0041] For example, the employee's work evaluation information may be obtained from the terminal device, and the joint table may be generated, ie, created, based on the obtained work evaluation information.
[0042] Optionally, work evaluation information for employees of financial institutions such as securities, banks, or insurance companies may include, but is not limited to, at least one of the following: grade information, process indicators, and performance indicators. For example, grade information may include different levels such as Grade A / Grade B / Grade C / Grade D / Grade E. Process indicators may include at least one of the following: average number of face-to-face interviews per employee, number of online contacts, tool usage rate, and attendance rate before supplementary enrollment. Performance indicators may include at least one of the following: NBEV (New Business Embedded Value), FYC (First Year Commission), FYP (First Year Premium), and number of long-term insurance sales.
[0043] In some embodiments, obtaining the joint table includes: obtaining initial data, the initial data including work evaluation information of multiple employees at different times; based on preset slicing rules, slicing the initial data according to the width of the time range corresponding to the slicing rules to obtain the joint table.
[0044] Optionally, the width of the time range can be one week, half a month, one month, one quarter, etc., and of course it is not limited thereto. For example, work evaluation information of some evaluation dimensions is mainly analyzed within a monthly time range, such as grade information; work evaluation information of some evaluation dimensions can be analyzed within a weekly time range. By slicing the initial data according to the width of the time range corresponding to the slicing rule, the work evaluation information of the employee within a time range with an optimal width can be obtained. For example, the daily NBEV obtained can be aggregated to the corresponding month to obtain monthly cumulative data, that is, the monthly cumulative NBEV data of the employee in the corresponding month.
[0045] In some embodiments, an electronic device used to implement the employee evaluation information visualization method, such as a server, is equipped with Tableau software. This electronic device can obtain the federated table as a data source for Tableau software, where Tableau is business intelligence visualization and analysis software. Optionally, this electronic device, or another electronic device used to provide the federated table, is equipped with a Druid computing engine or other computing engine. The Druid computing engine is a real-time analytical database designed for rapid query and analysis of large data sets. The Druid computing engine is capable of handling billions of data volumes, compensating for Tableau's computing power limitations.
[0046] For example, the Druid computing engine can easily aggregate data from the DWD layer into data from the DWS layer or the ADS layer based on pre-set rules. The DWD layer can be a data detail table with ETL (extract, transform, load) functionality, while the DWS layer can be called the data service layer, typically using methods such as topic modeling or dimensional modeling. The ADS layer can be called the application service layer, typically directly connecting to OLAP analysis or business-layer data call interfaces. This is the top layer, typically containing result-type data that can be directly used or displayed, and is also the layer with the highest degree of data extraction and analysis.
[0047] For example, the Druid computing engine can slice the initial data based on preset slicing rules and the width of the time range corresponding to the slicing rules to obtain the joint table, and provide the joint table to the Tableau software. Through secondary development on the Tableau software front end, the joint table can be processed and the employee evaluation information can be visualized.
[0048] In some embodiments, the joint table includes work evaluation information across multiple evaluation dimensions. For example, the evaluation dimensions include at least one of the following: grade information, average number of face-to-face interviews per person, number of online contacts, tool usage rate, pre-recruitment attendance rate, NBEV, FYC, FYP, and number of long-term insurance sales, though these are not limiting. For ease of illustration, this embodiment primarily uses the grade information evaluation dimension as an example.
[0049] Exemplarily, the work evaluation information includes at least different work evaluation information of target evaluation dimensions. Optionally, the target evaluation dimensions include the grade information. It should be noted that the target evaluation dimensions can be pre-set or set by the user.
[0050] Optionally, the method further includes: obtaining evaluation dimensions of the work evaluation information in the joint table; displaying the evaluation dimensions via the visualization interface; and determining a target evaluation dimension from the evaluation dimensions based on a user's dimension determination operation on the visualization interface. Exemplarily, at least one preset evaluation dimension corresponding to the joint table is displayed, such as grade information, weekly NBEV cumulative data, etc., and the target evaluation dimension may be determined based on the user's dimension determination operation, such as determining grade information as the target evaluation dimension.
[0051] Exemplarily, obtaining the evaluation dimensions of the work evaluation information in the combined table includes: determining, based on the width of the time range, the evaluation dimensions corresponding to the time range from the evaluation dimensions of the work evaluation information in the combined table. For example, when the width of the time range is monthly, obtaining and displaying the evaluation dimensions with a monthly evaluation period allows the user to determine the target evaluation dimension from the evaluation dimensions with a monthly evaluation period.
[0052] For example, when slicing the initial data based on a preset slicing rule and the width of the time range corresponding to the slicing rule to obtain the joint table, the evaluation dimension corresponding to the time range of the width may be labeled to indicate that the evaluation dimension is an optional dimension. When the evaluation dimension is displayed through the visualization interface, the optional dimension is displayed so that the user can determine the target evaluation dimension from the optional dimensions.
[0053] Step S120: performing statistics on the work evaluation information in the combined table according to the multiple time ranges, and determining the number of employees with different work evaluation information within each time range.
[0054] Exemplarily, based on the multiple time ranges and the different work evaluation information of the target evaluation dimension, the work evaluation information in the joint table is statistically analyzed to determine the number of employees with different work evaluation information of the target evaluation dimension within each time range. It should be noted that statistics can also be analyzed for work evaluation information of other evaluation dimensions besides the target evaluation dimension.
[0055] For example, the target evaluation dimension is grade information, and the number of employees of different grades each month may be counted, such as the number of employees of grades A to E.
[0056] Step S130: Display the multiple time ranges and the number of employees with different work evaluation information within each time range through a visual interface.
[0057] For example, taking the multiple time ranges as variable time parameters, based on the preset slicing rules and according to the width of the time range corresponding to the slicing rules, the initial data is sliced to obtain the joint table. The multiple time ranges can be automatically determined as the variable time parameters for display, so that the user can determine the target time range.
[0058] Optionally, displaying the multiple time ranges and the number of employees with different work evaluation information within each time range through a visual interface includes: displaying the multiple time ranges, different work evaluation information of the target evaluation dimensions, and the number of employees with different work evaluation information of the target evaluation dimensions within each time range through a visual interface.
[0059] Exemplarily, the multiple time ranges include multiple months, such as January to December; the number of employees of different levels from January to December and each month can be displayed, so that users can understand the distribution of work evaluation information of different employees in each month.
[0060] Step S140: determining a target time range within the multiple time ranges and determining target work evaluation information according to the user's target determination operation on the visual interface.
[0061] For example, the user may determine a target time range within the multiple time ranges displayed on the visualization interface, such as determining September as the target time range.
[0062] Illustratively, the user may determine the target time range to be analyzed and the target work evaluation information within the target time range according to the number of employees with different work evaluation information within each time range displayed on the visualization interface.
[0063] For example, the work evaluation information includes at least different work evaluation information for a target evaluation dimension, and the target work evaluation information is determined from the different work evaluation information for the target evaluation dimension. For example, in September, the number of employees with grades A, B, C, D, and E are A9, B9, C9, D9, and E9, respectively; the user determines grade C as the target evaluation dimension.
[0064] Step S150: Determine a target employee in the joint table according to the target time range and the target work evaluation information, where the target employee is an employee whose work evaluation information in the target time range is the target work evaluation information.
[0065] For example, when September is determined as the target time range and grade C is the target evaluation dimension, employees whose grade is grade C in September are determined as the target employees, and the grade distribution of these target employees in subsequent months can be further analyzed in step S160.
[0066] Step S160: Determine, in the combined table, the distribution of the work evaluation information of the target employee in each time range after the target time range.
[0067] In some embodiments, the distribution includes: the number of target employees with different work evaluation information in each time range after the target time range; in some embodiments, the distribution can be called the evaluation migration data of the target employees in each time range after the target time range.
[0068] For example, the actual achievement of the grades of these target employees in each month after September can be determined in the combined table, such as Figure 3 shown.
[0069] Step S170: Display the distribution status through the visualization interface.
[0070] By displaying the distribution, a reference can be provided for managers, making it easier for them to formulate corresponding operational strategies. For example, in the financial field, by displaying the distribution of the target employee's work evaluation information (such as grade information, average number of face-to-face interviews per person, number of online contacts, tool usage rate, pre-recruitment attendance rate, NBEV (New Business Embedded Value), FYC (First Year Commision), FYP (First Year Premium), number of long-term insurance sales, etc.) in each time range after the target time range, it is easier for managers to formulate corresponding operational strategies. For example, managers can ensure that the target employee's grade target is achieved as much as possible by improving the target employee's average number of face-to-face interviews, number of online contacts, tool usage rate and other process indicators, or improving the target employee's NBEV (New Business Embedded Value), FYC (First Year Commision), FYP (First Year Premium), number of long-term insurance sales and other performance indicators.
[0071] It should be noted that the visualization interface displaying the multiple time ranges and the number of employees with different work evaluation information within each time range, and the visualization interface displaying the distribution situation can be the same visualization interface, for example, displayed separately in different areas in the same visualization interface, for example, to facilitate the user to adjust the target time range and the target work evaluation information; or they can be different visualization interfaces.
[0072] In some embodiments, displaying the distribution through the visualization interface includes: generating an employee evaluation migration chart based on the number of target employees with different work evaluation information within each time range after the target time range; and displaying the employee evaluation migration chart through the visualization interface.
[0073] Exemplarily, the employee evaluation migration chart includes but is not limited to at least one of the following: a table, a scatter plot, a histogram, a bar chart, a line chart, and a pie chart.
[0074] In some embodiments, displaying the distribution situation through the visualization interface includes: when the distribution situation meets a preset change condition, displaying the distribution situation through the visualization interface, wherein the time range and work evaluation information that meet the change condition are displayed with a preset display effect.
[0075] For example, the preset display effects include but are not limited to at least one of the following: highlight display, bold display, specific color display, and flashing display.
[0076] For example, based on the change conditions and according to the distribution of one or more time ranges, it can be analyzed to determine whether the target employee has the ability to maintain or continue to improve his or her grade within a certain time range, or is at risk of grade decline.
[0077] For example, when it is determined that the target employee has a risk of falling to another level within a certain time range, the time range and the other level are displayed with the preset display effect.
[0078] See also Figure 3 When it is determined that the target employee has the ability to be promoted to level B in January, the number of target employees in January and at level B is highlighted, such as 1832.
[0079] Exemplarily, the distribution condition satisfies a preset abnormal condition, including:
[0080]
[0081] Among them, n represents the number of types of work evaluation information in the current evaluation dimension, x sIndicates the sth type of work evaluation information in the current evaluation dimension, is the number of target employees with the sth type of job evaluation information within two adjacent time ranges; X represents the change threshold.
[0082] See also Figure 3 , when determining:
[0083] (2495-4669) 2 +(1770-333) 2 +(1832-75) 2 +(1217-758) 2 +(1203-2778) 2 ≥X
[0084] It can be determined that the distribution of work evaluation information in January 2022 and December 2021 meets the preset change conditions, and the work evaluation information of these two months can be displayed with the preset display effect to prompt the user to focus on analyzing the data that meets the change conditions, such as by analyzing the actual level achievement of these target employees in January 2022 and December 2021, checking the factors affecting the level achievement, and giving improvement suggestions, such as the need to increase the average number of face-to-face visits, number of online contacts, tool utilization rate and other process indicators of the target employees, or the need to improve the target employees' NBEV (New Business Embedded Value), FYC (First Year Commision), FYP (First Year Premium), number of long-term insurance sales and other performance indicators.
[0085] The embodiment of the present application provides a method for visualizing employee evaluation information, which obtains a joint table, the joint table including work evaluation information of multiple employees within different time ranges; performs statistics on the work evaluation information in the joint table according to the multiple time ranges, and determines the number of employees with different work evaluation information in each of the time ranges; displays the multiple time ranges and the number of employees with different work evaluation information in each of the time ranges through a visualization interface; determines a target time range and target work evaluation information within the multiple time ranges according to a target determination operation of the user in the visualization interface; determines a target employee in the joint table according to the target time range and the target work evaluation information, the target employee being an employee whose work evaluation information in the target time range is the target work evaluation information; determines the distribution of the work evaluation information of the target employee in each time range after the target time range in the joint table; and displays the distribution through the visualization interface. This can improve the processing efficiency of financial institutions such as securities, banks, or insurance companies in determining the distribution of work evaluation information of target employees and displaying it.
[0086] In some implementations, the embodiments of the present application can ensure the consistency of data caliber and greatly save development time costs; for example, users can obtain the latest visual dashboard through refresh operations, without having to manually export data to create business dashboards, achieving zero cost in terms of data usage time.
[0087] See also Figure 4 , Figure 4 1 is a schematic diagram of a visualization device for employee evaluation information provided by an embodiment of the present application. Optionally, the visualization device for employee evaluation information can be configured in a server to execute the steps of the aforementioned visualization method for employee evaluation information.
[0088] like Figure 4 As shown, the visualization device of the employee evaluation information includes:
[0089] A joint table acquisition module 110 is used to acquire a joint table, wherein the joint table includes work evaluation information of multiple employees within different time ranges;
[0090] A statistics module 120 is configured to collect statistics on the work evaluation information in the combined table according to the multiple time ranges, and determine the number of employees with different work evaluation information in each time range;
[0091] A first display module 130 is configured to display the multiple time ranges and the number of employees with different work evaluation information within each time range through a visual interface;
[0092] An operation determination module 140 is configured to determine a target time range and target work evaluation information according to a target determination operation of the user in the visual interface;
[0093] A target determination module 150 is configured to determine a target employee in the joint table according to the target time range and the target work evaluation information, wherein the target employee is an employee whose work evaluation information within the target time range is the target work evaluation information;
[0094] A distribution determination module 160 is configured to determine, in the joint table, the distribution of the work evaluation information of the target employee in each time range after the target time range;
[0095] The second display module 170 is configured to display the distribution status through the visual interface.
[0096] In some embodiments, the joint table acquisition module 110 is used to obtain initial data, which includes work evaluation information of multiple employees at different times; and based on a preset slicing rule, the initial data is sliced according to the width of the time range corresponding to the slicing rule to obtain the joint table.
[0097] In some embodiments, the visualization device also includes: a dimension determination module 180, the dimension determination module 180 is used to: obtain the evaluation dimensions of the work evaluation information in the joint table; display the evaluation dimensions through the visualization interface; and determine the target evaluation dimensions in the evaluation dimensions based on the user's dimension determination operation on the visualization interface.
[0098] The work evaluation information at least includes different work evaluation information of a target evaluation dimension, and the target work evaluation information is determined in the different work evaluation information of the target evaluation dimension.
[0099] In some embodiments, when obtaining the evaluation dimensions of the work evaluation information in the joint table, the dimension determination module 180 is configured to: determine the evaluation dimensions corresponding to the time range in the evaluation dimensions of the work evaluation information in the joint table according to the width of the time range.
[0100] In some embodiments, the second display module 170 is used to: generate an employee evaluation migration chart based on the number of target employees with different work evaluation information within each time range after the target time range; and display the employee evaluation migration chart through the visual interface.
[0101] In some embodiments, the second display module 170 is used to: when the distribution situation meets the preset change conditions, display the distribution situation through the visual interface, wherein the time range and work evaluation information that meet the change conditions are displayed with a preset display effect.
[0102] In some embodiments, the second display module 170 is configured to determine whether the distribution condition satisfies a preset abnormal condition according to the following formula:
[0103]
[0104] Among them, n represents the number of types of work evaluation information in the current evaluation dimension, x s Indicates the sth type of work evaluation information in the current evaluation dimension, is the number of target employees with the sth type of job evaluation information within two adjacent time ranges; X represents the change threshold.
[0105] It should be noted that those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the above-described devices and modules and units can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.
[0106] The methods and apparatus of the present application can be used in a wide variety of general-purpose or specialized computing system environments or configurations, such as personal computers, server computers, handheld or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, and distributed computing environments including any of the above.
[0107] For example, the above method and apparatus may be implemented in the form of a computer program. The computer program may be implemented in the form of a computer program. Figure 5 Runs on the computer equipment shown.
[0108] See also Figure 5 , Figure 5 1 is a schematic diagram of the structure of a computer device provided in an embodiment of the present application. The computer device may be a server or a terminal.
[0109] See Figure 5 The computer device includes a processor, a memory, and a network interface connected through a system bus, wherein the memory may include a non-volatile storage medium and an internal memory.
[0110] The non-volatile storage medium can store an operating system and a computer program. The computer program includes program instructions, which, when executed, can cause a processor to perform any step of the method for visualizing employee evaluation information.
[0111] The processor is used to provide computing and control capabilities and support the operation of the entire computer equipment.
[0112] The internal memory provides an environment for the operation of the computer program in the non-volatile storage medium. When the computer program is executed by the processor, the processor can execute any method for visualizing employee evaluation information.
[0113] The network interface is used for network communication, such as sending assigned tasks. Those skilled in the art will understand that the structure of the computer device is merely a block diagram of a portion of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than shown in the figure, or combine certain components, or have a different component arrangement.
[0114] It should be understood that the processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or any conventional processor, etc.
[0115] In one embodiment, the processor is configured to execute a computer program stored in the memory to implement the following steps:
[0116] Obtaining a joint table, the joint table including work evaluation information of multiple employees within different time ranges;
[0117] performing statistics on the work evaluation information in the combined table according to the multiple time ranges, and determining the number of employees with different work evaluation information in each of the time ranges;
[0118] Displaying the multiple time ranges and the number of employees with different work evaluation information within each time range through a visual interface;
[0119] determining a target time range and target work evaluation information within the plurality of time ranges according to a target determination operation of the user in the visual interface;
[0120] Determining a target employee in the joint table according to the target time range and the target work evaluation information, the target employee being an employee whose work evaluation information in the target time range is the target work evaluation information;
[0121] In the combined table, determining the distribution of the work evaluation information of the target employee in each time range after the target time range;
[0122] The distribution situation is displayed through the visualization interface.
[0123] In some implementations, obtaining the joint table includes:
[0124] Acquiring initial data, wherein the initial data includes work evaluation information of multiple employees at different times;
[0125] Based on a preset slicing rule, the initial data is sliced according to the width of the time range corresponding to the slicing rule to obtain the joint table.
[0126] In some embodiments, the method further comprises:
[0127] Obtaining the evaluation dimension of the work evaluation information in the joint table;
[0128] Displaying the evaluation dimension through the visual interface;
[0129] Determining a target evaluation dimension in the evaluation dimensions according to a user's dimension determination operation on the visualization interface;
[0130] The work evaluation information at least includes different work evaluation information of a target evaluation dimension, and the target work evaluation information is determined in the different work evaluation information of the target evaluation dimension.
[0131] In some implementations, obtaining the evaluation dimensions of the work evaluation information in the joint table includes:
[0132] According to the width of the time range, an evaluation dimension corresponding to the time range is determined in the evaluation dimensions of the work evaluation information in the joint table.
[0133] In some embodiments, displaying the distribution status through the visualization interface includes:
[0134] generating an employee evaluation migration chart based on the number of target employees with different work evaluation information within each time range after the target time range;
[0135] The employee evaluation migration chart is displayed through the visual interface.
[0136] In some embodiments, displaying the distribution status through the visualization interface includes:
[0137] When the distribution situation meets the preset change conditions, the distribution situation is displayed through the visualization interface, wherein the time range and work evaluation information that meet the change conditions are displayed with a preset display effect.
[0138] In some embodiments, the distribution condition satisfies a preset abnormal condition, including:
[0139]
[0140] Among them, n represents the number of types of work evaluation information in the current evaluation dimension, x s Indicates the sth type of work evaluation information in the current evaluation dimension, is the number of target employees with the sth type of job evaluation information within two adjacent time ranges; X represents the change threshold.
[0141] Through the description of the above embodiments, it can be seen that those skilled in the art can clearly understand that the present application can be implemented by means of software plus the necessary general hardware platform. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art, can be embodied in the form of a software product. The computer software product can be stored in a storage medium, such as ROM / RAM, a magnetic disk, an optical disk, etc., and includes a number of instructions for enabling a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in various embodiments of the present application or certain parts of the embodiments, such as:
[0142] A computer-readable storage medium stores a computer program, wherein the computer program includes program instructions, and the processor executes the program instructions to implement any of the employee evaluation information visualization methods provided in the embodiments of the present application.
[0143] The computer-readable storage medium may be an internal storage unit of the computer device described in the aforementioned embodiment, such as a hard disk or memory of the computer device. The computer-readable storage medium may also be an external storage device of the computer device, such as a plug-in hard disk, a SmartMedia Card (SMC), a Secure Digital (SD) card, a flash memory card, etc., equipped on the computer device.
[0144] The above description is merely a specific embodiment of the present application, but the scope of protection of the present application is not limited thereto. Any person skilled in the art can easily conceive of various equivalent modifications or substitutions within the technical scope disclosed in the present application, and such modifications or substitutions should be included in the scope of protection of the present application. Therefore, the scope of protection of the present application should be based on the scope of protection of the claims.
Claims
1. A method for visualizing employee evaluation information, characterized in that: The method comprises: Obtaining a joint table, the joint table including work evaluation information of multiple employees within different time ranges; performing statistics on the work evaluation information in the combined table according to the multiple time ranges, and determining the number of employees with different work evaluation information in each of the time ranges; Displaying the multiple time ranges and the number of employees with different work evaluation information within each time range through a visual interface; determining a target time range and target work evaluation information within the plurality of time ranges according to a target determination operation of the user in the visual interface; Determining a target employee in the joint table according to the target time range and the target work evaluation information, the target employee being an employee whose work evaluation information in the target time range is the target work evaluation information; In the combined table, determining the distribution of the work evaluation information of the target employee in each time range after the target time range; When the distribution situation meets the preset change conditions, the distribution situation is displayed through the visual interface, wherein the time range and work evaluation information that meet the change conditions are displayed with a preset display effect; The distribution situation satisfies the preset change conditions, including: in, Indicates the number of types of work evaluation information in the current evaluation dimension. Indicates the sth type of work evaluation information in the current evaluation dimension, 、 is the number of target employees for the sth type of job evaluation information within two adjacent time ranges; Indicates the abnormal threshold.
2. The visualization method according to claim 1, wherein: The obtaining of the joint table includes: Acquiring initial data, wherein the initial data includes work evaluation information of multiple employees at different times; Based on a preset slicing rule, the initial data is sliced according to the width of the time range corresponding to the slicing rule to obtain the joint table.
3. The visualization method according to claim 1, wherein: The method further comprises: Obtaining the evaluation dimension of the work evaluation information in the joint table; Displaying the evaluation dimension through the visual interface; Determining a target evaluation dimension in the evaluation dimensions according to a user's dimension determination operation on the visualization interface; The work evaluation information at least includes different work evaluation information of a target evaluation dimension, and the target work evaluation information is determined in the different work evaluation information of the target evaluation dimension.
4. The visualization method according to claim 3, wherein: The obtaining of the evaluation dimensions of the work evaluation information in the joint table includes: According to the width of the time range, an evaluation dimension corresponding to the time range is determined in the evaluation dimensions of the work evaluation information in the joint table.
5. The visualization method according to any one of claims 1 to 4, characterized in that: The displaying of the distribution situation through the visual interface includes: generating an employee evaluation migration chart based on the number of target employees with different work evaluation information within each time range after the target time range; The employee evaluation migration chart is displayed through the visual interface.
6. A device for visualizing employee evaluation information, characterized in that: include: A joint table acquisition module, configured to acquire a joint table including work evaluation information of multiple employees within different time ranges; A statistics module, configured to collect statistics on the work evaluation information in the combined table according to the multiple time ranges, and determine the number of employees with different work evaluation information in each time range; A first display module is configured to display the multiple time ranges and the number of employees with different work evaluation information within each time range through a visual interface; an operation determination module, configured to determine a target time range and target work evaluation information according to a target determination operation of the user in the visual interface; A target determination module is configured to determine a target employee in the joint table according to the target time range and the target work evaluation information, the target employee being an employee whose work evaluation information within the target time range is the target work evaluation information; a distribution determination module, configured to determine, in the joint table, the distribution of the work evaluation information of the target employee in each time range after the target time range; A second display module is configured to display the distribution situation through the visual interface when the distribution situation meets a preset change condition, wherein the time range and work evaluation information that meet the change condition are displayed with a preset display effect; The distribution situation satisfies the preset change conditions, including: in, Indicates the number of types of work evaluation information in the current evaluation dimension. Indicates the sth type of work evaluation information in the current evaluation dimension, 、 is the number of target employees for the sth type of job evaluation information within two adjacent time ranges; Indicates the abnormal threshold.
7. A computer device, characterized in that: The computer device includes a memory and a processor; The memory is used to store computer programs; The processor is configured to execute the computer program and implement the steps of the method for visualizing employee evaluation information according to any one of claims 1 to 5 when executing the computer program.
8. A computer-readable storage medium storing a computer program, characterized in that: If the computer program is executed by a processor, the steps of the method for visualizing employee evaluation information according to any one of claims 1 to 5 are implemented.
Citation Information
Patent Citations
Employee evaluation method and device, equipment and storage medium
CN110197313A
Data visualization processing method and device and electronic device
CN113254542A