knobit.org

Data warehousing and business intelligence

edu:Competence

https://knobit.org/id/competence/dw-bi

Also as Turtle · JSON-LD · RDF/XML

consists ofCapture BI requirements
consists ofDefine metrics and KPIs
consists ofDesign the bus matrix and data products
consists ofPopulate the warehouse and reconcile it
consists ofSpecify reports and dashboards
dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
owl:sameAshttps://bitbucket.org/reffa/ontology/id/competence/dw-bi
rdfs:commentData warehousing and business intelligence end to end — BI requirements as decisions and questions, metric and KPI definitions with populations, time semantics, additivity and currency (NPL ratio, net interest margin, cost-to-income, average balances), the enterprise bus matrix and data product catalogue with conformed dimensions, warehouse population controls and reconciliation to the general ledger, and report and dashboard specifications (IBCS) — each deliverable a YAML file gated by an anomaly review checklist. Use it whenever the user mentions BI requirements, a KPI or metric definition, a semantic layer, a bus matrix, conformed dimensions, data marts or data products, warehouse loads, control totals, reconciliation to the GL, a dashboard or report design, chart scaling, or two reports showing different numbers for the same KPI — or hands over a metric catalogue, a bus matrix, a load log or a dashboard spec for review, even if they never say "data warehouse". en
rdfs:labelAndmeladu ja ärianalüütika et
rdfs:labelData warehousing and business intelligence en
related topicData warehousing and business intelligence (DAMA-DMBOK2 chapter 11)

Used by

related learning outcomedw-bi skill (SKILL.md)
related learning outcomeDW/BI file schemas
related learning outcomeTests of the dw-bi skill
requires competenceData warehouse and BI developer