Gender Diversity Hiring, Performance & Promotion Analysis Dashboard is a comprehensive tool developed as part of a job simulation by PwC Switzerland on the Forage website. The dashboard is designed to provide insights into the hiring, turnover, performance, and promotion trends within an organization, focusing on gender diversity. It helps in understanding the dynamics of employee demographics, job status changes, and performance ratings across different departments and job levels.

Key Features:

• Employee Job Status Visualization: Displays the distribution of employees who have left, are newly hired, or are existing employees.

• Gender Ratio Analysis: A donut chart shows the overall gender distribution within the organization.

• Nationality Breakdown: A pie chart categorizes employees based on nationality, providing insights into the geographical diversity of the workforce.

• Age Group Analysis: Bar charts display the distribution of employees by age group, segregated by job status.

• Departmental Trends: Analysis of hiring and turnover trends by department, indicating areas with higher turnover rates or hiring spikes.

• Yearly Hiring Trends: Historical data visualization showing the hiring trends over the years, with a focus on gender representation.

• Performance Ratings by Job Level and Department: Line charts and bar charts compare performance ratings across different job levels and departments for two fiscal years (FY19 and FY20).

• Promotion Insights: Analysis of promotions across various job levels and departments, highlighting trends and potential areas of improvement in gender diversity.

• Interactive Filters: Allows users to filter data by gender, region, department, and job level to customize the analysis as per specific requirements.

Requirements:

• Power BI Desktop: To build, modify, and visualize data in the dashboard.

• Dataset: The dataset includes employee details such as job status, gender, nationality, age group, department, job level, performance ratings, and promotion history.

Important Points to Remember:

• This dashboard helps identify patterns in gender diversity, hiring practices, employee turnover, and performance ratings, providing actionable insights for HR and management teams.

• The ability to filter data dynamically makes it a versatile tool for tailoring insights to specific queries or demographic slices.

• Understanding these trends is crucial for developing strategic initiatives aimed at improving diversity and equity in the workplace.

This project exemplifies the practical application of data analytics in HR, enabling informed decision-making to foster a diverse and inclusive work environment.