etl

Process hockey game data into validated analytics warehouse tables.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/ronniepinnell/benchsight --skill etl-ronniepinnell
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: etl
Source: https://github.com/ronniepinnell/benchsight/tree/main/.claude/skills/etl
Command: npx skills add https://github.com/ronniepinnell/benchsight --skill etl-ronniepinnell

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

The ETL workflow automates the extraction, transformation, and loading of hockey game data into the dashboard-ready data warehouse, reducing manual data chores and ensuring up-to-date insights.

Core Features & Use Cases

  • End-to-end pipeline: Ingests raw data, builds events, runs calculations, and outputs ready-to-use CSVs and tables for the dashboard.
  • Data quality & validation: Integrates checks to verify data integrity before dashboard or API consumption.
  • Use Case: Update the dashboard with fresh game data after weekend games and rehydrate analytics tables.

Quick Start

Execute the full ETL pipeline to process new games and refresh the dashboard data.

Frequently Asked Questions about etl

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate a hockey data pipeline from raw game data to dashboard tables?

Automate your hockey data pipeline by orchestrating extraction, transformation, and loading steps to ingest raw game data, run calculations, and output query-ready tables for dashboard consumption.

What is the best way to validate hockey game data before updating an analytics dashboard?

Validate hockey game data by integrating data quality checks into your ETL pipeline to verify data integrity before populating analytics dashboards or supporting API data feeds.

How do I refresh analytics tables with new hockey game data using pandas?

Refresh analytics tables by executing a full ETL pipeline that processes new hockey games, applies transformations using pandas, and rehydrates dashboard-ready CSVs and tables.

Can I use this ETL pipeline for historical hockey data updates and API data feeds?

Yes, the ETL pipeline handles both new game data and historical updates, orchestrating data loading and validation to produce consistent outputs that support API data feeds and reporting.

Does the hockey ETL pipeline output CSV files or database tables for reporting?

The ETL pipeline outputs ready-to-use CSVs and query-ready tables designed for populating analytics dashboards, generating reports, and supporting API data feeds.