This project focuses on analyzing diversity and inclusion within a company's workforce, particularly highlighting gender-related KPIs. The dashboard provides valuable insights into gender representation across various departments and management levels, helping organizations identify areas for improvement and track progress toward diversity goals.
- Data Sources: The dataset includes employee demographics, role classifications, and gender representation.
- Visualizations: Includes charts and graphs focused on gender distribution, representation across management levels, and diversity trends over time.
- Metrics: Key metrics include gender diversity ratio, representation at executive levels, and gender pay gaps.
- Actionable Insights: Discusses potential root causes for slow progress in achieving gender balance, particularly at the executive management level.
- Power BI: Used for creating the dashboard with interactive visualizations.
- Excel: Used for data preprocessing and cleaning.
- Dataset: Provided as an Excel file (
03 Diversity-Inclusion-Dataset.xlsx).
The dataset contains the following key columns:
- Employee ID: Unique identifier for each employee.
- Gender: Gender of the employee.
- Department: The department where the employee works.
- Position Level: Whether the employee is in an executive, mid-level, or entry-level role.
- Tenure: How long the employee has been with the company.
Here are some of the key visualizations included in the dashboard:
- Gender Representation by Department: Bar charts displaying gender distribution across various departments.
- Executive Gender Balance: Line and bar charts tracking the gender diversity at the executive management level.
- Diversity Trends Over Time: Charts showing how gender representation has evolved over the years.
- Gender Pay Gap Analysis: Visualizations that explore pay disparities between genders at different levels.
- Download the
.pbixfile and open it in Power BI. - View the Dashboard: Explore the interactive visualizations to gain insights into diversity and inclusion metrics.
- Adjust filters: Use Power BI filters to dive deeper into specific departments, roles, or time periods.
- Gender Balance at Executive Levels: The dashboard highlights a slower rate of improvement in achieving gender diversity at the executive level. Potential causes include limited promotion opportunities and biased hiring processes. Targeted leadership programs and diversity-driven recruitment may help address this issue.
- Departmental Disparities: Certain departments have a noticeable gender imbalance, particularly in STEM fields. Encouraging more inclusive hiring practices and mentorship programs could help reduce these disparities.
- Addressing the Gender Pay Gap: Pay gaps at different levels of the organization need attention. Regular audits and transparency in compensation policies can help bridge these gaps.
This project is licensed under the MIT License - see the LICENSE file for details.
- LinkedIn Post: Project Overview
- Contact: Sunny Kumar