Top 27

Prep plan

Updated weekly · Last refresh Aug 30

Publicis Sapient Data Analyst Interview Questions

The questions to prepare for a Publicis Sapient Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

27questions

~4htotal time

Track your progressSign up free to work through all 27 questions and resume where you left off.

Start practicing free →

SQL & Data ManipulationStart here. 10 questions + 1 drill · ~99 min

Calculate Monthly Sales Growth by Product CategoryMedium

Practice

Calculate month-over-month sales growth for each product category using JOINs and window functions.

JoinsAggregations

Publicis Sapient

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 FunctionsAggregations

Publicis Sapient

Rolling 7-Day Revenue in SQLMedium

Practice

Practice drill

Calculate each active user's rolling seven-day revenue average with daily aggregation and window functions.

Window FunctionsDate FunctionsRunning Totals

Publicis Sapient

Ernst & Young Oman

More SQL & Data Manipulation questions with a free account

Metrics10 questions · ~89 min

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 RateDiagnosis

Publicis Sapient

Investigate User Engagement DeclineMedium

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

RetentionDiagnosisEngagement Metrics

Publicis Sapient

More Metrics questions with a free account

More topics7 questions · ~62 min

Real-Time Dashboard Pipeline DesignHard

Approach for building near-real-time dashboard pipelines with streaming, orchestration, and data quality controls.

Stream ProcessingSchedulingDependencies

Publicis Sapient

Experiment for Skewed DataHard

Tests experimental design and statistical reasoning for skewed data distributions.

ExperimentationStatistical SignificanceA/B Testing

Publicis Sapient

Personalizing Retail ExperiencesHard

Tests your approach to using data to drive personalization outcomes for a retail client.

User SegmentsUser NeedsValue Proposition

Publicis Sapient

Hypothesis-Driven Problem SolvingMedium

Tests structured thinking and ability to translate business questions into testable hypotheses.

User NeedsValue PropositionUse Cases

Publicis Sapient

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 27 questions plus 1 hands-on drill to finish this plan.