HR Analytics Project Summary

It is my great pleasure to finalize and share with you my third and last HR Analytics project at MeriSKILL. This project was created using Python and Power BI, and the project involved creating four dashboards to analyze different aspects of the company's workforce. The dashboards are as follows.

Employee demographics dashboard: This dashboard provides insights into the company's employee demographics, such as age, gender, marital status, and education level.

Employee work experience dashboard: This dashboard provides insights into the company's employee work experience, such as total working years, number of companies worked, and average salary.

Employee location and Performance dashboard: This dashboard provides insights into the company's employee location, such as distance from home, average overtime, and average job satisfaction.

Employee Attrition Rate: This dashboard provides insights into the company's employee Overall attrition rate: This is the percentage of employees who left the organization during a given period of time. Attrition rate by job role: This is the percentage of employees in a particular job role who left the organization during a given period of time. Attrition rate by department: This is the percentage of employees in a particular department who left the organization during a given period of time. Finaly the attrition rate by employee demographics: This is the percentage of employees in a particular demographic group (e.g., age group, gender, education level) who left the organization during a given period of time.

I used Python for data cleaning, analysis, and modeling, and Power BI for data visualization and creating interactive dashboards. Python's AI capabilities enabled me to perform advanced analytics and build predictive models, while Power BI provided a user-friendly interface for data visualization and reporting.

The Sales department has the largest number of employees, followed by the Research & Development and Manufacturing departments.

The most common job roles are Sales Representative, Research Scientist, and Medical Representative.

Married employees make up the majority of the workforce, followed by single employees.

Employees in the Research & Development department have the highest average number of years of experience, followed by the Manufacturing and Sales departments.

The Sales and Research & Development departments have the highest average performance ratings.

Employees in the Human Resources and Sales departments are most likely to take overtime.

The Sales department has the highest attrition rate, followed by the Research & Development and Marketing departments.

Male employees have a higher attrition rate than female employees.

Single employees have a higher attrition rate than married employees.

Employees at the highest job level have the lowest attrition rate.

The dashboard can be used to make informed decisions about a variety of HR-related issues, such as identifying areas where teams need additional training or support, identifying high-performing employees who are ready for a promotion, and developing strategies to improve retention.

I am proud of the work that I have done on this project, and I believe that it will be a valuable asset to you . I am confident that the insights gained from this project can be used to improve my BI and Data analysis experience and to make my professional skills more successful.

I am excited to present this project to you today, and I look forward to discussing the findings with you and other stakeholders.