HR Performance Insights: Unveiling Organizational Dynamics
Human Resources
This is an example of a Human Resources (HR) dashboard that allows HR teams to track, analyse and report HR KPIs. This enables HR teams to quickly find information that improves recruitment, optimizes workplace management and improves employee performance.
In a first step, a data cleaning and transformation was performed in MySQL, in order to solve and fix incorrectly formatted data. In a second step, also in MySQL was made an initial analysis and division of data into different tables. Finally, using the tables exported from MySQL, a report was made in Power BI.
This report allows easily verifies information about gender, age, and job title, but also about the average number of years of contract per department, as well as the variation of the number of employees over the years.
GOAL
The main purpose of this analysis is to measure the impact that several HR metrics have on the company's overall performance, and therefore make decisions based on the analyzed data.
-
What is the gender breakdown of employees in the company?
-
What is the age distribution of employees in the company?
-
How many employees work at headquarters versus remote locations?
-
What is the distribution of employees across locations?
-
What is the distribution of departments and job titles across the company?
-
How has the company's employee count changed over time?
-
What is the average length of employment?
RESULT
The human resource analysis performed allows analysing a series of KPIs of a company's human resources and in this way quickly find information that improves recruitment and candidate experience. In general, it can be seen that the company has a very young range of employees, where the majority are males. In addition, most of the workers work on an on-site basis in the state of Ohio. With these results, the company can take recruitment measures such as prioritizing the hiring of women, in order to equalize the company's gender, as well as studying strategies to distribute its employees to different states, in order to uniform the distribution of workers among the company's different locations. In conclusion, and taking into account the analysis of the department, job title and years of the contract, recruitment measures can be taken for specific positions.
SQL Code
INSIGHTS
51% of the company's employees are male, and in all age groups, there are more males than females.
Furthermore, more than 50% (10k) of the employees are between the ages of 25-44.
The company is based in 7 different states, however, a large majority of the employees (14K) work in the state of Ohio.
Additionally, only 1/4 of the employees work remotely.
Engineering and Auditing are, respectively, the departments with the highest and lowest number of employees. In terms of position in the company, Research Assistant II and Business Analyst are the two most common titles in the company, with 608 and 552 employees, respectively.
In terms of the number of contracts, there has been a gradual increase over the years, with Auditing and Legal being the departments with the highest average tenure (9 years).
