II.
LibraryProcess overview
Reference · livelib-process:data-engineering-analytics--dimensional-model
dimensional-model overview
Dimensional Model Design - Design comprehensive dimensional data warehouse models including business process selection, grain definition, dimension identification, fact table design, star/snowflake schema patterns, and Slowly Changing Dimension (SCD) implementation following Kimball methodology.
Attributes
displayName
dimensional-model
description
Dimensional Model Design - Design comprehensive dimensional data warehouse models including
business process selection, grain definition, dimension identification, fact table design, star/snowflake
schema patterns, and Slowly Changing Dimension (SCD) implementation following Kimball methodology.
libraryPath
library/specializations/data-engineering-analytics/dimensional-model.js
specialization
data-engineering-analytics
references
- - The Data Warehouse Toolkit (3rd Edition) by Ralph Kimball: https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/ - Kimball Dimensional Modeling Techniques: https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/ - Star Schema: The Complete Reference by Christopher Adamson: https://www.oreilly.com/library/view/star-schema-the/9780071744324/ - Slowly Changing Dimensions: https://en.wikipedia.org/wiki/Slowly_changing_dimension
example
const result = await orchestrate('data-engineering-analytics/dimensional-model', {
projectName: 'Sales Analytics DW',
businessProcesses: ['order_fulfillment', 'customer_service', 'inventory_management'],
dataSource: { type: 'OLTP', database: 'sales_db', schema: 'public' },
requirements: { realTimeUpdates: true, historicalTracking: 'full', queryPerformance: 'high' }
});
usesAgents
- business-analyst
- data-engineer
- data-architect
- data-modeler
- fact-designer
- schema-designer
- scd-architect
- validation-architect
- ddl-generator
- etl-architect
- documentation-specialist
Outgoing edges
lib_applies_to_domain1
- domain:data-engineering·DomainData Engineering
lib_belongs_to_specialization1
- specialization:data-engineering-analytics·Specialization
lib_implements_workflow1
- workflow:data-pipeline-deployment·WorkflowData Pipeline Deployment
uses_agent2
- lib-agent:data-science-ml--data-engineer·LibraryAgentdata-engineer
- lib-agent:software-architecture--data-architect·LibraryAgentdata-architect
Incoming edges
None.