Weekly Question: 16 October

Assume that you have been asked to design a data mart for Amazon to capture sales data. List a unique aspect that you wish to study and the associated dimensions (try and limit yourself to 3 dimensions). Additionally list the level of granularity that you would choose in order to make the exercise useful.

For example, you could be interested in sales of different products by different types of shipment among different weeks (to see if people order gifts at the last minute and have to rush ship them). In this case, the associated dimensions would be products, shipping and time.

The level of granularity of time could be week.