Skill Gap Analysis Template
A skill gap analysis that sizes the gap in headcount and cost, not just percentages. See how many people are short, what closing it costs, and whether to build, buy or borrow.
- Required versus current proficiency scored 1 to 5 by skill and team
- The gap sized in headcount, not just a percentage nobody can fund
- A cost-to-close estimate, so the gap becomes a business case
- A build, buy or borrow call on every gap, so the plan is decision-ready
What is inside
-
A required versus current view
the proficiency each skill needs, scored 1 to 5, against where the team is now, by skill and team.
- A headcount sizing that counts how many people sit below the required level per skill, so the gap is a number a leader can act on.
- A cost-to-close estimate that compares the cost of training the shortfall against the cost of hiring for it.
- A build, buy or borrow call on every gap, so the analysis lands as a decision-ready plan rather than a chart.
Who it is for
Anyone who has to close a skill gap, and get the budget to do it.
- L&D and capability teams
- Workforce and strategic planners
- Heads of function and department
- HR business partners
- Talent acquisition leads
- Operations and delivery leads
- Finance business partners
- COOs and HR directors
The proficiency scale
The gap is the distance between required and current on a shared 1 to 5 scale. Set the required level per skill against this scale, then score current proficiency the same way, so the gap means the same thing everywhere.
| Level | Label | What it means |
|---|---|---|
| 1 | Aware | Knows the basics but cannot yet do the task unaided. |
| 2 | Assisted | Can perform the task with supervision or a checklist. |
| 3 | Independent | Performs the task reliably alone at the standard the role needs. |
| 4 | Proficient | Handles edge cases and improves how the task is done. |
| 5 | Expert | Sets the standard and can coach and sign off others. |
When the build decisions become learning in an LMS, current proficiency updates as people complete and pass, so the gap re-sizes itself and you can show a budget holder the number moving, not just the money spent.
How to run it
Ten checks that turn a proficiency chart into a funded plan. Tick items as you work through yours, it stays in this browser. The download has the same list with an owner column.
- Required level set per skill against the scaleStandardEach skill
- Current proficiency scored, ideally from a matrixBaselineEach team
- Gap counted in headcount, not just a percentageSizingEach skill
- Business-critical skills flaggedPriorityEach skill
- Cost to train the shortfall estimatedCostEach gap
- Cost to hire for the gap estimatedCostEach gap
- Build, buy or borrow chosen per gapDecisionEach gap
- Single-person skills treated as a risk, not just a gapRiskEach skill
- Gaps sequenced by criticality and costPlanWhole analysis
- A date and an owner set for each closing actionGovernanceEach gap
The most common failure is stopping at percentages. Sixty percent proficient does not get funded; eleven people short at a stated cost to close does. Always translate the gap into headcount and money.
Required versus current by skill
This is the analysis itself. Teams down the side, skills across the top, current proficiency 1 to 5 in each cell, and the required level as the bar. Anyone below the bar is part of the gap. In Excel the gaps, headcount short and readiness calculate as you type.
| Team | People | Cloud | Data | Security | Automation | AI / ML | Ready |
|---|---|---|---|---|---|---|---|
| Platform eng | 40 | 5 | 4 | 4 | 4 | 4 | 84% |
| App dev | 70 | 4 | 3 | 3 | 3 | 2 | 60% |
| Data team | 30 | 3 | 4 | 2 | 2 | 3 | 56% |
| Ops / SRE | 35 | 3 | 1 | 3 | 2 | 1 | 40% |
| New graduates | 25 | 0 | 0 | 0 | 0 | 0 | 0% |
| Coverage at required | 40% | 40% | 60% | 40% | 20% | 48% |
AI and ML is the widest gap here: only Platform eng is at the required level, so most teams are short and the whole graduate cohort is at zero. Size that gap in headcount, cost the build against a hire, and it becomes the first thing to fund.
Sizing and closing each gap
The matrix finds the gaps. This turns each one into a decision: how many people are short, what it costs to close, and the cheapest credible route. The numbers here are illustrative, replace them with your own rates.
| Skill | Headcount short | Criticality | Route |
|---|---|---|---|
| AI / ML | Around 90 people | High | Build: structured learning path for existing staff, plus two senior hires to lead. |
| Data | Around 60 people | High | Build: internal upskilling is cheaper than hiring at this volume. |
| Automation | Around 70 people | Medium | Build: on-the-job learning tied to real automation projects. |
| Security | Around 30 people | High | Borrow: short-term specialist cover now, build capability in parallel. |
| Cloud | Around 20 people | Medium | Build: targeted training for the teams below the bar. |
How to use it
- Set the required level per skill
Define the proficiency the role needs on a 1 to 5 scale, so the gap is measured against a real bar.
- Score current proficiency
Rate where the team is now on each skill, ideally from a skills matrix, not from memory.
- Size the gap in headcount
Count how many people sit below the required level per skill. That number, not a percentage, is the gap.
- Cost each gap to close
Estimate the cost to train the shortfall, and the cost to hire, so the two options can be compared.
- Decide build, buy or borrow
For each gap, pick the cheapest credible route: train people, hire, or bring in short-term cover.
- Sequence by criticality and cost
Close the business-critical, cheapest-to-fix gaps first, and put a date and an owner on each.
Disprz customers see up to 8X training ROI, which is why building capability internally so often beats hiring when a gap analysis puts the two options side by side.
Common mistakes this template prevents
- Reporting the gap as a percentage, which no budget holder can act on.
- Sizing the gap but never costing it, so build versus hire is never a real comparison.
- Scoring current proficiency from memory instead of from an actual skills matrix.
- Treating every gap as build, when some are faster and cheaper to borrow or buy.
- A sized gap with no owner or date, so the analysis is admired and then ignored.
Which format should you use?
| Format | Best for | What is inside | Editable | Size |
|---|---|---|---|---|
| Sharing and print | The full template, formatted to print or circulate | No | 54 KB | |
| Word | Editing the wording | Every section as editable text you can adapt | Yes | 86 KB |
| Excel | Filling it in live | The grid and scoring set up as a working spreadsheet | Yes | 65 KB |
Questions people ask
What is a skill gap analysis?
Why size the gap in headcount and cost, not percentages?
What is build, buy or borrow?
Does the Excel version work in Google Sheets?
Do I have to fill the form three times?
More from the workforce library
Sizing the gap is half of it. Closing it so people finish is the part we run.
Bring your sized gaps to a 30-minute working session. We will show how Disprz turns each build decision into short mobile learning aimed at the exact people who are short, and tracks proficiency as it rises, so you can prove the gap is closing, not just funded.