Preparing chapter
Loading your data design lesson
The curriculum shell is ready while the requested chapter is being prepared. You can wait here or return to the design library.
Preparing chapter
The curriculum shell is ready while the requested chapter is being prepared. You can wait here or return to the design library.
Amazon · Big Data Engineering · Explicit grains, historical context, reusable joins
Connect Amazon-like customers, products, SKUs, offers, sellers, promotions, locations, carriers, and dates to order-item, payment, inventory, shipment, return, and behavior facts without mixing incompatible grains.
01 · Commerce analytical model
Hover, focus, or tap any table to highlight its warehouse joins and explain its exact row grain, contents, source, and Amazon use.
Fact table explanation
One row means
One row per accepted order item.
Key contents
order_item_id, order_id, customer/product/SKU/seller/offer keys, quantities, list/selling price, discounts, tax, shipping, net amount, status.
How Amazon uses it
Anchors units, GMV, discounts, seller attribution, fulfillment, cancellation, and return analysis at the marketplace’s most reusable sales grain.
Created from
Accepted order-item events reconciled with committed price, offer, promotion, seller, and lifecycle evidence.
Transaction facts
Immutable business events: order items, payments, movements, returns, and impressions.
Accumulating lifecycle
A rebuildable milestone view for a known journey such as place → ship → deliver.
Periodic snapshot
A semi-additive point-in-time view for fast inventory trend and risk analysis.
