Skilirium

All stages of Data modeller

Stage 7

Derive data quality rules

Derives data quality rules from the data rules and the physical model

34 knobits (8 knowledge, 26 skills) · Produces: data quality rule · Builds on: Design the physical data model, Document data rules as SBVR fact types and rule statements

Knobit map

Each mark is one knobit. Knobits higher up build on the ones below them; select one to open it.

K-312 Recognises a rule assigned to a missing data quality check312K-313 Recognises a declared constraint the target platform does not enforce313K-703 Recognises a constraint deferred without a check703K-704 Recognises a derived or copied column without a check704K-705 Recognises history kept without its constraints checked705K-314 Recognises a data-update rule with no enforcing or detecting mechanism314K-707 Recognises a check with no rule behind it707K-708 Recognises a check outliving its rule708K-709 Recognises a check unable to fail709K-710 Recognises a check on the wrong object710K-711 Recognises a check weaker than its rule711K-712 Recognises a check stronger than its rule712K-713 Recognises a check measuring the wrong population713K-714 Recognises nulls left to chance in a check predicate714K-715 Recognises a past event judged against present data715K-716 Recognises a set rule written as a row rule716K-717 Recognises a check expression unable to run717K-718 Recognises a misfiled data quality dimension718K-719 Recognises duplicate checks for one rule719K-720 Recognises a threshold at odds with its rule720K-721 Recognises disagreeing severity, threshold and failure action721K-722 Recognises a rejection destroying more than it protects722K-723 Recognises a check failure with no capable owner723K-724 Recognises a check scheduled at the wrong moment724K-725 Recognises an aggregate hiding a total failure725K-726 Recognises an empty population reported as a pass726K-751 Explains data quality dimensions751K-752 Explains traceability from data rule to check752K-753 Explains the population, measure and threshold of a check753K-754 Explains row-level and set-level checks754K-755 Explains severity, threshold and failure action755K-756 Explains scheduling checks against loads and use756K-757 Explains segmented data quality reporting757K-758 Explains ownership of data quality failures758
  • Circle: skill
  • Square: knowledge

Knobits of this stage

KnobitType
K-312Recognises a rule assigned to a missing data quality checkSkill
K-313Recognises a declared constraint the target platform does not enforceSkill
K-703Recognises a constraint deferred without a checkSkill
K-704Recognises a derived or copied column without a checkSkill
K-705Recognises history kept without its constraints checkedSkill
K-314Recognises a data-update rule with no enforcing or detecting mechanismSkill
K-707Recognises a check with no rule behind itSkill
K-708Recognises a check outliving its ruleSkill
K-709Recognises a check unable to failSkill
K-710Recognises a check on the wrong objectSkill
K-711Recognises a check weaker than its ruleSkill
K-712Recognises a check stronger than its ruleSkill
K-713Recognises a check measuring the wrong populationSkill
K-714Recognises nulls left to chance in a check predicateSkill
K-715Recognises a past event judged against present dataSkill
K-716Recognises a set rule written as a row ruleSkill
K-717Recognises a check expression unable to runSkill
K-718Recognises a misfiled data quality dimensionSkill
K-719Recognises duplicate checks for one ruleSkill
K-720Recognises a threshold at odds with its ruleSkill
K-721Recognises disagreeing severity, threshold and failure actionSkill
K-722Recognises a rejection destroying more than it protectsSkill
K-723Recognises a check failure with no capable ownerSkill
K-724Recognises a check scheduled at the wrong momentSkill
K-725Recognises an aggregate hiding a total failureSkill
K-726Recognises an empty population reported as a passSkill
K-751Explains data quality dimensionsKnowledge
K-752Explains traceability from data rule to checkKnowledge
K-753Explains the population, measure and threshold of a checkKnowledge
K-754Explains row-level and set-level checksKnowledge
K-755Explains severity, threshold and failure actionKnowledge
K-756Explains scheduling checks against loads and useKnowledge
K-757Explains segmented data quality reportingKnowledge
K-758Explains ownership of data quality failuresKnowledge