# 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`) |
| --- | --- | --- | --- | --- | --- | --- |
|   |   |   |   |   |   |   |