A solicitação
“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.”
Depois, tenteAdd shipment status.Add discount measures.
O que há neste desenho
Entenda as decisões por trás dele.
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.