Skip to content

yonglun/dama-skill / skills/delivering-data-warehousing-and-bi

delivering-data-warehousing-and-bi

Verified

Use when delivering an analytical data warehouse, data mart, governed dataset, report, dashboard, scorecard, or self-service BI portfolio; when business measures conflict, historical comparisons require policy, or analytical data and reports need business acceptance, release, service, and adoption controls.

templates/delivery-pack.en.md

View on GitHub
# Data Warehousing and BI Pack

Skill: `delivering-data-warehousing-and-bi`

[Word report](report.en.docx) · [Excel register](register.en.xlsx)

## Record details

| ID | Field | Project value |
| --- | --- | --- |
| `artifact_id` | Artifact ID | |
| `project` | Project | |
| `skill` | Skill | |
| `version` | Version | |
| `date` | Date | |
| `status` | Status | |
| `author` | Author | |
| `owner` | Owner | |
| `approver` | Approver | |
| `purpose` | Purpose | |
| `business_outcome` | Business outcome | |
| `scope` | Scope and exclusions | |
| `source_inputs` | Inputs and sources | |
| `assumptions` | Assumptions and constraints | |
| `decisions` | Decisions | |
| `rationale` | Rationale | |
| `risks` | Risks | |
| `exceptions` | Exceptions | |
| `open_items` | Open items | |
| `due_date` | Due date | |
| `acceptance_criteria` | Acceptance criteria | |
| `evidence_location` | Evidence location | |
| `reviewer_decision` | Reviewer decision | |
| `next_gate` | Next stage gate | |

## Domain analysis and decisions

### Business decisions and use cases (`decisions`)

Derive questions, priorities, and metrics from user decisions.

> Enter project evidence, conclusion, and owner.


### Metric contract (`metric_contract`)

Fix definition, numerator, denominator, grain, time, exclusions, and approval.

> Enter project evidence, conclusion, and owner.


### Source profile and semantic conflicts (`source_profile`)

Profile sources and record conflicting definitions and adjudication.

> Enter project evidence, conclusion, and owner.


### Fact grain and conformed dimensions (`fact_grain`)

Define fact-row meaning, dimension conformance, and master-data dependencies.

> Enter project evidence, conclusion, and owner.


### History and restatement policy (`history`)

Define late-arriving data, historical versions, comparisons, and restatement gates.

> Enter project evidence, conclusion, and owner.


### Load reconciliation and rejects (`loading`)

Compare source and target totals, rejects, duplicates, and latency with repair ownership.

> Enter project evidence, conclusion, and owner.


### Reporting and business acceptance (`business_acceptance`)

Accept with real decision scenarios, permissions, and critical metrics.

> Enter project evidence, conclusion, and owner.


### Release support and adoption (`operations`)

Plan release, rollback, SLA, support, and usage-outcome monitoring.

> Enter project evidence, conclusion, and owner.


## Working registers

### Metric Catalog (`metrics`)

Govern metric definitions, sources, and ownership.

| Metric (`metric`) | Definition (`definition`) | Denominator (`denominator`) | Source (`source`) | Owner (`owner`) | Approver (`approver`) | Version (`version`) |
| --- | --- | --- | --- | --- | --- | --- |
|   |   |   |   |   |   |   |

### Reconciliation UAT (`uat`)

Track reconciliation differences and business acceptance tests.

| Metric (`metric`) | Test (`test`) | Test result (`test_result`) | Impact (`impact`) | Owner (`owner`) | Evidence (`evidence`) | Status (`status`) |
| --- | --- | --- | --- | --- | --- | --- |
|   |   |   |   |   |   |   |
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