Skip to content
The Tech Team Skills Matrix: the workbook's matrix, a heat map of a sample team's skills with the cover for each, on a yellow background

The Tech Team Skills Matrix

See who on your tech team can do what, where only one person - or nobody - can do something the business depends on, and plan the training that closes the gaps: a scored matrix, cover for every skill, each person's load and a training plan.

Ask a tech team who can restore the backups, change the firewall or deploy the customer portal, and you'll usually get one name. That's fine until that person is on vacation, off sick or gone - and nobody notices until the day it matters.

This workbook puts the whole team on one page: every skill and system the business runs on, everyone's level, and how much cover you really have.

What's in it

  • Matrix: one row per skill or system, one column per person, each scored 0 to 4 - from "hasn't used it" to "can teach it". You set how many people should be able to do each one alone, and it shows the cover: Covered, Below target, Only one person or Nobody, with the name of the one person where there's only one.
  • People: what each person holds, what only they hold, how many of those are critical, and what they're learning - with what to do next for each of them.
  • Training Plan: who learns what, from whom, by when, how many hours and what it costs. It reads each person's level from the Matrix, flags anything overdue, and reminds you to update the Matrix when training's done.
  • Summary: coverage against your targets, the gaps with nothing planned, cover by area, who holds the most alone, and the training under way.

It comes filled in with a made-up nine-person tech team at a 120-person company: 21 skills, 71% coverage, and four critical systems only one person can run. Clear the sample and the formulas stay.

Who it's for

CTOs, heads of technology, IT managers and engineering leads with a team of roughly 3 to 12 people - or one tab per team for bigger ones. It's a map of the team, not a ranking of people, and the Start Here tab says how to keep it that way.

It goes deeper than The Key-Person Risk Map: that finds the people the business can't run without, this maps every skill across the whole team and plans the training. Scores make good one-to-one conversations - The One-to-One Kit for Tech Managers has the questions - and The Tech Career Ladder shows each person where the skills lead.

It's a single Excel file. It also opens in Google Sheets and Apple Numbers.

Want them all? The Complete Collection has every guide in the store in one download, for less than a third of the price.

Reviews

No reviews yet.