HR Analytics in Tableau

Case Study: HR Analytics in Tableau

Jess Ahmet

Content Developer at DataCamp

What is a case study?

  • Apply Tableau skills
  • Combine previously learned concepts
  • Solve an example real-world problem

$$

Prerequisite courses:

  • Introduction to Tableau
  • Connecting Data in Tableau
Case Study: HR Analytics in Tableau

Working with Tableau

4 boxes outlining the Tableau development process

Case Study: HR Analytics in Tableau

Working with Tableau

4 boxes outlining the Tableau development process with yellow highlight on first 3 boxes

Case Study: HR Analytics in Tableau

Revisiting relationships

Relationships are a dynamic, flexible way to combine data from multiple tables for analysis.

Cardinality

  • One-to-One
  • One-to-Many
  • Many-to-One
  • Many-to-Many

Related Fields

  • To create a relationship, there must be at least one field that we use to link our tables
Case Study: HR Analytics in Tableau

Case study goals

Primary goal:

  • Monitor key HR metrics on employees

 

Secondary goal:

  • Understand what factors impact attrition

Analytics

Case Study: HR Analytics in Tableau

Dataset: Employees

Column name Description
Employee ID A unique ID that identifies an employee. Connects to Performance Rating table.
First Name First name of an employee
Last Name Last name / surname of an employee
Department Most recent department that employee belongs/belonged to
Job Role Most recent department that employee belongs/belonged to
Salary Most recent record of employee salary
Education A unique ID that identifies an employees education level. Connects to Education Level table
... ...
Case Study: HR Analytics in Tableau

Dataset: Performance Ratings

Column name Description
Performance ID A unique id that identifies a performance review
Employee ID A unique ID that identifies an employee. Connects to Employee table.
Review Date Date an employees' review took place.
Environment Satisfaction Rating for employees' satisfaction with their environment.
... ...
Case Study: HR Analytics in Tableau

Dataset: Education Level

Column name Description
Education Level ID A unique id that identifies a education level
Education Level A unique ID that identifies an employee. Connects to Employee table.
Case Study: HR Analytics in Tableau

Employee connects to PerformanceRating

Model with relationship between employee and performance rating

Case Study: HR Analytics in Tableau

Employee connects to EducationLevel

Model with relationship between employee and education level

Case Study: HR Analytics in Tableau

Let's practice!

Case Study: HR Analytics in Tableau

Preparing Video For Download...