TechSales Bakutech by Kaggle | Other

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

Product Subcategories

@kaggle.farhadzeynalli_techsales_bakutech.product_subcategories

3.32 KB
15 rows
3 columns


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

Customer Lookup

@kaggle.farhadzeynalli_techsales_bakutech.customer_lookup

23.92 KB
2000 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
);

Product Returns

@kaggle.farhadzeynalli_techsales_bakutech.product_returns

7.74 KB
1000 rows
3 columns


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

Product Categories

@kaggle.farhadzeynalli_techsales_bakutech.product_categories

2.39 KB
5 rows
2 columns


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

Dates

@kaggle.farhadzeynalli_techsales_bakutech.dates

4.96 KB
365 rows
2 columns


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

Products Lookup

@kaggle.farhadzeynalli_techsales_bakutech.products_lookup

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

Assets

@kaggle.farhadzeynalli_techsales_bakutech.assets

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

Sales Data

@kaggle.farhadzeynalli_techsales_bakutech.sales_data

119.88 KB
10000 rows
7 columns


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