📊 HR Analytics - MySQL 50 Queries

📌 Project Overview

This project solves 50 real-world SQL queries on an HR Analytics dataset using MySQL, covering employee attrition, salary trends, department performance, and job role analysis. Findings are visualized in an interactive Power BI dashboard, with a summary presentation covering key insights.

---

🗂️ Dataset

Dataset	Records	Type
HR_1	[VERIFY: actual row count]	Excel/CSV
HR_2	[VERIFY: actual row count]	Excel/CSV

⚠️ Confirm actual record counts before publishing — double-check against the source dataset.

---

🛠️ Tech Stack

Layer	Tools Used
Database & Querying	MySQL 8.0 (MySQL Workbench)
Dashboarding	Power BI (DAX)
Presentation	PowerPoint
Dataset Format	Excel / CSV

---

🔄 Project Workflow

1. Data Import — loaded HR_1 and HR_2 datasets into MySQL
2. SQL Analysis — wrote 50 business queries covering attrition, salary, performance, and department metrics
3. Dashboarding — built an interactive Power BI dashboard (HR ANALYTICS DASHBOARD.pbix) on top of query outputs
4. Reporting — summarized key findings in HR_Analytics_50_Queries_Complete.pptx

---

❓ Key Business Questions

• ✅ Average Attrition Rate by Department
• ✅ Average Hourly Rate of Male Research Scientists
• ✅ Attrition Rate vs Monthly Income
• ✅ Average Working Years per Department
• ✅ Job Role vs Work-Life Balance
• ✅ Gender-based Salary Analysis
• ✅ Performance & Satisfaction Metrics

---

🧮 SQL Concepts Used

[ADD: tick off whichever of these your 50 queries actually use — don't list ones you didn't use]

• Joins (Inner/Left/Right)
• Aggregate Functions (SUM, AVG, COUNT)
• GROUP BY / HAVING
• Window Functions (RANK, ROW_NUMBER, etc.)
• CTEs / Subqueries
• CASE Statements

---

🖼️ Dashboard

[ADD: 1-2 line note on what the dashboard shows — key KPIs/visuals]

📎 Full presentation: HR_Analytics_50_Queries_Complete.pptx

---

💡 Business Insights

[ADD: your actual top 3-4 findings from the queries/dashboard, e.g. which department has highest attrition, biggest pay gap finding, etc. — don't leave this section out, it's what recruiters read first]

---

📁 Folder Structure

HR-Analytics-MySQL-50-Queries
│
├── README.md
├── LICENSE
│
├── sql
│   └── HR Analytics 50 MySQL Queries.docx
│
├── powerbi
│   ├── HR ANALYTICS DASHBOARD.pbix
│   └── Dashboard_Preview.png
│
└── docs
    └── HR_Analytics_50_Queries_Complete.pptx

---

🚀 How to Use

1. Clone this repository
2. Import HR_1 and HR_2 datasets into MySQL
3. Run the queries from sql/HR Analytics 50 MySQL Queries.docx in MySQL Workbench
4. Open powerbi/HR ANALYTICS DASHBOARD.pbix in Power BI Desktop to explore the dashboard
5. Refer to docs/HR_Analytics_50_Queries_Complete.pptx for the summarized findings

---

👤 Author

Sagar Shende Data Analyst Trainee @ Dream With Data | Microsoft Certified: Power BI Data Analyst Associate (PL-300)