PwC Virtual Internship Project

Data Source

Diversity & Inclusion Data : This dataset is from PWC Switzerland by Forage, this task involves developing key performance indicators (KPIs) related to hiring, promotion, performance, and turnover, along with creating a visualization to track and communicate progress.

Tools

Power BI - To create Dashboard, Data visualization

Data Preparation

Here's a quick rundown of the steps I took in the project:

1️. Data Preparation: Ensured the data was clean, organized, and ready for analysis.

2️. Data Modeling: Structured the data for effective analysis using Power BI.

3️. Data Analysis (DAX): Leveraged DAX functions to dig deep into the numbers.

4️. Data Visualization (Dashboard): Created visually compelling dashboards to make complex data easily understandable.

5️. Insights: Unearthed some fascinating findings!

Insights

1] 𝐄𝐦𝐩𝐥𝐨𝐲𝐞𝐞𝐬 :

• The Total customer is 500, Male count is 295 contribution (59%) while Female contribution is 205 (41%) Out of 500 employees 465 (93%) are Permanent employees where 35 (7%) employees works as part time job.

2] 𝐇𝐢𝐫𝐢𝐧𝐠

• We have records of last 10 years employees between 2011 to 2020, in 2011 Hired employees 47, in 2012 Hired employees 32 (-47%) Decreased from last year, in 2013 Hired employees 27 (-19%) Decreased from last year, in 2014 remain same as last year, in 2015 Hired employees 46 (41%) increased from last year, in 2016 Hired employees 52 (12%) increased from last year, in 2017 Hired employees 90 (42%) increased from last year, In 2018 Hired employees 80 (-13%) increased from last year, in 2013 Hired employees 33 (-142%) increased from last year & in 2013 Hired employees 66 (50%) increased from last year.

3] 𝐏𝐫𝐨𝐦𝐨𝐭𝐢𝐨𝐧 :

• Our Promotion rate is 7.20% in FY20 and 10.20% rate in FY21, in FY20 Male got promoted 5.60% out of 7.20% & 1.60% promoted as female.. in FY20 Male got promoted 6.60% out of 10.20% & 3.60% promoted as female..

4] 𝐏𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞 :

• The average performance rate is 2.57 in FY19 & 2.41 in FY20, Male & female got almost same performance in both FY. Male received 2.58 while Female received 2.56 in 2019 & 2.41 received for Male & female for 2.42 in 2020.

5] 𝐓𝐮𝐫𝐧𝐨𝐯𝐞𝐫 : -This section illustrates the turnover rate, indicating how many employees left the company in FY20, segmented by gender and job level.

✤ Graphs:

• The upper graph shows the turnover rate for employees who left (Yes) versus those who stayed (No) for each job level.
• The lower graph breaks down turnover rates by gender for each job level.

✤Turnover Rate Values: Executive (Level 1): Female 3.00, Male 1.86 Director (Level 2): Female 3.40, Male 3.09 Senior Manager (Level 3): Female 1.80, Male 2.33 Manager (Level 4): Female 2.37, Male 2.48 Senior Officer (Level 5): Female 2.29, Male 2.68 Junior Officer (Level 6): Female 2.13, Male 2.20

• 47 Employees has turnover out of 500 Employees the percentage rate is only 9.40%,in which, male % is 5.20 & for female 4.20%

Key Insights :

• 𝐇𝐢𝐫𝐢𝐧𝐠: There is a higher percentage of female hires at the Junior Officer level, but as job levels increase, the percentage of female hires decreases significantly.
• 𝐏𝐫𝐨𝐦𝐨𝐭𝐢𝐨𝐧: More females are being promoted at the Junior Officer level, but the number decreases at higher levels, though the percentage line indicates a higher promotion rate for females in some mid-level positions.
• 𝐓𝐮𝐫𝐧𝐨𝐯𝐞𝐫 : The turnover rate varies by job level and gender, with some levels showing higher turnover rates for females compared to males. This dashboard provides a comprehensive view of gender diversity across hiring, promotions, and turnover rates at PwC, highlighting areas where gender disparities exist.