/HR-Emloyee-Report

HR Employee dashboard using Power Bi

Tools used : MySQL, Excel, Power Bi

Objective Questions:

  1. What is the gender breakdown of employees in the company?
  2. What is the race/ethnicity breakdown of employees in the company?
  3. What is the age distribution of employees in the company?
  4. How many employees work at headquarters versus remote location?
  5. What is the average length of employment for employees who have been terminated?
  6. How does the gender distribution vary across departments and job titles?
  7. What is the distribution of job titles across the company?
  8. Which department has the highest turnover rate?
  9. What is the distribution of employees across location across city and states?
  10. How has the employees count changed over time based on hire and term dates?
  11. What is the tenure distribution for each department?

Findings:

(a) Number of male employees are more as compared to the other genders.
(b) The change (net change) in employees has gradually increased over years.
(c) Ohio has maximum number of employees.
(d) There are more employees in headquarter as compared to remote.

Note: Employees of age 18+ has been considered.