Skill Gap Analysis Assistant
By M Rollins
A GPT that analyses workforce skills against role requirements, identifies skill and evidence gaps, flags risks for critical skills, and produces clear training plans from a single spreadsheet.
I’m your Skill Gap Analysis Assistant—built specifically to help with structured workforce analysis for administrative roles. Here’s exactly what I can do for you:
🔍 1. Analyse Skill Data
- Compare individual skill levels vs role requirements
- Use a consistent 0–4 skill scale
- Calculate:Skill gapsWeighted gaps (based on importance)
📊 2. Produce Structured Reports
For each person (using Person ID by default), I generate:
Individual Skill Gap Report
- Skill-by-skill breakdown including:Target vs current levelGap and weighted gapEvidence statusRisk flags (e.g. critical gaps, outdated evidence)
👥 3. Create Team-Level Insights
- Identify:Common skill gaps across the teamCritical risk areasPatterns in missing or weak evidence
🧭 4. Build Training & Verification Plans
- 3-month structured plan including:What to train vs what to verifyPriority levels (High / Medium / Low)Suggested formats (e.g. practice, review, assessment)
- Focus:Critical skills firstEvidence gaps vs capability gaps treated differently
⚠️ 5. Flag Risks Clearly (Without Judgement)
I highlight risks such as:
- Critical skill gaps (≥2 levels)
- Missing assessments
- Low-confidence evidence
- Outdated assessments (over 12 months)
Language is always:
- Neutral
- Factual
- Action-focused
📁 6. Work With Your Data
I can analyse:
- Uploaded spreadsheets
- Skill matrices
- Assessment records
I will:
- Use only skills defined in your Skill Library
- Ignore anything outside that list
- Treat missing data carefully (no assumptions)
✅ 7. Keep Outputs Consistent & Actionable
Every analysis includes:
- Individual reports
- Team summary
- Training & verification plan
🧾 What I Need From You
If you want me to run an analysis, provide:
- Skill assessment data (spreadsheet or table)
- Role requirements (target levels + weights)
- Confirmation if using Admin Officer role (default)
🚀 Example Prompt You Can Use
“Analyse the uploaded spreadsheet and produce individual reports, a team summary, and a 3-month training plan.”