II.
SkillArea overview
Reference · liveskill-area:data-warehouse-modeling
Data Warehouse Modeling overview
Dimensional modeling, star/snowflake schemas, slowly-changing dimensions, and modern lakehouse table design.
Attributes
displayName
Data Warehouse Modeling
description
Dimensional modeling, star/snowflake schemas, slowly-changing
dimensions, and modern lakehouse table design.
domains
expertiseLevels
- intermediate
- expert
Outgoing edges
applies_to1
- specialization:data-engineering-analytics·Specialization
Incoming edges
lib_requires_skill_area12
- lib-agent:data-engineering-analytics--data-warehouse-architect·LibraryAgentdata-warehouse-architect
- lib-agent:data-engineering-analytics--dbt-project-engineer·LibraryAgentdbt-project-engineer
- lib-agent:data-engineering-analytics--dimensional-modeler·LibraryAgentDimensional Modeler Agent
- lib-agent:data-engineering-analytics--migration-specialist·LibraryAgentMigration Specialist Agent
- lib-agent:software-architecture--data-architect·LibraryAgentdata-architect
- lib-skill:data-engineering-analytics--bi-semantic-layer-generator·LibrarySkillBI Semantic Layer Generator
- lib-skill:data-engineering-analytics--cost-optimizer·LibrarySkillCost Optimizer (Cloud Data Platforms)
- lib-skill:data-engineering-analytics--dbt-project-analyzer·LibrarySkilldbt-project-analyzer
- lib-skill:data-engineering-analytics--dimensional-model-validator·LibrarySkillDimensional Model Validator
- lib-skill:data-engineering-analytics--obt-design-optimizer·LibrarySkillOBT Design Optimizer
- lib-skill:data-engineering-analytics--scd-implementation-generator·LibrarySkillSCD Implementation Generator
- lib-skill:data-engineering-analytics--sql-query-optimizer·LibrarySkillsql-query-optimizer
prerequisite_for_learning2
- skill-area:data-visualization·SkillAreaData Visualization
- skill-area:data-lakehouse-architecture·SkillAreaData Lakehouse Architecture
requires_expertise5
- role:database-administrator·RoleDatabase Administrator
- role:data-engineer·RoleData Engineer
- role:data-architect·RoleData Architect
- role:business-intelligence-analyst·RoleBusiness Intelligence Analyst
- role:chief-data-officer·RoleChief Data Officer
requires_skill_area14
- stack-profile:data-lakehouse·StackProfileData Lakehouse Stack (Databricks, Spark, Delta Lake, dbt, Airflow)
- stack-profile:batch-processing·StackProfileBatch Processing (Airflow + dbt + PostgreSQL + Python + S3)
- stack-profile:data-warehouse-bi·StackProfileData Warehouse / BI Stack (dbt, BigQuery, Metabase/Looker, Python, Airflow)
- stack-profile:real-time-analytics-stack·StackProfileReal-Time Analytics Stack (Kafka, ClickHouse, Grafana, dbt)
- stack-profile:data-lake-stack·StackProfileData Lake Stack (Spark, Object Storage, Delta/Iceberg)
- workflow:self-serve-analytics-enablement·WorkflowSelf-Serve Analytics Enablement
- workflow:end-to-end-customer-journey-audit·WorkflowEnd-to-End Customer Journey Audit
- workflow:data-warehouse-schema-governance·WorkflowData Warehouse Schema Governance
- workflow:data-warehouse-cost-optimization·WorkflowData Warehouse Cost Optimization
- workflow:climate-risk-scenario-analysis·WorkflowClimate Risk Scenario Analysis
- workflow:inventory-optimization-review·WorkflowInventory Optimization Review
- workflow:hotel-revenue-management-review·WorkflowHotel Revenue Management Review
- workflow:scenario-planning-workshop·WorkflowScenario Planning Workshop
- workflow:donor-stewardship-cycle·WorkflowDonor Stewardship Cycle
stack_part_used_by1
- stack-part:data-warehouse·StackPartData Warehouse