The data warehouse has to allow analyzing the company's situation at least with respect to the Furniture , Customer and Time. More ever, the company needs to analyses: The furniture with respect to its type category and material. The customer with respect to their spatial location, by considering at least cities, regions and states. The company is interested in learning the quantity, income and discount of its sales

Dimensional model is used to analyze data/business facts with respect to business dimensions example customers, products, etc.

DW for furniture company.

Dimensions:

1. Furniture : type, category, material.

2. Customer : Name, street, city, state, min.

3. Time : date, day of week, day of month, week, month, quarter, half year.

Facts :

Quantity, income and % discount.