01
How would you forecast next quarter's sales in Excel?
Show answer
Use FORECAST.ETS or a trendline on monthly history, check seasonality, compare with a simple moving average and present a range, not a single number.
ZS Associates Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About ZS Associates hiring for Business Analytics roles
ZS is a management consulting and technology firm known for its work with pharmaceutical and life sciences companies on sales, marketing and analytics. Its India offices in Pune, Gurugram and Bengaluru handle analytics, data engineering and technology delivery. It hires for business analysts, decision analytics associates, data engineers and data scientists.
For Business Analytics roles, this ZS Associates practice set focuses most on Requirements and Agile (6), Product Analytics (5), Stakeholder Communication (5), Excel for Business Analysts (4). It has 9 easy, 24 medium, 7 hard questions, so you can start easy and work up to the harder ones.
- Company type
- Consulting
- Headquarters
- Evanston, Illinois, USA
- Main India offices
- Pune, Gurugram, Bengaluru
ZS Associates Business Analytics interview process
- Online assessment (aptitude + analytics)
- Case interview
- Technical interview
- Managerial round
- HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for ZS AssociatesStart 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
A feature launched two months ago is used by only 4 percent of users. What would you do?
Show answer
Find out whether it is a discovery problem or a value problem. Check how many users saw the entry point, how many tried it and how many returned. If few saw it, test better placement or onboarding prompts. If many tried and few returned, interview users and review session recordings to understand why. Also check if the 4 percent are high-value users. Then decide to improve, reposition or remove it.
03
What is the difference between release notes and a user manual?
Show answer
Release notes describe what changed in a specific release: new features, enhancements, fixed defects, known issues and any actions users must take. They are short and version-specific. A user manual or user guide explains how to use the whole system to complete tasks, with step-by-step instructions and screenshots, and is updated as the product evolves. BAs often review both, because users rely on them in the first weeks after go-live.
04
Explain the defect life cycle.
Show answer
A defect is logged as New with steps, expected and actual results, and evidence. It is reviewed in triage and moves to Open or Assigned, or to Rejected, Duplicate or Deferred. The developer fixes it and marks it Fixed or Ready for retest. The tester retests: if it passes it moves to Closed, and if not it is Reopened. Tracking status and age helps the UAT lead report readiness and spot defects stuck too long.
05
Tell me about a time you mapped a process and discovered a major inefficiency.
Show answer
Situation: vendor onboarding at my company took around 18 days and procurement blamed finance. Task: I was asked to map the AS-IS process. Action: I interviewed five roles, traced 25 recent vendor records through system timestamps and built a swimlane map. It showed that bank details were collected twice and verified by two teams separately. Result: we merged the steps into one checklist at intake, cut onboarding to 9 days and reduced rework emails by about half.
06
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.
07
What is Excel Solver and give a business example of using it.
Show answer
Solver is an optimisation add-in that finds the best value of a target cell by changing decision cells within constraints. Unlike Goal Seek, it handles many variables and constraints. Example: choose how many units of three products to make to maximise profit, subject to machine hours, raw material and minimum order limits. You set the objective, the variable cells, constraints and a method such as Simplex LP for linear problems.
08
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.
09
Revenue is 50 crore, cost of goods sold 30 crore, operating expenses 12 crore and depreciation 2 crore. Calculate EBITDA and EBITDA margin.
Show answer
Operating expenses here exclude depreciation. Gross profit is 50 - 30 = 20 crore. EBITDA is gross profit minus operating expenses: 20 - 12 = 8 crore. EBITDA margin is 8 / 50 = 16 percent. EBIT is EBITDA minus depreciation, 8 - 2 = 6 crore, which is a 12 percent operating margin. In an interview, state your assumption about whether operating expenses include depreciation, because that changes the answer.
10
Split the epic 'Customers can track their order online' into user stories.
Show answer
Possible stories: As a customer, I want to see my order status (placed, packed, shipped, delivered) so that I know its progress. As a customer, I want an SMS or email when the status changes so that I do not have to check. As a customer, I want the expected delivery date so that I can plan. As a customer, I want a courier tracking link once shipped. As support staff, I want to see the same timeline so that I can answer queries.
11
Your project is going to miss its deadline by two weeks. How do you communicate this?
Show answer
Tell the sponsor and key stakeholders as soon as you are confident, not on the deadline. Be direct about the delay, the cause and the impact. Come with options, such as reducing scope to hit the date, adding resources, or moving the date with a phased release, plus your recommendation. Agree on the new plan, update the communication plan and track the recovery visibly.
12
Stakeholders give conflicting requirements. What do you do?
Show answer
Clarify the goal behind each request, map them to business objectives, prioritise with MoSCoW, run a joint session, then document the decision and get sign-off.
13
What is a UAT test plan and what does it contain?
Show answer
A UAT test plan defines how acceptance testing will be run. It covers scope and out-of-scope items, business processes to be tested, entry and exit criteria, roles such as testers, UAT lead and sign-off authority, test environment and test data, schedule and cycles, defect management process with severity definitions, communication and reporting, and risks. The BA usually drafts it with business owners so testers know exactly what they are accepting and when.
14
Describe a time you influenced an important decision without having authority.
Show answer
Situation: leadership planned to expand a loyalty programme company-wide. Task: as the analyst, I believed the pilot results were inflated. Action: I showed that pilot stores were already our best performers and built a matched control comparison, which cut the estimated uplift from 15 to 4 percent. I presented it to the sponsor first and proposed a larger randomised pilot. Result: the rollout was redesigned, saving significant cost on a weak programme.
15
What is the answer-first or pyramid principle approach to presenting analysis?
Show answer
Start with the main conclusion or recommendation, then give the two or three supporting reasons, and only then the detailed data. Senior stakeholders have little time, so a summary like 'Churn rose because of payment failures; fixing retries can save 4 lakh a month' should come first. Detail goes in the appendix. It is the opposite of a chronological walk through every step of the analysis.
16
Write a DAX measure to count distinct active customers in the last 30 days.
Show answer
Active Customers 30D =
CALCULATE(
DISTINCTCOUNT(Sales[CustomerID]),
DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -30, DAY)
)
-- MAX('Date'[Date]) makes it relative to the date in the current filter
17
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.
18
Guesstimate: how many laptops are sold in India each year?
Show answer
Segment by buyer. Households: about 30 crore households, roughly 15 percent own a laptop, so 4.5 crore laptops, replaced every 5 years, gives about 90 lakh a year, plus around 20 lakh first-time student buyers. Businesses: assume 4 crore office workers using laptops, replaced every 4 years, giving 1 crore. Government and education schemes add around 10 lakh. Total is about 2.2 crore. Sanity check against industry trends and give a range of 1.5 to 2.5 crore.
19
Write a SQL query to calculate the DAU to MAU stickiness ratio for a month.
Show answer
WITH daily AS (
SELECT event_date, COUNT(DISTINCT user_id) AS dau
FROM events
WHERE event_date >= '2026-10-01' AND event_date < '2026-11-01'
GROUP BY event_date
),
monthly AS (
SELECT COUNT(DISTINCT user_id) AS mau
FROM events
WHERE event_date >= '2026-10-01' AND event_date < '2026-11-01'
)
SELECT ROUND(AVG(d.dau) * 1.0 / MAX(m.mau), 3) AS stickiness
FROM daily d CROSS JOIN monthly m;
20
How do you handle changing requirements?
Show answer
Log the change, assess impact on scope, cost and timeline, get approval through change control or backlog grooming, and update documents and stakeholders.
21
What is feature adoption rate and how do you measure it?
Show answer
Feature adoption rate is the share of eligible active users who used a feature in a period. For example, if 4,000 of 20,000 monthly active users used saved searches, adoption is 20 percent. Measure it against eligible users only, track first use and repeat use separately, and compare retention of adopters versus non-adopters. High first use with low repeat use often means the feature is discoverable but not valuable.
22
Two analysts report different monthly active user numbers from the same database. How do you resolve it?
Show answer
Put both queries side by side and compare definitions: which events count as active, time zone, calendar versus rolling month, test and internal accounts, deleted users, and DISTINCT on user ID versus device ID. Run both on a single day to find where they diverge. Agree on one definition with the metric owner, document it, and publish it as a shared view or metric so everyone queries the same logic.
23
What is the difference between absolute, relative and mixed cell references in Excel?
Show answer
A relative reference like A1 shifts when the formula is copied. An absolute reference like $A$1 stays fixed, useful for a tax rate or target cell. A mixed reference fixes only the column ($A1) or only the row (A$1), which is handy in multiplication grids or when copying a formula across months and products. Press F4 to cycle through the four options while editing a formula.
24
Use case vs user story?
Show answer
A use case describes the full interaction between an actor and the system (main and alternate flows). A user story is a short statement of need from the user's point of view, refined with acceptance criteria.
25
Explain Porter's Five Forces.
Show answer
A model assessing industry attractiveness through supplier power, buyer power, threat of new entrants, threat of substitutes and rivalry among competitors.
26
A manager says the dashboard total does not match the finance team's Excel sheet. What do you do?
Show answer
First agree on the definition: date range, gross or net, tax, returns, currency and which date (order or invoice) is used. Then reconcile at a small grain, such as one month and one region, comparing row counts and sums between the source query and the sheet. Common causes are filters on the page, missing relationships, duplicate rows after a join or a late refresh. Document the agreed definition in the report tooltip.
27
What is conditional formatting and how would you use it in a business report?
Show answer
Conditional formatting changes a cell's look based on rules or formulas. In reports you can highlight targets missed in red, use data bars for sales size, colour scales for a region heatmap, icon sets for trend direction, or a formula rule like =$E2<$F2 to colour an entire row. Use it sparingly and with a legend so the eye goes only to the exceptions that need action.
28
What is AS-IS and TO-BE process modelling, and where does BPMN fit in?
Show answer
AS-IS modelling documents how a process works today, including pain points, delays and handoffs. TO-BE modelling shows the improved future process after changes or a new system. Comparing the two reveals the gaps and requirements. BPMN, Business Process Model and Notation, is the standard notation, using events, tasks, gateways for decisions and swimlanes for roles, so both business and IT read the diagrams the same way.
29
What is the time value of money?
Show answer
The time value of money means a rupee today is worth more than a rupee in the future, because today's rupee can be invested to earn a return and future money carries inflation and risk. Future cash is converted to present value using PV = FV / (1 + r)^n. At a 10 percent discount rate, 1,10,000 rupees received after one year is worth 1,00,000 rupees today. It is the basis of NPV, IRR, loan EMIs and valuation.
30
What are LOD expressions in Tableau and how do FIXED, INCLUDE and EXCLUDE differ?
Show answer
Level of Detail expressions compute an aggregate at a granularity different from the view. FIXED computes at the stated dimensions regardless of the view, for example { FIXED [Customer ID] : MIN([Order Date]) } for first purchase date. INCLUDE adds a dimension to the view level, useful for average sales per customer by region. EXCLUDE removes a dimension, useful for comparing each month with the yearly total. FIXED ignores normal dimension filters unless they are context filters.
31
How do you run an effective stakeholder meeting?
Show answer
Send an agenda with the goal and the decisions needed beforehand, along with any pre-read. Invite only people who contribute or decide. Start by restating the goal, keep to time, park off-topic issues and confirm decisions aloud. End by summarising actions with owners and dates. Send minutes within a day. A meeting without a clear decision or output usually could have been an email.
32
Write a SQL query for Day-7 retention by weekly sign-up cohort.
Show answer
WITH cohort AS (
SELECT user_id, signup_date,
DATE_TRUNC('week', signup_date) AS cohort_week
FROM users
),
ret AS (
SELECT DISTINCT c.user_id
FROM cohort c
JOIN events e ON e.user_id = c.user_id
AND e.event_date = c.signup_date + INTERVAL '7 day'
)
SELECT c.cohort_week, COUNT(*) AS users,
ROUND(100.0 * COUNT(r.user_id) / COUNT(*), 1) AS d7_retention_pct
FROM cohort c
LEFT JOIN ret r ON r.user_id = c.user_id
GROUP BY c.cohort_week
ORDER BY c.cohort_week;
33
The CEO wants one KPI to judge the customer support team. What would you propose?
Show answer
A single KPI can be gamed, so I would propose one headline with guardrails. The headline could be first-contact resolution rate, because it reflects solving problems, not just closing tickets. Guardrails would be customer satisfaction score after the ticket and median first response time. I would also watch ticket volume per thousand orders, which shows whether product issues are falling. Review targets quarterly with the support head.
34
An online learning platform finds that only 12 percent of learners complete paid courses. How do you analyse it?
Show answer
Define completion and see where learners drop: first week, a specific module or before assessments. Segment by course, length, learner background, device and acquisition channel. Look at causes in content difficulty, video length, lack of deadlines, mentor support and job relevance. Recommend tests such as shorter modules, cohort-based deadlines, progress nudges and live doubt sessions, and measure completion and referral impact.
35
What is gap analysis?
Show answer
Compare the current state (as-is) with the desired state (to-be), list the gaps in process, people or technology, and plan actions to close them.
36
What is a CTE?
Show answer
A named temporary result introduced with WITH that makes long queries readable and reusable in the same statement.
37
What is process mining and how does it help a business analyst?
Show answer
Process mining uses event logs from systems such as ERP or CRM, each record holding a case ID, activity name and timestamp, to automatically rebuild how a process really runs. It shows actual paths, rework loops, bottlenecks and how often cases deviate from the designed flow. For a BA it replaces opinion-based AS-IS workshops with evidence, for example showing that 22 percent of purchase orders are changed after approval. Data quality of the logs is the main limitation.
38
You must gather requirements to replace a 15-year-old legacy system with no documentation. How do you approach it?
Show answer
Combine several sources. Interview and observe users doing real tasks, and review screens, reports and outputs to infer business rules. Analyse the database and logs to see which data and functions are actually used. Work with long-serving staff and IT support for hidden rules and workarounds. Build AS-IS process maps, decide what to keep, drop or improve, and validate the findings with users. Plan data migration requirements early.
39
Write a SQL query for the top 3 products by revenue in each category.
Show answer
WITH ranked AS (
SELECT category, product_id, SUM(amount) AS revenue,
DENSE_RANK() OVER (PARTITION BY category
ORDER BY SUM(amount) DESC) AS rk
FROM sales
GROUP BY category, product_id
)
SELECT category, product_id, revenue
FROM ranked
WHERE rk <= 3
ORDER BY category, rk;
40
What is the difference between revenue and profit?
Show answer
Revenue is total money from sales; profit is what remains after subtracting all costs and expenses.
Tips to crack the ZS Associates Business Analytics interview
- Learn pharma commercial basics like sales force effectiveness, market share and prescriber data for case questions.
- Practise case interviews and guesstimates with a clear structure, as consulting rounds are central at ZS.
- Revise Excel, SQL and basic statistics, since associate roles involve heavy data analysis.
- 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; ZS Associates interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the ZS Associates Business Analytics interview?
Candidates usually go through 5 stages: Online assessment (aptitude + analytics); Case interview; Technical interview; 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 ZS Associates Business Analytics interview?
This practice set leans on Requirements and Agile (6), Product Analytics (5), Stakeholder Communication (5), Excel for Business Analysts (4). Revise those first, then practise explaining one or two of your own projects end to end, because most ZS Associates interviewers ask you to walk through real work.
Are these the exact questions asked at ZS Associates?
No. These are curated practice questions that match the skills and difficulty usually tested in consulting interviews like ZS Associates's. They are not a leaked or verified list of past questions.
Where does ZS Associates hire Business Analytics professionals in India?
ZS Associates has large teams in Pune, Gurugram, Bengaluru. Openings and locations change often, so check the ZS Associates careers page and filter by city and experience.
Business Analytics questions for similar companies
Consulting
Grant Thornton Bharat
Business Analytics interview questions
Gurugram, Mumbai, Bengaluru +3
View questionsConsulting
KPMG
Business Analytics interview questions
Gurugram, Bengaluru, Mumbai +2
View questionsConsulting
Bain & Company
Business Analytics interview questions
Gurugram, Mumbai, Bengaluru
View questionsConsulting
McKinsey & Company
Business Analytics interview questions
Gurugram, Mumbai, Bengaluru +1
View questionsConsulting
Protiviti
Business Analytics interview questions
Gurugram, Mumbai, Bengaluru +1
View questionsConsulting
Deloitte
Business Analytics interview questions
Hyderabad, Bengaluru, Mumbai +2
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