@prefix activity: <https://knobit.org/id/activity/> .
@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix owl: <http://www.w3.org/2002/07/owl#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .

<https://knobit.org/id/competence/dw-bi> a edu:Competence ;
    rdfs:label "Data warehousing and business intelligence"@en,
        "Andmeladu ja ärianalüütika"@et ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    rdfs:comment "Data 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 ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/competence/dw-bi> ;
    edu:consistsOf activity:WO-1,
        activity:WO-2,
        activity:WO-3,
        activity:WO-4,
        activity:WO-5 ;
    edu:relatedTopic <https://knobit.org/id/topic/dmbok2-dw-bi> .

edu:Competence rdfs:label "Competence"@en,
        "Pädevus"@et .

activity:WO-1 rdfs:label "Capture BI requirements"@en,
        "Ärianalüütika nõuete kogumine"@et .

activity:WO-2 rdfs:label "Define metrics and KPIs"@en,
        "Mõõdikute ja võtmetulemusnäitajate määratlemine"@et .

activity:WO-3 rdfs:label "Design the bus matrix and data products"@en,
        "Siinimaatriksi ja andmetoodete kavandamine"@et .

activity:WO-4 rdfs:label "Populate the warehouse and reconcile it"@en,
        "Andmelao laadimine ja vastavuskontroll"@et .

activity:WO-5 rdfs:label "Specify reports and dashboards"@en,
        "Aruannete ja juhtpaneelide spetsifitseerimine"@et .

<https://knobit.org/id/topic/dmbok2-dw-bi> rdfs:label "Data warehousing and business intelligence (DAMA-DMBOK2 chapter 11)"@en,
        "Andmeladu ja ärianalüütika (DAMA-DMBOK2 11. peatükk)"@et .