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