Scenario: Star vs Snowflake for Self-Serve BI

BI team needs fast ad-hoc queries with moderate model complexity. Choose star or snowflake and justify with one performance trade-off.

fact_sales + dimensions (date, product, customer, region)