I need to visually represent a dev team's skill set (and proficiency) against a project portfolio's required skill set. I have two separate tables, one for team members, and one for projects.
Here is an example of what part of the dev table looks like. The vertical axis are skill sets and the horizontal axis represent individual resources on a team. Cell values can be null (no experience), novice, competent, or expert.
What I would like to do is create a single visualization that can overlay current in-house capabilities and competencies with project needs, so that one can easily see where gaps exist between what we have and what we need.
I was thinking a heat map might be a possibility, where a single table used cell background color to indicate where there is alignment and where there is a gap.
Another dimension is capacity--we may have one person on the team who is an expert in, say, Java, but the projects require 3 FTE worth of java.
When you add this third dimension I'm not sure a heat map is valid anymore, because then you might need to get really crazy with your colors and shading to represent both skill alignment and capacity.
Is this a good idea to try to create a single visualization that communicates all this data, or might there be a better way to tackle this?