In this blog I often talk about the project prioritization process and the best method of implementing it. In this article I would like to share some ideas on how to use the prioritization matrix to prioritize projects in a way that gives you a chance to succeed.
What is Prioritization Matrix?
A prioritization matrix is a simple tool where you create a set of criteria (which should map to your business goals) and use them to score your projects. Why? Well, you’re trying to work out which projects are most important so that you can prioritize them.
It’s pretty simple in concept, but can be really hard to do well.
It’s not the maths that’s difficult (and that’s where most articles on prioritization matrices focus), it’s all the human stuff...
Benefits of Prioritization Matrix
In principle, a prioritization matrix is easy to use and to use to make decisions. Most business managers can understand the concept of a weighted score in a spreadsheet.
Once you have your spreadsheet, it’s easy to tweak criteria weights and to see the effect on your ranking immediately.
Your priority matrix also spits out a clean, unambiguous number for “priority”. This is something that everyone can understand and relate to.
Prioritization Matrix For Projects
Let’s spend a minute looking at how the project prioritization matrix is usually deployed.
First, you define a set of criteria that you will use to score projects. These criteria should reflect your business goals. You should then weight these criteria - usually people will give each one a percentage-based weighting.
Next, you score your projects. You need to score each project against each criterion, but you need to come up with a suitable scale.
In decision-science speak, we talk about normalizing scores. This means either using the same scale (e.g. 1-5 scale) for all criteria or doing some maths to convert scores into “normalized scores” - I won’t go into how you do this here, but be aware of this step - many people miss it and it causes problems.
Now you have your weighted criteria and your scores for each project, you can work out the weighted score for each project by doing a fairly simple calculation:
(Weight of Criterion 1 x Score of Criterion 1) + (Weight of Criterion 2 x Score of Criterion 2) + (Weight of Criterion 3 x Score of Criterion 3) + …..
Keep going until you have added up the weighted scores for all the criteria… and that’s it. You have a priority score for your project… and you can move on to do the same calculation for the next project.
Of course, you’ll probably want to do this in a spreadsheet. This example (which you can download here) will show you what the maths looks like.
Problems with Project Prioritization Matrix
The core problem is caused by its main benefits - the prioritization matrix is a tool designed to be quick and easy to use... which is okay if decisions are not very important. If you’re prioritizing short tasks, things that don’t have much impact over the long term, then this is fine.
But projects are not tasks.
Projects are bigger and the consequences of picking the wrong ones can be spectacular.
What’s more, if you ask 5 stakeholders what weight to put on the criteria, you’ll probably get 10 answers!
Without agreement on this, your project prioritization matrix is meaningless.
Sure, it will give you some numbers, but those numbers will not be trusted (or even relevant) to your stakeholders. So yes, you’ll be able to make prioritization decisions, but you won’t be making decisions that actually help your stakeholders.
You can fix this problem by using project prioritization software to add AHP (which stands for the Analytic Hierarchy Process) to the front-end of the prioritization matrix maths.
AHP allows you to build a strong and clear consensus between stakeholders. This results in a set of weighted criteria that the stakeholders own, that they trust, that they value.
3. Broken collaboration on scoring
When you’re scoring a project against a criterion like “Impact on customer satisfaction,” you have to make a subjective judgement. Some people might see the “impact” of the project as being “Major” and others might consider it “Insignificant”.
If you don’t have a mechanism for resolving this, for bringing together different stakeholders to make subjective judgments, then your scores will end up being totally meaningless… at least, they will be meaningless to your stakeholders.
Some of your scores will be “hard numbers”. For example, the “net present value” or “number of systems impacted” are hard numbers, but somehow you have to get those data from the “subject matter expert” who holds them. This typically involves a lot of chasing and then cutting-and-pasting into spreadsheets.
This not only takes time, but is open to errors as you copy data from one place to another. It’s also common for data to be out of date.
Moving online, using a system like TransparentChoice, can really help.
TransparentChoice lets you collaborate with your stakeholders to build consensus around subjective judgments (such as “Impact on customer satisfaction”). By involving different stakeholders, and by automating some of this collaboration, you can build this consensus quickly and easily.
Overall, if you don’t collaborate effectively when scoring projects, your prioritized scores will not be “trusted”.
4. Score-based decisions
When you’re prioritizing small, tactical items (tasks, maintenance items, etc.), you can usually use the “score” from your matrix to prioritize work. Taking the task with the highest score is typically a good rule.
Projects are different.
Projects exist to help you achieve more strategic business goals. They compete for resources and for budget. Sometimes, there are dependencies between projects and the whole decision is usually quite political. This means you need to balance resources across different departments, different business goals, etc…. and all while tracking your various resource constraints and budget.
You could do this in spreadsheets, but if you have more than 5 or 10 projects, it will get really complicated really quickly.
Good software, like TransparentChoice, lets you track not only the scores but also the cost for each project. It lets you balance the projects across business drivers while tracking your different resource constraints. It even tracks project dependencies for you (so you never approve a project without first approving its “predecessors”).
And you can do it all in one convenient dashboard.
The concepts behind it are sound - we want to maximize alignment with our goals, and use weighted scoring to do that - but the practice typically falls short in areas such as:
Defining the appropriate criteria to use
Weighting those criteria (with stakeholder buy-in)
Collaborating to score projects quickly and “accurately”
Balancing factors other than “score”
Software like TransparentChoice can help you take the project prioritization matrix ideas to a new level leading to a portfolio of projects that enjoy stronger stakeholder support and, in turn, enjoy higher success rates.