Wayfair Business Analyst Interview Questions
The questions to prepare for a Wayfair Business Analyst interview. Questions from real interview reports rank first. Updated weekly.
Calculate month-over-month sales growth for each product category using JOINs and window functions.
WayfairUse joins, a CTE, and aggregation to rank the top 5 products by non-returned revenue in the last 30 days.
WayfairUse a CTE and ROW_NUMBER to return the top 2 products by revenue within each category from completed orders.
WayfairTests diagnostic thinking, data validation, and root-cause analysis for forecasting issues at Wayfair.
WayfairTests KPI selection, dashboard design, and communication of operational performance to executives at Wayfair.
WayfairSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests time-series anomaly handling and baseline forecasting adjustments for Wayfair demand planning.
WayfairTests approaches to demand forecasting with cold-start data and assumptions for Wayfair’s catalog expansion.
WayfairTests prioritization and metric selection for inventory placement decisions under capacity constraints at Wayfair.
Wayfair