Top 19
Prep plan
Updated weekly · Last refresh Oct 17

Nextdoor Data Analyst Interview Questions

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

19questions
~3htotal time
Track your progressSign up free to work through all 19 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 3 questions · ~26 min
Investigate User Engagement DeclineMedium

Investigate a 15% engagement decline by decomposing the metric, isolating root causes, and proposing actions.

RetentionDiagnosisEngagement MetricsNextdoor
Metrics for Local Ad FeatureMedium

Tests metric design and product analytics thinking for Nextdoor monetization features.

KPIConversion RateEngagement MetricsNextdoor
More Metrics questions with a free account
2
SQL & Data Manipulation5 questions + 2 drills · ~63 min
Top Categories by Postal CodeMedium

Tests SQL window function skills and ability to rank categories by geography on Nextdoor data.

Window FunctionsRankingGroup ByNextdoor
Month-Over-Month Retention QueryHard
Practice

Calculate next-month checking account retention for Chase customers with an online deposit during their first seven days.

sqlNextdoor
Dimensional vs Fact TablesEasy

Tests understanding of dimensional modeling concepts applied to Nextdoor user-generated content data.

fact tablesdimensionsData ModelingNextdoor
7-Day Rolling Active UsersMedium
Practice
Practice drill

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsMetaSpotifyMeta IT
Calculate 30-Day User RetentionHard
Practice
Practice drill

Use CTEs, joins, and date filtering to calculate 30-day retention by signup cohort from login and feature usage data.

Window FunctionsDate FunctionsAggregationsCurefitIndeedTikTok
More SQL & Data Manipulation questions with a free account

Sign up to see every question

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

Get my prep plan
3
Pipelines5 questions · ~43 min
Self-Serve Finance Revenue ModelHard

Tests data modeling for self-serve analytics and usability for non-technical stakeholders.

Data ModelingNextdoor
Version Control and Code Review for PipelinesMedium

Tests engineering process discipline for reliable, maintainable analytics pipelines.

version controlAutomationNextdoor
More Pipelines questions with a free account
4
Behavioral & Leadership5 questions · ~43 min
More Behavioral & Leadership questions with a free account
5
More topics1 question · ~9 min
Experiment for Notification SystemMedium

Tests experimental design, measurement, and success criteria for Nextdoor engagement changes.

experiment designGuardrail Metricsprimary metricsNextdoor
The finish line: interview-readyComplete all 19 questions plus 2 hands-on drills to finish this plan.