Skip to main content

Analytics: Workforce Structure (dashboard)

An ideal dashboard to analyze your workforce distribution, optimize your structure/billable balance, and manage your company payroll.

Written by Charlie Troccaz

🤖 This article was translated by AI.

Prerequisites

Modules Analytics and Opportunities enabled in your permissions.


What does this dashboard contain and what is it for?

This dashboard consolidates your HR KPIs on both organizational and economic levels (total workforce, overall and average monthly payroll cost per employee, structure/billable workforce split, and billable workforce breakdown by type) to help you:

  • maintain an optimal billable/structure resources ratio;

  • compare the average payroll cost per resource to your internal or industry benchmarks;

  • measure your use of external providers and anticipate potential recruitment needs.

Leverage the monthly evolution charts (workforce, payroll cost) to identify seasonal patterns, growth or stabilization phases, and adjust your HR strategy accordingly.


How to view data details?

To access the detail table of an indicator:

1. Hover over the widget → click on the 3 dots (⋮)

2. Select "View details"

3. A modal opens with the detailed data table

In the modal, you can refine your analysis by modifying the filters. These changes apply only within the modal and do not affect the widget's default configuration.


Available indicators

Indicators related to workforce and their distribution

Indicator

Definition

Total workforce

Total number of resources with an active contract

Structure/billable workforce split

Distribution of the total workforce between structure resources (not assigned to client projects) and billable resources. Key indicator for managing your profitability lever.

Billable workforce breakdown by type

Breakdown of billable resources by type (e.g., internal consultant, external consultant). Allows you to monitor the rate of use of external providers

Monthly workforce evolution

Stacked histogram over 12 months showing the evolution of the number of resources with breakdown between "structure" and the types of "billable" resources

Where are the modes and types of resources used for these distributions defined?

In Administration > Global settings > HR data:

  • Resource type: Resource function/role (e.g., Internal consultant, ADV). Visible and editable from the resource card.

  • Mode: Visible in admin only. Indicates if the type is billable or structure.

Indicators related to workforce cost

Indicator

Definition

Payroll cost (this month)

[Gross monthly salary × Charge coefficient × Number of months] - [Number of days not included in the contract in the month × gross annual loaded salary / 365.25]

Average monthly cost per employee

Average monthly payroll cost per employee

Monthly payroll cost evolution

Stacked curves over 12 months showing the evolution of payroll cost with distinction between costs related to structure and billable resources. Allows you to identify if your profitability potential is decreasing (increase in the structure share)


Did this answer your question?