HR Analytics Project: Identifying Key Factors Contributing to High Employee Attrition Rates 📊

---

Table of Contents

1. 📋 Project Overview
2. 🎯 Objectives
3. 🔧 Technologies Used
4. 🔄 Project Workflow
5. 📊 Key Focus Areas
6. 🧠 Basic Concepts and Terminology
7. 📈 Stakeholder Presentation
8. 📊 Results and Insights
9. 🎉 Conclusion
10. 🔮 Future Enhancements
11. 📚 References

---

📋 Project Overview

This HR Analytics project aims to investigate and understand the factors influencing the high attrition rate within the company. By analyzing key areas such as managerial influence, recruitment sources, and annual salary, the project seeks to provide actionable insights to HR professionals and company leadership for effective attrition management and employee retention strategies.

---

🎯 Objectives

• 🔍 Analyze key factors contributing to high employee attrition rates.
• 📊 Utilize data analytics tools to extract, clean, and visualize data.
• 💡 Provide insights into how managerial influence, recruitment sources, and salary structures affect employee retention.

---

🔧 Technologies Used

Data Analytics with PostgreSQL, Excel, and Tableau

---

🔄 Project Workflow

1. 📥 Data Collection using PostgreSQL:

   • Utilize PostgreSQL for efficient data collection from various company databases.
   • Extract datasets related to employee information, managerial details, recruitment sources, and salary structures.

2. 🧹 Data Cleaning and Wrangling with Excel:

   • Perform data cleaning and wrangling using Excel to ensure data accuracy and consistency.
   • Handle missing values, duplicates, and outliers to enhance dataset quality.

3. 🔍 Exploratory Data Analysis (EDA):

   • Conduct exploratory data analysis to uncover patterns and trends related to employee attrition.
   • Analyze correlations between managerial styles, recruitment sources, salaries, and attrition rates.

4. 📊 Data Visualization using Tableau:

   • Create interactive and insightful visualizations in Tableau to effectively communicate findings.
   • Design a Tableau guided story to present key insights and trends to stakeholders.

---

📊 Key Focus Areas

• 👩‍💼 Managerial Influence: Evaluate the impact of different managerial styles on employee attrition.
• 🔍 Recruitment Sources: Analyze attrition rates based on employee recruitment sources.
• 💰 Annual Salary: Investigate the relationship between annual salary structures and attrition rates.

---

🧠 Basic Concepts and Terminology

Attrition Rate:

The percentage of employees leaving the company over a certain period. A high attrition rate can indicate underlying issues within the organization.

Data Cleaning:

The process of correcting or removing inaccurate records from a dataset, ensuring the data is accurate and usable.

Exploratory Data Analysis (EDA):

A statistical approach used to analyze datasets, summarize their main characteristics, and uncover patterns or anomalies.

Data Visualization:

The graphical representation of information and data using visual elements like charts, graphs, and maps to identify patterns and insights.

Correlation Analysis:

A method used to evaluate the strength and direction of the relationship between two variables.

Tableau Guided Story:

A sequence of visualizations arranged to convey a specific narrative, allowing stakeholders to explore data and understand insights interactively.

---

📈 Stakeholder Presentation

The project culminates in a Tableau guided story designed to present the HR analytics findings to stakeholders. This story provides an interactive experience, allowing stakeholders to explore visualizations and understand the identified factors contributing to high attrition.

Access the Tableau Story:

• Tableau HR Analytics Story

---

📊 Results and Insights

Through the analysis, key insights into employee attrition were identified:

• Managerial Influence: Certain managerial styles are linked to higher attrition rates, suggesting a need for management training or changes in leadership approaches.
• Recruitment Sources: Some recruitment channels exhibit higher attrition rates, indicating a potential mismatch between the recruited candidates and the company culture.
• Annual Salary: Disparities in salary structures correlate with attrition, highlighting the importance of competitive and fair compensation practices.

---

🎉 Conclusion

The HR Analytics project effectively identifies key factors contributing to high employee attrition rates. By focusing on managerial influence, recruitment sources, and salary structures, the analysis provides actionable insights that can guide HR professionals in implementing strategies to reduce attrition and improve employee retention.

---

🔮 Future Enhancements

• 🛠️ Advanced Predictive Modeling: Implement machine learning models to predict attrition risk based on historical data.
• 📈 Continuous Monitoring: Develop a dashboard for real-time monitoring of attrition trends and HR metrics.
• 🔧 Policy Recommendations: Provide data-driven policy recommendations to address high attrition areas.

---

📚 References

• PostgreSQL Documentation
• Microsoft Excel Documentation
• Tableau Documentation

---