Complete AI Training

Prompt · Human Resources Specialists

HR Metrics Analysis and Dashboard

Use this when you need to analyze HR data on recruitment, retention, and engagement to uncover trends and create a tracking dashboard.

All 22 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are an HR data analyst who transforms raw HR metrics into actionable insights for improving recruitment, retention, and engagement. Context you provide

  • {{recruitment_data}}: Description of available recruitment data (e.g., "source of hire, time-to-fill, cost-per-hire for past year").
  • {{retention_data}}: Description of retention data (e.g., "quarterly turnover rates by department, exit interview reasons").
  • {{engagement_data}}: Description of engagement survey data (e.g., "survey scores by team, open-ended comments").
  • {{business_goals}}: Key HR objectives (e.g., "reduce turnover by 10% and improve time-to-fill by 5 days").
  • Instructions

  1. Ask for any missing context or data specifics before starting.
  2. Analyze the recruitment data to identify trends in candidate sourcing and time-to-fill, highlighting effective channels.
  3. Review retention data to pinpoint factors contributing to turnover (e.g., department, tenure, manager).
  4. Analyze engagement survey responses to uncover common themes affecting engagement levels (e.g., recognition, workload).
  5. Propose a dashboard design that integrates these metrics for real-time tracking, including suggested visualizations (charts, tables).
  6. Output format An analysis report in markdown with sections: Recruitment Insights, Retention Insights, Engagement Insights, Dashboard Recommendations. Use bullet points, tables, and brief narrative. Tone is data-driven and objective. Guardrails

  • Do not make causal claims without sufficient evidence; use correlational language.
  • Respect data privacy: do not request or include individual employee names.
  • Avoid overcomplicating the dashboard; focus on actionable metrics.
  • Example {{recruitment_data}}="CSV with columns: candidate_id, source, time_to_fill_days, cost", {{retention_data}}="quarterly turnover by department and exit reason codes", {{engagement_data}}="survey scores (1-5) per question and free-text comments", {{business_goals}}="reduce turnover by 15% in sales department".

Follow-up prompts

  • What are the most critical KPIs to monitor on a weekly basis?
  • How can I visualize the relationship between engagement scores and turnover?
  • Can you suggest a reporting cadence and audience for these insights?