Question

You are building a sales star schema in a Fabric warehouse. Source data contains one row per order line item, including OrderID, OrderLineID, ProductKey, CustomerKey, OrderDate, Quantity, and LineAmount. Business users need to analyze revenue by product, customer, and date, and must also be able to count distinct orders. What is the most appropriate grain for the sales fact table?

Accepted Answer

One row per order line item, storing OrderID as a degenerate dimension

Answer

One row per order, summing LineAmount and concatenating ProductKeys into a single column

Answer

One row per product per day, aggregating Quantity and LineAmount across all customers

Answer

One row per customer, storing total lifetime LineAmount as a single measure