Motivation And Project Overview
Human Resource Analytics is the idea of using data in the organizational context to understand different factors about employees such as their degree of collaboration and influence. Known researcher Rob Cross has also said “Organizational Network Analysis provides a powerful means of making invisible patterns of information flow and collaboration, visible.” These factors are generally computed based on various sets of data that are primarily collected via pulse surveys. The data collection process is slow because pulse surveys must be distributed at regular intervals to receive updated insights. However, this is not a viable option as it is not only a repetitive process but also makes it difficult for managers to view real-time insights.
This study explores and investigates whether subject lines and frequency of emails exchanged between employees can be used as a representative resource for analyzing organizational networks, specifically, the work network. We define work network as the network of employees with whom one interacts with on a daily basis for work purposes.
Objective
- Perform Feature Engineering to create a new ‘Trust Score’ algorithm. A trust score is an aggregate weightage shows the strength of communication tie between two employees in a social network.
- Develop a dashboard that displays various metrics that would quantify the collaboration between employees, identify the most influential employees and give managers a high-level view of these statistics to maintain a collaborative and efficient workplace.
- Research and validate the potential of a Hybrid Centrality (potentially a combination of betweeness and degree) calculated from email communication data as a measure of influence score.
Data
We are provided with an excel sheet containing a huge set of email exchange log via the TrustSphere domain. The data consists of 14 columns as described below:
Column Explanations
| Date
|
Timestamp of the email
|
| Remote IP
|
If the email exchange is external then this column shows the external person's email
|
| Remote
|
The TrustSphere employee who is receiving or sending the email
|
| Remote Domain
|
Always TrustSphere
|
| Local
|
Email address of the person sending the email
|
| Local Domain
|
Domain of the person who is sending the email
|
| Originator
|
Inbound, outbound or internal (if you’re receiving the email, sending it or if the email is between 2 TrustSphere employees)
|
| Direction
|
Always TrustSphere in this case
|
| Domain Group
|
Email Header (Subject Line)
|
| Subject
|
Type of message: email/im (instant messaging)/voice/sms
|
| Inbound Count
|
Number of emails received
|
| Outbound Count
|
Number of emails sent
|
| Size
|
Size of the message (number of characters)
|
| Msgid
|
Encoded Message ID
|
Data Statistics
| Number of rows
|
121,154
|
| Date Range
|
11/26/2016 8:00 am to 02/01/2017 00:00 am
|
|
|
|
