HR Employee Attrition Tracker

Difficulty
Intermediate
Estimated Time
15 Hours
Portfolio Value
High
Interview Value
High
HR Employee Attrition Tracker

The Business Problem

The company has a high turnover rate among junior developers. HR needs to know if salary, distance from home, or manager satisfaction are the primary drivers.

Project Overview

This project simulates a real data engineering pipeline. You will take a flat HR file, load it into a SQL database, and write advanced queries to uncover why employees are quitting. Finally, you will connect Tableau directly to your SQL database to visualize the results for the HR Director.

Step-by-Step Implementation

Follow this structured path to complete the project successfully.

1

Step 1: Database Setup

Create a local database. Write a CREATE TABLE script and import the IBM HR CSV data.

2

Step 2: Exploratory SQL

Write queries to find the attrition rate by Department and Job Role.

3

Step 3: Advanced SQL

Use CTEs to segment employees into salary bands. Use Window functions to rank departments by highest average tenure.

4

Step 4: Tableau Connection

Connect Tableau directly to your local SQL database or export your SQL views to a new CSV.

5

Step 5: Visualization

Build a dashboard showing a heatmap of Attrition by Job Role and OverTime.

Expected Output

A clean, professional Tableau dashboard and a beautifully formatted SQL script demonstrating you know how to write production-level code.

Common Mistakes to Avoid

  • Writing messy SQL without indentation or comments.
  • Making the Tableau dashboard too cluttered with unnecessary charts (like 3D pies).

More Intermediate Projects

Netflix Content Strategy Analysis
Available

Netflix Content Strategy Analysis

Analyze the entire Netflix catalog using Power BI to uncover content trends, durations, and geographical focus.

Intermediate
20 Hours
Power BI
Data ModelingDAX+1
View Project
E-Commerce Database Optimization
Available

E-Commerce Database Optimization

Take a chaotic e-commerce dataset, normalize it into a star schema, and write performance-optimized SQL queries.

Intermediate
18 Hours
MySQLDBeaver
SQLData Modeling+1
View Project