Dataset: Online Sales Data

About this Dataset

Online Sales Data

Within this, I have added 2 datasets for Online Sales Data.
These are helpful to generate dashboards on Power BI.
Orders.csv contains :
Order ID (primary key), Order Date, CustomerName, State, City ->Customer details.
whereas Details.csv contains:
Order ID (primary key) and the details of all the subsequent orders within the Orders.csv ->Order details.

Tables

Details

@kaggle.samruddhi4040_online_sales_data.details

19.27 KB
1500 rows
7 columns


CREATE TABLE details (
  "order_id" VARCHAR,
  "amount" BIGINT,
  "profit" BIGINT,
  "quantity" BIGINT,
  "category" VARCHAR,
  "sub_category" VARCHAR,
  "paymentmode" VARCHAR
);

Orders

@kaggle.samruddhi4040_online_sales_data.orders

12.42 KB
500 rows
5 columns


CREATE TABLE orders (
  "order_id" VARCHAR,
  "order_date" VARCHAR,
  "customername" VARCHAR,
  "state" VARCHAR,
  "city" VARCHAR
);