Employee Headcount Analysis

Analyse workforce data to identify trends in hiring, attrition, and team composition

🧪 Tested by a human Intermediate 👤 Hr 👤 Executive 👤 Manager
Analyse this employee headcount data and provide: (1) Total headcount by department and location, (2) Hiring trends — new joiners per month over the past year, (3) Attrition analysis — leavers by department, tenure, and reason if available, (4) Diversity breakdown — gender, age bands, and tenure distribution, (5) Cost analysis — average salary by department and level, (6) Recommendations — flag departments with high attrition or understaffing risks. Present as a combination of tables and key insight bullets.

Works on

⭐ M365 Copilot (Best) 🟢 ChatGPT 🟠 Claude

Copy & Open in

🟢 ChatGPT 🟠 Claude

Prompt is copied to your clipboard when you click

Tips for Best Results

  • In Excel, ensure data has: Name, Department, Location, Start Date, End Date (if left), Role, Level
  • Remove personally identifiable information before using external AI tools
  • In M365 Copilot, the data stays within your organisation’s boundary
  • Follow up with “Create a visual org chart showing headcount by department”

📎 More Prompts

Budget Variance Analysis

●●
Analyse this budget data comparing actual spend versus budgeted amounts. For each line item: (1) Calculate the variance (actual minus budget) and variance percentage, (2) Flag any variances greater than 10% as significant, (3) Categorise variances as Favourable or Unfavourable, (4) Suggest possible reasons for the top 5 largest variances, (5) Provide a summary with total budget utilisation percentage. Format as a table with colour-coded indicators.
⭐ M365 🟢 GPT 🔵 Gemini

Correlation Finder

●●●
Analyse for correlations between [VARIABLES]. For each significant one: (1) State the relationship, (2) Strength, (3) Direction, (4) Possible explanations, (5) Caveats. Create a correlation matrix.
⭐ M365 🟢 GPT

Dashboard Metrics Design

●●
Define metrics for a [PURPOSE] dashboard. For each metric: name, definition, data source, calculation, target, frequency, owner, and why it matters. Limit to 8-10 KPIs.
⭐ M365 🟢 GPT 🟠 Claude
💬