window-function-generator

Window Function Generator - Auto-activating skill for Data Analytics. Triggers on: window function generator, window function generator Part of the Data Analytics skill category.

1.00x

Quality

Does it follow best practices?

Impact

97%

1.00x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./planned-skills/generated/12-data-analytics/window-function-generator/SKILL.md

Evaluation results

92%

Sales Performance Dashboard Queries

SQL ranking and running total window functions

Criteria

Without context

With context

Uses ranking function

100%

Uses running total

100%

PARTITION BY present

100%

ORDER BY in window

100%

Production-ready SQL

100%

Step-by-step breakdown

100%

Expected output described

70%

Correct function choice rationale

50%

Analytics context preserved

100%

No deprecated or incorrect syntax

100%

Without context: $0.2359 · 1m 18s · 12 turns · 13 in / 4,653 out tokens

With context: $0.3645 · 1m 25s · 19 turns · 99 in / 5,206 out tokens

100%

Weekly Sales Trend Analysis

Moving average and lag statistical window functions

Criteria

Without context

With context

Moving average function

100%

Correct frame specification

100%

LAG or LEAD usage

100%

ORDER BY in window

100%

Production-ready SQL

100%

Step-by-step explanation

100%

Validation / expected output

100%

Statistical analysis domain

100%

Handles NULL at window boundaries

100%

No incorrect frame defaults

100%

Without context: $0.3027 · 1m 14s · 18 turns · 19 in / 4,515 out tokens

With context: $0.3410 · 1m 14s · 21 turns · 22 in / 5,042 out tokens

100%

Customer Loyalty Tier Classification

BI customer segmentation with percentile window functions

Criteria

Without context

With context

Percentile/segmentation function

100%

Aggregate before windowing

100%

ORDER BY in window

100%

Production-ready SQL

100%

BI context output

100%

Step-by-step guidance

100%

Validation with sample data

100%

Correct NTILE or PERCENT_RANK usage

100%

BI reporting domain

100%

No incorrect window defaults

100%

Without context: $0.2886 · 1m 18s · 15 turns · 16 in / 4,926 out tokens

With context: $0.3658 · 1m 50s · 18 turns · 53 in / 6,149 out tokens

Repository: jeremylongshore/claude-code-plugins-plus-skills
Commit: 0c08951

Evaluated: 18 days ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Sales Performance Dashboard Queries Weekly Sales Trend Analysis Customer Loyalty Tier Classification

Is this your skill?

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.