הבקשה
“A retail sales star schema with a Sales fact table linked to Date, Product, Store, and Customer dimensions, storing quantity and sales amount.”
ואז נסוAdd a promotion dimension to SalesAdd a sales channel dimension
מה מופיע בתרשים הזה
פענחו את ההחלטות שמאחוריו.
01
Use a star schema with a single fact table containing foreign keys to each dimension and additive measures.
02
Each dimension table is denormalized with descriptive attributes.
03
Relationships from fact to dimensions are many-to-one (many sales per dimension row).
When building a data mart for retail sales analytics, where queries involve aggregating measures by dimension attributes.