Excel-based HR Attrition Dashboard Project supervised by the Director, Skills Ahead Academy, Lagos, Nigeria.
This project was carried out under the supervision of the Director of Skills Ahead Academy, Lagos, Nigeria, as a practical application of data analysis in human resource management. The primary goal was to use Microsoft Excel to analyse workforce data and identify factors influencing employee attrition, enabling management to make informed, data-driven decisions to improve retention.
Project Overview Using Excel as the main analytical tool, the project examined key HR metrics like employee demographics, tenure, job satisfaction, and compensation.
Techniques such as Pivot Tables, Conditional Formatting, and Regression Analysis were applied to uncover trends and patterns in employee turnover.
The analysis provided a clear picture of how various factors contribute to attrition and yielded actionable insights to improve employee satisfaction and retention.
HR-PREDICTION-ATTRITION
This project was completed under the guidance of the Director of Skills Ahead Academy (Lagos, Nigeria).
Using Microsoft Excel as the primary analytics tool, we analysed historical HR data to understand and predict employee attrition and to provide clear, data-backed retention recommendations.
Objectives
• Profile workforce demographics and turnover patterns
• Identify key drivers of attrition (e.g., tenure, satisfaction, compensation)
• Build Excel-based dashboards and run regression/correlation analyses
• Translate findings into actionable retention strategies
Tools & Methods
• Excel: Power Query (cleaning), Pivot Tables/Charts (EDA), Slicers & Timelines (interactivity)
• Analytics: Descriptive stats, correlation, simple regression, cohort/tenure analysis
• Visualisation: Attrition by department, role, age band, tenure, satisfaction, compensation
Key Insights (example highlights)
• Higher attrition observed among short-tenure staff and roles with limited progression
• Low satisfaction and below-market compensation correlate with higher turnover
• Improving career path clarity and reward structures can materially reduce attrition