HR PERFORMANCE DASHBOARD

I dedicated part of my weekend to designing this HR Performance Dashboard. After completing the essential data cleaning steps—such as removing duplicates, adjusting data types, replacing values, creating a date table, establishing relationship with the fact table ,and performing the necessary transformations, I was able to answer the following key questions:

1. How many employees does the company currently have?
   

2. What is the total recruitment cost incurred so far each year?
   

3. How much has the company spent on overtime costs ?
   

4. What is the current churn rate among employees?
   

5. How many employees have been hired each year between 2002 and 2024?
   

6. Which hiring sources are most and least used by applicants?

7. What is the average cost per hire?
   

8. What percentage of job offers are accepted by candidates?
   

9. How long, on average, does it take to recruit an employee?
   

10. How many employees fall into each salary range?

11. Which departments have the highest overtime costs?

12. Which employees are earning the highest monthly salaries among the top 5?

13. Which quarter has the highest labor efficiency rate ?

14. How satisfied are candidates with the hiring process?

15. What is the ratio of male to female employees?

16. What percentage of employees are full-time versus part-time?