This is a Power Bi Project for a Company in the retails industry. WeCare is a large organization with over a thousand employees working in various departments and roles. WeCare is looking to identity factors influencing attrition is their company.
Disclaimer: All datasets and reports do not represent any company, institution or country. All info are dummy dataset to demonstrate my capabilities in Power Bi.
- Analyze the dataset to find out factors influencing Employee Attrition in the company
- Is there a relationship between attrition and monthly income and monthly rate?
- How do factors like job satisfaction, marital status, gender, job role department, work life balance etc affects attrition?
- Understanding the data was the first thing then the scenario. Identified general factors before we explore the data.
- To better understand attrition behaviour we deployed Power Bi to further analyze factors.
- Using Analytical approach like Data Cleasing, Uni & Multivariate Analysis, DAX etc & Visualization approach like Scatter plot, Gauge, Decomposition tree, Bar chart.
- Identification of patterns and trends to get informed insights and data-driven recommendation.
Automatically derived relationship are adjusted to remove and replace relationships with required informations.
This report contains
- Scatter Plot
- Decomposition Tree
- Key Influencers
- Donut Chart
- Clustered Bar Chart
- Table
Every point on this chart represent each worker in the company and amount they earn. The Chart further gives insight that workers earning between $0 - $5,000 populates high percentage of the attrition.
This chart looked at the gender of workers, marital and age. The insights from this further shows that Single, male workers between 18years to 22 years also pupolates the attrition affection the company.
This chart dig very dip comparing many variables against eachother so we can truly identify the main reason for this attrition. Insights from this chart shows us that OverTime is a major contributor to attrition while we also have Job Roles & Worklife Balance.
I recommend the company to recognize employees who consistently take up overtime through rewards, such as gift cards, bonuses, rewarding pay and extra time off. ⌚
Sales, HR, and Laboratory Technicians, bear the brunt of attrition, accounting for 40%, 24%, and 23% respectively. improving employee satisfaction and retention in these key departments, like providing more training and support, creating a more positive and supportive work environment, and offering competitive compensation and benefits. 🏦
Implement measures to improve work-life balance, such as flexible scheduling, wellness programs, and clear boundaries between work and personal time. ⚖
Improving the work-life balance and compensation for younger employees. They should also provide them with opportunities for professional development and advancement, consider providing financial assistance to employees who are struggling to make ends meet. 💸
For more info you can Email me
