knobit.org

Data warehousing and business intelligence (DAMA-DMBOK2 chapter 11)

edu:Topic

https://knobit.org/id/topic/dmbok2-dw-bi

Also as Turtle · JSON-LD · RDF/XML

dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
owl:sameAshttps://bitbucket.org/reffa/ontology/id/topic/dmbok2-dw-bi
rdfs:labelAndmeladu ja ärianalüütika (DAMA-DMBOK2 11. peatükk) et
rdfs:labelData warehousing and business intelligence (DAMA-DMBOK2 chapter 11) en

Used by

has subtopicData management (DAMA-DMBOK2)
related topicData warehousing and business intelligence
related topicdw-bi skill (SKILL.md)
related topicStage 1 — BI requirements
related topicStage 2 — Metric and KPI definitions
related topicStage 3 — Bus matrix and data products
related topicStage 4 — Population and reconciliation
related topicStage 5 — Report and dashboard specification
related topicDW/BI file schemas
related topicBI requirements anomaly checklist
related topicMetric definitions anomaly checklist
related topicBus matrix and data products anomaly checklist
related topicPopulation and reconciliation anomaly checklist
related topicReport specification anomaly checklist
related topicStates BI requirements as decisions and questions the sources can serve
related topicDefines each KPI once, precisely enough to compute, and explains two values of it in numbers
related topicIntegrates processes through dimensions conformed by grain and key
related topicProves each load complete and reconciles to the ledger where differences cannot hide
related topicSpecifies reports that show catalogue metrics honestly, dated, and only to entitled audiences
related topicBank bus matrix - two Customer dimensions and a process with no fact (bus matrix anomaly skills)
related topicPayments 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)
related topicDAMA-DMBOK2 data warehousing and BI: general knowledge no stage test reaches (CDMP-style question)
related topicKPI catalogue review before the Q3 board pack - balances added over months, a quarterly margin shown as annual, a pooled rate the board wants averaged (metric precision, additivity, annualisation, conversion)
related topicTwo NPL ratios for one quarter - explain the difference in numbers (metric definition anomaly skills)
related topicDeposits mart month-end - a reconciliation that passes because two errors cancel (population anomaly skills)
related topicRetail lending dashboard - a 2% change drawn as a cliff, and borrowers' names for the branch network (report specification anomaly skills)
related topicRetail lending BI requests - decisions, not charts (BI requirements anomaly skills)
related topicDeposit franchise dashboard - weekly market rates wanted daily, a 2% rise drawn 48 times too big, next month's rate plan shown to branches (BI requirements and report specification knowledge)
related topicTests of the dw-bi skill