Apple Retail transaction data supports reporting on sales, discounts, stores, products, and customer behavior. Interviewers ask this to evaluate whether you can translate operational retail data into an analytics-friendly warehouse design.
Explain how you would design a data warehouse schema for Apple Retail transactions. Your answer should cover:
Keep the discussion practical and warehouse-focused rather than application-focused. The interviewer expects a clear dimensional model, tradeoffs between star and snowflake approaches, and how the schema enables common SQL analysis such as revenue by store, product performance, and customer purchase trends.