Guide

Training Needs Analysis Template: Decide What to Train Before You Build Anything

A training needs analysis (TNA) turns a vague request for training into a ranked list of gaps with evidence behind each one. Here is the five-step method, the template columns that matter, and a downloadable CSV you can fill in today.

What a training needs analysis is

A training needs analysis is the work you do before designing training: establishing which business problem you are trying to move, which people are involved, what they can already do, and where the shortfall sits. The output is not a course list. It is a ranked set of gaps, each with a cause and a proposed response.

The distinction that saves the most money is cause. A gap caused by missing knowledge responds to training. A gap caused by an unclear process, missing tooling, or a broken incentive does not, and building a course for it wastes the budget while leaving the problem in place.

The five steps

  1. State the business problem in a measurable sentence. "Refund disputes are escalating at 22% and we want that under 10% by Q2" is workable; "the team needs upskilling" is not.
  2. List the roles and tasks that touch that problem. Keep the unit at the level of a task someone performs, not a broad theme like "communication".
  3. Gather evidence of the current level. Use knowledge assessments, work samples, observation, quality or ticket data, and manager input. Two independent sources per task beats one confident opinion.
  4. Size the gap. Record the required level, the current level, how critical the task is, and how many people are affected. Multiply criticality by population to get a weighted score you can sort on.
  5. Decide the response per gap. Train, coach, change the process, fix the tool, or accept the risk. Assign an owner and a re-measurement date to each decision.

Template columns and what goes in them

The downloadable template below uses these columns. Keep them; the analysis loses its teeth when the evidence and decision columns get dropped.

ColumnWhat to put in it
Business problemThe measurable outcome this row is meant to move
RoleThe job the gap applies to
Task or competencyOne observable task, phrased as something a person does
Criticality (1-3)3 if failure is unsafe, costly or customer-visible
People affectedHow many hold the role
Required level (0-4)What the role needs, agreed with the manager
Current level (0-4)What the evidence shows today
GapRequired minus current
Weighted priorityGap x criticality x people affected
Evidence sourceAssessment score, observation, ticket data, audit finding
Likely causeKnowledge, skill, process, tooling or motivation
ResponseTrain, coach, change process, fix tool, accept
OwnerThe named person accountable for the response
Re-measure dateWhen the same evidence gets collected again

Want the current-level column measured for you? Metronic turns your own documents into short assessments and keeps the scores up to date.

Start free — 200 credits included

Where the evidence comes from

Self-assessment alone is the most common failure mode: people who do not know a topic tend to rate themselves generously, and the confident-but-wrong cases are exactly the ones worth finding. Pair every self-rating with an objective source.

Knowledge questions work well for policy, product and process recall. Work samples and observation work well for physical or judgement-heavy tasks. Operational data - ticket reopen rates, defect rates, audit findings - is usually already sitting in a system and costs nothing to pull.

Training needs analysis vs skills gap analysis

They overlap and are often run together. A skills gap analysis compares current capability against required capability across a population. A training needs analysis starts from a business problem and ends with a decision about what to do, of which training is only one option.

Training needs analysisSkills gap analysis
Starting pointA business problem or changeA role or capability framework
ScopeAny cause, any responseCapability shortfall only
OutputRanked decisions with ownersGap map across people and skills
RunsPer initiative or annuallyContinuously or per review cycle

Mistakes that ruin the analysis

  • Starting from a course catalogue and working backwards to justify it.
  • Measuring themes ("leadership") instead of tasks anyone can observe.
  • Collecting evidence once and never re-measuring, so nobody learns whether the response worked.
  • Treating every gap as equal instead of weighting by criticality and population.
  • Leaving rows without an owner, which guarantees nothing happens after the spreadsheet is circulated.

Running the analysis continuously with Metronic

A one-off spreadsheet ages fast. Metronic turns the evidence step into something that repeats: upload the material a role depends on, generate assessment questions from it, and the platform tracks per-person and per-topic mastery over time - so the current-level column refreshes itself instead of needing another survey round.

Download the training needs analysis template

A CSV with the fourteen columns above, three worked example rows, and the 0-4 level scale written out. Opens in Excel, Google Sheets or Numbers.

What is inside

  • Fourteen ready-made columns from business problem to re-measure date
  • Three filled-in example rows across support, field and compliance roles
  • The 0-4 level scale with plain-language descriptors
  • A weighted priority column so the list sorts itself

Frequently asked questions

What is a training needs analysis template?

A structured sheet that records, for each role and task, the required level, the current level, the evidence behind that judgement, the likely cause of the gap, and the decision about what to do. It keeps the analysis auditable instead of anecdotal.

How long does a training needs analysis take?

For a single team and a defined business problem, a focused analysis takes one to two weeks: a few days to agree tasks and required levels, a week to collect evidence, and a session to prioritise and assign owners. Organisation-wide analyses take longer mainly because agreement takes longer, not because the method changes.

Who should be involved?

The manager accountable for the outcome, one or two experienced practitioners in the role to validate the task list and required levels, and whoever owns the operational data you plan to use as evidence.

Is training always the answer?

No. Roughly speaking, only gaps caused by missing knowledge or skill respond to training. Gaps caused by unclear process, missing tooling, unrealistic workload or misaligned incentives need a different fix, and labelling them as training needs is how programmes lose credibility.

Try it with your own material

Metronic turns a document, an SOP, or a website into a structured assessment tagged to your competency framework — then keeps asking the questions that matter until people remember them.

Start free

Related guides

Written by the Metronic team. Have feedback on this guide? info@metronic.ai