The Supermarket sales dataset encompasses comprehensive information pertaining to

customers, products, and specific attributes of each customer transaction. Below is an

enumeration of the variables encapsulated within our dataset for each transaction:

Order Number $-$ A unique identifier assigned to each order.

Order Date $-$ The date on which the order was placed.

Customer Name $-$ The name of the customer who initiated the order.

Shipment Date $-$ The date on which the order was dispatched to the customer.

Retail Price $-$ The unit price of the product sold.

Order Quantity $-$ The quantity of products ordered in a single transaction.

Tax $-$ The tax amount, calculated as a percentage of the purchase price, remitted to

the government.

Total $-$ The aggregate amount paid by the customer, inclusive of tax.

Process

The dataset is in XLSX format attached with two worksheets, one is the Input Data

sheet which consists of $528$ rows with columns: date, product ID$,$ quantity, sale type,

payment mode, and discount. The Master Data worksheet consists of the

specifications of each product. The data is already cleaned no further data cleaning

was done