Motivation
The way the employees of a company collaborate within teams and even across regions is very important to the success of a company. Thus, the business leaders are interested in keeping a check on this area of the firm and ask various questions such as:
• Are different geographies working well?
• Which employees work in silos?
• How effective are the sales people at email correspondence?
Answers for such questions usually rely more on qualitative observations as not many standard metrics can be directly used to track these details. Due to its general derivation, the results are often considered unreliable and hence non-actionable. The main motivation of our project is to assist TrustSphere to derive reliable and actionable insights regarding collaboration due to our data-driven approach.
Objective
The primary objective of our project is to use social network analysis theories to create a hybrid centrality scoring method and a comprehensive dashboard based on email correspondence data that would provide TrustSphere with direct insights on various aspects of global collaboration effectiveness.
Data
We are provided with an excel sheet containing a huge set of email exchange log via the trustsphere domain. The data provided is clean.
The data consists of the following attributes:
1. Date: date the email was sent/received
2. Originator address: email address of the sender
3. Recipient address: email address of the recipient
4. Direction:
a. ‘Inbound’ – email received by an employee of TrustSphere from an external sender
b. ‘Outbound’ – email sent by an employee of TrustSphere to external recipient
c. ‘Internal’ – email exchanged within TrustSphere employees
5. Type:
a. ‘em’ – message sent via email
b. ‘im’ – message sent via instant messaging
6. Size: number of characters in the message
7. Msg ID: unique ID given to every emailing chain
8. Email Subject: subject of the email
|
|
|
