Skip to main content

Analytics: Staff Structure (dashboard)

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

Written by Charlie Troccaz

🤖 This article was translated by AI.

Prerequisites

Modules Analytics and Opportunities enabled in your rights.


What does this dashboard contain and what is it for?

This dashboard consolidates your HR KPIs on organizational and economic levels (total staff, total and average monthly payroll cost per employee, structure/billable staff distribution, and billable staff 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 (staff, payroll cost) to identify seasonal patterns, growth or stabilization phases, and adjust your HR strategy accordingly.


How to view detailed data?

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 staff and their distribution

Indicator

Definition

Total staff

Total number of resources with an active contract

Structure/Billable staff distribution

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

Billable staff breakdown by type

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

Monthly staff 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: Function/role of the resource (e.g., Internal consultant, ADV). Visible and editable from the resource card.

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

Indicators related to staff cost

Indicator

Definition

Payroll cost (this month)

[Gross monthly salary × Charge coefficient × Nb. months] - [Number of days not included in the contract in the month × gross annual salary with charges / 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, distinguishing 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?