Kpi definition standard

Skill nicholashidalgo/claude-skillforge/data-engineering/kpi-definition-standard

Install

npx -y skills add nicholashidalgo/claude-skillforge --skill kpi-definition-standard

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

1 stars1 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

Define KPIs with formula, grain, source, exclusions, ownership, cadence, caveats, and business interpretation notes.

SKILL.md

1.6 KB, as published. Nobody here has run it

Runtime Configuration

version: "1.0.0"
gotcha_pack: "sql-data-gotcha-pack"
gotcha_pack_version: "1.0.0"
gotcha_enforcement: "block_on_high"

Purpose

Create formal KPI definitions that are usable across reporting and governance.

Required fields

KPI name
business purpose
formula
grain
source system or source table
inclusions and exclusions
owner
refresh cadence
caveats
interpretation notes

Rules

Distinguish business definition from technical implementation.
Document edge cases.
State where competing definitions may exist.

Output format

Return a clean data-dictionary-style KPI entry.

Gotcha Enforcement

A KPI definition that violates any HIGH rule below is incomplete. Do not return a definition until all HIGH rules pass. Flag MEDIUM violations in the Governance risks section.

ID	Sev	Check
G003	HIGH	Formula must specify NULL treatment explicitly
G006	HIGH	Calculation grain and reporting grain must be separately stated
G008	HIGH	Inclusions AND exclusions must both be populated; no exclusions = incomplete
G013	LOW	If the KPI is used in a ranked output, tie-break behavior must be documented