The facts represent the numeric columns to be included in the fact table. While the dimension columns from step 3 will be used for relationships to dimension tables, the fact columns will be used in measures containing aggregation logic such as the sum of a quantity column and the average of a price column:
- Define the business logic for each fact that will be represented by measures in the dataset:
- For example, gross sales is equal to the extended amount on a sales order, and net sales is equal to gross sales minus discounts
- Any existing documentation or relevant technical metadata should be reviewed and validated
- Similar to the dimensions, any conflicts between existing definitions should be addressed so that a single ...