HR Analytics & Employee Retention Dashboard

Business Background A mid-sized IT services company (≈500 employees) is facing high employee attrition, especially in critical roles. Leadership wants a data-driven HR analytics platform to: 1. Monitor workforce health 2. Identify attrition drivers 3. Improve training ROI 4. Enable predictive retention strategies You are hired as a Data Analyst to design this end-to-end solution. ________________________________________ DATA AVAILABLE 1. Employee master data with their Salary, performance data and Attrition status 2. Training participation data ________________________________________ BUSINESS OBJECTIVES 1. Understand why employees leave 2. Identify high-risk employee segments 3. Measure training effectiveness 4. Enable future attrition prediction ________________________________________ ANALYTICAL QUESTIONS (WITH TOOLS) ________________________________________ BASIC HR METRICS Question Tool Used What is the total number of employees? Excel / SQL What is the overall attrition rate? SQL / Power BI How many employees left the organization? SQL What is the gender distribution across the company? Power BI What is the average age of employees? Excel / SQL ________________________________________ ATTRITION ANALYSIS Question Tool Used Which department has the highest attrition? Power BI Attrition rate by job role? Power BI Does attrition vary by education level? Power BI Attrition trend over time (year-wise)? Power BI What is the average tenure of employees who left? SQL ________________________________________ COMPENSATION & PERFORMANCE Question Tool Used Is attrition higher among low-salary employees? Power BI Compare average salary of active vs exited employees SQL Does low performance lead to higher attrition? Power BI Which salary band has the highest attrition risk? Excel / Power BI ________________________________________ TRAINING EFFECTIVENESS Question Tool Used What % of employees completed training programs? Power BI Which trainings have the highest completion rate? Power BI Do trained employees have lower attrition? SQL / Power BI Is performance better after training completion? SQL Which department benefits most from training? Power BI ________________________________________ DIVERSITY & EQUITY ANALYSIS Question Tool Used Gender distribution by department Power BI Is there a salary gap by gender? Excel / Power BI Attrition rate by gender Power BI Education-wise salary comparison SQL ________________________________________ OPERATIONAL HR INSIGHTS Question Tool Used Average tenure by department SQL New hire attrition within first 1 year SQL Which job roles have the shortest tenure? Power BI Attrition among high performers Power BI ________________________________________ ADVANCED ANALYTICS (PREDICTIVE) Question Tool Used Can we predict if an employee will leave? Python Which features are most important for attrition? Python Identify top 10 high-risk active employees Python Build an attrition risk score Python Model accuracy & validation Python ________________________________________ DASHBOARD REQUIREMENTS KPI Tool Used Attrition Rate Power BI Average Salary Power BI Training Completion % Power BI Diversity Index Power BI High-Risk Employees Count Power BI _______________________________ DASHBOARD PAGES (POWER BI) 1. Executive Summary 2. Attrition Analysis 3. Compensation & Performance 4. Training Impact 5. Diversity & Inclusion 6. Predictive Insights ________________________________________ TOOLS & SKILLS MAPPED Tool Usage Excel Data cleaning, salary bands, basic KPIs SQL Joins, aggregations, CTEs, filters Power BI Dashboarding, DAX, storytelling Python Machine learning, prediction models