The Employee Salary (Organization Hierarchy) Trend Analytics workbook lists the average salaries of employees, within a given date range, for time periods such as year, semi-year, month, bi-month, and quarter. Each worksheet represents the average salaries for one specific time period.

You can select which area of your enterprise you want to investigate. You can also choose the currency you want to view the salaries in and include or exclude salaries that you pay in a different currency.

Business Questions

Are average salaries in my enterprise rising at a faster rate now than in previous time periods?

Workbook Parameters

You must enter a value for the following parameters:

• Start Date

• End Date

• Organization Hierarchy

• Top Organization

• Rollup Organizations - Yes/No

• Convert to Currency

  The workbook converts the salaries to the currency you select here, before averaging them for the grouping

Use the following parameters to further restrict the values in the workbook:

• Area

• Country

• Region

• Location

• Job

• Grade

• Position

• Performance Rating

• Include Currencies

Worksheets

This workbook has the following worksheets:

• By Year

• By Semi Year

• By Quarter

• By Bi Month

• By Month

• By Year and Organization

• By Quarter and Organization

• By Month and Organization

The worksheets display one row for each time period. For example, the by Year worksheet displays one row per year. The three reports that include Organization break the data down even further. For example, the by Month and Organization worksheet displays one row for each month per organization.

Headings and Calculations

All worksheets contain the following columns:

• A time period column

  This heading depends on the selected worksheet, for example, in the by Year worksheet, this column is named "Year".

• Organization

  One column for each sub-organization - appears only in the three worksheets that break the report down into time period and organization.

• Date

  The date corresponding to the start of each time period.

• Total Salary

  The total salary for each time period and organization.

• Average Salary

  The average annualized salary per time period - appears only in the five worksheets that do not break the report down into sub-organizations.