HR Analytics In-Depth: Using Excel Tools to Solve HR Analytics at Work

  • 2h 20m
  • Reuben Ray, Subhashini Sharma Tripathi
  • BPB Publications
  • 2022

TAGLINE

A must-have book for HR professional to explore Excel based analytics

KEY FEATURES

  • Manage people effectively by exploring performance metrics, attrition and retention strategies.
  • HR Analytics explained in an easy to follow and crisp methodology for HR aspirants.
  • Practical examples and solutions with frameworks.
  • Mark out career growth for resources with learning & development mapping.
  • Learn various hiring strategies to onboard the right people.
  • Case studies explored with sample datasets and access for real-time practice.

DESCRIPTION

This book is a start to end guide on all HR processes right from hiring to attrition of the resource. Each chapter is designed with easy to follow explanations and real life scenarios to help HR professionals get an in-depth understanding of HR analytics. You will start with various hiring strategies and identifying the right resource to onboard for your organization. You will then move on to exploring different learning and development plans to enrich the skillset of the resources and chalk out a career plan for them. Different employee engagement strategies are discussed to ensure the employees are active and do not burn out which may result in brain drain.

Performance metrics, which is a key part of employee management, is dealt with in detail to give you more insights into effectively managing and motivating good performers alongside devising improvement plans for the average performers. Compensation, payroll related topics are then explored and the book finally takes you through the final stage, attrition and retention strategies.

The book is an HR Analytics treatise combining 07 chapters and each chapter of this book is dedicated to key people practice problems – starting from hiring and ending with attrition. The chapters are linked as a flow of events in the life of an employee where each practice is interlinked to the forthcoming one along with the previous. A common thread is the competency-linked approach to understand the interlinkages between each practice, its numbers and its further effects elsewhere using analytics.

WHAT YOU WILL LEARN

  • Mastering Hiring Analytics.
  • Explore Learning and Development strategies and analytics.
  • Keep your employee engaged with different Employee Engagement techniques and analytics.
  • Best practices on managing Employee Performance.
  • Compensation and Payroll Analytics with case studies.
  • Attrition Analytics and Retention strategies to engage with top talent.

WHO THIS BOOK IS FOR

This book is aimed at HR practitioners and analysts or anyone who aims to make a career in Human Resources. Prior knowledge of HR or organization behavior would be helpful but not mandatory.

About the Author

Subhashini Sharma Tripathi : An Analytics and Data Science enthusiast with 20 years of professional experience in Analytics & Data Science in Banking, Financial Services, Start-up Co-founder, Educationist and Author sums up the range of experience. She is the co-founder of Pexitics

Reuben Ray is an data enthusiast while being more focused on the subject of people management and practices with an experience of over 20 years. He is the co-founder of Pexitics.com which offers people excellence solutions with primary responsibility for HR practice and consulting.

In this Book

  • Coloured Images
  • Piracy
  • Factors to Measure in HR Analytics
  • Analytics—Introduction
  • Hiring
  • Case Study - Hiring Through Numbers –Using Hands-On Excel
  • Learning and Development
  • Case Study - Learning Needs Identification
  • Employee Engagement
  • Case Study - Analytics for Employee Engagement
  • Performance Metrics
  • Case Study - Performance Analytics Measuring and Benchmarking Performance Using MS Excel - Business Problems, Solutions, and Insights
  • Compensation and HR Analytics
  • Case Study - Compensation and Rewards for a Performance-Driven Outcome
  • Attrition and Retention
  • Attrition Management Scorecard
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 157 users Rating 4.5 of 157 users (157)
Rating 4.5 of 265 users Rating 4.5 of 265 users (265)
Rating 4.6 of 260 users Rating 4.6 of 260 users (260)