BUS5VA: Visual Analytics
Tasks for Assessment 2: Project
TASK 1: Why do employees leave? (50 marks)
Employees are the backbone of any organisation. An organisationàperformance is heavily based on the quality
and retention of the employees. With employee attrition, organisations are faced with many challenges including:
•
•
the expense in terms of both money and time to train new employees
loss of experienced employees
impact on productivity
impact on profit.
The employee attrition data used for this task and detailed descriptions can be found here.
The dataset used in this task contains HR analytics data of employees that stay and leave. The types of data
include metrics such as education level, job satisfaction and commute distance. The goal is to uncover the factors
that lead to employee attrition. The dataset for this task is provided under the main Assessment page.
Use visualisations to address the below questions.
1.1 Is there a correlation between age and daily rate? (12.5 marks)
1.2 Is there a difference in attrition between male and female employees? (12.5 marks)
1.3 What is the distribution of daily rates across different departments? (12.5 marks)
1.4 What factors lead to employee attritions? Focus on four columns: Department, OverTime, JobLevel, and
JobSatisfaction. (12.5 marks)
TASK 2: Sport analytics (50 marks)
The soccer match event dataset provides to the public the largest open collection of soccer logs ever released,
collected by Wyscout and containing all the spatiotemporal events (passes, shots, fouls, etc.) that occur during all
matches of an entire season of seven competitions (La Liga, Serie A, Bundesliga, Premier League, Ligue 1,
FIFA World Cup 2018, UEFA Euro Cup 2016). A match event contains information about its position, time,
outcome, player and characteristics. The two datasets used in this task are as follows:
•
Player dataset: describes all players of the teams playing in seven national and international soccer
competitions (Italian, Spanish, French, German, English first divisions, World Cup 2018, European Cup 2016).
See this link for a detailed description of each attribute.
Event dataset: describes all the events that occur during each match. Each event refers to a ball touch and
contains the information such as players involved, event names and event times. See this link for a detailed
description of each attribute.
The datasets for this task are provided under the main Assessment page.
Create interactive visualisations to analyse this large dataset and answer the following questions.
2.1 Create visualisation(s) to rank players based on the number of shots they made. Highlight the top five players
with the most shots. Also allow users to see each playeràattributes such as weight, height, full name and
nationality when users hover their mouse on a player of interest. (12.5 marks)
2.2 Compare the performance (number of shots, number of passes, number of free kicks, number of fouls,
number of offsides) of Lionel Messi (wyId: 3359) and Cristiano Ronaldo (wyId: 3322) who are the two greatest
players in the last decade based on the events in the dataset. (12.5 marks)
2.3 Create a Datapane report that (1) allows users to rank players based on a selected event (focusing on the five
events: Pass, Shot, Free Kick, Foul, Offside), and (2) compares the number of passes and the number of shots
recorded across all positions (idfielder ¯rward %fender ïalkeepern (25 marks)
Page 1 of 1

Purchase answer to see full
attachment