La richiesta
“Create an e-commerce gold-layer star schema with DimDate, DimCustomer, DimProduct, DimPaymentType, and FactOrder tables, the shown keys, attributes, and order measures, with facts linked to customer, product, date, and payment type dimensions.”
Prova alloraAdd shipment status.Add discount measures.
Cosa contiene questo disegno
Leggi le decisioni che ne stanno alla base.
01
Chose a star schema over snowflake to simplify analytics and improve query performance.
02
Included a date dimension to enable time-based analysis on orders.
03
Used mandatory relationships to ensure referential integrity in the gold layer.
When designing a data warehouse for e-commerce order analytics with a focus on ease of use and performance.