Employee Performance Review Ratings

This dataset provides detailed, standardized employee performance review records, including department, job level, review periods, reviewer information, and multiple scoring dimensions. It enables organizations to analyze workforce performance, identify development needs, and support data-driven promotion and talent management decisions across departments and job levels.

  • opened 13 times
  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Analyzing workforce performance trends by department and job level

Sample rows

preview · 8 of 110 rows · all 17 columns
review_idstringoverall_scorefloatpromotion_recommendedbooleandepartmentstringemployee_idstringemployee_namestringjob_levelintegerreview_period_startdatereview_period_enddatereview_datedatereviewer_idstringreviewer_namestringcompetency_scorefloatgoals_achieved_scorefloatleadership_scorefloatdevelopment_needsstringreview_commentsstring
R000014.2trueEngineeringE1010Carlos Mendoza32022-01-012022-12-312023-01-10M101Julia Müller44.34.1Expand technical mentoring of juniors.Carlos demonstrated strong initiative, leading project teams and exceeding expectations for his role.
R000022.9falseMarketingE1011Amina El-Sayed22022-04-012022-10-012022-10-10M301David Song2.83.1blankWork on campaign analytics and reporting accuracy.Amina meets expectations but should focus on improving marketing analytics and data accuracy.
R000032.1falseITE1012Zhihao Lin12022-06-152022-12-152022-12-20M501Elena Petrova2.32blankImprove troubleshooting and documentation skills.Zhihao needs to focus on documentation accuracy and respond more quickly to support tickets.
R000044.6trueFinanceE1013Léa Dubois42022-01-012022-12-312023-01-08M401Marek Nowak4.74.54.8blankLéa consistently delivers financial analysis with high accuracy and has mentored her team effectively.
R000053.3falseSupportE1014Samuel Johnson22022-03-012022-09-012022-09-05M801Fatima Benali3.23.5blankIncrease first-call resolution rate.Samuel is reliable but can further improve efficiency in customer interactions.
R000064trueProductE1015Giulia Romano32022-02-012022-08-012022-08-11M601Sven Eriksson4.23.94Continue cross-team communication training.Giulia shows strong leadership and has successfully led her product team through major releases.
R000072.5falseHuman ResourcesE1016Marina Oliveira12022-05-012022-11-012022-11-10M701Nina Yamada2.72.6blankNeeds to improve onboarding process familiarity.Marina is dedicated but requires more exposure to HRIS and onboarding workflows.
R000083falseEngineeringE1017Omar Al-Farsi22022-07-012023-01-012023-01-11M101Julia Müller3.12.8blankEnhance code review participation.Omar is progressing steadily; more involvement in code reviews is encouraged.

What the 110 rows show

from the 110-row sample
  • 26%promotion_recommended = true
  • 3.5median overall_score
  • 3median job_level
  • 3.7median competency_score
  • 3.6median goals_achieved_score
  • 4.3median leadership_score
overall_score110 rows, in bands of 0.5
0153043111320162221135overall_score →

Median 3.5, from 1.0 to 5.0.

department110 rows · 9 values
  1. Engineering21
  2. Sales13
  3. Finance12
  4. Support12
  5. Product12
  6. Marketing11
  7. IT11
  8. Legal11
  9. Human Resources7
17 columns by typefrom the column list below
  • string 8
  • integer 1
  • float 4
  • date 3
  • boolean 1

Columns

17 columns in four groups
blueprint · 17 columns
columntypedescriptionexample
Text 8 columns
review_idstringUnique identifier for each performance review recorduniqueR00001
employee_idstringUnique identifier for the employee being reviewedE1010
employee_namestringFull name of the employee being reviewedCarlos Mendoza
departmentstringDepartment to which the employee belongs9 departmentsEngineering
reviewer_idstringUnique identifier for the reviewer (e.g., manager or supervisor)M101
reviewer_namestringFull name of the reviewerJulia Müller
development_needsstringSummary of areas where the employee needs development or improvementoptionalExpand technical mentorin…
review_commentsstringAdditional comments or qualitative feedback from the revieweroptionalCarlos demonstrated stron…
Numbers 5 columns
job_levelintegerJob level or grade of the employee (e.g., 1 for entry, 5 for senior/executive)1 or more3
overall_scorefloatStandardized overall performance score assigned to the employee (e.g., 0.0 to 5.0)0 to 54.2
competency_scorefloatScore reflecting the employee's competency in their role (e.g., 0.0 to 5.0)0 to 5 · optional4
goals_achieved_scorefloatScore reflecting achievement of set goals during the review period (e.g., 0.0 to 5.0)0 to 5 · optional4.3
leadership_scorefloatScore reflecting leadership or initiative shown (e.g., 0.0 to 5.0; may be null for non-leadership roles)0 to 5 · optional4.1
Dates and times 3 columns
review_period_startdateStart date of the performance review period2022-01-01
review_period_enddateEnd date of the performance review period2022-12-31
review_datedateDate when the performance review was conducted2023-01-10
True or false 1 column
promotion_recommendedbooleanIndicates if the employee is recommended for promotion based on the reviewoptionaltrue

15 SQL practice questions for the Employee Performance Review Ratings

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · WHERE · ORDER BY

    Top-rated reviews

    Return review_id, employee_name, department and overall_score for all reviews with an overall_score of at least 4.5. Order the results by overall_score descending, then by review_id ascending.

    Tables: employee_performance_review_ratings · your result: 4 columns, 21 rows
  2. 02BeginnerFreeDISTINCT · ORDER BY

    Distinct departments

    Return a single column named department that lists each distinct department once, sorted alphabetically.

    Tables: employee_performance_review_ratings · your result: 1 columns, 9 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Reviews per department

    Return department and review_count (the number of reviews) for each department. Order by review_count descending, then by department ascending.

    Tables: employee_performance_review_ratings · your result: 2 columns, 9 rows
  1. 04Average score by job levelBeginner
  2. 05Promotions recommended by departmentPower BI
  3. 06Departments with high averageIntermediate
  4. 07Performance bucketsIntermediate
  5. 08Departments above company averageIntermediate
  6. 09Reviews by monthIntermediate
  7. 10Average leadership score by departmentPower BI
  8. 11Rank employees within departmentAdvanced
  9. 12Score change between reviewsAdvanced
  10. 13Running count of reviewsAdvanced
  11. 14Department share of promotionsAdvanced
  12. 15Score anomalies versus departmentPower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

Use it for

  • promotion reco…26%29 of 110 rows

    A human resources dashboard

    The promotion_recommended rate, overall_score and a breakdown of department. Excel, Power BI or Tableau.

  • Why do 29 of 110 rows have promotion_recommended = true?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 110 rows.

  • A software demo

    Believable reviews with employee_id, employee_name and department to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 17 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 dataset110 rows17 columns
Yours1,000 rows17 columns

blueprint · employee-performance-review-ratings

Behind this dataset

Same schema. As many rows as you need.

These 110 rows came out of a blueprint — 17 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
  • Score employees on multiple competencies
  • Associate each review with reviewer and reviewee
  • Include review period start and end dates
  • Highlight employees with consistent top/bottom scores
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
employee-performance-review-ratings

What should your data show?

Preview 20 rows free
No signup. No card.