Four step dimensional design process

中英对照 Fundamental Concepts Kimball Group 官网公开资料（Dimensional Modeling Techniques Glossary）原文出处 ↗ 本文 .md

Four step dimensional design process

四步维度设计流程

The four key decisions made during the design of a dimensional model include:

设计维度模型时需要做出的四个关键决策包括：

Select the business process.
Declare the grain.
Identify the dimensions.
Identify the facts.

选择业务过程。
声明粒度。
确定维度。
确定事实。

The answers to these questions are determined by considering the needs of the business along with the realities of the underlying source data during the collaborative modeling sessions. Following the business process, grain, dimension, and fact declarations, the design team determines the table and column names, sample domain values, and business rules. Business data governance representatives must participate in this detailed design activity to ensure business buy-in.

这些问题的答案，需要在协作式建模会议中，结合业务的需求与底层源数据的现实来确定。在完成业务过程、粒度、维度和事实的声明之后，设计团队再确定表名与列名、示例域值以及业务规则。业务数据治理代表必须参与这一详细设计环节，以确保业务方的认可与支持。