Pivot Table Creator - Auto-activating skill for Data Analytics. Triggers on: pivot table creator, pivot table creator Part of the Data Analytics skill category.
34
Quality
3%
Does it follow best practices?
Impact
86%
1.02xAverage score across 3 eval scenarios
Passed
No known issues
Optimize this skill with Tessl
npx tessl skill review --optimize ./planned-skills/generated/12-data-analytics/pivot-table-creator/SKILL.mdSQL pivot table for sales reporting
Production-ready SQL
100%
100%
Pivot structure present
100%
100%
Aggregation function used
100%
100%
Column aliases defined
100%
100%
Step-by-step explanation
100%
100%
Best practices: NULL handling
100%
80%
Validation step included
100%
100%
Schema or table definitions
100%
100%
Output file produced
100%
100%
Business context addressed
100%
80%
Without context: $0.2458 · 1m 3s · 14 turns · 17 in / 3,451 out tokens
With context: $0.3733 · 1m 20s · 23 turns · 22 in / 4,405 out tokens
Python pandas pivot table with statistical analysis and visualization
Uses pandas pivot_table
100%
100%
Statistical aggregation
100%
100%
Visualization produced
100%
100%
Step-by-step workflow
90%
80%
Production-ready code
100%
100%
Margins or subtotals
0%
50%
Output CSV saved
100%
100%
Validation check
0%
0%
Multiple metrics
100%
100%
Readable column labels
90%
70%
Without context: $0.5053 · 2m 5s · 30 turns · 29 in / 7,042 out tokens
With context: $0.4720 · 1m 51s · 26 turns · 364 in / 5,927 out tokens
Business intelligence data transformation and validation
Pivot transformation present
60%
100%
Production-ready script
100%
100%
Validation against source
0%
0%
BI-ready output format
100%
100%
Multiple aggregation metrics
100%
100%
Step-by-step comments
62%
100%
Handles missing data
30%
50%
Column naming conventions
100%
100%
Best practices: no hardcoded magic values
83%
100%
Summary documentation
100%
100%
Without context: $0.4121 · 1m 43s · 23 turns · 24 in / 5,771 out tokens
With context: $0.6752 · 2m 31s · 37 turns · 36 in / 8,561 out tokens
0c08951
Table of Contents
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.