Name: TechSales Bakutech
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

TechSales Bakutech

This dataset consists of .csv and .pbix files that contain Bakutech sales information. In pbix file, the relational database was built, and various DAX formulas were applied to visualize data, including gross profit margin, net profit margin, most popular product, previous month's order, return on assets, return on equity, total revenue, total quantity sold, and total orders.

Tables

Assets

@kaggle.farhadzeynalli_techsales_bakutech.assets

5.8 kB
1 row
7 columns

CREATE TABLE assets (
  "cash_assets" BIGINT,
  "inventory" BIGINT,
  "equipment" BIGINT,
  "accounts_receivable" BIGINT,
  "total_assets" BIGINT,
  "shareholder_equity" BIGINT,
  "total_liabilities" BIGINT
);

Customer Lookup

@kaggle.farhadzeynalli_techsales_bakutech.customer_lookup

24.5 kB
2,000 rows
8 columns

CREATE TABLE customer_lookup (
  "customer_id" BIGINT,
  "name" VARCHAR,
  "surname" VARCHAR,
  "email" VARCHAR,
  "age" BIGINT,
  "education" VARCHAR,
  "city" VARCHAR,
  "marital_status" VARCHAR
);

Dates

@kaggle.farhadzeynalli_techsales_bakutech.dates

5.08 kB
365 rows
2 columns

CREATE TABLE dates (
  "da" TIMESTAMP,
  "e" VARCHAR
);

Product Categories

@kaggle.farhadzeynalli_techsales_bakutech.product_categories

2.45 kB
5 rows
2 columns

CREATE TABLE product_categories (
  "productcategorykey" BIGINT,
  "categoryname" VARCHAR
);

Product Returns

@kaggle.farhadzeynalli_techsales_bakutech.product_returns

7.92 kB
1,000 rows
3 columns

CREATE TABLE product_returns (
  "returndate" TIMESTAMP,
  "productkey" BIGINT,
  "returnquantity" BIGINT
);

Products Lookup

@kaggle.farhadzeynalli_techsales_bakutech.products_lookup

15.25 kB
111 rows
8 columns

CREATE TABLE products_lookup (
  "productkey" BIGINT,
  "productsubcategorykey" BIGINT,
  "productname" VARCHAR,
  "modelname" VARCHAR,
  "productdescription" VARCHAR,
  "productcolor" VARCHAR,
  "productcost" DOUBLE,
  "productprice" DOUBLE
);

Product Subcategories

@kaggle.farhadzeynalli_techsales_bakutech.product_subcategories

3.4 kB
15 rows
3 columns

CREATE TABLE product_subcategories (
  "productsubcategorykey" BIGINT,
  "subcategoryname" VARCHAR,
  "productcategorykey" BIGINT
);

Sales Data

@kaggle.farhadzeynalli_techsales_bakutech.sales_data

122.76 kB
10,000 rows
7 columns

CREATE TABLE sales_data (
  "orderdate" TIMESTAMP,
  "stockdate" TIMESTAMP,
  "ordernumber" BIGINT,
  "productkey" BIGINT,
  "customerkey" BIGINT,
  "orderlineitem" BIGINT,
  "orderquantity" BIGINT
);