Quality dashboard: steering your training organisation with the right indicators

Many training providers measure everything and steer nothing: satisfaction questionnaires pile up, attendance sheets are filed away, quotes are tracked from memory — and no consolidated figure exists on the day the auditor asks “how do you know it works?”. The quality dashboard is the missing piece: a single document, even a simple spreadsheet, in which every indicator has a definition, a source and a frequency. Here is how to build it without giving up your weekends.

Why a dashboard: two Qualiopi indicators depend on it

The framework does not require a “dashboard” as such, but two requirements make it unavoidable:

• Indicator 2 requires the publication of performance indicators that are suited, dated and sourced. Publishing a rate means being able to reconstruct it: the dashboard is precisely that calculation base. The publishable rates and their formulas are covered in a dedicated article on performance indicators.
• Indicator 32 requires a continuous improvement process built on the analysis of feedback and complaints. The dashboard is its raw material: it is what turns scattered feedback into trends, and trends into corrective actions documented in your continuous improvement process.

A single document therefore feeds two indicators — one of which (32) is among the most scrutinised in surveillance audits.

The founding idea: few indicators, several dimensions

The principle of the modern dashboard was formalised by Robert Kaplan and David Norton in their seminal 1992 article, “The Balanced Scorecard—Measures that Drive Performance”, published in the Harvard Business Review: steer an organisation with a small number of indicators covering several dimensions (customers, internal processes, learning, finances) rather than with a single financial figure. Transposed to a training provider: neither revenue alone nor the satisfaction rate alone tells you whether the organisation is healthy. It is the cross-view — teaching, learner journey, sales — that makes steering possible.

Which indicators to track: three families

Teaching indicators

• Hot satisfaction rate: satisfied respondents ÷ respondents × 100, measured at the end of the session through your trainee satisfaction surveys.
• Cold satisfaction rate: same logic, measured several weeks or months after the course through the cold evaluation — the one that approximates real usefulness back at work.
• Objective-achievement rate: trainees who met the set objectives (learning assessments) ÷ trainees assessed × 100.
• Certification pass rate: candidates who passed ÷ candidates who sat the exam × 100, for certifying courses.

Learner-journey indicators

• Dropout rate: trainees who left the course permanently ÷ trainees enrolled × 100. A rising rate feeds directly into your dropout prevention plan.
• Interruption rate: suspended journeys (without permanent dropout) ÷ trainees enrolled × 100 — keep it separate from dropout, as causes and responses differ.
• Attendance rate: hours actually attended ÷ planned hours × 100, from attendance sheets or connection logs.

Sales and administrative indicators

• Quote conversion rate: quotes accepted ÷ quotes issued × 100, per period.
• Average response time to enquiries: sum of response times ÷ number of enquiries, in working days.
• Number of complaints and average handling time: each complaint dated at receipt and at closure, in line with your complaints and incident management process.

Defining each indicator properly: the three-column rule

A poorly defined indicator is worse than no indicator: it produces figures that cannot be compared from one year to the next, and are therefore useless for steering and for the audit alike. For each indicator, set down in writing:

1. The exact formula: numerator, denominator, unit. “Satisfaction rate” means nothing until you have specified: score ≥ 8/10? Respondents or enrollees in the denominator?
2. The period: calendar quarter, calendar year, or session — and stick to it.
3. The data source: which file, which questionnaire, which register. If the source changes (a new questionnaire), record the date of the change: the auditor understands a documented break in the series, not a figure that can no longer be reconstructed.

This discipline is what makes your published figures defensible under indicator 2: one rate = one formula + one period + one source.

A typical dashboard for a small training provider

Indicator	Formula	Source	Frequency	Alert threshold
Hot satisfaction	Respondents scoring ≥ 8/10 ÷ respondents × 100	End-of-session questionnaire	Every session, consolidated quarterly	Average score falling over 2 consecutive quarters
Cold satisfaction	Satisfied respondents ÷ respondents × 100	Cold questionnaire (day 90)	Quarterly	Marked gap between hot and cold
Objective achievement	Trainees who validated the objectives ÷ trainees assessed × 100	Learning assessments	Every session	Drop versus the previous quarter
Certification pass rate	Passed ÷ sat the exam × 100	Certifying body’s results	Every exam session	Drop versus the previous cohort
Dropout	Permanent exits ÷ enrolled × 100	Entry/exit register	Quarterly	Any quarter-on-quarter increase
Attendance	Hours attended ÷ planned hours × 100	Attendance sheets / connection logs	Quarterly	Continuous erosion over 2 quarters
Quote conversion	Quotes accepted ÷ quotes issued × 100	Quote register	Quarterly	Drop versus the same period last year
Response time	Sum of delays ÷ enquiries (working days)	Mailbox / CRM	Quarterly	Exceeding your published commitment
Complaints	Number received; average closure time	Complaints register	As they occur, quarterly review	Complaint not closed within your own deadline

The alert thresholds are deliberately relative to your own data (trend, year-on-year comparison, published commitment): your history is the benchmark, not some supposed market standard.

A realistic rhythm: quarterly

For an organisation of one to five people, the sustainable rhythm is this: data entry as you go (every questionnaire received, every quote issued, every complaint goes into the spreadsheet the same day or at the end of the week), quarterly consolidation (one hour per quarter: calculate the rates, compare with the thresholds, decide on corrective action if a threshold is crossed), and an annual review that updates the published figures and feeds the review of your quality system. A monthly rhythm promises more than an independent provider can sustain; an annual rhythm detects drifts a year too late.

What the auditor does with it

The dashboard is one of the highest-yield documents in an audit, because it serves as a common thread across several indicators at once. Concretely, the auditor:

• traces back to the source: takes a published rate and asks to reconstruct it — your formula/source columns answer immediately;
• looks for drifts: a falling score, a rising dropout rate — and checks that you saw them;
• demands the full loop for indicator 32: drift detected → analysis → corrective action → effectiveness check. An annotated dashboard (“Q2: satisfaction drop on module X → materials reworked in September → Q4: back to previous level”) is exactly the expected evidence.

A spreadsheet is enough

No need to invest in quality software: a workbook with one entry tab per data type (sessions, surveys, quotes, complaints) and a summary tab that calculates the rates covers the entire need of a small provider. The only real requirements are the stability of the definitions, the regularity of data entry and the trace of the actions triggered. The best dashboard is not the most complete one: it is the one still being kept up to date in the fourth quarter.

Take action

The Complete Kit Certif (€297, 14-day guarantee) includes a ready-to-use quality dashboard, with the rate calculation formulas, the complaints register and the continuous improvement templates linked to indicators 2 and 32. Setting up your organisation and want the steering system in place from day one? The ebook “Create your training organisation in 30 days” (€67) guides you step by step — or take the Complete Pack (€347).