Session Ready
Exercise

Combining HR datasets (II)

As per Gallup's research, employees leave managers, not companies. This explains the importance of a manager's role in an employee's commitment to stay in an organization.

Annual engagement surveys captures critical feedback from employees on multiple facets such as manager effectiveness, work satisfaction, performance satisfaction etc.

In this exercise, you will combine survey results to your dataset using mgr_id as the lookup key to compare manager effectiveness scores between Active and Inactive employees.

Instructions
100 XP
  • Use glimpse() to view the structure of the survey dataset.
  • Left join survey to org3 using "mgr_id" as the lookup key.
  • Generate a box plot to visualize the distribution of mgr_effectiveness scores for Active and Inactive employees.