window-function-generator
Window Function Generator - Auto-activating skill for Data Analytics.Triggers on: window function generator, window function generatorPart of the Data Analytics skill category.
When & Why to Use This Skill
The Window Function Generator is a specialized Claude skill designed to automate the creation of complex SQL window functions for data analytics. It simplifies the process of writing advanced analytical queries by providing production-ready code, ensuring best practices in SQL syntax, and validating outputs for tasks like running totals, moving averages, and ranking.
Use Cases
- 1. Advanced Financial Reporting: Generate SQL queries for calculating running totals, cumulative sums, and year-to-date (YTD) metrics to track financial performance over time.
- 2. User Behavior Analytics: Implement ranking functions such as RANK(), DENSE_RANK(), and ROW_NUMBER() to identify top-performing users or products within specific categories.
- 3. Time-Series Data Analysis: Utilize LEAD() and LAG() functions to compare current data points with previous or subsequent records for period-over-period growth analysis.
- 4. Statistical Data Partitioning: Create complex partitions and frames (ROWS BETWEEN) to calculate moving averages and rolling windows for trend smoothing in large datasets.
| name | window-function-generator |
|---|---|
| description | | |
| Triggers on | window function generator, window function generator |
| allowed-tools | Read, Write, Edit, Bash, Grep |
| version | 1.0.0 |
| license | MIT |
| author | Jeremy Longshore <jeremy@intentsolutions.io> |
Window Function Generator
Purpose
This skill provides automated assistance for window function generator tasks within the Data Analytics domain.
When to Use
This skill activates automatically when you:
- Mention "window function generator" in your request
- Ask about window function generator patterns or best practices
- Need help with data analytics skills covering sql queries, data visualization, statistical analysis, and business intelligence.
Capabilities
- Provides step-by-step guidance for window function generator
- Follows industry best practices and patterns
- Generates production-ready code and configurations
- Validates outputs against common standards
Example Triggers
- "Help me with window function generator"
- "Set up window function generator"
- "How do I implement window function generator?"
Related Skills
Part of the Data Analytics skill category. Tags: sql, analytics, visualization, statistics, bi