Clean-and-Analyze-Employee-Exit-Surveys-

Source: Employee Exit Survey - DETE

In this project, we'll work with exit surveys from employees of the Department of Education, Training and Employment (DETE) and the Technical and Further Education (TAFE) institute in Queensland, Australia. The original TAFE exit survey data is no longer available. We've made some slight modifications to the original datasets to make them easier to work with, including changing the encoding to UTF-8 (the original ones are encoded using cp1252.). You can find the DETE exit survey data here

The aim of this project is we want to know the following: Are employees who only worked for the institutes for a short period of time resigning due to some kind of dissatisfaction? What about employees who have been there longer? Are younger employees resigning due to some kind of dissatisfaction? What about older employees?

Table of Contents

• Introdution
• Read the dataset
• Identify Missing Values and Drop Unnecessary Columns
• Clean Column Names
• Filter the Data
• Verify the Dates Data
• Create a New Column
• Identify Dissatisfied Employees
• Combine the Data
• Perform Initial Analysis
• Investigating Dissatisfaction among different Age Groups
• Investigating Dissatisfaction among Different Employment Positions