Dataset: Mexico Toy Sales

About this Dataset

Mexico Toy Sales

Sales & inventory data for a fictitious chain of toy stores in Mexico called Maven Toys, including information about products, stores, daily sales transactions, and current inventory levels at each location.

Recommended Analysis
Which product categories drive the biggest profits? Is this the same across store locations?

Can you find any seasonal trends or patterns in the sales data?

Are sales being lost with out-of-stock products at certain locations?

How much money is tied up in inventory at the toy stores? How long will it last?

Tables

Inventory

@kaggle.mysarahmadbhat_toy_sales.inventory

5.32 KB
1593 rows
3 columns


CREATE TABLE inventory (
  "store_id" BIGINT,
  "product_id" BIGINT,
  "stock_on_hand" BIGINT
);

Products

@kaggle.mysarahmadbhat_toy_sales.products

5.06 KB
35 rows
5 columns


CREATE TABLE products (
  "product_id" BIGINT,
  "product_name" VARCHAR,
  "product_category" VARCHAR,
  "product_cost" VARCHAR,
  "product_price" VARCHAR
);

Sales

@kaggle.mysarahmadbhat_toy_sales.sales

4.87 MB
829262 rows
5 columns


CREATE TABLE sales (
  "sale_id" BIGINT,
  "date" TIMESTAMP,
  "store_id" BIGINT,
  "product_id" BIGINT,
  "units" BIGINT
);

Stores

@kaggle.mysarahmadbhat_toy_sales.stores

5.85 KB
50 rows
5 columns


CREATE TABLE stores (
  "store_id" BIGINT,
  "store_name" VARCHAR,
  "store_city" VARCHAR,
  "store_location" VARCHAR,
  "store_open_date" TIMESTAMP
);