Data Warehousing and BI Pack
Skill: delivering-data-warehousing-and-bi
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) |
|---|---|---|---|---|---|---|