Tuesday, December 1, 2015

Edison Board of Education - Current Staffing Data

Well, just received the EBoE's current salary data. This file has total salaries of $131,672,374 for 1,948 employees. The file is by name, location, department, title and salary. Put some summaries of the data together and added a couple of tables so the data can be sorted by any of the main groupings above.

Summary by Salary Range:

Salary Range Chart:

Salary Range Comparison:

By Department with Salary Breakdown:

Department Comparison:

Here's two tables that you can use to sort the data in Excel:
Pivot Table:

Anyhoo, if anyone wants this Excel file, you're welcome to it. Just drop me a note.

No comments:

Post a Comment