概述
数据仓库模型设计工作流是一个高级难度的工作流。为数据仓库设计维度模型，包含事实表和维度表，优化分析查询。该工作流的目标是：Design a star schema data warehouse model for efficient analytics.
环境准备
执行本工作流需要以下环境：Source data and business requirements；A data warehouse platform；Understanding of dimensional modeling。请确保在开始前准备好所有必需的工具和资源，以避免中途因环境问题中断。
执行步骤
本工作流包含5个步骤。步骤1：Identify facts——Determine the business processes that need measurement (sales, clicks, shipments). 步骤2：Identify dimensions——Define the descriptive attributes for each fact (time, product, customer, geography). 步骤3：Choose grain——Select the most granular level of data for each fact table. 步骤4：Design keys——Choose between surrogate and natural keys for dimension tables. 步骤5：Validate with queries——Test the model against representative analytical queries for performance and simplicity.
验证与清理
预期结果：A dimensional data warehouse model is designed and validated against business requirements.。验证方法：Run representative queries against the model and confirm they return correct results with good performance.。清理操作：Revise the model if queries are slow or do not match business requirements.。estimatedMinutes 为 180 分钟。
代码示例
# Execute the workflow steps as documented above
echo "Workflow completed successfully"