Baselight

SalesDataAnalysis

"Uncovering Profitable Insights: Navigating Sales Data for Strategic Growth"

@kaggle.aemyjutt_salesdata

Loading...
Loading...

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
  • 6.72 MB
  • 185950 rows
  • 11 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.