knobit.org

Integrates processes through dimensions conformed by grain and key

edu:LearningOutcome edu:Skill

https://knobit.org/id/outcome/WO-3

Also as Turtle · JSON-LD · RDF/XML

dcterms:descriptionStage 3 of the dw-bi skill: Integrates processes through dimensions conformed by grain and key; produces 03-bus-matrix/bus-matrix.yaml. en
dcterms:identifierWO-3
dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
has prerequisiteStates BI requirements as decisions and questions the sources can serve
has prerequisiteDefines each KPI once, precisely enough to compute, and explains two values of it in numbers
includes knobitRecognises a dimension conformed in name only
includes knobitRecognises a business process with no fact
includes knobitRecognises a mart bypassing the conformed dimensions
includes knobitRecognises a drill-across without a shared conformed dimension
includes knobitRecognises a data product with no owner or consumer
includes knobitRecognises two data products answering one question differently
includes knobitRecognises a fact with mixed grain
includes knobitRecognises a matrix tick the fact cannot carry
includes knobitJudges dimension conformance by grain and key
includes knobitTraces the consequence of a drill-across mismatch
includes knobitKeeps the bus matrix to the given processes
includes knobitExplains the enterprise bus matrix and conformed dimensions
includes knobitExplains data products in a warehouse
includes knobitExplains the declared grain of a fact
owl:sameAshttps://bitbucket.org/reffa/ontology/id/outcome/dw-bi/03-bus-matrix-data-products
rdfs:labelIntegrates processes through dimensions conformed by grain and key en
rdfs:labelLõimib äriprotsessid dimensioonide kaudu, mis on ühtlustatud detailsusastme ja võtme järgi et
related topicData warehousing and business intelligence (DAMA-DMBOK2 chapter 11)

Used by

assesses learning outcomeBank bus matrix - two Customer dimensions and a process with no fact (bus matrix anomaly skills)
assesses learning outcomePayments joins the bus - an Account keyed by IBAN, a file fee on payment rows and a load that does not balance (conformance, grain, load control and GL reconciliation knowledge)
has prerequisiteProves each load complete and reconciles to the ledger where differences cannot hide
includes learning outcomeLearning path: Data warehousing and business intelligence
related learning outcomeStage 3 — Bus matrix and data products
related learning outcomeBus matrix and data products anomaly checklist
schema:itemhttps://knobit.org/id/path/dw-bi/WO-3