M

MARIAM ADEPOJU

HR ANALYSIS

This report presents a detailed analysis of employee-related metrics based on the company's Human Resources Dashboard. It encompasses statistics on workforce activity, departmental distribution, state-level hiring, employee demographics, performance ratings, educational qualifications, and income patterns. The visualizations used to derive these insights provide a comprehensive view of the HR landscape, enabling data-driven decision- making for workforce planning and management.

1. Employee Statistics

This section summarizes the total number of active employees, hires, and terminations observed during the reporting period. These figures reflect the organization’s workforce dynamics and reveal trends in employee turnover and recruitment.

  • Total Active Employees: 7,984
  • Total Employees Hired: 8,950
  • Total Employees Terminated: 966

The hiring trend shows monthly hires fluctuating between 472 and 804, indicating periodic recruitment drives across the organization. Meanwhile, terminations appear to rise gradually, peaking at 142 in a single month. These fluctuations may reflect seasonal employment needs, performance reviews, or restructuring initiatives.



2. Departmental Breakdown

This section highlights the total number of employees distributed across each department and the number of terminations recorded within each department. It provides insights into departmental sizes and possible areas with higher turnover.

  • Operations: 2,429 employees (289 terminations)
  • Sales: 1,634 employees (201 terminations)
  • Customer Service: 1,489 employees (184 terminations)
  • IT: 1,243 employees (139 terminations)
  • Marketing: 648 employees
  • Finance: 389 employees
  • HR: 152 employees


3.Total Hired by State

The geographic distribution of hires shows the concentration of recruitment efforts across various states. This data can help identify key operational locations and regions with growing workforce needs.

  • New York: 6,270 hires
  • Michigan: 976 hires
  • Pennsylvania: 435 hires
  • North Carolina: 430 hires
  • Illinois: 285 hires
  • Ohio: 271 hires
  • Virginia: 180 hires
  • West Virginia: 103 hires


4. Demographics

This section provides insights into the gender distribution and educational background of employees.

  • This section provides insights into the gender distribution and educational background of employees.
    • Male: 54%
    • Female: 46%
  • Employee Education Levels:
    • High School: 1,633 employees
    • Bachelor’s Degree: 4,809 employees
    • Master’s Degree: 1,109 employees
    • PhD: 433 employees


5. Active Employees Performance Ratings

Performance ratings help gauge employee effectiveness and highlight the overall talent quality within the organization. A significant portion of the workforce has received positive performance evaluations.

  • Needs Improvement: 918 employees
  • Satisfactory: 2,333 employees
  • Good: 3,401 employees
  • Excellent: 1,332 employees


6. Income Analysis

Income data is analyzed across three major dimensions: education level, age group, and department.

a. Income by Education Level

  • High School – Male: $33K | Female: $29K
  • Bachelor – Male: $40K | Female: $30K
  • Master – Male: $43K | Female: $40K
  • PhD – Male: $41K | Female: $45K

b. Income by Age Group

  • <25 – Male: $39K | Female: $30K
  • 25–34 – Male: $38K | Female: $31K
  • 35–44 – Male: $39K | Female: $32K
  • 45–54 – Male: $39K | Female: $33K
  • 55+ – Male: $40K | Female: $34K

c. Income by Department

The IT department has the highest average income, followed by Finance and Sales. HR records the lowest average departmental income.

Conclusion

The HR dashboard provides valuable insights into the organization’s workforce distribution, hiring trends, performance metrics, and income structures. The majority of employees are performing well, with most categorized under ‘Good’ or ‘Excellent’ ratings. Educational qualifications are predominantly at the Bachelor's level, and income levels correlate positively with both education and age. Regional hiring trends indicate strong presence in New York, with substantial hiring also in Michigan and Pennsylvania. These insights can guide future HR strategies in talent acquisition, retention, and development.