📊 HR Analytics Dashboard | Final Project – NTI Data Analytics Scholarship

📊 HR Analytics Dashboard | Final Project – NTI Data Analytics Scholarship

I'm excited to share our Final Project for the NTI (National Telecommunication Institute) Data Analytics Scholarship, where we developed an end-to-end HR Analytics solution to transform raw employee data into actionable business insights.

🎯 Project Objective

The goal of this project was to analyze employee data, understand workforce trends, identify the key drivers behind employee attrition, and provide data-driven recommendations to support better HR decision-making and improve employee retention.

🛠️ Project Workflow

🔹 Python (Pandas & NumPy) – Data Cleaning & Preparation

🔹 Excel (Pivot Tables & Pivot Charts) – Exploratory Data Analysis (EDA)

🔹 Power BI – Interactive Dashboard Development & Data Visualization

🔹 DAX & Power Query – Data Modeling, KPIs, and Business Metrics

📊 Dashboard Pages

✅ Home Dashboard

✅ Workforce Overview

✅ Attrition Analysis

✅ Root Cause Analysis

✅ Employee Satisfaction

🔍 Key Insights

• Attrition Rate reached 16.05%

• Employees working overtime showed higher attrition rates

• The highest attrition occurred during the first 1–3 years of employment

• Lower-income employees were more likely to leave the company

• Employee satisfaction showed a strong impact on employee retention

💡 Business Recommendations

• Reduce excessive overtime and workload pressure

• Strengthen onboarding and mentorship programs for new employees

• Review compensation structures for high-risk employee groups

• Conduct regular employee satisfaction surveys to identify issues early