SQL Bi Reporting

Use when writing T-SQL for business intelligence, analytics, or reporting. Includes building summary reports with GROUPING SETS, ROLLUP, and CUBE, writing time-series queries with date bucketing, creating pivot/unpivot transformations, generating tally/numbers tables for gap-filling, building running totals and moving averages with window functions, writing year-over-year comparisons, designing materialized views for dashboards, or producing CSV/JSON exports from SQL Server.

damusix Updated 61 repo stars

File contents

damusix/skills commit 6a5fcfe090

Frequently asked questions

npx get-skill add damusix/sql-bi-reporting