Employee Survey Insights

Purpose

Employee Survey Insights turns the supplied records into insight report and theme/action sheet with question scores, anonymized comments, segment comparisons, trends, and proposed actions. It keeps source facts, derived values, recommendations, and limitations separate so each conclusion can be checked.

Scope

Cover question ID, wording, scale direction, ratings, comment ID, theme, sentiment, segment, period, suppression minimum. Preserve source identifiers, dates, units, and wording needed to trace every result.

Excluded for employee feedback reporting and anonymity: changing source records, taking external actions, making a human approval or employment decision, and asserting facts absent from the corpus.

Data basis

• Process documents and tables containing question ID, wording, scale direction, ratings, comment ID, theme, sentiment, segment, period, suppression minimum.
• Company policy, rubric, schema, templates, and reference tables in scope.
• Run input for period, audience, entity, or threshold when it changes this run.

Result

Produce insight report and theme/action sheet with question scores, anonymized comments, segment comparisons, trends, and proposed actions. Each material row and conclusion cites a document, section, page, row, field, or run input.

Quality criteria

• Every question scores, comment themes, and suppression record is included or has an exclusion reason.
• Calculations state fields, units, denominator, and rule.
• Missing, contradictory, stale, and ambiguous values stay labelled rather than guessed.
• Facts, interpretations, and proposed next actions use separate fields.
• Supplied terminology, thresholds, and status values are used consistently.
• The final limitations section states what the corpus could not establish.

Instructions

Apply anonymity suppression before segment analysis. Show denominators, reverse-score only catalogue-marked items, and compare periods only when wording and scales match. Never identify respondents. Preserve original values beside normalized values, cite every material finding, and use “not assessed” when required evidence or a rule is absent. When sources disagree, show both citations and explain the conflict. Keep row-level evidence in the supporting sheet and summarize only supported conclusions in the document.

Adapt before use

• Map the survey question and segment mapping fields and row citation convention.
• Add the governing policy, rubric, schema, or reference tables to the scope.
• Define thresholds, status values, units, and exception severity.