Agent skill · data analytics · aradotso
employee-performance-analytics-hr
SQL and Python-based employee performance analytics with KPI aggregation, departmental insights, and HR dashboard generation
Why this skill is useful
Provides specific SQL queries and Python scripts for HR analytics that the AI wouldn't reliably generate on its own.
What it needs
Requires matplotlib, numpy, pandas, seaborn installed locally. About 7k tokens when loaded. Last updated 2026-08-05. 5 stars on the source repository.
What this skill does
Employee Performance Analytics HR Skill Skill by ara.so — Data Skills collection. Overview Employee Performance Analytics is a Python and SQL-based HR analytics tool that transforms employee data into actionable insights. It uses SQLite for KPI aggregation and pandas/matplotlib for visualization, generating departmental performance reports, efficiency metrics, and workload analysis. The project provides an end-to-end analytics pipeline: data loading → SQL feature engineering → Python analysis → visualization exports. Installation Dependencies Project Structure Data Schema The project expects employee data with these columns: Column Type Description -------- ------ ------------- employeeid int Unique identifier name string Employee name department string Department (Engineering, Sales, etc.) role string Job title date date Record date (YYYY-MM-DD) taskscompleted int Daily tasks completed hoursworked float Hours worked rating float Performance rating (1-5) projects int Active projects absences int 1 if absent, 0 otherwise Key Commands 1. Load Data into SQLite Options: --csv: Path to input CSV file --db: Output SQLite database path --table: Table name (default: employees) 2. Run Performance Analysis Options: --db: Path to SQLite database --sql: Path to SQL queries file --outdir: Output directory for CSV reports and charts Core SQL Queries The queries.sql file contains three main analytical views: Department KPIs Employee Summary Daily Productivity Python API Usage Creating Database from CSV Running SQL Queries Generating Visualizations Complete Analysis Pipeline Common Patterns Custom KPI Queries Filtering and Aggregation Adding New Metrics Configuration Custom Chart Styling Database Configuration Troubleshooting Missing Columns Error SQL View Not Found Division by Zero in Efficiency Date Parsing Issues Advanced Use Cases Time Series Analysis Comparative Analysis This skill provides comprehensive guidance for using the Employee Performance Analytics project to build HR …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aradotso/employee-performance-analytics-hr