01
What is a CTE?
Show answer
A named temporary result introduced with WITH that makes long queries readable and reusable in the same statement.
Publicis Sapient Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Publicis Sapient hiring for Business Analytics roles
Publicis Sapient is the digital business transformation arm of Publicis Groupe, combining strategy, product, experience design, engineering and data. Its India offices in Gurugram, Noida and Bengaluru deliver engineering and data work for global clients in retail, financial services and energy. It hires for software engineers, quality engineers, data engineers and data scientists.
For Business Analytics roles, this Publicis Sapient practice set focuses most on Excel for Business Analysts (7), SQL for Business Analysis (6), Requirements and Agile (5), Power BI and Tableau (4). It has 6 easy, 31 medium, 3 hard questions, so you can start easy and work up to the harder ones.
- Company type
- Consulting
- Headquarters
- Boston, Massachusetts, USA
- Main India offices
- Gurugram, Noida, Bengaluru
Publicis Sapient Business Analytics interview process
- Online coding assessment
- Technical round 1 (coding + fundamentals)
- Technical round 2 (design or domain)
- Managerial round
- HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Publicis SapientStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
3 questions free Unlock the rest in seconds
02
What does the CALCULATE function do in DAX?
Show answer
CALCULATE evaluates an expression under a modified filter context. You pass a measure plus filter arguments that add, replace or remove filters, for example CALCULATE([Sales], 'Region'[Name] = "North") or CALCULATE([Sales], ALL('Product')). It is the basis of time intelligence, percent-of-total and comparison measures. It also triggers context transition when used inside a row context, which is powerful but a common source of confusion.
03
Write a SQL query that groups customers into spend buckets using CASE WHEN.
Show answer
SELECT
CASE
WHEN total_spend >= 50000 THEN 'High'
WHEN total_spend >= 10000 THEN 'Medium'
ELSE 'Low'
END AS segment,
COUNT(*) AS customers
FROM (
SELECT customer_id, SUM(amount) AS total_spend
FROM orders GROUP BY customer_id
) t
GROUP BY 1
ORDER BY customers DESC;
04
What is an event-based gateway and when would you use it?
Show answer
An event-based gateway is a decision point where the path is chosen by whichever event happens first, not by a data condition. It is followed by intermediate catching events such as a message or a timer. Example: after sending a quotation, either the customer's acceptance message arrives, or a 7-day timer fires and a reminder is sent. It models real waiting situations that an exclusive gateway cannot express correctly.
05
A food delivery company's orders fell 15%. How do you investigate?
Show answer
Check data accuracy, then segment by city, restaurant, time and user type; look at supply, delivery time, pricing, competitors and seasonality before proposing fixes.
06
What is the difference between Definition of Ready and Definition of Done?
Show answer
Definition of Ready is a checklist a story must meet before the team pulls it into a sprint: clear description, acceptance criteria, dependencies identified, designs attached and estimated. Definition of Done is the checklist for calling work complete: coded, reviewed, tested, acceptance criteria passed, documented and deployable. The BA mostly drives readiness, while the whole team owns done. Both reduce rework and arguments at sprint end.
07
What is user story mapping and how does it help plan releases?
Show answer
User story mapping arranges stories in two dimensions. Across the top is the user journey as a sequence of activities, for example search, compare, buy and track. Below each activity, stories are stacked by priority. Drawing horizontal lines across the map creates release slices, where the first slice is a thin end-to-end MVP that covers every step at a basic level. It prevents a flat backlog where teams build one area deeply while the journey stays incomplete.
08
What is a stakeholder analysis?
Show answer
Identifying everyone affected by the project and mapping their influence and interest to decide how to communicate with and involve each group.
09
The scheduled refresh failed overnight and leadership reviews the dashboard at 10 am. What do you do?
Show answer
Check the refresh history error first: expired credentials, gateway offline, source schema change or timeout. Fix the quick cause and trigger a manual refresh. If it cannot be fixed in time, inform the stakeholders early, state the last refreshed date clearly on the report and share the key numbers from a direct query if needed. Afterwards add refresh failure alerts and a data-as-of label so it never surprises anyone.
10
Agile vs Waterfall?
Show answer
Waterfall runs fixed phases one after another with requirements frozen early. Agile delivers in short sprints with continuous feedback, so requirements can change. In Agile, BAs maintain the backlog and user stories.
11
How do you evaluate a marketing campaign's ROI?
Show answer
ROI = (incremental profit - campaign cost) / campaign cost. Measure incremental sales using a control group or before-after comparison.
12
What steps would you follow to run a process discovery workshop?
Show answer
Before: agree scope and process boundaries, invite people who actually do the work, not only managers, and collect existing documents and sample cases. During: state the goal, map the happy path first on a wall or digital board, then add exceptions, pain points, handoffs and volumes, and park off-topic issues. Keep timing visible. After: convert the output to a clean BPMN diagram within two days, circulate it for validation, and record open questions with owners and dates.
13
What do statistical significance and p-value mean in an A/B test?
Show answer
The p-value is the probability of seeing a difference at least as large as observed if the change truly had no effect. If it is below the chosen threshold, often 0.05, the result is called statistically significant. It does not mean there is a 95 percent chance the variant is better, and significance is not the same as business importance. Always report the confidence interval of the lift as well.
14
A query using NOT IN to find customers without orders returns zero rows, although you know such customers exist. Why?
Show answer
The subquery probably returns at least one NULL, for example SELECT customer_id FROM orders where some orders have a NULL customer_id. With NOT IN, comparing any value to NULL gives UNKNOWN, so no row passes the condition. Fix it by using NOT EXISTS with a correlated subquery, or a LEFT JOIN with WHERE o.customer_id IS NULL, or by adding WHERE customer_id IS NOT NULL inside the subquery. NOT EXISTS is the safest habit.
15
What is a stakeholder and who are the typical stakeholders in a project?
Show answer
Anyone affected by or influencing the project: sponsors, product owners, end users, developers, testers, operations and customers.
16
What is a traceability matrix?
Show answer
A table linking each requirement to design, test cases and delivery status, ensuring nothing is missed and helping assess change impact.
17
You receive two customer lists from sales and billing and must reconcile them. How do you do it?
Show answer
Standardise both first: trim spaces, fix case, convert IDs to the same type and remove duplicates. Use a unique key like customer ID, or a combined key of phone and email if IDs differ. Then use XLOOKUP or COUNTIFS to mark each record as matched, only in sales or only in billing, or a Power Query merge with anti joins. Summarise mismatches by type and share the exception list with both owners.
18
In UAT cycle 2, a feature that passed in cycle 1 is now broken after a defect fix. What does this tell you and what should change?
Show answer
It is a regression: the fix for one defect broke existing functionality, which usually means changes were not impact-analysed and there is no regression suite. Log it as a new high-priority defect linked to the fix. Agree with the team that every UAT build comes with release notes listing the changes, and that QA runs an automated or core manual regression pack before handing the build to business testers. Also add the broken flow to the UAT regression checklist.
19
What is sensitivity analysis?
Show answer
Testing how changes in key inputs such as price or volume affect the output, in Excel using data tables or scenario manager.
20
The totals in your Excel report differ from the finance system by a few rupees. What could cause this?
Show answer
Usually rounding. Excel may display rounded values while summing the full-precision numbers, or line items were rounded individually in the source system and the total was computed differently. Check whether finance rounds each invoice line before summing, and apply ROUND at the same level in Excel. Other causes include floating-point artifacts, values stored as text being skipped by SUM, or hidden filtered rows. Agree and document one rounding rule with finance.
21
A lookup formula returns #N/A for some rows even though the values look present. What could be wrong?
Show answer
Usually the values only look the same. Common causes are trailing or leading spaces, numbers stored as text in one sheet and as numbers in the other, non-breaking spaces from web exports, or different spellings. Check with =LEN() and =ISNUMBER(), clean with TRIM, CLEAN or VALUE, and confirm the lookup range covers all rows and uses exact match. Wrap the final formula in IFNA to label true misses.
22
What is COALESCE in SQL and how does it differ from ISNULL or IFNULL?
Show answer
COALESCE returns the first non-NULL value from a list of expressions, for example COALESCE(mobile, landline, 'Not available'). It is ANSI standard and works in all major databases. ISNULL (SQL Server) and IFNULL (MySQL) accept only two arguments and are vendor-specific. Analysts commonly use COALESCE to show zero instead of NULL after a LEFT JOIN, such as COALESCE(SUM(o.amount), 0), so that customers without orders appear with zero revenue.
23
A Tableau dashboard on a 50 million row data source responds slowly to filters. How do you fix it?
Show answer
Use an extract with only the needed columns and rows, aggregated to the visible grain where possible. Replace quick filters showing all values with fewer filters, use context filters wisely and avoid 'only relevant values' on large fields. Move complex calculations into the data source, reduce marks per view and the number of sheets per dashboard. Use the Performance Recorder to find the slowest queries and fix those first.
24
What is the difference between accrual accounting and cash accounting?
Show answer
Under accrual accounting, revenue is recorded when it is earned and expenses when they are incurred, regardless of when cash moves. Under cash accounting, transactions are recorded only when cash is received or paid. Companies in India report under accrual-based standards (Ind AS). Example: an annual software contract billed in April is recognised as revenue month by month over 12 months under accrual, even though all the cash came in April.
25
Your monthly Excel report takes a full day of manual work. How would you automate it?
Show answer
Map the steps first: which files arrive, what cleaning is done and which outputs are needed. Move the import and cleaning into Power Query so a refresh replaces copy-paste. Base calculations on Excel Tables and PivotTables that update automatically, and keep a fixed template for the output. Use a small macro or Office Script only for the remaining formatting or emailing. Add checks such as row counts and totals so errors surface quickly.
26
Tell me about a dashboard you built that changed a business decision.
Show answer
Situation: regional sales heads reviewed discount spend only at month end. Task: I was asked to give weekly visibility. Action: I built a Power BI report linking discounts to margin by product and region, with a drill-through to deal level and an alert when margin fell below target. Result: the team spotted two regions giving deep discounts on low-margin items, tightened approval rules, and margin improved by about two points the next quarter.
27
How would you improve a company's low app conversion rate?
Show answer
Map the funnel, find the biggest drop-off, check usability and load time, run A/B tests on fixes and track conversion lift.
28
How do you protect a worksheet or workbook?
Show answer
Review > Protect Sheet or Workbook with a password, lock cells, hide formulas and allow only selected cells to be edited.
29
How would you prioritise 10 features with a limited budget?
Show answer
Score them with RICE or value-vs-effort, align with goals, consider dependencies and risks, validate with stakeholders, then use MoSCoW for the release plan.
30
Push notifications increased weekly engagement, but app uninstalls also rose. What do you recommend?
Show answer
Quantify both effects: extra sessions and revenue from notifications versus users lost through uninstalls and notification opt-outs, including their lifetime value. Segment by notification type and frequency to find which ones annoy users. Recommend frequency caps, personalised timing, relevance rules and easy preference settings, then test them with uninstall rate and opt-out rate as guardrails. Short-term engagement should not cost long-term users.
31
What is the difference between churn rate and retention rate?
Show answer
Churn rate is the percentage of customers who leave in a period: customers lost divided by customers at the start. Retention rate is the percentage who stay, roughly 100 minus churn for the same cohort. If you start a month with 1,000 subscribers and 50 cancel, churn is 5 percent and retention 95 percent. Count new customers separately, otherwise growth hides churn. Revenue churn can differ from customer churn.
32
How do you calculate monthly revenue growth in SQL?
Show answer
Aggregate revenue per month and use LAG(revenue) OVER (ORDER BY month) to compute (revenue - previous) / previous.
33
Guesstimate: how many smartphones are sold in India each year?
Show answer
Use a replacement plus new-buyer approach. India has about 144 crore people; assume around 60 crore active smartphone users. If people replace phones every 4 years on average, replacements are about 15 crore a year. Add first-time buyers, say 2 to 3 percent of the remaining adult population, roughly 1.5 crore. The estimate is about 16 to 17 crore phones a year, which is close to reported industry numbers of around 15 crore.
34
What is the difference between sequence flow and message flow in BPMN?
Show answer
A sequence flow is a solid arrow that shows the order of activities inside one pool, so it represents work controlled by one participant. A message flow is a dashed arrow with an open circle at its start and shows communication between two different pools, such as an order email from a customer to a seller. A common modelling mistake is drawing sequence flows across pools, which wrongly implies one party controls the other's work.
35
How do you use Excel's Scenario Manager?
Show answer
Define named scenarios such as best, base and worst with different input values and compare the outputs in a summary report.
36
How do you find duplicate customers?
Show answer
SELECT email, COUNT(*) FROM customers GROUP BY email HAVING COUNT(*) > 1;
37
What is a break-even point?
Show answer
The sales volume where total revenue equals total cost. It equals fixed cost divided by contribution margin per unit.
38
What is a communication plan in a project and what does it include?
Show answer
A communication plan defines who needs what information, when, in which format and from whom. It typically lists stakeholders, their information needs, the channel such as status email, standup, steering meeting or dashboard, frequency, owner and escalation path. It prevents both silence and overload, and makes sure decision-makers hear about risks early. A BA usually keeps it updated as stakeholders change.
39
What is a balanced scorecard?
Show answer
A balanced scorecard is a strategic performance framework that tracks objectives and KPIs across four perspectives: financial (revenue growth, margin), customer (NPS, retention), internal processes (cycle time, defect rate) and learning and growth (training hours, employee engagement). The idea is that financial results are lagging, so leaders also need leading measures of what drives future performance. A strategy map links the objectives with cause-and-effect arrows from people to processes to customers to financial outcomes.
40
Describe a time you explained a complex technical topic to a non-technical audience.
Show answer
Situation: operations managers did not trust a new demand forecast that drove staffing. Task: explain it so they would use it. Action: I avoided model terms and showed how it used last year's same week, recent trend and festival calendar, with a chart of past forecasts against actuals. I compared the forecast range to a weather forecast. Result: managers started using it for rosters and gave feedback that improved it further.
Tips to crack the Publicis Sapient Business Analytics interview
- Revise Java or JavaScript fundamentals, microservices and REST APIs, which are common in Publicis Sapient engineering roles.
- Prepare to discuss design patterns and clean code, as technical rounds often go beyond simple coding.
- Read about its SPEED model of strategy, product, experience, engineering and data for culture questions.
- Keep a one-minute story ready for every project on your CV: problem, your part, tools, result.
- Practise the hard questions on this page aloud; Publicis Sapient interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Publicis Sapient Business Analytics interview?
Candidates usually go through 5 stages: Online coding assessment; Technical round 1 (coding + fundamentals); Technical round 2 (design or domain); Managerial round; HR round. The exact rounds change with the role, team, location and your experience, so confirm the process with the recruiter.
Which topics should I prepare for the Publicis Sapient Business Analytics interview?
This practice set leans on Excel for Business Analysts (7), SQL for Business Analysis (6), Requirements and Agile (5), Power BI and Tableau (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Publicis Sapient interviewers ask you to walk through real work.
Are these the exact questions asked at Publicis Sapient?
No. These are curated practice questions that match the skills and difficulty usually tested in consulting interviews like Publicis Sapient's. They are not a leaked or verified list of past questions.
Where does Publicis Sapient hire Business Analytics professionals in India?
Publicis Sapient has large teams in Gurugram, Noida, Bengaluru. Openings and locations change often, so check the Publicis Sapient careers page and filter by city and experience.
Business Analytics questions for similar companies
Consulting
Deloitte
Business Analytics interview questions
Hyderabad, Bengaluru, Mumbai +2
View questionsConsulting
ZS Associates
Business Analytics interview questions
Pune, Gurugram, Bengaluru
View questionsConsulting
EY
Business Analytics interview questions
Bengaluru, Kolkata, Gurugram +2
View questionsConsulting
Bain & Company
Business Analytics interview questions
Gurugram, Mumbai, Bengaluru
View questionsConsulting
Grant Thornton Bharat
Business Analytics interview questions
Gurugram, Mumbai, Bengaluru +3
View questionsConsulting
McKinsey & Company
Business Analytics interview questions
Gurugram, Mumbai, Bengaluru +1
View questionsMore ways to practise
Company-wise Business Analytics questionsPackage-wise Business Analytics questionsExperience-wise Business Analytics questionsRole-wise Business Analytics questionsCity-wise Business Analytics questionsMost asked Business Analytics questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsBusiness Analytics mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsBusiness Analytics topic sheets