Personnel productivity breakdown

We begin the analysis of each office's teams by investigating their overall compositions and actions. We have a variety of metrics that may help us understand why one team may perform better than another. The following is a list of common metrics that we can use in our HR perspective:

• Age distribution

• Salary distribution

• Employee-retention rate

• Employee sick and vacation days

• Employee training and performance

Age distribution

Let's begin with our analysis and compare the age distribution between the two offices. Instead of using a histogram, we use a frequency polygon so that we can compare more than one distribution in the same chart.

Exercise 17.3

1. Create the following variable:

   Variables	Details
   Label	Value
   vEmployeeAgeBinSize	1

2. Let's create the following line chart:

   Dimensions	Details
   Label	Value
   Age	=ValueLoop($(=floor(min({$<_Employee_Active_Flag={1}>} [Employee Age]),vEmployeeAgeBinSize)),$(=floor(max({$<_Employee_Active_Flag...