SharePoint Online - Employee Skills Tracker - SharePoint Lists / PowerApps / PowerBi ? -- 2

Job ID: 34160815

Budget: $30 – $250 AUD

We are seeking to implement a skills tracker for employees and require assistance with data modeling, setup and forms. Users will use Microsoft 365 available tools to view, track and update employee progress.
Tools can include; SharePoint lists, PowerApps.

Skills data
Group, Sub-group, Title

Employee data
Full Name, Position, Grade of all skills (1 to 5), date against each skill update / submission,

Skill score / level data
1 - None
2 - Basic
3 - Demonstrating
4 - Proficient
5 - Expert

Manager / Supervisor submission form (must be easy to use)
- Choose Employee from drop-down list
- Choose Group from drop-down list
- Choose Sub-group from drop-down list
View a dynamic list of all skills, allowing the user to individual grade that employee (1 to 5) on each skill in that sub-group.

Goals:
- Seeking quickest and easiest way to implement.
- NOT looking for excessive cost or build time.
- to be able to print an Employee report
- to tracker employee progress over time.
- view all employees progress via a matrix, table or dashboard.
- view individual employee progress.
- view employee progress across groups and sub-groups, then be able to drill down in sub-groups skills.
- The ability to add, edit and update skill list as need, as required.
- The ability to add, remove employees
- OPTIONAL a PDF report to be auto generated and sent to employee and / or supervisors
- OPTIONAL to be able to publish results to a SharePoint page, allowing the user (employee) to see their own results once logged in.