Skip to content

KPIs

Overview

The main goal of the TOP dashboard project is to measure profitability, and slice it by various dimensions.

The recruitment activities are obviously one of the most important drivers of Delta's success. However, this is not included in the scope of this project. We first focus on the financial/profitability part. The data architecture will allow us to add new perspectives (recruitment, sales & marketing..) later on.

TOP

KPQ

How can we know how:
- profitable
- growing
- productive

we are by
- team
- sector
- client
- office/region
- price setting (invoicing type)
- work place /city

Finance

  • How can we measure the margins?
  • How do we know when to use factoring?
  • How do we know if we are in line with the budgets?
  • How do we know DSO?

Recruitment (not yet included in this project)

  • How can we know how much we spent for hiring a student?
  • How can we know which channels work best to find students?
  • How can I know the the quality of the students coming from these channels?

Sales (not yet included in this project)

  • How can we know which sales tactics work?
  • How can we know what source channels bring the most and the best clients?
  • How do we track standard sales activity metrics?

Note from Jaimy via email on 2022-06-28: Just a small side note, if possible we would also like to see per client the evolution in revenue in the first draft of the dashboard. This is very important for our business to be able to see quickly which clients stopped or dropped in revenue.

KPIs

Margin

\[ M€ = R - C \]
\[ M\% = \frac{(R - C)}{R} \]

Revenue

\[ R = SUM(InvoiceLine.NetAmount) \]

Hours/shift

Shift = 1 day worked per 1 student on 1 job

NOTE: in the platform, the respective table is called Vacancy_Allocation (for legacy reasons)

Days Worked/Month

We get the days worked from Prato. Namely:

1. for each student
  a. find all salary lines with Looncode 201
  b. count the distinct dates of these lines

Fill Rate

\[ FR = \frac{FS}{RS} \]

with

FR = Fill Rate
FS = Filled Shifts
RS = Requested Shifts

QUESTION to Tayfun / Jaimy: How can we get \(RS\), requested shifts, from the platform.

Missed Revenue

If possible, distinguish non-fill rate and no-show rate

Missed Revenue due to not filled

\[ R^{missed\,not\,fillled} = \#Shifts^{not\,filled} * AVG(R) \]

QUESTION to Tayfun: Can we get the reason for missed shifts?

Where:

  • \(\#Shifts^{not filled}\) : Number of shifts that couldn't be filled

  • \(AVG(R)\): average revenue per client for up to 20 last jobs

Missed Revenue due to no show

Similarly:

\[ R^{missed\,no\,show} = \#Shifts^{no\,show} * AVG(R) \]

Distribution of statutes

% of employee codes

25% working student

25% Flexi

50% student