Employee Attrition Insights

The Client

Major e-commerce retailer

The Challenge

An e-commerce retailer was not able to predict employee retention rates. Client was seeking a data structure that would utilize predictive analytics to better reveal employee attrition insights.

The Solution

  • Provided an analytical environment for predictive across multiple disparate data sources
  • Provided a data structure to fit predictive analytics needs
  • Provided actionable insights into employee data that helped prevent attrition and churn
  • Provided a roadmap for the Employee Attrition Model that can be operationalized in a production environment

The Approach

  • Utilized onsite/offshore delivery model to contain cost
  • Created SAP HANA environment with R Integration / Predictive Analytics
  • Identified data sources and designed a data extraction strategy
  • Designed and build data models in SAP HANA (SAP Studio)
  • Built sample data by converting transactional data structure to monthly snapshots
  • Performed data discovery and modeling, including data cleansing, derived variable creation, variable selection and data visualization
  • Developed predictive models to identify key drivers associated with a high/low probability of attrition and predicted those employee segments in a given time period
  • Developed model operationalization roadmap and transfer knowledge