HR Diversity & Inclusion - POWER BI

Creating a Power BI project for diversity and inclusion in HR is a great way to visualise and analyze data related to diversity and inclusion efforts within your company. Here's a step-by-step guide on how to approach this project:

1. Define Your Goals and Objectives:

Clearly define the goals of your diversity and inclusion project. What specific metrics or key performance indicators (KPIs) are you looking to track and improve?

Identify the data sources you'll need to collect and analyse, such as HR records, employee surveys, and demographic data.

2. Data Collection and Preparation:

Gather relevant data from your HR department, including employee demographics (age, gender, race, etc.), recruitment data, promotion data, and exit data.

Ensure that the data is clean and well-structured. You may need to clean, format, and transform the data for analysis.

3. Key Metrics: The KPIs defined were:

1) # of men

2) # of women

3) # of leavers

4) % employees promoted (FY21)

5) % of women promoted

6) % of hires men

7) % of hires women

8) % turnover

9) Average performance rating: men

10) Average Performance rating: women