Candidates describe a Publicis Groupe Data Analyst interview built around a recruiter screen, conversations on background and fit, and practical Excel, SQL and dashboard checks. Reports vary by team and interviewer.
$91K
Avg. Base Comp
$108K
Avg. Total Comp
3-4 rounds
Typical Rounds
Not reported
Process Length
Candidates describe the Publicis Groupe Data Analyst interview as practical and conversational rather than theoretical, and the technical depth appears to vary by team and interviewer. Four candidates reported rejections or no offer, so preparation should aim to stand out on clarity and fit.
One candidate reported Excel tasks such as VLOOKUP and other spreadsheet work, SQL queries, and Power BI dashboard questions. That candidate also described a take-home Excel and dashboard assignment that took a couple of hours, plus a question on how they would approach exploratory analysis of a new dataset. Another candidate described a short call of about 16 minutes. It covered their Excel and SQL proficiency, an elevator pitch, why they suited the role, and what the client relationship might look like.
A third candidate described a recruiter call, a team conversation, and a final round with the head of the team and a director. The final round included a short live Excel exercise, and the candidate had to explain their reasoning while working. A fourth candidate described a conversation weighted toward career history and soft skills, with a low technical bar and unclear role scope.
In practice, rehearse spreadsheet fundamentals and basic SQL, and be ready to talk through your steps aloud. Have a clear account of your past projects and your career goals. Ask early about team structure and what the role owns.
Synthesized from 4 candidate reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Publicis Groupe process.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Publicis Groupe
Write a query that returns all neighborhoods that have 0 users.
| Question | |
|---|---|
| 2nd Highest Salary | |
| Comments Histogram | |
| Employee Salaries | |
| Top Three Salaries | |
| Experiment Validity | |
| First Touch Attribution | |
| 500 Cards | |
| First to Six | |
| Last Transaction | |
| Button AB Test | |
| Top 3 Users | |
| Session Difference | |
| Like Tracker | |
| Random SQL Sample | |
| Weighted Keys | |
| Subscription Overlap | |
| Impression Reach | |
| Lazy Raters | |
| Average Order Value | |
| Largest Salary by Department | |
| Swipe Precision | |
| Raining in Seattle | |
| Notification Deliveries | |
| Third Purchase | |
| Project Budget Error | |
| Network Experiment Design | |
| Decreasing Comments | |
| Minimum Change | |
| Find the Missing Number |
Synthesized from candidate reports. Individual experiences may vary.
Candidates report starting with a recruiter or HR call. One described it as professional and responsive. Another was told the team was hiring for more than one level. Expect questions about your background and interest in the role, though the exact content likely varies by team.
Candidates describe a conversation with a hiring manager or team member about experience, past projects, and fit. One report mixed behavioral and technical questions, and another focused on career goals. Another candidate reported an elevator pitch and a discussion of the client relationship. Have project stories and a clear reason for wanting the role ready.
One candidate reported an hour-long technical interview covering Excel tasks such as VLOOKUP, SQL queries, Power BI dashboard questions, and an approach to exploratory data analysis. Others described lighter questions on Excel and SQL proficiency. Depth may vary by interviewer, so be ready to explain your skill level honestly with concrete examples.
One candidate reported a take-home Excel and dashboard assignment that took a couple of hours. Not every candidate described one, so it may not apply to every team. If you receive one, allow time to polish the work and be ready to explain your design choices.
One candidate reported a final round with the head of the team and a director. It included a short live Excel exercise where they had to explain their thinking as they worked. That candidate was later rejected with positive remarks about their task results and received no further feedback. Practice narrating your analysis step by step.
