Design an e-commerce data warehouse for a nationwide chain of superstores of
Bangladesh. There are many suppliers for the chain shop. The suppliers has sup-
id, name, type of products to supply (clothes, machineries, food etc. ), address
(street, city, district). The chain shops serve the customers physically from the
superstores and each superstore has its own system for all kinds of transactions
(sale, procurement from the suppliers etc.). There are registered customers and
each customer has customer id, name, NID, address (House no., street, thana,
city, district, division and age-group. A customer can purchase many items in a
single transaction with transaction id, transaction type (cash or card), timestamp
id, time of the day, day of the week, date, week, month, year, quantity, unit price
and total price. Each item has an item id, name, type, country of manufacture.
You have to design and implement a warehouse for this chain of superstores to
support the policy decision process and knowledge discovery. The following reports
will be generated from the warehouse.
Task 1: Design the architecture of the warehouse and explain the sources,
preprocessing, noise reduction, transformation and uploading.