HR Analytics Project (MySQL)

📌 Project Overview

This project focuses on analyzing Human Resources (HR) data using MySQL to extract meaningful business insights related to employees, attrition, performance, and demographics.

The goal is to practice SQL querying, data exploration, and advanced analysis in a real-world HR dataset.

---

📂 Project Structure

HR-PROJECT
│
├── data
│ └── HumanResources.csv
│
├── src
│ ├── 01_create_load_tables.sql
│ ├── 02_eda.sql
│ └── 03_advanced_analysis.sql
│
├── results
│ └── insights.md
│
└── README.md

---

🛠 Tools & Technologies Used

• MySQL – Data storage and analysis
• SQL – Queries, joins, aggregations, subqueries
• CSV Dataset – Human Resources data

---

🔍 Analysis Workflow

1. Table Creation & Data Loading

   • Created HR table
   • Loaded CSV data into MySQL

2. Exploratory Data Analysis (EDA)

   • 1 Database & Table Explotation
   • 2 Dimension Exploration
   • 3 Date Exploration
   • 4 Measures Exploration
   • 5 Magnitude Analysis
   • 6 Ranking Analysis

3. Advanced Data Analysis

   • 7 CHANGES-OVER-TIME TRENDS
   • 8 CUMULATIVE ANALYSIS
   • 9 PERFORMANCE ANALYSIS
   • 10 PART TO WHOLE
   • 11 DATA SEGMENTATION
   • 12 REPORTING

---

📊 Key Business Questions Answered

• Which departments have the highest attrition?
• Does salary affect employee attrition?
• What age group leaves the company most?
• Is experience linked to employee retention?

---

📈 Final Outcome

This project demonstrates:

• Strong SQL fundamentals
• Analytical thinking
• Ability to convert raw HR data into business insights

---

👤 Author

Nishant Singh
Data Analytics Student