Systems and methods for commute analysis and modeling

• US 10,474,978 B2
• Filed: 04/28/2015
• Issued: 11/12/2019
• Est. Priority Date: 04/28/2015
• Status: Active Grant

• Current Assignee: ADP, Inc.
• Original Assignee: ADP LLC (ADP, Inc.)
• Inventors: Bangali, Kishore, Havaldar, Sachin V., Rind, Marc, Wang, Xiaojing
• Primary Examiner(s): Waesco, Joseph M
• Application Number:
  US14/698,146
• Publication Number:
  US 20160321590A1
• Time in Patent Office: 1,659 Days
• Field of Search: None
• CPC Class Codes: G06Q 10/06393 Score-carding, benchmarking or key performance indicator [KPI] analysis

Abstract

A method and system for analyzing employee retention across an enterprise based on commuter modeling is disclosed. The method can be implemented in a computer system which includes: mapping longitudinal and latitudinal coordinates of address information of a plurality of employees and a work location onto a map, which shows a predefined geographic location encompassing the work location surrounded by the longitudinal and latitudinal coordinates of the address information; obtaining calculated analytics data of employee turnover rate for the plurality of employees based on a commute distance from the work location to each of the longitudinal and latitudinal coordinates of the plurality of employees; and graphically overlaying the analytics data of the turnover rate for the plurality of employees onto the map to show employee turnover rate for different segments of the map.

Claims

1. A method implemented in a computer system, the method comprising:

extracting address information of a plurality of employees from a database using an application programming interface (API);

converting the extracted address information of the plurality of employees into longitudinal and latitudinal coordinates corresponding to the plurality of employees using a geocode service API;

using a mapping module, by the computer system, to map the longitudinal and latitudinal coordinates corresponding to the plurality of employees and a work location onto a map, the map being visually displayed on a display device of the computer system and showing a predefined geographic location encompassing the work location surrounded by the longitudinal and latitudinal coordinates of the address information;

receiving, by the computer system, a selection of the work location;

obtaining, by the computer system, calculated analytics data of employee turnover rate for the plurality of employees based on a commute distance from the work location to each of the longitudinal and latitudinal coordinates of the plurality of employees;

in response to the computer system receiving the selection of the work location, using the mapping module to graphically overlay the analytics data of the turnover rate for the plurality of employees onto the map to provide a graphical representation of employee turnover rate for different segments of the map displayed on the display device,

using the mapping module, by the computer system, to plot additional information onto the map displayed on the display device including at least forming lines connecting each of the longitudinal and latitudinal coordinates of each employee to the work location,

wherein the lines connecting each of the employees to the work location signify different metrics associated with each of the employees,

wherein the different metrics are represented, respectively, by at least one of different colors for the lines and different types of dashed lines for the lines displayed on the display device,

wherein the additional information further includes a plurality of concentric circles at certain radii from the work location that are displayed on the display device, and employee turnover rate is calculated and graphically shown for each of the concentric circles on the display device based on the longitudinal and latitudinal coordinates falling within each of the concentric circles, and

wherein a center of the concentric circles corresponds to the selected work location, and wherein the longitudinal and latitudinal coordinates fall within each of the concentric circles such that a predictive model is created to determine how many employees would have terminated employment based on a commute distance from the selected work location; and

determining, by the computer system, a location of a new work site based on the longitudinal and latitudinal coordinates of a number of employees being within the concentric circles around the new work site.

2. The method of claim 1, wherein the obtaining of the analytics of the turnover rate is extracted from a database using an API.

3. The method of claim 1, wherein the map is obtained through a JavaScript charting library and the latitudinal and longitudinal coordinates is plotted onto the map using a geo-JSON specification.

4. The method of claim 1, further comprising using a jQuery to plot additional information onto the map.

5. The method of claim 1, wherein the employee turnover rate is represented as a percentage of termination within each of the concentric circles.

6. The method of claim 1, wherein the different metrics comprise employee status including at least one of new hire, current employee, terminated employee and employment information.

7. A computer system comprising:

a hardware memory device that stores program instructions; and

a processor that executes the program instructions and causes the computer system to;

extract address information of a plurality of employees from a database using an application programming interface (API);

convert the extracted address information of the plurality of employees into longitudinal and latitudinal coordinates corresponding to the plurality of employees using a geocode service API;

