Attrition is a metric that represents the percentage of employees who leave an organisation(either voluntarily or involuntarily) for reasons including resignation, termination, death or retirement. It is a key indicator used by HR department to monitor and improve their organisation's workforce planning and overall management.
- Can have negative impact on your organization’s performance
- Struggle to recruit new people
- Hiring cost to replace employees
- Impact those employees working with them that can result in adding more work to them. This can increase stress and impact organization’s performance
- To find insights for HR department about the important factors associated with the attrition from the data collected. So that, the HR can take preventive measures to control the attrition in the organization.
Using Power Query we do the following:
- Clean and Prepare Data
- Check the data and its data types
- Check for Blank cells
- Find missing value
- Remove dupliactes
- Remove columns with constant values