Question

iKiwi wants to be able to analyse sales information from all its stores so that any opportunities to increase revenue can be identified and acted on. They also want to be able to track product returns for quality control purposes. You are the Chief Knowledge Officer and have been asked to create two Data Warehouses:

1. Create a Data Warehouse schema (with one central table and at least four lookup tables) that iKiwi can use to monitor sales performance. Provide some context for your schema. 2. Create another Data Warehouse schema (with one central table and at least four lookup tables) to monitor products returned by customers. Provide some context for your schema.

Answer 1

1. Create a Data Warehouse schema (with one central table and at least four lookup tables) that iKiwi can use to monitor sales performance. Provide some context for your schema.

Context of the scema - Let iKiwi be a super market chain selling different products and having stores at different locations of the country. The knowledge offices could use this datawarehouse schema to analyze the sales of various products purchased by different customers.The sales of various branches and the peak time or season of sales could also be analyzed.

2. Create another Data Warehouse schema (with one central table and at least four lookup tables) to monitor products returned by customers. Provide some context for your schema.

Context of the scema - Let iKiwi be a super market chain selling different products and having stores at different locations of the country. The knowledge offices could use this datawarehouse schema to analyze the products returned by different customers and the reason for returning it. Also he could analyse which branch has the highest rate of returning goods and during which time there was a peak in returning of goods. The schema in Question 1 is modified and is given below.