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
- 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.
- 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".
- 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.
- 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.
- 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.
| Column | What to put in it |
|---|---|
| Business problem | The measurable outcome this row is meant to move |
| Role | The job the gap applies to |
| Task or competency | One observable task, phrased as something a person does |
| Criticality (1-3) | 3 if failure is unsafe, costly or customer-visible |
| People affected | How 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 |
| Gap | Required minus current |
| Weighted priority | Gap x criticality x people affected |
| Evidence source | Assessment score, observation, ticket data, audit finding |
| Likely cause | Knowledge, skill, process, tooling or motivation |
| Response | Train, coach, change process, fix tool, accept |
| Owner | The named person accountable for the response |
| Re-measure date | When 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 includedWhere 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 analysis | Skills gap analysis | |
|---|---|---|
| Starting point | A business problem or change | A role or capability framework |
| Scope | Any cause, any response | Capability shortfall only |
| Output | Ranked decisions with owners | Gap map across people and skills |
| Runs | Per initiative or annually | Continuously 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 freeRelated guides
- Skills Gap Analysis: A Template and a Method That Survives Contact With Reality
Run a skills gap analysis in five steps: free template, score current vs required levels 0-4, rank the gaps, and turn results into training.
- Competency Matrix Template: How to Build One People Actually Use
A competency matrix template with levels, criteria, and worked examples — plus how to score it, keep it current, and avoid the mistakes that make matrices go stale.
- How to Measure Training Effectiveness Without Fooling Yourself
How to measure training effectiveness beyond attendance: the Kirkpatrick levels in practice, which metrics to track, how to baseline, and how to report ROI to finance.
- How to Assess Employee Skills and Competencies
A practical employee skills assessment process: map the skills that matter, baseline your team, re-test with spaced questions, and track measurable skill gain over time.
- Skills Matrix Builder
Free, no signup — build a skills matrix, see gaps and coverage, download as CSV.
- Assessment Method Picker
Free, no signup — get a recommended scoring algorithm and question selection method.
- Training ROI Calculator
Free, no signup — estimate cost, value and payback for a programme.
Written by the Metronic team. Have feedback on this guide? info@metronic.ai