HR Analytics – Project Details

CompanyInfosys Ltd
RoleHR Analyst / BI Developer
Duration4 Weeks
Skill LevelIntermediate
Tools UsedPower BI, Excel, SQL
DeliverablesAttrition Dashboard, Hiring Pipeline, Retention Analysis
Objective

Design an HR Analytics dashboard to track employee attrition, hiring trends, and workforce retention metrics across departments at Infosys. The dashboard integrates HRMS data and performance datasets to uncover insights on employee churn, training effectiveness, and tenure patterns. Interactive filters enable stakeholders to analyze department-level KPIs such as voluntary exits, cost-to-hire, internal promotions, and engagement metrics. The solution supports HR managers in making data-driven decisions to improve talent retention and optimize hiring strategies.

Key Challenges
  • Data inconsistency across HR platforms
  • Tracking passive attrition causes
  • Visualizing training ROI by team
Features
  • Attrition vs Retention tracking
  • Hiring cost & source efficiency
  • Interactive filters by location & tenure
Outcome

Enabled HR managers to improve workforce retention by 20%, reduce average hiring time, and align hiring strategy with attrition trends.