Aggregating data from a plurality of data sources

A computer system configured to aggregate and analyze data from a plurality of data sources, the computer system comprising:

• one or more hardware computer processors configured to execute code in order to cause the system to:
• access first and second data from a plurality of data sources, the plurality of data sources comprising a first data source and a second data source, wherein the first data source and the second data source are different from one another, each of the first data source and the second data source comprising one two or more of:
• email data, system logon data, system logoff data, badge swipe data, employee data, software version data, software license data, remote access data, phone call data, work production data, VPN login data, remote access data, or job processing data, each data source of the plurality of data sources associated with a plurality of workers, wherein for each data source, each worker of the plurality of workers is associated by a respective identifier;
• detect a discrepancy associated with data from the first data;
• in response to the detection of the discrepancy, reaccess first data from the first data source;
• detect inconsistencies in formatting of data from each of the reaccessed first data and the second data;
• transform data from each of the reaccessed first data and the second data into a format that is compatible for combining data from respective data sources of the plurality of data sources, and wherein the reaccessed first data and the second data comprise different identifiers that identify the same employee;
• generate a mapping of data items from each of the reaccessed first data and the second data to respective workers of the plurality of workers, wherein the mapping is based at least in part on correlating each worker's respective identifier to the different identifiers from the reaccessed first data and the second data that identify the same employee;
• generate combined data by combining data from the reaccessed first data, the second data, and the mapping;
• generate an intermediate output based at least in part on generating summary data associated with some data items of the combined data;
• and
• display, in a user interface, statistics associated with the respective workers based on the intermediate output, wherein the statistics indicate efficiency of the respective workers who have at least one common characteristic and wherein the at least one common characteristic comprises at least a common job description or job title, and wherein the statistics are associated with work productivity data over a period of time for the respective workers, and wherein the work productivity data comprises a correlation between email summary data and the common job description or job title of the respective workers.

A non-transitory computer readable storage medium comprising instructions for aggregating and analyzing data from a plurality of data sources that cause a computer processor to:

• access first and second data from a plurality of data sources, the plurality of data sources comprising a first data source and a second data source, wherein the first data source and the second data source are different from one another, each of the first data source and the second data source comprising one or more of:
• email data, system logon data, system logoff data, badge swipe data, employee data, software version data, software license data, remote access data, phone call data, work production data, VPN login data, remote access data, or job processing data, each data source of the plurality of data sources associated with a plurality of employees, wherein for each data source, each employee of the plurality of employees is associated by a respective identifier;
• detect a discrepancy associated with data from the first data;
• in response to the detection of the discrepancy, reaccess first data from the first data source;
• detect inconsistencies in formatting of data from each of the reaccessed first data and the second data;
• transform data from each of the reaccessed first data and the second data into a format that is compatible for combining data from respective data sources of the plurality of data sources, and wherein the reaccessed first data and the second data comprise different identifiers that identify the same employee;
• associate data items from each of the reaccessed first data and the second data to respective employees of the plurality of employees, wherein the association is based at least in part on correlating each employee's respective identifier to the different identifiers from the reaccessed first data and the second data that identify the same employee;
• generate combined data by combining data from two or more data sources from the reaccessed first data, the second data, and the associated data items;
• and
• generate an intermediate output based at least in part on generating summary data associated with some data items of the combined data;
• and
• generate output data comprising statistics associated with respective employees based at least in part on the the intermediate output, wherein the statistics indicate efficiency of respective employees who have at least one common characteristic and wherein the at least one common characteristic comprises at least a common job description or job title, and wherein the statistics are associated with work productivity data over a period of time for the respective workers, and wherein the work productivity data comprises a correlation between email summary data and the common job description or job title of the respective employees.