SME Employee Skill Audit Records

This dataset captures detailed skill audit records for SME employees, including individual skill assessments, training completion, and eligibility for internal mobility and upskilling. It enables SMEs to monitor workforce capabilities, identify skill gaps, and optimize talent development strategies for agile business growth.

  • last updated 5 Sept 2025
  • by GoMask
The brief that made it

Identifying skill gaps and training needs across SME workforces

Sample rows

preview · 8 of 200 rows · all 20 columns
record_idintegerskill_categorystringskill_proficiency_levelintegertraining_completedbooleantraining_providerstringemployee_idintegeremployee_first_namestringemployee_last_namestringemployee_emailstringemployee_departmentstringemployee_rolestringskill_namestringskill_last_assessed_datedatetraining_namestringtraining_completion_datedateinternal_mobility_eligiblebooleanupskilling_recommendedbooleanaudit_datedatecompany_idintegercompany_namestring
1technical4trueCoursera101PriyaSharmapriya.sharma@techpulse.comEngineeringSoftware DeveloperPython Programming2024-04-05Advanced Python Bootcamp2024-04-02truefalse2024-04-101001TechPulse
2soft2falseblank102JonasBergjonas.berg@greenleafsme.comSalesSales ExecutiveNegotiation2023-10-25blankblankfalsetrue2023-11-022001Greenleaf SME
3technical3trueUdemy103YukiNakamurayuki.nakamura@northfusion.comData ScienceData ScientistMachine Learning2024-05-12ML Mastery Series2024-04-30truefalse2024-05-143001NorthFusion
4managerial1falseblank104FatimaAl-Farsifatima.alfarsi@acmeanalytics.comSupportCustomer Support RepConflict Resolution2023-11-15blankblankfalsetrue2023-12-014001Acme Analytics
5managerial3trueLinkedIn Learning105AvaKingava.king@techpulse.comHuman ResourcesHR ManagerEmployee Engagement2024-02-15Modern HR Practices2024-02-14truefalse2024-02-201001TechPulse
6managerial2falseblank106CarlosOrtizc.ortiz@greenleafsme.comOperationsOperations AssistantProcess Optimization2024-03-09blankblankfalsetrue2024-03-182001Greenleaf SME
7soft3trueAmazon Training107HelenNguyenhelen.nguyen@northfusion.comCustomer SuccessCustomer Success ManagerCustomer Retention2024-06-01Customer Success Strategies2024-05-25truefalse2024-06-033001NorthFusion
8soft1falseblank108MaxRichtermax.richter@acmeanalytics.comMarketingMarketing AnalystCreative Campaigning2024-01-19blankblankfalsetrue2024-01-214001Acme Analytics

What the 200 rows show

from the 200-row sample

Soft (skill category) stands out: mean skill_proficiency_level is 1.6, against 3.0 for the rest.

  • 66%training_completed = true
  • 3median skill_proficiency_level
  • 4company names
  • 14employee departments
Mean skill_proficiency_level by skill_category200 rows
0243.0technical119 rows1.6soft35 rows3.0manageri…36 rows2.4other10 rows
skill_proficiency_level200 rows, in bands of 0.5
04590190550844212.54skill_proficiency_level →

Median 3, from 1 to 4.

training_provider131 rows with a value · 69 left blank
  1. Coursera35
  2. Udemy31
  3. LinkedIn Learning21
  4. Pluralsight9
  5. Amazon4
  6. Microsoft4
  7. Amazon Training3
  8. AWS3
  9. CompTIA2
  10. Product School2
20 columns by typefrom the column list below
  • string 10
  • integer 4
  • date 3
  • boolean 3

Columns

20 columns in four groups
blueprint · 20 columns
columntypedescriptionexample
Text 10 columns
employee_first_namestringEmployee's first namePriya
employee_last_namestringEmployee's last nameSharma
employee_emailstringEmployee's email addressava.king@techpulse.com
employee_departmentstringDepartment where the employee worksEngineering
employee_rolestringEmployee's current job title or roleSoftware Developer
skill_namestringName of the skill being auditedPython Programming
skill_categorystringCategory of the skill (e.g., technical, soft, managerial)technical · soft · managerial · othertechnical
training_namestringName of the training program completed (if any)optionalAdvanced Python Bootcamp
training_providerstringOrganization or individual providing the trainingoptionalCoursera
company_namestringName of the SME company4 namesTechPulse
Numbers 4 columns
record_idintegerUnique identifier for each skill audit recordunique · 1 or more1
employee_idintegerUnique identifier for the employee1 or more101
skill_proficiency_levelintegerEmployee's proficiency in the skill (1=Beginner, 2=Intermediate, 3=Advanced, 4=Expert)1 to 44
company_idintegerUnique identifier for the SME company1 or more1001
Dates and times 3 columns
skill_last_assessed_datedateDate when the skill was last assessed2024-04-05
training_completion_datedateDate when the training was completedoptional2024-04-02
audit_datedateDate when the skill audit record was created2024-04-10
True or false 3 columns
training_completedbooleanIndicates if related training has been completedtrue
internal_mobility_eligiblebooleanIndicates if the employee is eligible for internal mobility based on skills and trainingtrue
upskilling_recommendedbooleanIndicates if further upskilling is recommended for this skillfalse

Use it for

  • training compl…66%131 of 200 rowsmean skill proficienc…3.0tech…1.6soft3.0mana…2.4other

    A human resources dashboard

    The training_completed rate, skill_proficiency_level by skill_category and a breakdown of training_provider. Excel, Power BI or Tableau.

  • Why do the 35 soft rows have a mean skill_proficiency_level of 1.6?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable rows with employee_id, employee_first_name and employee_last_name to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 20 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows20 columns
Yours1,000 rows20 columns

blueprint · sme-employee-skill-audit-records

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 20 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Employee ID required
  • Skill rating included
  • Training completion date tracked
  • Flag outdated skill profiles
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
sme-employee-skill-audit-records

More in Human Resources

Browse all
Also in Human ResourcesEmployee Leave Balance LedgerEmployee Training Participation DatasetEmployee Attrition Prediction DatasetAll 1,958 datasets

What should your data show?

Preview 20 rows free
No signup. No card.