3. Tables in Our Dataset

• The Orders table is the main fact table. It contains information about each order, including the order and shipping dates, the customer, store and product IDs for associating with dimension tables, and the amount of each product ordered. Each order in this table consists of an order of a single product type, so there is only one product code per order.

• The Products table contains information about each product sold by the company, including the product code, name, category, cost price, sale price, and weight.

• The Stores table contains information about each store, including the store code, store type, country, region, and address.

• The Customers table contains names and personal details of all customers.