Top 7
Prep plan
Updated weekly · Last refresh Sep 22

Areli Data Analyst Interview Questions

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

7questions
~1htotal time
Track your progressSign up free to work through all 7 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 1 drill · ~44 min
7-Day Rolling Active UsersMedium
Practice

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

Window FunctionsDate FunctionsRunning TotalsAreli
Top 3 Products Per RegionMedium
Practice

Rank Abbott medical device products by regional unit sales using joins, aggregation, date filtering, and ROW_NUMBER().

JoinsRankingAggregationsAreli
Optimize Slow Locked QueryHard

Tests query optimization skills and ability to reduce contention in production databases.

SubqueriesData WranglingCTEsAreli
Top Credit Score Applicants by StateMedium
Practice
Practice drill

Identify the highest-credit-score 5% of applicants within each state using percentiles and window ranking.

Window FunctionsJoinsRankingAmerican Credit Acceptance
2
More topics4 questions · ~46 min
Experiment for New Subscription TierHard

Tests experimental design and statistical thinking for product decisions at Areli.

ExperimentationStatistical SignificanceA/B TestingAreli
Visualize Onboarding FunnelMedium

Tests funnel modeling and visualization choices to diagnose onboarding drop-offs.

Funnel AnalysisConversion RateLeading IndicatorsAreli
Measure Success of Support PortalMedium

Tests product analytics metrics selection and measurement strategy.

User NeedsValue PropositionUse CasesAreli
Investigate 15% Weekly Active DropHard

Tests structured metrics debugging and root-cause analysis using data.

RetentionLeading IndicatorsDiagnosisAreli

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 7 questions plus 1 hands-on drill to finish this plan.