Data Modeling Delivery Pack
Skill: modeling-data
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 use cases and scope (use_cases)
State the business processes, decisions, and consumers supported by the model.
Enter project evidence, conclusion, and owner.
Model level and approach (model_level)
Choose conceptual, logical, or physical level and the appropriate relational, dimensional, or other pattern.
Enter project evidence, conclusion, and owner.
Requirements and terms (requirements)
List governed definitions, disputed terms, and approval status of business rules.
Enter project evidence, conclusion, and owner.
Grain keys and relationships (grain_keys)
Fix entity or fact grain, keys, cardinality, optionality, and temporal rules.
Enter project evidence, conclusion, and owner.
Model and source traceability (traceability)
Trace conceptual to logical to physical design and source-to-target mappings and deviations.
Enter project evidence, conclusion, and owner.
Review and approval (review)
Record findings and decisions from requirements, design, and physical feasibility reviews.
Enter project evidence, conclusion, and owner.
Version and change control (change_control)
For breaking changes, record impact, migration, compatibility, and rollback.
Enter project evidence, conclusion, and owner.
Quality and acceptance evidence (acceptance_evidence)
Use scenarios, profiling, and reverse comparison with implementation to verify the model.
Enter project evidence, conclusion, and owner.
Working registers
Data Dictionary (dictionary)
Maintain entities, attributes, keys, and precise definitions.
Entity or fact (entity) |
Attribute (attribute) |
Definition (definition) |
Key (key) |
Source (source) |
Owner (owner) |
Version (version) |
|---|---|---|---|---|---|---|
Model Mappings (mappings)
Trace source fields to target fields and transformation rules.
Source field (source_field) |
Target field (target_field) |
Transformation (transformation) |
Rule (rule) |
Owner (owner) |
Test (test) |
Evidence (evidence) |
|---|---|---|---|---|---|---|