🔹 Business Problem

The organisation is facing a 16.12% employee attrition rate, raising concerns about workforce stability and long-term productivity.

HR leadership seeks to identify the underlying drivers of employee turnover and develop data-driven retention strategies to reduce voluntary exits.

🔹 Tools Used

• Google BigQuery - SQL Analysis
• Power BI
• Google Sheets

🔹 Approach

• Data cleaning
• SQL analysis
• KPI development
• Dashboard storytelling

🔹 Data Cleaning

• Removed duplicates
• Standardised text columns
• Checked for blanks
• Converted attrition to numeric values

🔹 SQL Analysis

• Queries

🔹 Dashboard Preview

• Dashboard snip

🔹 Key Insights

• Overall attrition rate is ~16.12%
• Sales department has highest attrition
• Employees under 30 show higher attrition
• Overtime employees leave at nearly 2x rate
• Majority attrition occurs within first 3 years

🔹 Business Recommendations

• 1️⃣ Improve Early Employee Engagement
• 2️⃣ Monitor Overtime Load
• 3️⃣ Compensation Review for Junior Roles
• 4️⃣ Increase Promotion Frequency