Dataford
Top 50
Prep plan
Updated weekly · Last refresh Aug 30

Publicis Groupe Holdings B.V Data Analyst Interview Questions

The questions to prepare for a Publicis Groupe Holdings B.V Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 4 questions · ~32 min
Backfilling Missing Pipeline DataMedium

Approach for safely backfilling missing data while preserving correctness, idempotency, and data quality.

ETLQualityPublicis Groupe Holdings B.V
More Pipelines questions with a free account
2
SQL & Data Manipulation10 questions + 3 drills · ~110 min
Marketing Attribution Query WalkthroughHard

Explain a multi-CTE attribution query using joins, CASE logic, and window functions to assign Salesforce campaign credit.

Window FunctionsJoinsAggregationsPublicis Groupe Holdings B.V
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
Weekly Service KPI by TeamMedium
Practice
Practice drill

Analyze weekly service delivery performance by team using joins, a CTE, date aggregation, and KPI calculations.

KPIJoinssqlDeloitteReputation
Advanced SQL With PartitionsHard
Practice
Practice drill

Use CTEs, aggregations, and window functions to compare gender pay and find each department's second-highest salary.

Window FunctionsJoinssqlMeesho
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
Metrics10 questions · ~80 min
Leading vs Lagging Campaign SignalsEasy

Distinguish early campaign signals from outcome metrics and explain how each should guide decisions.

Lagging IndicatorsLeading IndicatorsDiagnosisPublicis Groupe Holdings B.V
Healthy Programmatic Campaign KPIsEasy
Recently asked

Identify the core KPIs that show whether a programmatic campaign is delivering, engaging, and driving business results.

programmatic advertisingKPIscampaign healthPublicis Groupe Holdings B.V
More Metrics questions with a free account
4
A/B Testing & Experimentation4 questions · ~32 min
Diagnose Sample Ratio MismatchHard

Investigate sample ratio mismatch and decide whether an experiment readout is trustworthy enough to ship.

Guardrail MetricsSample Ratio MismatchA/B TestingPublicis Groupe Holdings B.V
Primary vs Guardrail MetricsEasy

Explain how a primary metric differs from a guardrail metric and how both are used in A/B test decisions.

ExperimentationGuardrail MetricsA/B TestingPublicis Groupe Holdings B.V
More A/B Testing & Experimentation questions with a free account
5
Statistics & Probability6 questions · ~48 min
P-Value vs Confidence IntervalEasy

Tests understanding of uncertainty quantification and statistical inference.

Confidence IntervalsHypothesis TestingP-ValuesPublicis Groupe Holdings B.V
More Statistics & Probability questions with a free account
6
Behavioral & Leadership15 questions · ~120 min
More Behavioral & Leadership questions with a free account
7
More topics1 question · ~8 min
Brief Business Idea PitchMedium

Evaluates product sense, prioritization, and clarity of communication.

presentation skillsPublicis Groupe Holdings B.V
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.