Top 32
Prep plan
Updated weekly · Last refresh Sep 24

Perk Data Analyst Interview Questions

The questions to prepare for a Perk Data Analyst interview. Questions from real interview reports rank first. Updated daily.

32questions
~4htotal time
Track your progressSign up free to work through all 32 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 9 questions + 2 drills · ~95 min
Monthly Active User Growth by PlatformMedium
Practice

Use joins, CTEs, and monthly aggregation to compute Google Maps active users and month-over-month growth.

Window FunctionsDate FunctionsAggregationsPerk
Explain SQL Join TypesEasy

Explain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.

JoinsData WranglingGroup ByPerk
Validating Data Before ReportingEasy

Explain how to validate SQL data before reporting, including null checks, duplicates, outliers, and aggregation reconciliation.

JoinsData WranglingQualityPerk
Top Daily Rides by VehicleMedium
Practice
Practice drill

Rank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.

Window FunctionsJoinsData WranglingWaymoCruise
Handling Large DatasetsMedium
Practice
Practice drill

Summarize processed records by category and return the three categories with the highest record counts.

large datasetsJoinsData WranglingPlaidQuantifind
More SQL & Data Manipulation questions with a free account
2
Product Sense3 questions · ~25 min
Using Data to Influence DecisionsEasy

Share how you used data to shape a business decision, including the analysis, recommendation, and outcome.

User ResearchUser NeedsValue PropositionPerk
Investigating a Conversion DropHard

Evaluates your debugging and analytical reasoning for diagnosing product metric regressions.

Conversion RateData AnalysisPerk
Dashboard for Feature HealthMedium

Tests your ability to translate product goals into actionable monitoring metrics and dashboard design.

monitoringdashboard designPerk

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership18 questions · ~151 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~17 min
COVID KPI SelectionMedium

Evaluates your ability to choose relevant KPIs under changing business conditions and constraints.

KPIsPerk
Success Metrics for Booking IncentivesMedium

Tests your ability to define measurable outcomes and select relevant metrics for product experiments.

MetricsPerk
The finish line: interview-readyComplete all 32 questions plus 2 hands-on drills to finish this plan.