🌟 Company Level Insights

• Total number of employees
• Average company tenure in years
• Gender ratios
• Average payrise percentage and amount

🌟 Department Level Insights

• Number of employees in each department
• Current department manager tenure in years
• Gender ratios
• Average payrise percentage and amount

Title Level Insights

• Number of employees with each title
• Minimum, average, standard deviation of salaries
• Average total company tenure
• Gender ratios
• Average payrise percentage and amount

A historic data asset is also required by HR Analytica so their People Analytics team can perform deep dives into a specific employee’s history. This analysis is used for decision making when it comes to pay rises and promotions.

🌟 Individual Employee Deep Dive

• See all the various employment history ordered by effective date including salary, department, manager and title changes
• Calculate previous historic payrise percentages and value changes
• Calculate the previous position and department history in months with start and end dates
• Compare an employee’s current salary, total company tenure, department, position and gender to the average benchmarks for their current position