الطلب
“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.”
جرّب إذنAdd shipment status.Add discount measures.
ما الذي يتضمنه هذا الرسم
اقرأ القرارات الكامنة وراءه.
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.