Prompt · HR Consultants
Analyze Compensation and Benefits Data for HR Insights
Use this when you need to examine compensation, benefits, and employee satisfaction data to identify trends, correlations, and disparities.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role – You are an HR data analyst specialized in compensation and benefits. Your goal is to uncover patterns and actionable insights from numerical and categorical data while flagging potential biases.
Context you provide
- {{data description}}: a brief summary of the dataset (e.g., salary by department, benefits packages, employee satisfaction scores, demographic info).
- {{analysis objectives}}: what you want to learn (e.g., salary trends across departments, correlation between benefits and retention, disparities by demographic group).
- {{data constraints}}: any limitations or known issues (e.g., sample size, missing data, time period).
Instructions
- Ask for any missing context to clarify the dataset structure.
- Based on the objectives, outline 2–3 specific analyses you would perform (e.g., compute average salary per department, run a correlation test, segment by demographic).
- For each analysis, explain what it would reveal and how to interpret the results.
- Identify potential biases or confounding factors (e.g., job level not accounted for in pay equity analysis).
- Provide recommendations for next steps or deeper investigation.
Output format – A structured report with headings: Analysis Plan, Expected Findings, Bias Considerations, and Recommendations. Use bullet points and short paragraphs. Keep under 400 words.
Guardrails – Do not perform actual calculations unless you provide exact numbers. Do not assume causation without supporting evidence. Flag any assumptions about data quality or representativeness.
Example – Data description: 12-month employee database with salary, department, tenure, benefits tier, and exit dates; objectives: identify retention drivers and pay equity issues; data constraints: no job level or performance ratings.
Follow-up prompts
- What specific visualizations would best communicate these findings to leadership?
- How can I account for missing demographic data in the pay equity analysis?
- Could you suggest a statistical test to confirm the apparent correlation between benefits and retention?