HR Diversity & Inclusion Dashboard

I joined a virtual internship of PwC through forage, where my role was of Power BI Analyst. This is the 3rd BI task from the internship, objective was to analyse the trends of Hires, Resigns, Promotions & Performance in the company. My first approach was to check the data & perform cleaning for better results & started my analysis on Power BI Desktop.

𝗖𝗼𝘃𝗲𝗿 𝗣𝗮𝗴𝗲 -

▶ I have added some navigation buttons on the cover page for easy switch between the reports.

𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 :-

𝗢𝘃𝗲𝗿𝘃𝗶𝗲𝘄 -

▶ There were total 500 employees in the company, out of which 434 employees were from start.

▶ 66 new candidates were hired into the company in FY20, 47 employees left the company in FY20.

▶ Currently there are 453 employees working with the company.

▶ The gender balance of the employees in the company is 59%(Males) : 41%(Females).

𝗛𝗶𝗿𝗲𝘀 -

▶ There were total 66 new hires in the company, 32 males & 34 females. Average age of new hires was 32 years.

▶ Most hires were in the department of Operations i.e. , followed by Sales & Marketing and Internal services.

▶ Most new candidates were recruited for the position of Junior Officer.

▶ 32 candidates with age group of 20-29 were hired.

𝗥𝗲𝘀𝗶𝗴𝗻𝘀 -

▶ 47 of our employees left the company, out of which 26 were male candidates & 21 were female candidates.

▶ Majority employees were of age group 40-49.

▶ Average performance rating of resigners was 2.73 / 4.

▶ Employees with tenure of 9 years are the majority.

𝗣𝗿𝗼𝗺𝗼𝘁𝗶𝗼𝗻𝘀 -

▶ 36 employees were promoted in FY20, 51 employees were promoted in FY21.

▶ Most promotion was in operations department to Junior Officers.