Sales performance dashboard
Help a fictional retailer understand which products and regions changed sales.
- Sample inputs
- Synthetic orders with order ID, date, region, product, quantity, price and refund status.
- Your tasks
- Define net sales, clean duplicates, aggregate by period and build filters with a concise findings memo.
- What to deliver
- A dashboard, calculation dictionary and reconciliation sheet.
- Quality checks
- A duplicated order must not increase totals; refunded orders and incomplete periods need explicit treatment.
- Interview discussion
- Explain why growth in revenue may not imply growth in profit.