Dataford
Dataford
Top 16
Prep plan
Updated weekly · Last refresh Oct 17

Kepler Group Data Analyst Interview Questions

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

16questions
~2htotal time
Track your progressSign up free to work through all 16 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 4 questions · ~32 min
Calculate CAC From Campaign InputsMedium

Calculate customer acquisition cost from campaign budget, impression cost, and conversion rate.

CACConversion Ratecampaign performanceKepler Group
Diagnose Conversion Drop Post LaunchMedium

Diagnose why conversion fell from 4.8% to 3.1% after a launch by breaking the metric across funnel steps, cohorts, and segments.

Funnel AnalysisConversion RateDiagnosisKepler Group
Attribution With Conflicting DataHard

Tests measurement reasoning and decision-making when attribution signals conflict across channels.

attributioncampaign performanceDiagnosisKepler Group
More Metrics questions with a free account
2
Behavioral & Leadership8 questions · ~64 min
Strategic Recommendation With Incomplete DataMedium

Tests leading through ambiguity in marketing analytics by making a recommendation with incomplete data, clear assumptions, and stakeholder alignment.

Decision MakingOwnershipDealing With AmbiguityKepler Group
More Behavioral & Leadership questions with a free account
3
More topics4 questions · ~32 min
Landing Page Conversion Test DesignMedium

Design a landing-page A/B test with clear metrics, power, and significance criteria while guarding against common experiment pitfalls.

Statistical SignificanceSample SizeA/B TestingKepler Group
Budget Allocation for CampaignsHard

Tests ability to translate analytics into budget strategy across brand and performance objectives.

Kepler Group
Optimizing Large Marketing QueriesMedium

Tests SQL performance tuning and practical approaches to speed up large marketing analytics queries.

Performance TuningindexessqlKepler Group
Transitioning From Third-Party CookiesHard

Tests planning for measurement changes, first-party data strategy, and impact on analytics pipelines.

data integrationKepler Group

Sign up to see every question

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

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Identify Funnel Bottlenecks in OnboardingHard
Practice
Practice drill

Use joins, CTEs, and aggregations to find the weakest step in an onboarding funnel and estimate lost conversions.

Funnel AnalysissqlDiagnosisAtlassianRevolut
Collections Funnel SQL AnalysisMedium
Practice
Practice drill

Calculate collections funnel conversion rates and drop-off counts between sequential stages using PostgreSQL aggregations and window functions.

Funnel AnalysisLag/LeadConversion RateTrueaccord
Sales Funnel SQL AnalysisMedium
Practice
Practice drill

Calculate Synthesia funnel stage counts, conversion rates, and drop-off percentages using aggregation and window functions.

Funnel AnalysisJoinsConversion RateSynthesia
The finish line: interview-readyComplete all 16 questions plus 3 hands-on drills to finish this plan.