With the data warehouse bus matrix as a guide, the business intelligence team can work with representatives from the relevant business teams and project sponsors to complete the following four-step dataset design process:
- Select the business process.
- Declare the grain.
- Identify the dimensions.
- Define the facts.