County Trends
Employees
Project Report

Predicting Employee Turnover

A proof-of-concept dashboard for exploring an employee's likeliness to voluntarily leave employement and other employment trends.

Active Employees in the County

2452

20% lower this year

predicted number of turnover

490

in 12 months

Estimated Cost
of Turnover

$6,102,950

20% compensation


Department most at risk

Health

34% in state of turnover

Department Trends

Through our exploratory analyses, we found that the department in which an employee finds themselves correlate with an employee's likeliness to turnover. Therefore, this page provides both county and department-level trends in employee demographics, workforce population, and salaries over our study window (2006-2021).

Click through the tabs below (Turnover, Employee Count, etc.) to interact with these data views.


Employee Risk Trends by Department

Click through each department to see employees working in that department and their associated risk of turnover. The pie charts and risk score boxes are department specific and update based on the department selected. Try adjusting the way the table is sorted by clicking on the heading labels (ID, Employee, Age, etc.)


Current Selected ID:
Highest Risk Score

100%

Average Risk Score

49.8%

Health

Departments

  1. Public Health

  2. Animal Services

  3. Mental Health

At Risk by Gender

At Risk by Age

At Risk by EEO Class

Current Selected ID:
Highest Risk Score

100%

Average Risk Score

51.6%

Law Enforcement

Departments

  1. Law Enforcement

At Risk by Gender

At Risk by Age

At Risk by EEO Class

Current Selected ID:
Highest Risk Score

99.8%

Average Risk Score

48.7%

Financial Administration

Departments

  1. Purchasing
  2. Security
  3. Human Resources
  4. Elections
  5. Tax
  6. Internal Audit
  7. Veterans Services
  8. Finance
  9. Information Technology
  10. Risk Management
  11. Commissioners
  12. Budget & Management Services
  13. Clerk to the Board
  14. Legal
  15. Administration
  16. Property Management/Courts
  17. Register of Deeds

At Risk by Gender

At Risk by Age

At Risk by EEO Class

Current Selected ID:
Highest Risk Score

98.8%

Average Risk Score

52.9%

Public Welfare

Departments

  1. Social Services
  2. Child Support Enforcement
  3. Family Justice Center
  4. Transportation- Human Services

At Risk by Gender

At Risk by Age

At Risk by EEO Class

Current Selected ID:
Highest Risk Score

96.7%

Average Risk Score

48.8%

Corrections

Departments

  1. Corrections

At Risk by Gender

At Risk by Age

At Risk by EEO Class

Current Selected ID:
Highest Risk Score

99%

Average Risk Score

48.6%

Community Development

Departments

  1. Community & Economic Development
  2. Planning
  3. Facilities
  4. PLN/Solid Waste
  5. PLN/Soil & Water
  6. PLN/Inspections
  7. Parks (Prev Prop Mgmt)

At Risk by Gender

At Risk by Age

At Risk by EEO Class