# employee-performance-analytics-hr

This skill turns an employee CSV into department KPIs, per-person efficiency scores and charts. Useful when you need to read a workforce export without building pivot tables by hand.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode · 2100 installs · ★ 5
- Author: reason-machines
- License: LicenseRef-Unknown · policy=link-only · description only; the file stays with the author
- Source: https://github.com/reason-machines/data-skills/tree/HEAD/skills/employee-performance-analytics-hr/SKILL.md
- Updated: 2026-10-09
- HTML: https://affpapa.org/en/nevibecode/skills/employee-performance-analytics-hr

## What it does

The pipeline runs in four steps: load the CSV into SQLite, run SQL queries for the metrics, analyse with Python, export reports and charts. Three views do the work. `department_kpis` gives average rating, task totals and absence rate per department. `employee_summary` aggregates each person's tasks, hours and efficiency. `daily_productivity` tracks tasks, hours and rating by day and department. Output lands in `outputs/` as CSV files plus a `charts/` folder.

Your CSV needs the columns `employee_id`, `name`, `department`, `role`, `date`, `tasks_completed`, `hours_worked`, `rating`, `projects`, `absences`. The loader `src/create_db.py` asserts on the required ones and stops if any is missing, so an export from another system has to be reshaped first. Then `src/analyze_performance.py` takes the database, `src/queries.sql` and an output directory.

Dependencies come from `requirements.txt`: pandas, matplotlib, seaborn, numpy. SQLite is built into Python, so it needs no separate install. Charts are drawn with seaborn — skip it and the SQL metrics still compute, but the visualisations won't render.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill employee-performance-analytics-hr -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/employee-performance-analytics-hr/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/employee-performance-analytics-hr/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill employee-performance-analytics-hr -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/employee-performance-analytics-hr/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill employee-performance-analytics-hr -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/employee-performance-analytics-hr/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install reason-machines/data-skills employee-performance-analytics-hr
```

2. **Manually: put the files in place**
- File: `.github/skills/employee-performance-analytics-hr/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill employee-performance-analytics-hr -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/reason-machines/data-skills --path skills/employee-performance-analytics-hr
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/employee-performance-analytics-hr/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill employee-performance-analytics-hr -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/reason-machines/data-skills/tree/HEAD/skills/employee-performance-analytics-hr/SKILL.md

## When to use it
- compute average rating and task totals per department
- spot high-efficiency employees with few absences
- track daily productivity by department
- export CSV reports and charts from one command
- validate the input CSV schema before loading

## Example prompts
- load employees.csv into SQLite and compute department KPIs
- plot average rating by department from hr.db
- build the employee efficiency summary and save it to outputs

## Similar
- [analytics-data-analysis](https://affpapa.org/en/nevibecode/skills/analytics-data-analysis.md) — skill · 1100 installs
- [lean-analytics](https://affpapa.org/en/nevibecode/skills/lean-analytics.md) — skill · 3100 installs
- [business-analytics-reporter](https://affpapa.org/en/nevibecode/skills/business-analytics-reporter.md) — skill · 2200 installs
- [seaborn](https://affpapa.org/en/nevibecode/skills/k-dense-ai-seaborn.md) — skill · 2100 installs
- [data-analysis-jupyter](https://affpapa.org/en/nevibecode/skills/data-analysis-jupyter.md) — skill · 1500 installs
- [Data Visualization](https://affpapa.org/en/nevibecode/skills/aj-geddes-data-visualization.md) — skill · 568 installs

From the same set: [reason-machines/data-skills](https://affpapa.org/en/nevibecode/by/reason-machines/data-skills.md) — 22 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md