HR Analytics Dashboard

Goal

From HR data, answer:

• Attrition rate
• Attrition by department/job role
• Salary and tenure differences

Analysis pipeline

diagram HR analytics pipeline mermaid

  flowchart LR
  A["Raw HR data
(attrition 0/1)"] --> B["Rate
(overall attrition %)"]
  B --> C["Segment
(department, role)"]
  C --> D["Visualize
(attrition by segment)"]
  D --> E["Conclude
(interventions)"]

From raw employee records to attrition insights by segment.

From the book

McKinney builds a two-way pivot_table (movie title x gender) instead of running several separate groupby calls, because it puts both dimensions side by side in one readable table. The same move works here: df.pivot_table("attrition", index="department", columns="job_role", aggfunc="mean") shows every department/role combination’s attrition rate at once.

Step 1: Load

Load HR data

import pandas as pd
 
df = pd.read_csv("data/hr.csv")
print(df.head())

Step 2: Attrition rate

Attrition

rate = df["attrition"].mean()  # assuming attrition is 0/1
print("Attrition rate:", rate)

Step 3: Bar plots by segment

Attrition by dept

import seaborn as sns
import matplotlib.pyplot as plt
 
plt.figure(figsize=(10, 4))
sns.barplot(data=df, x="department", y="attrition")
plt.title("Attrition rate by department")
plt.xticks(rotation=20)
plt.tight_layout()
plt.show()

Step 4: Box plots for numeric features

Salary vs attrition

import seaborn as sns
import matplotlib.pyplot as plt
 
plt.figure(figsize=(7, 4))
sns.boxplot(data=df, x="attrition", y="salary")
plt.title("Salary vs attrition")
plt.tight_layout()
plt.show()

Visualize it

sketch Attrition rate by department p5.js Pause Restart

Departments with taller amber bars need attention first.

Deliverable

A dashboard should include:

• Attrition KPI
• Top segments with high attrition
• Suggested interventions (training, compensation, career path)

🧪 Try It Yourself

Exercise 1 – Overall attrition rate

pch.exerciseTag pch.exerciseTitle

Exercise 2 – Attrition by department

pch.exerciseTag pch.exerciseTitle

Exercise 3 – Two-way attrition pivot table

pch.exerciseTag pch.exerciseTitle