La solicitud
“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.”
Entonces pruebaAdd shipment status.Add discount measures.
Qué hay en este dibujo
Lee las decisiones que hay detrás.
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.