Company Focus

Spotify Interview Problems (30)

Problems reported from Spotify data science interviews

Status Title Difficulty
Average Rating Per Product Category Pro Easy
Count Orders Per Customer Free Easy
Defining a KPI for a Subscription Business Free Easy
Group By and Aggregate Pro Easy
Monthly Signups with Date Truncation Pro Easy
Unlock all 30+ problems
Silhouette Score Interpretation Pro Easy
Simple CASE WHEN Classification Pro Easy
Subscription Renewal Dates Pro Easy
Sum and Average by Category Pro Easy
Calculating Required Sample Size Pro Medium
Unlock all 30+ problems
Churn Prediction Approach Pro Medium
Cohen's d Effect Size Pro Medium
Conditional Aggregation with CASE Pro Medium
Customers Who Ordered Every Product Category Pro Medium
Data Storytelling Pro Medium
Unlock all 30+ problems
Group By with HAVING on MIN/MAX Pro Medium
Multiple Aggregations with HAVING Pro Medium
Pivot Table Pro Medium
t-SNE vs PCA for Visualization Pro Medium
3-Row Moving Average of Daily Signups Pro Hard
Unlock all 30+ problems
Beta Distribution Applications Pro Hard
CASE WHEN for Dynamic Sorting and Bucketing Pro Hard
Cohort Retention Rate With CTEs Pro Hard
Collaborative Filtering Cold Start Pro Hard
Grouping with Rollup-style Totals Pro Hard
Unlock all 30+ problems
Show 25 50 100 per page