Skip to content
Competition - Employee Network Analysis
0
  • AI Chat
  • Code
  • Report

    • How can the company improve collaboration?

    📖 Background

    You work in the analytics department of a multinational company, and the head of HR wants your help mapping out the company's employee network using message data.

    They plan to use the network map to understand interdepartmental dynamics better and explore how the company shares information. The ultimate goal of this project is to think of ways to improve collaboration throughout the company.

    💾 The data

    The company has six months of information on inter-employee communication. For privacy reasons, only sender, receiver, and message length information are available (source).

    Messages has information on the sender, receiver, and time.
    • "sender" - represents the employee id of the employee sending the message.
    • "receiver" - represents the employee id of the employee receiving the message.
    • "timestamp" - the date of the message.
    • "message_length" - the length in words of the message.
    Employees has information on each employee;
    • "id" - represents the employee id of the employee.
    • "department" - is the department within the company.
    • "location" - is the country where the employee lives.
    • "age" - is the age of the employee.

    Acknowledgments: Pietro Panzarasa, Tore Opsahl, and Kathleen M. Carley. "Patterns and dynamics of users' behavior and interaction: Network analysis of an online community." Journal of the American Society for Information Science and Technology 60.5 (2009): 911-932.

    suppressPackageStartupMessages(library(tidyverse))
messages <- readr::read_csv('data/messages.csv', show_col_types = FALSE)
messages
    employees <- readr::read_csv('data/employees.csv', show_col_types = FALSE)
employees

    💪 Competition challenge

    Create a report that covers the following:

    1. Which departments are the most/least active?
    2. Which employee has the most connections?
    3. Identify the most influential departments and employees.
    4. Using the network analysis, in which departments would you recommend the HR team focus to boost collaboration?

    🧑‍⚖️ Judging criteria

    CATEGORYWEIGHTINGDETAILS
    Recommendations35%
    • Clarity of recommendations - how clear and well presented the recommendation is.
    • Quality of recommendations - are appropriate analytical techniques used & are the conclusions valid?
    • Number of relevant insights found for the target audience.
    Storytelling35%
    • How well the data and insights are connected to the recommendation.
    • How the narrative and whole report connects together.
    • Balancing making the report in-depth enough but also concise.
    Visualizations20%
    • Appropriateness of visualization used.
    • Clarity of insight from visualization.
    Votes10%
    • Up voting - most upvoted entries get the most points.

    ✅ Checklist before publishing into the competition

    • Rename your workspace to make it descriptive of your work. N.B. you should leave the notebook name as notebook.ipynb.
    • Remove redundant cells like the judging criteria, so the workbook is focused on your story.
    • Make sure the workbook reads well and explains how you found your insights.
    • Try to include an executive summary of your recommendations at the beginning.
    • Check that all the cells run without error

    ⌛️ Time is ticking. Good luck!