yonglun/dama-skill / skills/delivering-data-warehousing-and-bi
delivering-data-warehousing-and-bi
VerifiedUse 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.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 4.0 KB |
| agents/openai.yaml | config | 305 B |
| references/playbook.md | markdown | 13.9 KB |
| templates/delivery-pack.en.md | markdown | 3.1 KB |
| templates/delivery-pack.zh.md | markdown | 2.8 KB |
| templates/register.en.xlsx | binary | 8.6 KB |
| templates/register.zh.xlsx | binary | 9.0 KB |
| templates/report.en.docx | binary | 37.5 KB |
| templates/report.zh.docx | binary | 38.0 KB |
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`) |
| --- | --- | --- | --- | --- | --- | --- |
| | | | | | | |
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 198k | Updated | Claude CodeCodex | Verified | Install |
| 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: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| 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: 194k | Updated | Claude CodeCodex | Verified | Install |