Name: SalesDataAnalysis
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

SalesDataAnalysis

-In this dataset, the language was in France so I converted or mapped some col and its values to English
-There are no null values or duplicates in it
-I extract years in which sales have increased or decreased like the number of products purchase
-I also extract or split city from the address column
-I also handle a maximum number of unique values into small segments unique values
-Then I do EDA and feature engineering

Tables

Sales Data

@kaggle.aemyjutt_salesdata.sales_data

7.04 MB
185,950 rows
11 columns

CREATE TABLE sales_data (
  "order_date" TIMESTAMP,
  "order_id" BIGINT,
  "product" VARCHAR,
  "product_ean" DOUBLE,
  "cat_gorie" VARCHAR,
  "purchase_address" VARCHAR,
  "quantity_ordered" BIGINT,
  "price_each" DOUBLE,
  "cost_price" DOUBLE,
  "turnover" DOUBLE,
  "margin" DOUBLE
);