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 permissions.


What does this dashboard contain and what is it for?

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

  • maintain an optimal billable/structure resource 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 trend charts (staff, 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 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 split

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

Billable staff 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 staff trend

Stacked histogram over 12 months showing the evolution of the number of resources with a split between “structure” and the types of "billable" resources

Where are the resource modes and types used for these splits 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 record.

  • Mode: Visible in admin only. Indicates if 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 this month × gross annual loaded salary / 365.25]

Average monthly cost per employee

Average monthly payroll cost per employee

Monthly payroll cost trend

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


Did this answer your question?