People Analytics Reporter
Generate headcount, attrition, diversity, and organizational health reports
Your CHRO asks for attrition data by department and you spend two hours pulling it from three different systems. Headcount reports, diversity metrics, and retention trends all live in separate spreadsheets that someone manually updates quarterly — if they remember.
Who it's for: people analytics teams building recurring HR dashboards, HR business partners reporting workforce metrics to leadership, talent acquisition leads tracking hiring funnel health, diversity and inclusion officers measuring representation metrics, CHROs preparing board-level people reports
Example
"Generate our quarterly people analytics report" → Comprehensive report with headcount by department, attrition rates with trending, diversity breakdown across levels, hiring funnel metrics, time-to-fill analysis, and flight risk indicators with recommended actions
New here? 3-minute setup guide → | Already set up? Copy the template below.
# People Analytics Reporter
Generate people analytics reports from your HR data. Analyze workforce data to surface trends, risks, and opportunities.
## Report Types
**Headcount**: Current org snapshot — by team, location, level, tenure
**Attrition**: Turnover analysis — voluntary/involuntary, by team, trends
**Diversity**: Representation metrics — by level, team, pipeline
**Org Health**: Span of control, management layers, team sizes, flight risk
## Key Metrics
### Retention
- Overall attrition rate (voluntary + involuntary)
- Regrettable attrition rate
- Average tenure
- Flight risk indicators
### Diversity
- Representation by level, team, and function
- Pipeline diversity (hiring funnel by demographic)
- Promotion rates by group
- Pay equity analysis
### Engagement
- Survey scores and trends
- eNPS (Employee Net Promoter Score)
- Participation rates
- Open-ended feedback themes
### Productivity
- Revenue per employee
- Span of control efficiency
- Time to productivity for new hires
## Approach
1. Understand what question they're trying to answer
2. Identify the right data (upload, paste, or pull from HRIS)
3. Analyze with appropriate statistical methods
4. Present findings with context and caveats
5. Recommend specific actions based on data
## What You Can Provide
Upload a CSV or describe your data. Helpful fields:
- Employee name/ID, department, team
- Title, level, location
- Start date, end date (if applicable)
- Manager, compensation (if relevant)
- Demographics (for diversity reports, if available)
## Output Format
```markdown
## People Report: [Type] — [Date]
### Executive Summary
[2-3 key takeaways]
### Key Metrics
| Metric | Value | Trend |
|--------|-------|-------|
| [Metric] | [Value] | [up/down/flat] |
### Detailed Analysis
[Charts, tables, and narrative for the specific report type]
### Recommendations
- [Data-driven recommendation]
- [Action item]
### Methodology
[How the numbers were calculated, any caveats]
```
## If Connectors Available
If **HRIS** is connected:
- Pull live employee data — headcount, tenure, department, level
- Generate reports without needing a CSV upload
If **chat** is connected:
- Offer to share the report summary in a relevant channel
What This Does
This playbook turns Claude into a people analytics assistant that generates workforce reports from your HR data. It produces headcount snapshots, attrition analyses, diversity metrics, and organizational health assessments -- complete with executive summaries, key metrics tables, detailed analysis, and data-driven recommendations.
Quick Start
Step 1: Download the Template
Click Download above to get the CLAUDE.md file.
Step 2: Set Up Your Project
Create a project folder and place the template inside:
mkdir -p ~/Documents/PeopleAnalytics
mv ~/Downloads/people-analytics-reporter.md ~/Documents/PeopleAnalytics/CLAUDE.md
Step 3: Start Working
cd ~/Documents/PeopleAnalytics
claude
Say: "Generate a headcount report by department"
Report Types
- Headcount -- Current org snapshot by team, location, level, and tenure
- Attrition -- Voluntary/involuntary turnover analysis by team with trends
- Diversity -- Representation metrics by level, team, and pipeline
- Org Health -- Span of control, management layers, team sizes, and flight risk
Key Metrics Covered
| Category | Metrics |
|---|---|
| Retention | Overall attrition rate, regrettable attrition, average tenure, flight risk |
| Diversity | Representation by level/team, pipeline diversity, promotion rates, pay equity |
| Engagement | Survey scores, eNPS, participation rates, feedback themes |
| Productivity | Revenue per employee, span of control efficiency, time to productivity |
What to Provide
Upload a CSV or paste your data. Helpful fields include:
- Employee name/ID, department, team
- Title, level, location
- Start date, end date (if applicable)
- Manager, compensation (if relevant)
- Demographics (for diversity reports, if available)
Example Prompts
"Generate a headcount report by department"
"Analyze voluntary attrition trends over the past 12 months"
"Show me diversity representation by level across engineering"
"What's our regrettable attrition rate by team?"
"Assess org health — span of control, management layers, and flight risks"
"Compare attrition rates Q1 vs Q2 by department"