use a mapping module to map the longitudinal and latitudinal coordinates corresponding to the plurality of employees and a work location onto a map, the map being visually displayed on a display device of the computer system, in response to the computer system receiving a selection of the work location;

extract analytics data of employee turnover rate for the plurality of employees associated with a commute distance from the work location to each of the longitudinal and latitudinal coordinates of the plurality of employees;

use the mapping module to generate an overlay of the extracted analytics data on the map displayed on the display device, the overlay graphically representing employee turnover rate for different segments of the map centered about the work location,

wherein;

the program instructions are stored on computer readable storage medium for execution by a CPU via computer readable memory,

the processor that executes the program instructions causes the computer system to use the mapping module to further plot additional information onto the map displayed on the display device including a plurality of concentric circles at certain radii from the work location which is representative of the different segments of the map centered about the work location,

employee turnover rate is calculated and graphically shown on the map displayed on the display device for each of the concentric circles based on the longitudinal and latitudinal coordinates falling within each of the concentric circles,

the concentric circles correspond to a selected work location,

the longitudinal and latitudinal coordinates are plotted with respect to the concentric circles,

the longitudinal and latitudinal coordinates fall within each of the concentric circles such that a predictive model is created to determine how many employees would have terminated employment based on a commute distance from the selected work location;

the processor that executes the program instructions causes the computer system to further calculate and graphically show using the mapping module, in an overlay format on the map displayed on the display device, how many employees would have terminated employment based on a commute distance from the selected work location; and

the processor that executes the program instructions further causes the computer system to determine a location of a new work site based on the longitudinal and latitudinal coordinates of a number of employees being within the concentric circles around the new work site.

8. The computer system of claim 7, wherein the analytics of the turnover rate and employee information including the address information is extracted from a database using one or more APIs.

9. The computer system of claim 7, wherein the map is obtained through a JavaScript charting library and the latitudinal and longitudinal coordinates is plotted onto the map using a geo-JSON specification.

10. The computer system of claim 9, wherein the processor that executes the program instructions causes the computer system to further plot additional information onto the map including at least a line connecting each of the longitudinal and latitudinal coordinates of each employee to the work location.

11. The computer system of claim 10, wherein the lines connecting each of the employees to the work location signifies different metrics associated with each of the employees.

12. A computer program product comprising computer readable program instructions stored on non-transitory computer readable storage medium, the computer readable program instructions causing a computing device to:

extract address information of a plurality of employees from a database using one or more service APIs;

convert the address information into longitudinal and latitudinal coordinates using geocode service APIs;

upon selection of a selectable work location provided on a map, the map being visually displayed on a display device of the computer system;

plot the longitudinal and latitudinal coordinates of the plurality of employees onto the map displayed on the display device, surrounding the selectable work location;

extract an employee termination rate for the plurality of employees associated with a commute distance from the work location to each of the longitudinal and latitudinal coordinates of the plurality of employees;

draw defined segments on the map, displayed on the display device, which centers about the selectable work location and which includes at least some of the longitudinal and latitudinal coordinates within the defined segments;

post data of the turnover rate for each segment of the map displayed on the display device graphically showing a percentage of the employee termination rate for each segment based on the commute distance,

plot additional information onto the map displayed on the display device including at least forming lines connecting each of the longitudinal and latitudinal coordinates of each employee to the work location,

wherein the lines connecting each of the employees to the work location signify different metrics associated with each of the employees,

wherein the additional information further includes a plurality of concentric circles at certain radii from the work location that are displayed on the display device and employee turnover rate is calculated and graphically shown for each of the concentric circles on the display device based on the longitudinal and latitudinal coordinates falling within each of the concentric circles, and

wherein the concentric circles correspond to a selected work location, and wherein the longitudinal and latitudinal coordinates fall within each of the concentric circles such that a predictive model is created to determine how many employees would have terminated employment based on a commute distance from the selected work location; and

determine a location of a new work site when the longitudinal and latitudinal coordinates of a number of employees are within the concentric circles around the new work site.

13. The method of claim 12, wherein the different metrics comprise employee status including at least one of new hire, current employee, terminated employee and employment information.

14. The method of claim 12, wherein the different metrics are represented, respectively, by at least one of different colors for the lines and different types of dashed lines for the lines.