Dataset: Fictional Sales Data

About this Dataset

Fictional Sales Data

The purpose of this fictional sales dataset is to provide data for Data Analysis practice. The 3 tables must be joined before one can analyze the data.

This fictional data set consists of 3 tables:

Customer dimension (history preserving)
Product dimension (history preserving)
Sales Transactions

The Customer Dimension dataset includes unique customer IDs, addresses, ages, and indicators of current records, with effective start and end dates for each customer.

The Product Dimension dataset details unique product IDs, names, prices, and their validity periods, along with indicators of current price records.

The Sales Transactions dataset captures sales activities with unique order IDs, product IDs, customer IDs, quantities sold, and order dates. Together, these datasets offer a comprehensive view of customer demographics, product pricing history, and sales transactions.

Tables

Customer Dim

@kaggle.teluskiman_fictional_sales_data.customer_dim

2.41 MB
140787 rows
6 columns


CREATE TABLE customer_dim (
  "cust_id" BIGINT,
  "cust_address" VARCHAR,
  "cust_age" BIGINT,
  "effective_start_date" TIMESTAMP,
  "effective_end_date" VARCHAR,
  "current_ind" VARCHAR
);

Product Dim

@kaggle.teluskiman_fictional_sales_data.product_dim

6.28 KB
121 rows
6 columns


CREATE TABLE product_dim (
  "product_id" BIGINT,
  "product_name" VARCHAR,
  "product_price" DOUBLE,
  "effective_start_date" TIMESTAMP,
  "effective_end_date" VARCHAR,
  "current_ind" VARCHAR
);

Sales Transactions

@kaggle.teluskiman_fictional_sales_data.sales_transactions

2.13 MB
185950 rows
5 columns


CREATE TABLE sales_transactions (
  "order_id" BIGINT,
  "product_id" BIGINT,
  "cust_id" BIGINT,
  "product_quantity" BIGINT,
  "order_date" TIMESTAMP
);