Data Warehouse design - 9140

Request Posted by


Rating : No Rating
  • Requests:0
  • Solutions:0
Earned: $0
Request Detail
Price: $30
  • From: Computer Science, Programming
  • Due on: Tue 24 Apr, 2012 (02:46am)
  • Asked on: Tue 24 Apr, 2012
  • Due date has passed, but you can still Post Solution.

You are design a dimensional model for your data warehouse to answer a set of the questions regarding your retail chain stores sells, supply, and customer loyalty information. The following are some of the sample questions you can use.

1. Sells revenue by stores
2. Sells revenue by products
3. Profit margin by stores
4. Profit margin by products
5. Customer total value as a function of dollar amount spent
6. Frequency of purchase and returns by a customer in a quarter

Please come up at least 3 more measures in addition to the 6 listed above and produce a set of fact tables and dimension tables to answer those questions. Please use Word file if you need to show your table layout 

1 Solution for Data Warehouse design
Title Price Category solution By purchased  
Data Warehouse design
$30.00 no category praveen0201 0 time(s)
Please Login or Register to Submit the Solution for the Request