Supply Chain Snowflake Schema

Supply chain snowflake schema

This supply chain snowflake schema stores shipment measures in FactShipment. Each shipment links to a date, product, warehouse and carrier, then records units shipped and freight cost. Product rolls into category and department. Warehouse rolls into city and region. Those normalized hierarchies let operations teams analyse volume and cost by product department, carrier or warehouse region while maintaining common hierarchy values in one place. It is a useful pattern when logistics reporting combines transactional shipment data with shared master-data structures. It supports common rollups even when warehouse and product master data are maintained by different operational teams. Shared dimensions also improve comparisons across sites, carriers and product portfolios over time.

유형 ERD표준 Chen 1976 / Everest 1976 (crow's foot)엔진 schematex-erd업데이트됨 2026. 9. 24.

요청 내용

“A supply chain snowflake schema: FactShipment linked to Date, Product, Warehouse, and Carrier; normalize Product through Category to Department and Warehouse through City to Region.”

그렇다면Add a customer dimension to shipmentsAdd a carrier service-level table

이 도면에 담긴 내용

그 이면의 의사결정을 읽어 보세요.

01Shipment grain

Store one row per shipment.

02Product hierarchy

Separate category and department.

03Warehouse geography

Normalize warehouse location through city and region.

Use this when shipment measures need consistent product and location rollups.

모든 ERD 템플릿 보기 →

자주 묻는 질문

What does FactShipment measure?

It records shipment units and freight cost at the shipment grain.

Why use a carrier dimension?

It enables shipment measures to be grouped by carrier.

Where is warehouse geography stored?

Warehouse links to City, which links to Region.