We are looking for a way to use SharePoint to manage an employee skills matrix. This matrix is currently an Excel spreadsheet, however this is becoming rather cumbersome.
Our data consists of:
- 150 different skills, separated in groups (likely to expand)
- 25 employees (likely to expand)
- Skill level for every employee against each skill, using a number-based scale (0 = no experience through to 3 = Proficient)
Example of the type of matrix we're using at the moment:
We'd like to be able to search for Skill X
(or if possible: Skill X and Skill Y
) and have SharePoint report back the employees with experience in this skill.
If possible, We'd still like to maintain the data in a single list so we easily can make adjustments, additions for new staff members/skills in a single view.
We are running SharePoint 2010, but have access to SharePoint 2013 if that helps.
I am very rusty with my SharePoint skills, so your help is much appreciated. I have access to SharePoint Designer and InfoPath Designer, but no back-end access to the SharePoint servers.