Product Dataset
Group Category: Dataset
Product Category: Database Design & Development
Sub Category: PostgreSQL
Track product trends, optimize inventory, and uncover sales insights with structured, SQL-ready datasets.
Business Overview:
The Product Performance Dataset offers a clean, relational view of product, subcategory, and category-level information designed to support e-commerce and retail data projects. Perfect for data analysts, BI professionals, and engineers, this PostgreSQL-compatible dataset helps you model real-world retail structures, monitor stock levels, and analyze product categorization patterns — all without synthetic noise or irrelevant features.
Product Highlights:
- Structured and interrelated CSV datasets (
products.csv,subcategories.csv,categories.csv) ready for SQL querying - Field-level data dictionary included for every table to support quick understanding and modeling
- Designed for practicing SQL joins, aggregations, filtering, and hierarchical data exploration
- Ideal for building retail dashboards, analytical prototypes, or data pipeline proofs-of-concept
- Clean, production-style schema modeled after real-world e-commerce catalogs
Learning Outcomes:
By working with this dataset, you will:
- Practice writing advanced SQL queries across normalized retail tables
- Analyze product categorization and inventory spread using filtering and aggregation
- Explore schema design patterns in sales and product domains
- Simulate BI use cases like inventory analysis, category performance, and stock distribution
- Prepare for real-world roles involving retail analytics, data engineering, and BI reporting
subcategories
| CSVLists subcategories under each product category, providing mid-level grouping for product classification.
Supports hierarchical navigation and filtering within the catalog structure.
Key Features:
- 68 unique subcategories
- Includes category linkage and descriptive metadata
- Enables faceted search, classification logic, and category-level rollups
products
| CSVContains detailed product-level data including identifiers, descriptions, pricing, stock levels, and subcategory associations.
This file supports inventory management, pricing analysis, and catalog optimization use cases.
Key Features:
- 965 product records with pricing and inventory
- Direct linkage to subcategories via foreign key
- Ideal for performing product segmentation, stock analysis, or listing operations
categories
| CSVCaptures top-level product groupings with general descriptions. Serves as the parent layer for subcategories and products.
Useful for high-level analysis, KPI tracking by department, and product tree structuring.
Key Features:
- 10 main product categories
- Forms the root hierarchy for the catalog schema
- Can be used to generate filters, summary views, or landing pages by category
Dataset Document
| PDFThis document outlines the structure and use cases of a retail product catalog dataset designed for e-commerce and analytics applications.
It explains the schema and metadata of three interrelated tables: products, subcategories, and categories.
Ideal for users aiming to understand the dataset structure before performing analysis or building data pipelines.
Highlights:
- Defines column-level metadata across all three CSVs
- Offers real-world possibilities including BI dashboards, product search logic, and ETL pipelines
- Suitable for database architects, business analysts, and data engineers
$1.50 $1.00 33% OFF
About this Dataset:
Similar Products
Read All The Top User Reviews
Loading ratings and reviews...
No reviews yet
Be the first to review this product!
Error loading reviews
Please try refreshing the page.