Employee Attrition Analysis

Project Overview

Employee attrition can significantly impact an organization's productivity and costs. This project analyzes key factors driving employee churn and provides actionable insights and strategies to improve retention. By leveraging Excel, Power BI, and data analysis techniques, this project aims to identify trends and patterns to support HR decision-making.

Key Features

• Data Cleaning and Preprocessing: Handling missing values, duplicates, and ensuring data quality.
• Exploratory Data Analysis (EDA): Uncovering patterns and trends in employee attrition using Excel.
• Interactive Visualizations: Building insightful dashboards in Power BI to highlight key findings.
• Actionable Recommendations: Proposing strategies to reduce attrition and enhance employee engagement.

Tools and Technologies

• Excel: Data cleaning, analysis, and trend identification.
• Power BI: Interactive dashboards and data visualization.
• GitHub: Version control and project collaboration.

Project Structure

employee-attrition-analysis/
├── data/
│   ├── raw_employee_data.xlsx       # Raw dataset
│   ├── cleaned_employee_data.xlsx   # Cleaned dataset
├── docs/
│   ├── data-cleaning-notes.md       # Notes on data preprocessing
│   ├── eda-summary.md               # Summary of exploratory data analysis
│   ├── insights-and-strategies.md   # Key findings and recommendations
├── visualizations/
│   ├── attrition_dashboard.pbix     # Power BI report file
├── presentation/
│   ├── attrition_analysis_presentation.pptx  # Final presentation
├── README.md                        # Project overview and instructions

Setup Instructions

1. Clone the Repository

   git clone https://github.com/Mayank-2545/employee-attrition-analysis.git
   cd employee-attrition-analysis

2. Required Tools:

   • Microsoft Excel (or a similar spreadsheet tool).
   • Power BI Desktop.
   • Git (for version control).

3. Workflow:

   • Perform data cleaning and preprocessing in the data folder.
   • Conduct exploratory data analysis and document findings in the docs folder.
   • Create visualizations using Power BI and save the .pbix file in the visualizations folder.
   • Summarize insights and strategies in docs/insights-and-strategies.md.
   • Prepare the final presentation and save it in the presentation folder.

Deliverables

• Cleaned dataset with actionable variables.
• EDA findings and trend analysis.
• Power BI dashboard showcasing key insights.
• HR strategy recommendations based on the analysis.
• Final presentation summarizing the entire project.

Contribution

If you'd like to contribute:

1. Fork the repository.
2. Create a new branch for your feature or fix.

   git checkout -b feature-name

3. Commit your changes and push to your fork.
4. Create a pull request for review.

License

This project is licensed under the MIT License.

---

Author: Mayank Patil
For questions or collaboration, feel free to reach out!