RWFD has teamed up with Steve Wexler for a new challenge! See the end of this page for how to share your finished work!
The data set contains information about cross-function mobility within an organization over a six-month period.
What is cross-function mobility? It’s when people move from one team to another team within a department, or when they move from one department to another.
This type of movement is a good thing… If it’s balanced. If a lot of people are fleeing a particular team or department, that is NOT a good thing. It indicates there may be something toxic about that department. Or maybe it’s just one or two teams within that department?
And are things so toxic that people aren’t just leaving the team/department and moving to another? Are people leaving the company?
We’ve also provided tenure information as a demographic to analyze. When people who have only been with the company for under a year leave the company, it is particularly costly as the company will have invested time and money in onboarding these people only to see them leave before they are productive.
Your assignment is to show
- Are things healthy or out of balance?
- If there are problems, in which teams or departments is that happening?
- Are there any particularly popular destinations? That is, do a lot of people appear to be flocking to a particular team?
- Is the flow among teams and departments consistent, or were there particular months when there was a lot of movement?
- Are a lot of new hires leaving the company? If “yes” are the leaving from all teams equally?
The data set can be found here, on Data.World
The Data Dictionary
Employee ID – Unique employee identifier
Current Department** – The department the employee is currently assigned
Current Team** – The team the employee is currently assigned
Previous Department** – the department the employee left
Previous team** – the team the employee left
Tenure – Grouping of the number of years the employee has worked for the company
**Teams Belong to Departments
Movement Type Category – Describes the type of movement the employee experienced
(Dept change, leaver, left the company, Newcomer, no movement, team change)
Gainer/Loser – marks the employee change as a loss of a gain for the team/department
Gainer/Loser Team – Marks the team that the movement occurred within
Gainer/Loser Department – Marks the department the that movement occurred within
Gainer/Loser (Team Category) – designates movement within a department from one team to another
Date YearMonth – Time period the movement occurred
SHARING YOUR WORK
Once you are done and published to Tableau Public, please post on LinkedIn or Twitter and tag Jacqui Moore, Steve Wexler, and Mark Bradbourne with the hashtag #RWFD. This ensures we will see it and can provide feedback (if wanted), and share it to a wider audience.