🧪
Knowledge Challenge
A friend thinks you can answer this question about Star Schema Design
An analyst notices that the 'orders' fact table has one row per order, but the dashboard that needs to show revenue by product line is double-counting orders that contain multiple line items. The data team's first instinct is to filter the dashboard. What is the underlying root cause and the right fix?