{
  "id": "skill-area:data-warehouse-modeling",
  "_kind": "SkillArea",
  "_file": "domain/skill-areas/skill-areas-data-eng.yaml",
  "_cluster": "domain",
  "attributes": {
    "displayName": "Data Warehouse Modeling",
    "description": "Dimensional modeling, star/snowflake schemas, slowly-changing\ndimensions, and modern lakehouse table design.\n",
    "domains": [
      "specialization:data-engineering-analytics"
    ],
    "expertiseLevels": [
      "intermediate",
      "expert"
    ]
  },
  "outgoingEdges": [
    {
      "from": "skill-area:data-warehouse-modeling",
      "to": "specialization:data-engineering-analytics",
      "kind": "applies_to",
      "attributes": {
        "confidence": "primary"
      }
    }
  ],
  "incomingEdges": [
    {
      "from": "skill-area:data-visualization",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "prerequisite_for_learning",
      "attributes": {
        "strength": "helpful"
      }
    },
    {
      "from": "skill-area:data-lakehouse-architecture",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "prerequisite_for_learning",
      "attributes": {
        "strength": "helpful"
      }
    },
    {
      "from": "stack-part:data-warehouse",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "stack_part_used_by",
      "attributes": {}
    },
    {
      "from": "stack-profile:data-lakehouse",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_skill_area"
    },
    {
      "from": "stack-profile:batch-processing",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_skill_area"
    },
    {
      "from": "stack-profile:data-warehouse-bi",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_skill_area"
    },
    {
      "from": "stack-profile:real-time-analytics-stack",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_skill_area"
    },
    {
      "from": "stack-profile:data-lake-stack",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_skill_area"
    },
    {
      "from": "lib-agent:data-engineering-analytics--data-warehouse-architect",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-agent:data-engineering-analytics--dbt-project-engineer",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-agent:data-engineering-analytics--dimensional-modeler",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-agent:data-engineering-analytics--migration-specialist",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-agent:software-architecture--data-architect",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-skill:data-engineering-analytics--bi-semantic-layer-generator",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-skill:data-engineering-analytics--cost-optimizer",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-skill:data-engineering-analytics--dbt-project-analyzer",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-skill:data-engineering-analytics--dimensional-model-validator",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-skill:data-engineering-analytics--obt-design-optimizer",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-skill:data-engineering-analytics--scd-implementation-generator",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-skill:data-engineering-analytics--sql-query-optimizer",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "role:database-administrator",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_expertise",
      "attributes": {}
    },
    {
      "from": "role:data-engineer",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_expertise",
      "attributes": {}
    },
    {
      "from": "role:data-architect",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_expertise",
      "attributes": {}
    },
    {
      "from": "role:business-intelligence-analyst",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_expertise",
      "attributes": {}
    },
    {
      "from": "role:chief-data-officer",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_expertise",
      "attributes": {}
    },
    {
      "from": "workflow:self-serve-analytics-enablement",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:end-to-end-customer-journey-audit",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:data-warehouse-schema-governance",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:data-warehouse-cost-optimization",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:climate-risk-scenario-analysis",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:inventory-optimization-review",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:hotel-revenue-management-review",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:scenario-planning-workshop",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:donor-stewardship-cycle",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_skill_area",
      "attributes": {}
    }
  ]
}