Steps of data warehouse design process

Question

State the different steps of data warehouse design process.

Answer 1

Steps for designing the data warehouse process are as follows:

a) Select a business process to model.

b) Select the grain of the business process

c) Select dimensions which will apply to every fact table record.

d) Select the measures which will populate every fact table record.