Data warehousing and business intelligence (DAMA-DMBOK2)
https://knobit.org/id/register/dw-bi
Also as Turtle · JSON-LD · RDF/XML
| LCG purposes | Assessing the learner's knowledge or skill state |
|---|---|
| LCG purposes | Opening up a learning outcome |
| LCG purposes | Selecting an assessment task or learning activity |
| conforms to profile | https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1 |
| dcterms:description | Recognising and repairing defects in DW/BI deliverables - requirements, metric definitions, bus matrix, population and reconciliation, report specifications - and explaining every difference between two numbers with the same name in numbers: the competence the dw-bi skill applies, and that skill-tests assesses. en |
| dcterms:identifier | SCOPE-1 |
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
| dcterms:rights | Copyright 2026 Peep Küngas. Licensed under CC BY 4.0. |
| dcterms:title | Data warehousing and business intelligence (DAMA-DMBOK2) en |
| owl:sameAs | https://bitbucket.org/reffa/ontology/skills/dw-bi |
| schema:license | https://creativecommons.org/licenses/by/4.0/ |
| skos:note | audience: BI architects and analysts, metric owners, and AI models assessed by skill-tests en |
| skos:note | domain: Data management, data warehousing and business intelligence (DAMA-DMBOK2 chapter 11) en |
| skos:note | level: CDMP Practitioner: the Data Warehousing and Business Intelligence specialist exam (DAMA International) en |
Items and references
dwbi-requirements C1: a RAG pie chart requested with no decision edu:Question
https://knobit.org/id/register/dw-bi#BI-101
| dcterms:identifier | BI-101 |
|---|---|
| rdfs:label | dwbi-requirements C1: a RAG pie chart requested with no decision en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (2 points) |
| solvable with | set of Recognises a chart requested instead of a question |
dwbi-requirements C1: each request restated as a decision and a question edu:Question
https://knobit.org/id/register/dw-bi#BI-102
| dcterms:identifier | BI-102 |
|---|---|
| rdfs:label | dwbi-requirements C1: each request restated as a decision and a question en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (2 points) |
| solvable with | set of Restates a BI request as a decision and a question |
dwbi-requirements C2: intraday arrears from a nightly load edu:Question
https://knobit.org/id/register/dw-bi#BI-103
| dcterms:identifier | BI-103 |
|---|---|
| rdfs:label | dwbi-requirements C2: intraday arrears from a nightly load en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C2 (2 points) |
| solvable with | set of Recognises timeliness the sources cannot meet |
dwbi-requirements C2: the timeliness gap raised against the refresh edu:Question
https://knobit.org/id/register/dw-bi#BI-104
| dcterms:identifier | BI-104 |
|---|---|
| rdfs:label | dwbi-requirements C2: the timeliness gap raised against the refresh en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C2 (2 points) |
| solvable with | set of Raises a timeliness gap against the source refresh |
dwbi-requirements I1: a dashboard of arrears with no decision edu:Question
https://knobit.org/id/register/dw-bi#BI-105
| dcterms:identifier | BI-105 |
|---|---|
| rdfs:label | dwbi-requirements I1: a dashboard of arrears with no decision en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a report request with no decision |
dwbi-requirements I1: branch decisions from monthly region totals edu:Question
https://knobit.org/id/register/dw-bi#BI-106
| dcterms:identifier | BI-106 |
|---|---|
| rdfs:label | dwbi-requirements I1: branch decisions from monthly region totals en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a grain coarser than the question |
dwbi-requirements I1: a question no source can answer edu:Question
https://knobit.org/id/register/dw-bi#BI-107
| dcterms:identifier | BI-107 |
|---|---|
| rdfs:label | dwbi-requirements I1: a question no source can answer en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a BI question the data cannot answer |
dwbi-requirements I1: an existing report under a new name edu:Question
https://knobit.org/id/register/dw-bi#BI-108
| dcterms:identifier | BI-108 |
|---|---|
| rdfs:label | dwbi-requirements I1: an existing report under a new name en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises an existing report requested under a new name |
dwbi-requirements I2: a requirement with no audience edu:Question
https://knobit.org/id/register/dw-bi#BI-109
| dcterms:identifier | BI-109 |
|---|---|
| rdfs:label | dwbi-requirements I2: a requirement with no audience en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (1 points) |
| solvable with | set of Recognises a BI requirement with no audience |
dwbi-requirements I2: ten years of card history from a 3-year source edu:Question
https://knobit.org/id/register/dw-bi#BI-110
| dcterms:identifier | BI-110 |
|---|---|
| rdfs:label | dwbi-requirements I2: ten years of card history from a 3-year source en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (1 points) |
| solvable with | set of Recognises history beyond what the sources keep |
dwbi-requirements Q1: no decisions invented; unclear ones raised edu:Question
https://knobit.org/id/register/dw-bi#BI-111
| dcterms:identifier | BI-111 |
|---|---|
| rdfs:label | dwbi-requirements Q1: no decisions invented; unclear ones raised en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | Q1 (1 points) |
| solvable with | set of Raises a decision for its owner instead of taking it |
dwbi-requirements-reporting C1: a daily rate gap needed from a weekly market-rate feed edu:Question
https://knobit.org/id/register/dw-bi#BI-150
| dcterms:identifier | BI-150 |
|---|---|
| rdfs:label | dwbi-requirements-reporting C1: a daily rate gap needed from a weekly market-rate feed en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (2 points) |
| solvable with | set of Explains the feasibility of BI requirements against sources |
dwbi-requirements-reporting C1: 36 months of rate changes from a 24-month source edu:Question
https://knobit.org/id/register/dw-bi#BI-151
| dcterms:identifier | BI-151 |
|---|---|
| rdfs:label | dwbi-requirements-reporting C1: 36 months of rate changes from a 24-month source en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (2 points) |
| solvable with | set of Explains the feasibility of BI requirements against sources |
dwbi-requirements-reporting C1: a feasible requirement (06:30 load, 08:00 need) left ok edu:Question
https://knobit.org/id/register/dw-bi#BI-152
| dcterms:identifier | BI-152 |
|---|---|
| rdfs:label | dwbi-requirements-reporting C1: a feasible requirement (06:30 load, 08:00 need) left ok en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (2 points) |
| solvable with | set of Explains the feasibility of BI requirements against sources |
dwbi-requirements-reporting I1: an incomplete requirement completed from the interview notes edu:Question
https://knobit.org/id/register/dw-bi#BI-153
| dcterms:identifier | BI-153 |
|---|---|
| rdfs:label | dwbi-requirements-reporting I1: an incomplete requirement completed from the interview notes en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (1.5 points) |
| solvable with | set of Explains BI requirements gathering |
Percentage point as a difference of percentages edu:Question
https://knobit.org/id/register/dw-bi#BI-1801
| dcterms:identifier | BI-1801 |
|---|---|
| rdfs:label | Percentage point as a difference of percentages en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:learningResourceType | multiple_choice |
| schema:text | The unemployment rate rose from 6% to 8%. Which statement is correct? (a) a rise of 2%; (b) a rise of 2 percentage points; (c) a rise of 25 percentage points; (d) a rise of 8 percentage points en |
| solvable with | set of Explains the meaning of a percentage point |
Exchange rate and conversion edu:Question
https://knobit.org/id/register/dw-bi#BI-1802
| dcterms:identifier | BI-1802 |
|---|---|
| rdfs:label | Exchange rate and conversion en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:learningResourceType | multiple_choice |
| schema:text | What does the exchange rate 1 EUR = 1.08 USD mean? (a) one euro buys 1.08 US dollars; (b) one dollar buys 1.08 euros; (c) the euro is 1.08% cheaper than the dollar; (d) the dollar is always worth 1.08 euros en |
| solvable with | set of Explains the meaning of an exchange rate and of currency conversion |
Arithmetic mean edu:Question
https://knobit.org/id/register/dw-bi#BI-1803
| dcterms:identifier | BI-1803 |
|---|---|
| rdfs:label | Arithmetic mean en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:learningResourceType | multiple_choice |
| schema:text | The arithmetic mean of the numbers 4, 6 and 11 is: (a) 6; (b) 7; (c) 21; (d) 5 en |
| solvable with | set of Explains the concept of the arithmetic mean |
Database structure edu:Question
https://knobit.org/id/register/dw-bi#BI-1804
| dcterms:identifier | BI-1804 |
|---|---|
| rdfs:label | Database structure en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:learningResourceType | multiple_choice |
| schema:text | What is the primary key of a table for? (a) it identifies each row uniquely; (b) it sets the colour of a column; (c) it deletes the table; (d) it counts the columns en |
| solvable with | set of Explains how database tables and relationships are structured |
Values on a line chart edu:Question
https://knobit.org/id/register/dw-bi#BI-1805
| dcterms:identifier | BI-1805 |
|---|---|
| rdfs:label | Values on a line chart en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:learningResourceType | short_answer |
| schema:text | A line chart shows the daytime air temperature from 6:00 to 18:00. At what time was the temperature highest, and how high was it? en |
| solvable with | set of Reads requested values from a chart |
Non-performing loan ratio across segments edu:Question
https://knobit.org/id/register/dw-bi#BI-1901
| dcterms:identifier | BI-1901 |
|---|---|
| rdfs:label | Non-performing loan ratio across segments en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:learningResourceType | multiple_choice |
| schema:text | Segment A has 10 non-performing loans out of 100 (10%), segment B 10 out of 1,000 (1%). What is the bank's non-performing loan ratio? (a) about 1.8%; (b) 5.5%; (c) 11%; (d) 10% en |
| solvable with | set of Explains a pooled rate as the weighted mean of its population rates |
What a currency conversion in a metric must state edu:Question
https://knobit.org/id/register/dw-bi#BI-1902
| dcterms:identifier | BI-1902 |
|---|---|
| rdfs:label | What a currency conversion in a metric must state en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:learningResourceType | multiple_choice |
| schema:text | A report converts USD loans to EUR. What must the metric definition state so the figure can be recomputed? (a) the rate source and the rate date; (b) only the rate; (c) only the currency of the result; (d) nothing, if the ECB rate is used en |
| solvable with | set of Explains converting a metric's currency at a stated rate source and date |
Annualising a quarterly rate edu:Question
https://knobit.org/id/register/dw-bi#BI-1903
| dcterms:identifier | BI-1903 |
|---|---|
| rdfs:label | Annualising a quarterly rate en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:learningResourceType | multiple_choice |
| schema:text | Net interest income for the third quarter is 0.55% of average assets. What is the annualised net interest margin, by the quarterly method? (a) 2.2%; (b) 0.55%; (c) 0.14%; (d) 6.6% en |
| solvable with | set of Explains annualising a period rate |
dwbi-metric-definitions C1: the difference reconciled into quantified effects edu:Question
https://knobit.org/id/register/dw-bi#BI-201
| dcterms:identifier | BI-201 |
|---|---|
| rdfs:label | dwbi-metric-definitions C1: the difference reconciled into quantified effects en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (3 points) |
| solvable with | set of Reconciles two values of one KPI into quantified effects |
dwbi-metric-definitions C1: non-performing forborne exposures brought into the definition edu:Question
https://knobit.org/id/register/dw-bi#BI-202
| dcterms:identifier | BI-202 |
|---|---|
| rdfs:label | dwbi-metric-definitions C1: non-performing forborne exposures brought into the definition en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (3 points) |
| solvable with | set of Aligns a KPI with its regulatory definition |
dwbi-metric-definitions C1: the corrected ratio recomputed from the extract edu:Question
https://knobit.org/id/register/dw-bi#BI-203
| dcterms:identifier | BI-203 |
|---|---|
| rdfs:label | dwbi-metric-definitions C1: the corrected ratio recomputed from the extract en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (3 points) |
| solvable with | set of Recomputes a ratio from summed numerators and denominators |
dwbi-metric-definitions I1: average balances used for a quarter-end ratio edu:Question
https://knobit.org/id/register/dw-bi#BI-204
| dcterms:identifier | BI-204 |
|---|---|
| rdfs:label | dwbi-metric-definitions I1: average balances used for a quarter-end ratio en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises point in time and period confused |
dwbi-metric-definitions I1: non-performing forborne exposures excluded edu:Question
https://knobit.org/id/register/dw-bi#BI-205
| dcterms:identifier | BI-205 |
|---|---|
| rdfs:label | dwbi-metric-definitions I1: non-performing forborne exposures excluded en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a management KPI under a regulatory name |
dwbi-metric-definitions I1: segment ratios averaged edu:Question
https://knobit.org/id/register/dw-bi#BI-206
| dcterms:identifier | BI-206 |
|---|---|
| rdfs:label | dwbi-metric-definitions I1: segment ratios averaged en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a ratio averaged across segments |
dwbi-metric-definitions I1: two definitions named NPL ratio edu:Question
https://knobit.org/id/register/dw-bi#BI-207
| dcterms:identifier | BI-207 |
|---|---|
| rdfs:label | dwbi-metric-definitions I1: two definitions named NPL ratio en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises two definitions of one KPI |
dwbi-metric-definitions I2: numerator and denominator over different populations edu:Question
https://knobit.org/id/register/dw-bi#BI-208
| dcterms:identifier | BI-208 |
|---|---|
| rdfs:label | dwbi-metric-definitions I2: numerator and denominator over different populations en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (1 points) |
| solvable with | set of Recognises a ratio over mismatched populations |
dwbi-metric-definitions I2: conversion without a rate date edu:Question
https://knobit.org/id/register/dw-bi#BI-209
| dcterms:identifier | BI-209 |
|---|---|
| rdfs:label | dwbi-metric-definitions I2: conversion without a rate date en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (1 points) |
| solvable with | set of Recognises a currency conversion without a rate date |
dwbi-metric-definitions Q1: the EBA definition used as quoted edu:Question
https://knobit.org/id/register/dw-bi#BI-210
| dcterms:identifier | BI-210 |
|---|---|
| rdfs:label | dwbi-metric-definitions Q1: the EBA definition used as quoted en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | Q1 (1 points) |
| solvable with | set of Uses a regulatory definition only as quoted |
dwbi-kpi-precision C1: KP-11 month-end balances summed over the quarter edu:Question
https://knobit.org/id/register/dw-bi#BI-250
| dcterms:identifier | BI-250 |
|---|---|
| rdfs:label | dwbi-kpi-precision C1: KP-11 month-end balances summed over the quarter en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (3 points) |
| solvable with | set of Recognises a semi-additive balance summed over time |
dwbi-kpi-precision C1: KP-12 quarterly margin shown as annual, annualised edu:Question
https://knobit.org/id/register/dw-bi#BI-251
| dcterms:identifier | BI-251 |
|---|---|
| rdfs:label | dwbi-kpi-precision C1: KP-12 quarterly margin shown as annual, annualised en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (3 points) |
| solvable with | set of Recognises a period rate not annualised |
dwbi-kpi-precision C1: KP-16 nine-month ratio passed with no annualisation edu:Question
https://knobit.org/id/register/dw-bi#BI-252
| dcterms:identifier | BI-252 |
|---|---|
| rdfs:label | dwbi-kpi-precision C1: KP-16 nine-month ratio passed with no annualisation en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (3 points) |
| solvable with | set of Recognises a period rate not annualised |
dwbi-kpi-precision C2: KP-14 as the pooled rate, not the plain mean of segment rates edu:Question
https://knobit.org/id/register/dw-bi#BI-253
| dcterms:identifier | BI-253 |
|---|---|
| rdfs:label | dwbi-kpi-precision C2: KP-14 as the pooled rate, not the plain mean of segment rates en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C2 (2 points) |
| solvable with | set of Explains a pooled rate as the weighted mean of its population rates |
dwbi-kpi-precision C2: the arrears rise explained as a mix effect edu:Question
https://knobit.org/id/register/dw-bi#BI-254
| dcterms:identifier | BI-254 |
|---|---|
| rdfs:label | dwbi-kpi-precision C2: the arrears rise explained as a mix effect en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C2 (2 points) |
| solvable with | set of Explains a pooled rate as the weighted mean of its population rates |
dwbi-kpi-precision I1: KP-15 converted at the ECB rate of the balance date edu:Question
https://knobit.org/id/register/dw-bi#BI-255
| dcterms:identifier | BI-255 |
|---|---|
| rdfs:label | dwbi-kpi-precision I1: KP-15 converted at the ECB rate of the balance date en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Explains converting a metric's currency at a stated rate source and date |
dwbi-kpi-precision I1: KP-13 with no owner edu:Question
https://knobit.org/id/register/dw-bi#BI-256
| dcterms:identifier | BI-256 |
|---|---|
| rdfs:label | dwbi-kpi-precision I1: KP-13 with no owner en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a metric with no owner |
dwbi-kpi-precision I2: every component of a computable definition stated edu:Question
https://knobit.org/id/register/dw-bi#BI-257
| dcterms:identifier | BI-257 |
|---|---|
| rdfs:label | dwbi-kpi-precision I2: every component of a computable definition stated en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (2 points) |
| solvable with | set of Explains the components of a metric definition |
dwbi-kpi-precision I2: additivity stated, ratio non-additive and balance semi-additive edu:Question
https://knobit.org/id/register/dw-bi#BI-258
| dcterms:identifier | BI-258 |
|---|---|
| rdfs:label | dwbi-kpi-precision I2: additivity stated, ratio non-additive and balance semi-additive en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (2 points) |
| solvable with | set of Explains additivity of facts |
dwbi-kpi-precision I3: non-performing at 20 days past due, unlikely to pay or forborne edu:Question
https://knobit.org/id/register/dw-bi#BI-259
| dcterms:identifier | BI-259 |
|---|---|
| rdfs:label | dwbi-kpi-precision I3: non-performing at 20 days past due, unlikely to pay or forborne en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I3 (1 points) |
| solvable with | set of Explains the EBA definition of non-performing exposures |
dwbi-kpi-precision I4: definitions kept once in a semantic layer all BI tools read edu:Question
https://knobit.org/id/register/dw-bi#BI-260
| dcterms:identifier | BI-260 |
|---|---|
| rdfs:label | dwbi-kpi-precision I4: definitions kept once in a semantic layer all BI tools read en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I4 (1.5 points) |
| solvable with | set of Explains DW architecture approaches, Explains DW/BI tools and their categories |
dwbi-kpi-precision I4: changed definitions released with a parallel run and monitored edu:Question
https://knobit.org/id/register/dw-bi#BI-261
| dcterms:identifier | BI-261 |
|---|---|
| rdfs:label | dwbi-kpi-precision I4: changed definitions released with a parallel run and monitored en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I4 (1.5 points) |
| solvable with | set of Explains DW/BI operations and maintenance |
dwbi-kpi-precision I4: owner sign-off and lineage before business acceptance edu:Question
https://knobit.org/id/register/dw-bi#BI-262
| dcterms:identifier | BI-262 |
|---|---|
| rdfs:label | dwbi-kpi-precision I4: owner sign-off and lineage before business acceptance en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I4 (1.5 points) |
| solvable with | set of Explains DW/BI governance and implementation |
dwbi-bus-matrix C1: two Customer dimensions at different grains called conformed edu:Question
https://knobit.org/id/register/dw-bi#BI-301
| dcterms:identifier | BI-301 |
|---|---|
| rdfs:label | dwbi-bus-matrix C1: two Customer dimensions at different grains called conformed en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (3 points) |
| solvable with | set of Recognises a dimension conformed in name only |
dwbi-bus-matrix C1: conformance judged by grain and key edu:Question
https://knobit.org/id/register/dw-bi#BI-302
| dcterms:identifier | BI-302 |
|---|---|
| rdfs:label | dwbi-bus-matrix C1: conformance judged by grain and key en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (3 points) |
| solvable with | set of Judges dimension conformance by grain and key |
dwbi-bus-matrix C1: the drill-across consequence for joint holders edu:Question
https://knobit.org/id/register/dw-bi#BI-303
| dcterms:identifier | BI-303 |
|---|---|
| rdfs:label | dwbi-bus-matrix C1: the drill-across consequence for joint holders en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (3 points) |
| solvable with | set of Traces the consequence of a drill-across mismatch |
dwbi-bus-matrix I1: loan arrears with no fact edu:Question
https://knobit.org/id/register/dw-bi#BI-304
| dcterms:identifier | BI-304 |
|---|---|
| rdfs:label | dwbi-bus-matrix I1: loan arrears with no fact en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a business process with no fact |
dwbi-bus-matrix I1: the card mart's private Customer edu:Question
https://knobit.org/id/register/dw-bi#BI-305
| dcterms:identifier | BI-305 |
|---|---|
| rdfs:label | dwbi-bus-matrix I1: the card mart's private Customer en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a mart bypassing the conformed dimensions |
dwbi-bus-matrix I1: card spend and deposits drilled across without a shared dimension edu:Question
https://knobit.org/id/register/dw-bi#BI-306
| dcterms:identifier | BI-306 |
|---|---|
| rdfs:label | dwbi-bus-matrix I1: card spend and deposits drilled across without a shared dimension en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a drill-across without a shared conformed dimension |
dwbi-bus-matrix I1: disbursements at loan and tranche grain edu:Question
https://knobit.org/id/register/dw-bi#BI-307
| dcterms:identifier | BI-307 |
|---|---|
| rdfs:label | dwbi-bus-matrix I1: disbursements at loan and tranche grain en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a fact with mixed grain |
dwbi-bus-matrix I2: branch ticked for a fact without a branch key edu:Question
https://knobit.org/id/register/dw-bi#BI-308
| dcterms:identifier | BI-308 |
|---|---|
| rdfs:label | dwbi-bus-matrix I2: branch ticked for a fact without a branch key en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (1.5 points) |
| solvable with | set of Recognises a matrix tick the fact cannot carry |
dwbi-bus-matrix I2: the legacy loan cube with no owner or consumer edu:Question
https://knobit.org/id/register/dw-bi#BI-309
| dcterms:identifier | BI-309 |
|---|---|
| rdfs:label | dwbi-bus-matrix I2: the legacy loan cube with no owner or consumer en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (1.5 points) |
| solvable with | set of Recognises a data product with no owner or consumer |
dwbi-bus-matrix I2: two products answering average deposit balance differently edu:Question
https://knobit.org/id/register/dw-bi#BI-310
| dcterms:identifier | BI-310 |
|---|---|
| rdfs:label | dwbi-bus-matrix I2: two products answering average deposit balance differently en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (1.5 points) |
| solvable with | set of Recognises two data products answering one question differently |
dwbi-bus-matrix Q1: no new processes invented edu:Question
https://knobit.org/id/register/dw-bi#BI-311
| dcterms:identifier | BI-311 |
|---|---|
| rdfs:label | dwbi-bus-matrix Q1: no new processes invented en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | Q1 (1 points) |
| solvable with | set of Keeps the bus matrix to the given processes |
dwbi-conformed-loads C2: an Account keyed by IBAN beside one keyed by account_id judged not conformed by key edu:Question
https://knobit.org/id/register/dw-bi#BI-350
| dcterms:identifier | BI-350 |
|---|---|
| rdfs:label | dwbi-conformed-loads C2: an Account keyed by IBAN beside one keyed by account_id judged not conformed by key en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C2 (2 points) |
| solvable with | set of Explains the enterprise bus matrix and conformed dimensions |
dwbi-conformed-loads C2: a bulk-file fee repeated on payment rows kept off the payment grain edu:Question
https://knobit.org/id/register/dw-bi#BI-351
| dcterms:identifier | BI-351 |
|---|---|
| rdfs:label | dwbi-conformed-loads C2: a bulk-file fee repeated on payment rows kept off the payment grain en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C2 (2 points) |
| solvable with | set of Explains the declared grain of a fact |
dwbi-conformed-loads I2: the payments mart given an SLA edu:Question
https://knobit.org/id/register/dw-bi#BI-352
| dcterms:identifier | BI-352 |
|---|---|
| rdfs:label | dwbi-conformed-loads I2: the payments mart given an SLA en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (1 points) |
| solvable with | set of Explains data products in a warehouse |
dwbi-conformed-loads Q1: the conformed Branch in an initiating-branch role left alone edu:Question
https://knobit.org/id/register/dw-bi#BI-353
| dcterms:identifier | BI-353 |
|---|---|
| rdfs:label | dwbi-conformed-loads Q1: the conformed Branch in an initiating-branch role left alone en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | Q1 (2 points) |
| solvable with | set of Explains the enterprise bus matrix and conformed dimensions |
dwbi-reconciliation C1: +2.1M and -2.0M offsetting inside a total tolerance edu:Question
https://knobit.org/id/register/dw-bi#BI-401
| dcterms:identifier | BI-401 |
|---|---|
| rdfs:label | dwbi-reconciliation C1: +2.1M and -2.0M offsetting inside a total tolerance en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (3 points) |
| solvable with | set of Recognises a reconciliation passing on offsetting differences |
dwbi-reconciliation C1: reconciliation per GL account with the differences edu:Question
https://knobit.org/id/register/dw-bi#BI-402
| dcterms:identifier | BI-402 |
|---|---|
| rdfs:label | dwbi-reconciliation C1: reconciliation per GL account with the differences en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (3 points) |
| solvable with | set of Reconciles per general ledger account |
dwbi-reconciliation C1: the manual adjustment made a recorded control edu:Question
https://knobit.org/id/register/dw-bi#BI-403
| dcterms:identifier | BI-403 |
|---|---|
| rdfs:label | dwbi-reconciliation C1: the manual adjustment made a recorded control en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (3 points) |
| solvable with | set of Brings a manual adjustment under a recorded control |
dwbi-reconciliation I1: 37 rejects discarded edu:Question
https://knobit.org/id/register/dw-bi#BI-404
| dcterms:identifier | BI-404 |
|---|---|
| rdfs:label | dwbi-reconciliation I1: 37 rejects discarded en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises load rejects dropped |
dwbi-reconciliation I1: the manual adjustment outside every control edu:Question
https://knobit.org/id/register/dw-bi#BI-405
| dcterms:identifier | BI-405 |
|---|---|
| rdfs:label | dwbi-reconciliation I1: the manual adjustment outside every control en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a manual adjustment outside any control |
dwbi-reconciliation I1: a 'standard' tolerance with no rationale edu:Question
https://knobit.org/id/register/dw-bi#BI-406
| dcterms:identifier | BI-406 |
|---|---|
| rdfs:label | dwbi-reconciliation I1: a 'standard' tolerance with no rationale en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a reconciliation tolerance with no rationale |
dwbi-reconciliation I1: the savings load without control totals edu:Question
https://knobit.org/id/register/dw-bi#BI-407
| dcterms:identifier | BI-407 |
|---|---|
| rdfs:label | dwbi-reconciliation I1: the savings load without control totals en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a warehouse load with no control totals |
dwbi-reconciliation I2: late postings ignored after close edu:Question
https://knobit.org/id/register/dw-bi#BI-408
| dcterms:identifier | BI-408 |
|---|---|
| rdfs:label | dwbi-reconciliation I2: late postings ignored after close en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (1 points) |
| solvable with | set of Recognises late data silently excluded |
dwbi-reconciliation I2: the mart has no as-of date edu:Question
https://knobit.org/id/register/dw-bi#BI-409
| dcterms:identifier | BI-409 |
|---|---|
| rdfs:label | dwbi-reconciliation I2: the mart has no as-of date en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (1 points) |
| solvable with | set of Recognises data delivered with no as-of date |
dwbi-reconciliation Q1: the tolerance not widened edu:Question
https://knobit.org/id/register/dw-bi#BI-410
| dcterms:identifier | BI-410 |
|---|---|
| rdfs:label | dwbi-reconciliation Q1: the tolerance not widened en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | Q1 (1 points) |
| solvable with | set of Keeps a reconciliation tolerance unchanged to pass |
dwbi-conformed-loads C1: a load reporting no rejects that loses 60 rows and EUR 240 000 edu:Question
https://knobit.org/id/register/dw-bi#BI-450
| dcterms:identifier | BI-450 |
|---|---|
| rdfs:label | dwbi-conformed-loads C1: a load reporting no rejects that loses 60 rows and EUR 240 000 en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (3 points) |
| solvable with | set of Explains warehouse load controls |
dwbi-conformed-loads C1: the EUR clearing break explained by the unbalanced load edu:Question
https://knobit.org/id/register/dw-bi#BI-451
| dcterms:identifier | BI-451 |
|---|---|
| rdfs:label | dwbi-conformed-loads C1: the EUR clearing break explained by the unbalanced load en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (3 points) |
| solvable with | set of Explains reconciliation to the general ledger |
dwbi-conformed-loads C1: the USD clearing account reconciled in transaction currency, not across two conversion rates edu:Question
https://knobit.org/id/register/dw-bi#BI-452
| dcterms:identifier | BI-452 |
|---|---|
| rdfs:label | dwbi-conformed-loads C1: the USD clearing account reconciled in transaction currency, not across two conversion rates en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (3 points) |
| solvable with | set of Explains reconciliation to the general ledger |
dwbi-conformed-loads I1: a fee income reconciliation with no owner or frequency edu:Question
https://knobit.org/id/register/dw-bi#BI-453
| dcterms:identifier | BI-453 |
|---|---|
| rdfs:label | dwbi-conformed-loads I1: a fee income reconciliation with no owner or frequency en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a reconciliation with no owner or frequency |
dwbi-conformed-loads I1: an intraday mart stamped with a date only edu:Question
https://knobit.org/id/register/dw-bi#BI-454
| dcterms:identifier | BI-454 |
|---|---|
| rdfs:label | dwbi-conformed-loads I1: an intraday mart stamped with a date only en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Explains data currency for consumers |
dwbi-conformed-loads Q1: a balanced load with held rejects left alone edu:Question
https://knobit.org/id/register/dw-bi#BI-455
| dcterms:identifier | BI-455 |
|---|---|
| rdfs:label | dwbi-conformed-loads Q1: a balanced load with held rejects left alone en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | Q1 (2 points) |
| solvable with | set of Explains warehouse load controls |
dwbi-conformed-loads Q1: an owned daily reconciliation left alone edu:Question
https://knobit.org/id/register/dw-bi#BI-456
| dcterms:identifier | BI-456 |
|---|---|
| rdfs:label | dwbi-conformed-loads Q1: an owned daily reconciliation left alone en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | Q1 (2 points) |
| solvable with | set of Explains reconciliation to the general ledger |
dwbi-conformed-loads Q1: a daily mart stamped end of day left alone edu:Question
https://knobit.org/id/register/dw-bi#BI-457
| dcterms:identifier | BI-457 |
|---|---|
| rdfs:label | dwbi-conformed-loads Q1: a daily mart stamped end of day left alone en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | Q1 (2 points) |
| solvable with | set of Explains data currency for consumers |
dwbi-report-specification C1: a y-axis from 95% of the minimum turning 2% into a cliff edu:Question
https://knobit.org/id/register/dw-bi#BI-501
| dcterms:identifier | BI-501 |
|---|---|
| rdfs:label | dwbi-report-specification C1: a y-axis from 95% of the minimum turning 2% into a cliff en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (2 points) |
| solvable with | set of Recognises a truncated axis exaggerating a change |
dwbi-report-specification C1: the axis rescaled to show the change truthfully edu:Question
https://knobit.org/id/register/dw-bi#BI-502
| dcterms:identifier | BI-502 |
|---|---|
| rdfs:label | dwbi-report-specification C1: the axis rescaled to show the change truthfully en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C1 (2 points) |
| solvable with | set of Rescales a chart so it shows the change truthfully |
dwbi-report-specification C2: named borrowers shown to a branch audience entitled to aggregates edu:Question
https://knobit.org/id/register/dw-bi#BI-503
| dcterms:identifier | BI-503 |
|---|---|
| rdfs:label | dwbi-report-specification C2: named borrowers shown to a branch audience entitled to aggregates en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C2 (2 points) |
| solvable with | set of Recognises restricted data shown beyond its audience |
dwbi-report-specification C2: the panel restricted to aggregates edu:Question
https://knobit.org/id/register/dw-bi#BI-504
| dcterms:identifier | BI-504 |
|---|---|
| rdfs:label | dwbi-report-specification C2: the panel restricted to aggregates en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C2 (2 points) |
| solvable with | set of Restricts a report panel to its entitled audience |
dwbi-report-specification I1: actual and plan in one style edu:Question
https://knobit.org/id/register/dw-bi#BI-505
| dcterms:identifier | BI-505 |
|---|---|
| rdfs:label | dwbi-report-specification I1: actual and plan in one style en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises actual and plan without distinct notation |
dwbi-report-specification I1: new lending without units edu:Question
https://knobit.org/id/register/dw-bi#BI-506
| dcterms:identifier | BI-506 |
|---|---|
| rdfs:label | dwbi-report-specification I1: new lending without units en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a report panel without units |
dwbi-report-specification I1: no as-of date edu:Question
https://knobit.org/id/register/dw-bi#BI-507
| dcterms:identifier | BI-507 |
|---|---|
| rdfs:label | dwbi-report-specification I1: no as-of date en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a report with no as-of date |
dwbi-report-specification I1: a pie per month of nine products edu:Question
https://knobit.org/id/register/dw-bi#BI-508
| dcterms:identifier | BI-508 |
|---|---|
| rdfs:label | dwbi-report-specification I1: a pie per month of nine products en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I1 (2 points) |
| solvable with | set of Recognises a pie chart for many parts or over time |
dwbi-report-specification I2: consumer and mortgage arrears on different scales edu:Question
https://knobit.org/id/register/dw-bi#BI-509
| dcterms:identifier | BI-509 |
|---|---|
| rdfs:label | dwbi-report-specification I2: consumer and mortgage arrears on different scales en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (1 points) |
| solvable with | set of Recognises comparable charts on different scales |
dwbi-report-specification I2: a 'portfolio health score' outside the catalogue edu:Question
https://knobit.org/id/register/dw-bi#BI-510
| dcterms:identifier | BI-510 |
|---|---|
| rdfs:label | dwbi-report-specification I2: a 'portfolio health score' outside the catalogue en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (1 points) |
| solvable with | set of Recognises a report metric outside the catalogue |
dwbi-report-specification Q1: every panel cites a catalogue metric edu:Question
https://knobit.org/id/register/dw-bi#BI-511
| dcterms:identifier | BI-511 |
|---|---|
| rdfs:label | dwbi-report-specification Q1: every panel cites a catalogue metric en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | Q1 (1 points) |
| solvable with | set of Cites a catalogue metric for every panel |
dwbi-requirements-reporting C2: columns from EUR 2,350m with lie factor 48, rescaled from zero edu:Question
https://knobit.org/id/register/dw-bi#BI-550
| dcterms:identifier | BI-550 |
|---|---|
| rdfs:label | dwbi-requirements-reporting C2: columns from EUR 2,350m with lie factor 48, rescaled from zero en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C2 (2 points) |
| solvable with | set of Explains honest scaling in charts |
dwbi-requirements-reporting C2: a line axis with a marked break left alone edu:Question
https://knobit.org/id/register/dw-bi#BI-551
| dcterms:identifier | BI-551 |
|---|---|
| rdfs:label | dwbi-requirements-reporting C2: a line axis with a marked break left alone en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C2 (2 points) |
| solvable with | set of Explains honest scaling in charts |
dwbi-requirements-reporting C3: restricted planned rate changes shown to branch managers edu:Question
https://knobit.org/id/register/dw-bi#BI-552
| dcterms:identifier | BI-552 |
|---|---|
| rdfs:label | dwbi-requirements-reporting C3: restricted planned rate changes shown to branch managers en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C3 (2 points) |
| solvable with | set of Explains access control for reports |
dwbi-requirements-reporting C3: customer-level data for its entitled desk left alone edu:Question
https://knobit.org/id/register/dw-bi#BI-553
| dcterms:identifier | BI-553 |
|---|---|
| rdfs:label | dwbi-requirements-reporting C3: customer-level data for its entitled desk left alone en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | C3 (2 points) |
| solvable with | set of Explains access control for reports |
dwbi-requirements-reporting I2: plan outlined in IBCS notation edu:Question
https://knobit.org/id/register/dw-bi#BI-554
| dcterms:identifier | BI-554 |
|---|---|
| rdfs:label | dwbi-requirements-reporting I2: plan outlined in IBCS notation en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (1.5 points) |
| solvable with | set of Explains IBCS notation |
dwbi-requirements-reporting I2: forecast hatched in IBCS notation edu:Question
https://knobit.org/id/register/dw-bi#BI-555
| dcterms:identifier | BI-555 |
|---|---|
| rdfs:label | dwbi-requirements-reporting I2: forecast hatched in IBCS notation en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (1.5 points) |
| solvable with | set of Explains IBCS notation |
dwbi-requirements-reporting I2: previous year grey, not red, in IBCS notation edu:Question
https://knobit.org/id/register/dw-bi#BI-556
| dcterms:identifier | BI-556 |
|---|---|
| rdfs:label | dwbi-requirements-reporting I2: previous year grey, not red, in IBCS notation en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I2 (1.5 points) |
| solvable with | set of Explains IBCS notation |
dwbi-requirements-reporting I3: a structure comparison as bars, not a line edu:Question
https://knobit.org/id/register/dw-bi#BI-557
| dcterms:identifier | BI-557 |
|---|---|
| rdfs:label | dwbi-requirements-reporting I3: a structure comparison as bars, not a line en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I3 (1 points) |
| solvable with | set of Explains IBCS notation |
dwbi-requirements-reporting I3: unit with magnitude (EUR m) for tens of millions edu:Question
https://knobit.org/id/register/dw-bi#BI-558
| dcterms:identifier | BI-558 |
|---|---|
| rdfs:label | dwbi-requirements-reporting I3: unit with magnitude (EUR m) for tens of millions en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | I3 (1 points) |
| solvable with | set of Explains IBCS notation |
dwbi-knowledge-general Q1: drivers of a data warehouse and BI capability edu:Question
https://knobit.org/id/register/dw-bi#BI-951
| dcterms:identifier | BI-951 |
|---|---|
| rdfs:label | dwbi-knowledge-general Q1: drivers of a data warehouse and BI capability en |
| schema:isPartOf | Data warehousing and business intelligence (DAMA-DMBOK2) |
| schema:isPartOf | Q1 (1 points) |
| schema:learningResourceType | multiple_choice |
| schema:text | Which set states the drivers DAMA-DMBOK2 gives for building a data warehouse and business intelligence capability? (a) Replacing the operational systems of record with one database, so that the source systems can be retired; (b) Operational support, compliance and regulatory reporting, and business value from integrated historical data for decisions; (c) Keeping every transaction forever in one place, so that the operational systems no longer need backups; (d) Giving each department its own reporting copy, so that each can keep its own definitions en |
| solvable with | set of Explains the drivers and goals of DW/BI |
DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence schema:CreativeWork
https://knobit.org/id/register/dw-bi#REF-1
| dcterms:identifier | REF-1 |
|---|---|
| dcterms:publisher | DAMA International |
| dcterms:title | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence en |
| schema:version | 2nd edition, revised (DMBOK2/RE) |
| skos:note | target level: CDMP Practitioner: the Data Warehousing and Business Intelligence specialist exam (DAMA International) en |
Understand requirements edu:LearningOutcome
https://knobit.org/id/register/dw-bi#WV-1
| dcterms:description | Gathering and stating BI requirements. en |
|---|---|
| dcterms:identifier | WV-1 |
| dcterms:source | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence, 2.1 en |
| includes knobit | Raises a decision for its owner instead of taking it |
| includes knobit | Restates a BI request as a decision and a question |
| includes knobit | Raises a timeliness gap against the source refresh |
| includes knobit | Explains BI requirements gathering |
| includes knobit | Explains the feasibility of BI requirements against sources |
| rdfs:label | Understand requirements en |
| schema:isPartOf | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence |
| skos:notation | 2.1 |
Implementation guidelines and DW/BI governance edu:LearningOutcome
https://knobit.org/id/register/dw-bi#WV-10
| dcterms:description | Governance. en |
|---|---|
| dcterms:identifier | WV-10 |
| dcterms:source | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence, 5-6 en |
| includes knobit | Explains DW/BI governance and implementation |
| rdfs:label | Implementation guidelines and DW/BI governance en |
| schema:isPartOf | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence |
| skos:notation | 5-6 |
Semantic layer and metric definitions edu:LearningOutcome
https://knobit.org/id/register/dw-bi#WV-2
DW architecture: bus matrix, conformed dimensions, data marts and products edu:LearningOutcome
https://knobit.org/id/register/dw-bi#WV-3
| dcterms:description | Integrating the warehouse through conformed dimensions. en |
|---|---|
| dcterms:identifier | WV-3 |
| dcterms:source | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence, 1.3.3-1.3.4, 2.2 en |
| includes knobit | Explains how database tables and relationships are structured |
| includes knobit | Judges dimension conformance by grain and key |
| includes knobit | Traces the consequence of a drill-across mismatch |
| includes knobit | Keeps the bus matrix to the given processes |
| includes knobit | Explains the enterprise bus matrix and conformed dimensions |
| includes knobit | Explains data products in a warehouse |
| includes knobit | Explains the declared grain of a fact |
| rdfs:label | DW architecture: bus matrix, conformed dimensions, data marts and products en |
| schema:isPartOf | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence |
| skos:notation | 1.3.3-1.3.4, 2.2 |
Populate and operate the warehouse: load controls and reconciliation edu:LearningOutcome
https://knobit.org/id/register/dw-bi#WV-4
| dcterms:description | Proving loads complete and reconciled. en |
|---|---|
| dcterms:identifier | WV-4 |
| dcterms:source | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence, 2.3, 2.5 en |
| includes knobit | Reconciles per general ledger account |
| includes knobit | Brings a manual adjustment under a recorded control |
| includes knobit | Keeps a reconciliation tolerance unchanged to pass |
| includes knobit | Explains warehouse load controls |
| includes knobit | Explains reconciliation to the general ledger |
| includes knobit | Explains data currency for consumers |
| rdfs:label | Populate and operate the warehouse: load controls and reconciliation en |
| schema:isPartOf | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence |
| skos:notation | 2.3, 2.5 |
Develop BI products: reports, dashboards, visualisation and access edu:LearningOutcome
https://knobit.org/id/register/dw-bi#WV-5
| dcterms:description | Specifying reports that inform decisions honestly. en |
|---|---|
| dcterms:identifier | WV-5 |
| dcterms:source | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence, 2.4 en |
| includes knobit | Reads requested values from a chart |
| includes knobit | Rescales a chart so it shows the change truthfully |
| includes knobit | Restricts a report panel to its entitled audience |
| includes knobit | Cites a catalogue metric for every panel |
| includes knobit | Explains IBCS notation |
| includes knobit | Explains honest scaling in charts |
| includes knobit | Explains access control for reports |
| rdfs:label | Develop BI products: reports, dashboards, visualisation and access en |
| schema:isPartOf | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence |
| skos:notation | 2.4 |
Business drivers, goals and principles edu:LearningOutcome
https://knobit.org/id/register/dw-bi#WV-6
| dcterms:description | Why DW/BI. en |
|---|---|
| dcterms:identifier | WV-6 |
| dcterms:source | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence, 1.1-1.2 en |
| includes knobit | Explains the drivers and goals of DW/BI |
| rdfs:label | Business drivers, goals and principles en |
| schema:isPartOf | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence |
| skos:notation | 1.1-1.2 |
DW architecture approaches and components edu:LearningOutcome
https://knobit.org/id/register/dw-bi#WV-7
| dcterms:description | Warehouse architectures. en |
|---|---|
| dcterms:identifier | WV-7 |
| dcterms:source | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence, 1.3.1-1.3.2 en |
| includes knobit | Explains DW architecture approaches |
| rdfs:label | DW architecture approaches and components en |
| schema:isPartOf | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence |
| skos:notation | 1.3.1-1.3.2 |
Tools edu:LearningOutcome
https://knobit.org/id/register/dw-bi#WV-8
| dcterms:description | DW/BI tools. en |
|---|---|
| dcterms:identifier | WV-8 |
| dcterms:source | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence, 3 en |
| includes knobit | Explains DW/BI tools and their categories |
| rdfs:label | Tools en |
| schema:isPartOf | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence |
| skos:notation | 3 |
Maintain data products: release, performance, operations edu:LearningOutcome
https://knobit.org/id/register/dw-bi#WV-9
| dcterms:description | Operating the warehouse. en |
|---|---|
| dcterms:identifier | WV-9 |
| dcterms:source | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence, 2.5, 4 en |
| includes knobit | Explains DW/BI operations and maintenance |
| rdfs:label | Maintain data products: release, performance, operations en |
| schema:isPartOf | DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (revised), chapter 11: Data Warehousing and Business Intelligence |
| skos:notation | 2.5, 4 |