40 likes | 185 Views
Screen 1: Turnover Root Cause Analysis. Screen 2: Drill Down
E N D
Screen 2: Drill Down Introducing new data elements (e.g., Performance Category) helps to discover new insights in the existing data. This is the same data as Screen1, but trellised by Performance Category. The data shows that the program does well in removing low performers, but the procurement data must be explored. An examination of high performers shows that a problem exists which is leading to the loss of quality resources. To further understand what is driving the trend, the last defined period is selected and further drilled down.
Screen 3: Further Drill Down Sorting the data by reason for leaving shows that a compensation problem exists, and further analysis reveals more specifically that the majority of the roles citing this issue are Programmers and QA. This analysis lends itself to discussion about mitigating these job losses, such as increasing bill rates for these roles or setting thresholds for reduction in turnover to break even from cost to hire.