Skip to content

yeaight7/agent-powerups / plugins/data-engineering/skills/metric-impact-analyzer

metric-impact-analyzer

Verified

Use when a change may affect metrics, semantic models, dashboards, reporting, or stakeholder-facing KPIs and you need to know whether business meaning or downstream BI assets change.

Metric Impact Analyzer

Use this skill when a change may affect metrics, semantic models, dashboards, reporting, or stakeholder-facing KPIs.

Goals

  • Detect whether a technical change also changes business meaning.
  • Identify likely downstream breakage in BI tooling and dashboards.
  • Separate harmless refactors from definition-level changes.

What to Inspect

  • Metric definitions and calculation logic.
  • Semantic model changes (dimensions, measures, relationships).
  • Renamed or removed fields referenced by saved queries or dashboards.
  • Changed filters, time windows, or default values.
  • Changed joins, granularity, or fanout.
  • Contract-breaking field type changes (e.g., INT → FLOAT, nullable → NOT NULL).

Change Classification

Change typeRisk levelAction required
Column rename with alias preservedLowValidate alias propagation
Description or label changeLowConfirm no tooling parses descriptions
New optional field addedLowNo action unless it changes defaults
Filter condition tightenedMediumValidate that the new filter matches intent
Metric formula changedHighStakeholder review required
Grain changed (e.g., day → week)HighAll downstream rollups must be revalidated
Dimension removedBreakingCannot ship without migration plan
Join path changedBreakingAll dependent metrics may be affected

Analysis Steps

  1. Summarize what changed technically (field names, types, logic, joins).
  2. Classify each change using the table above.
  3. Infer what may have changed semantically — ask: "will this metric return a different number for the same time period?"
  4. Identify who or what downstream may break: dashboards, saved queries, alerts, exports, downstream dbt models, BI tool semantic layers.
  5. Flag whether stakeholder sign-off is required before the change is promoted.

Output Format

  1. Technical change summary — what exactly changed, at the field/model level.
  2. Business meaning impact — does this change what the number means to a business user?
  3. Likely reporting or dashboard breakage — specific assets at risk.
  4. Required validation — what must be confirmed before shipping.
  5. Stakeholder confirmation needed? yes / no / depends — with reason.

Validation / Done Criteria

  • Technical change summary covers all modified fields, models, and logic.
  • Every change is classified by risk level using the table above.
  • Downstream breakage is identified or explicitly noted as "unknown — downstream consumers not traced."
  • Stakeholder confirmation requirement is stated as yes / no / depends, with a reason.

Rules

  • Be explicit about uncertainty when you cannot trace all downstream consumers.
  • Use plain business language in the final summary — avoid dbt/SQL jargon in the stakeholder section.
  • Do not edit code or models unless explicitly asked.
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 198kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall