Dashboard example: Workforce planning

No ratings

Problem to solve:

As an HR manager, I need to enter the salary raise numbers for multiple regions that I'm responsible for.

As a domain best practice, my driver-based model helps me to enter raise guidelines, which will then change at the employee level.

Usability issue addressed: I have ten regions, eight departments in each, with a total of 10,000+ employees. I need to align my bottom up plan, to the down target I received earlier.

I need to quickly identify what region is above/behind target and address the variance. My driver-based raise modeling is fairly advanced and I need to see what the business rules are. I need to quickly see how it impacts the employee level.

Call to action:

  • Step 1: Spot what region I need to address. 
  • Step 2: Drill into the variances by department.
    • Steps 1 & 2 are analytics steps: "As an end user, I focus first on where the biggest issues are." This is a good usability practice that helps users.
  • Step 3: Adjusting the guidelines (drivers)
    • There are not excessive instructions on how to build and use guidelines, which would have cluttered the dashboard. Instead, Anaplan added a "view guideline instruction" button. This button should open a dashboard dedicated to detailed instructions or link to a video that explains how guideline works.

Impact analysis:

  • The chart above the grid will adjust as guidelines are edited. That is a good practice for impact analysis: no scrolling or clicking needed to view how the changes will impact the plan.
  • Step 4: Review a summary of the variance after changes are made. Putting steps 1–4 close to each other is a usable way of indicating to a user that he/she needs to iterate through these four steps to achieve their objective, which is to have every region and every department be within the top down target.
  • Step 5: A detailed impact analysis, which is placed directly below steps 3 and 4. This allows end users to drill into the employee-level details and view the granular impact of the raise guidelines.

Notice the best practices in step 5:  

The customer will likely ask to see 20 to 25 employee KPIs across all employees and will be tempted to display these as one large grid. This can quickly lead to an unusable grid made of thousands of rows (employees) across 25 columns.

Instead, we have narrowed the KPI list to only ten that display without left-right scrolling.

Criteria to elect these ten: be able to have a chart that compares employees by these KPIs.

The remaining KPIs are displayed as an info grid, which only displays values for the selected employee. Things like region, zip codes, and dates are removed from the grid as they do not need to be compared side-by-side with other KPIs or between employees.WFP 01.png 


WFP 02.png


Version history
Revision #:
7 of 7
Last update:
‎03-01-2018 07:14 AM
Updated by: