eCommerce Star Schema

This track uses a simplified retail/eCommerce model.

New to dimensional modeling? Read Star Schema Basics first. It explains facts, dimensions, and grain, which this page assumes.

Core entities:

• ecom_customers (dimension)
• ecom_products (dimension)
• ecom_orders (order fact header)
• ecom_order_items (line-level fact)
• ecom_returns (returns fact)

• customers 1->many orders via customer_id
• orders 1->many order_items via order_id
• products 1->many order_items via product_id
• order_items 1->many returns via order_item_id

Continue with:

• Meet the E-commerce Dataset
• Data Quality Audit