Skip to content

Business Analytics Interview Questions for Senior Specialists (₹15–20 LPA)

40 questions with answers for senior specialists — 24 medium, 16 hard.

What ₹15–20 LPA interviews expect

Deep expertise in a specialisation Architecture-level reasoning Metrics and business impact Leading small initiatives

About ₹15–20 LPA Business Analytics roles

Roles in the ₹15–20 LPA band are typically for senior specialists. Interviewers check whether you can already do the work expected at this level, so questions here are weighted towards Case Studies and Guesstimates (7), Requirements and Agile (6), Product Analytics (6), Stakeholder Communication (5).

Salary bands are indicative only. The same skills can pay differently across cities, company types and negotiation.

Solved in this bandStart 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
01

Write a SQL query to show cumulative revenue by month.

Save to ▾
Show answer
WITH monthly AS ( SELECT DATE_TRUNC('month', order_date) AS month, SUM(amount) AS revenue FROM orders GROUP BY 1 ) SELECT month, revenue, SUM(revenue) OVER (ORDER BY month) AS cumulative_revenue FROM monthly ORDER BY month; -- add PARTITION BY EXTRACT(YEAR FROM month) to reset each year
02

How do you handle changing requirements?

Save to ▾
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.
03

What is a balanced scorecard?

Save to ▾
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.
04

What is the role of a BA in Scrum?

Save to ▾
Show answer
They help the Product Owner refine the backlog, write stories and acceptance criteria, clarify details with developers and support testing and demos.
05

Prepare a simple cost-benefit analysis for automating invoice processing.

Save to ▾
Show answer
Costs: software 12 lakh in year 1 plus 3 lakh per year support, and 4 lakh for implementation and training. Benefits: 60,000 invoices a year at 10 minutes saved each is 10,000 hours; at 400 rupees per hour that is 40 lakh, plus around 5 lakh from fewer late-payment penalties. Year-1 net benefit is 45 - 16 = 29 lakh and payback is under six months. Then test sensitivity, for example if only half the time saving is realised.
06

Tell me about a time you led or mentored a team of analysts.

Save to ▾
Show answer
Situation: I led three junior analysts on a pricing review with a six-week deadline. Task: deliver quality work while developing them. Action: I split the work by workstream, set up short daily check-ins and a shared query library, reviewed their logic rather than rewriting it, and let each present their section to the client. Result: we delivered a week early, two juniors later handled client calls alone, and the review practice became standard in our team.
07

Your analysis contradicts a strongly held belief of the vice president. How do you handle it?

Save to ▾
Show answer
Double-check the data and method first, and ask a peer to review it. Then share it privately with the VP before any group meeting, so they are not surprised in public. Present it neutrally: what we expected, what the data shows, and possible reasons. Invite their context, as they may know factors you missed. Suggest a small test to settle it. Focus on the decision, not on being right.
08

An online learning platform finds that only 12 percent of learners complete paid courses. How do you analyse it?

Save to ▾
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.
09

What are acceptance criteria?

Save to ▾
Show answer
Clear, testable conditions a story must meet to be accepted, often written as Given-When-Then scenarios.
10

A mid-size manufacturer must choose between building and buying a warehouse management system. How do you advise?

Save to ▾
Show answer
Compare options on fit, cost, time and risk. Buying a proven product is faster with lower risk and includes upgrades, but may need process changes and has recurring licence fees. Building fits unique processes exactly but needs a strong tech team, longer time and ongoing maintenance. Estimate five-year total cost of ownership, check whether processes are truly unique, and usually recommend buying and configuring unless warehousing is a core differentiator.
11

Vendor A has a lower licence price, but Vendor B has lower running costs. How do you compare them?

Save to ▾
Show answer
Compare total cost of ownership over the same period, usually 3 to 5 years. Include licence or subscription fees, implementation, data migration, integration, training, internal staff time, infrastructure, support and upgrade costs, and exit costs. Discount the yearly totals to present value if the timing differs. Then weigh the result against non-cost factors such as fit to requirements, scalability and vendor stability. Often the cheaper licence ends up costlier once customisation and support are added.
12

What is a BRD review and who signs it off?

Save to ▾
Show answer
Stakeholders and the sponsor review the Business Requirements Document for completeness and accuracy, and the business owner gives formal sign-off before design begins.
13

How do you use NPV and payback period to evaluate an investment in a case?

Save to ▾
Show answer
Estimate the upfront investment and yearly incremental cash flows, then discount future cash flows at the cost of capital to compute Net Present Value. A positive NPV means the investment creates value. Payback period is how many years until cumulative cash flows recover the investment, which shows risk and liquidity but ignores later cash flows and time value. Present both, with a sensitivity check on key assumptions like volume and price.
14

What is a spike in Agile and when would a business analyst request one?

Save to ▾
Show answer
A spike is a time-boxed story used for research or experimentation to reduce uncertainty, not to deliver a feature. Its output is knowledge, such as a recommendation or a prototype. A BA might request one when the team cannot estimate a story because an external API, a data source or a regulation is unclear, for example checking whether a payment gateway supports partial refunds. The time box, often one to three days, prevents open-ended investigation.
15

What are MRR and ARR, and how do you calculate net revenue retention?

Save to ▾
Show answer
MRR is monthly recurring revenue from active subscriptions; ARR is the annualised figure, usually MRR times 12. Net revenue retention measures revenue kept from an existing customer cohort over 12 months: (starting MRR + expansion - contraction - churned MRR) / starting MRR. Example: 100 lakh start, plus 15 expansion, minus 5 contraction, minus 8 churn gives 102 percent. Above 100 percent means existing customers grow revenue even without new sales.
16

Overall conversion fell this month, yet conversion improved for both mobile and desktop users. How is that possible?

Save to ▾
Show answer
This is Simpson's paradox caused by a change in mix. If mobile converts lower than desktop and the share of mobile traffic grew sharply, the overall average can fall even though each segment improved. Show conversion by segment along with the traffic mix. The insight is not that conversion got worse but that traffic shifted, so the question becomes how to raise mobile conversion further.
17

How do you prioritise requirements?

Save to ▾
Show answer
Use MoSCoW (Must, Should, Could, Won't), value versus effort scoring or the Kano model, agreed with stakeholders based on business value and risk.
18

What is DMN and how does it relate to BPMN?

Save to ▾
Show answer
DMN (Decision Model and Notation) is an OMG standard for modelling business decisions, mainly through decision tables that list input conditions, outputs and a hit policy. BPMN shows the flow of work, while DMN holds the decision logic. Instead of drawing ten nested gateways for loan eligibility, you place one business rule task in BPMN that calls a DMN table. This keeps diagrams clean and lets business users change rules without redrawing the process.
19

After joining orders to a payments table, your total revenue doubled. What went wrong?

Save to ▾
Show answer
The join created a fan-out: some orders have more than one payment row, such as split payments or retries, so each order amount is repeated. Check the grain by counting rows per order_id on both sides. Fix it by aggregating payments to one row per order in a CTE before joining, joining on the full key, or summing from the table whose grain matches the metric. Always compare row counts before and after a join.
20

An A/B test shows a 5 percent higher conversion rate, but revenue per user is lower. Should you ship it?

Save to ▾
Show answer
Not automatically. Find out why: the variant may push cheaper products, bigger discounts or smaller orders, so more people buy but each spends less. Check average order value, margin and long-term metrics like repeat purchase. Decide based on the metric tied to the business goal, usually revenue or contribution per user, which should have been the primary metric or a guardrail. Consider iterating to keep the conversion gain without lowering order value.
21

What is a RACI matrix?

Save to ▾
Show answer
A table assigning Responsible, Accountable, Consulted and Informed roles per task so ownership is clear.
22

Tell me about a time you worked with stakeholders in a different time zone or culture.

Save to ▾
Show answer
Situation: I worked on a reporting project where the business owners were in the UK and the development team was in Pune. Task: gather and confirm requirements without long delays. Action: I fixed a daily 30-minute overlap call, sent written summaries with decisions and open questions after each meeting, and used recorded walkthroughs of prototypes. I also learned that the UK team preferred direct written feedback. Result: we closed requirements in three weeks instead of the planned five.
23

Tell me about a time your analysis changed a product decision.

Save to ▾
Show answer
Situation: the team planned to add more filters to the search page to fix low conversion. Task: I was asked to size the opportunity. Action: funnel analysis showed most drop-off happened after users opened a product page with no delivery date shown, not in search. I shared the data with session recordings. Result: the team prioritised showing delivery dates on the product page, conversion rose about 8 percent, and the filter work was deprioritised.
24

How do you run an effective stakeholder meeting?

Save to ▾
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.
25

Finance asks you to build a monthly cohort retention table in Excel from raw order data. How do you approach it?

Save to ▾
Show answer
Add a helper column for each customer's first order month using MINIFS on customer ID, and another for the order month. Compute the month index as the difference in months between them. Then build a PivotTable or COUNTIFS grid with cohort month as rows, month index as columns and distinct customers as values. Divide each cell by the month-zero count to get retention percentages and add a colour scale to show decay.
26

Your A/B test was meant to split traffic 50/50, but the actual split is 52/48 on 200,000 users. What do you do?

Save to ▾
Show answer
This is a sample ratio mismatch. With 200,000 users, a 52/48 split is far outside random chance, which a chi-square test will confirm. It means the assignment or logging is broken, for example the variant page crashing before the tracking event fires, bots filtered unevenly or a redirect losing users. Do not trust the results. Investigate by segment, platform and day to find the cause, fix it and rerun the test.
27

The CFO asks whether the company should lease or buy 50 delivery vans. How do you approach the analysis?

Save to ▾
Show answer
Build a discounted cash flow comparison over the vehicle life. For buying: purchase price, financing cost, maintenance, insurance, tax benefit of depreciation, and resale value. For leasing: lease rentals, what maintenance is included, tax treatment and end-of-term conditions. Discount both at the company's cost of borrowing and compare present value of costs. Then add qualitative factors: flexibility if volumes drop, technology risk such as a shift to electric vans, and impact on the balance sheet.
28

Should a food-delivery app launch in a new city?

Save to ▾
Show answer
Check market size (population, online ordering share), competition, restaurant supply, unit economics per order, CAC and payback period. Propose a pilot with clear success metrics.
29

How do you find duplicate customers?

Save to ▾
Show answer
SELECT email, COUNT(*) FROM customers GROUP BY email HAVING COUNT(*) > 1;
30

How do you use Excel's Scenario Manager?

Save to ▾
Show answer
Define named scenarios such as best, base and worst with different input values and compare the outputs in a summary report.
31

How would you estimate the market size for an electric scooter in India?

Save to ▾
Show answer
Top-down: two-wheeler market x EV share x addressable segment. Bottom-up: target households x adoption rate x price. Compare both for a sanity check.
32

Write Excel formulas for IRR with yearly cash flows and XIRR with irregular dates.

Save to ▾
Show answer
# Yearly cash flows in B2:B7, year 0 investment negative =IRR(B2:B7) # Irregular dates: cash flows in B2:B7, dates in C2:C7 =XIRR(B2:B7, C2:C7) # XIRR returns an annualised rate based on actual dates, # which suits SIP returns or projects with uneven payments.
33

A critical defect is found on the last day of UAT, and the go-live date cannot move. What do you do?

Save to ▾
Show answer
Confirm the impact and reproduce it quickly. Work with development to estimate a fix and its regression effort. Then present options to the business owner with risks: fix and do targeted retesting before go-live, go live with a temporary workaround or manual process, go live with the affected feature switched off, or delay. The decision belongs to the business, documented at the go or no-go meeting. Never hide a critical defect to protect a date.
34

A client's profits are falling. How do you structure the problem?

Save to ▾
Show answer
Split into revenue and cost, then revenue into price, volume and mix, and cost into fixed and variable; check internal factors and external market factors.
35

A Tableau dashboard on a 50 million row data source responds slowly to filters. How do you fix it?

Save to ▾
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.
36

What do statistical significance and p-value mean in an A/B test?

Save to ▾
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.
37

How do you build a PivotTable to analyse sales by region and product?

Save to ▾
Show answer
Create a table, insert a PivotTable, drag region to rows, product to columns, sales to values, and add slicers for month or channel.
38

A new onboarding flow increased sign-ups by 15 percent, but Day-7 retention fell. How do you analyse this?

Save to ▾
Show answer
Check whether the extra sign-ups are lower-intent users who would naturally retain less. Compare Day-7 retention for comparable users in both versions and count retained users in absolute terms, not just rates. If the new flow skips a step that led users to the aha moment, retention per user may truly fall. The decision depends on whether total retained, valuable users went up or down.
39

Guesstimate: how many cars are sold in India every year?

Save to ▾
Show answer
Structure it: households × car-owning share ÷ replacement cycle + first-time buyers + commercial fleet. State each assumption clearly and sanity-check the final number.
40

What are unit economics and why do investors and leaders focus on them?

Save to ▾
Show answer
Unit economics measure revenue and cost for one unit of business, such as one order, one customer or one subscription. For an order you compute average order value minus product cost, delivery, payment fees, discounts and support cost to get contribution margin. If each unit loses money, scale only increases losses. Leaders use unit economics to decide pricing, which cities or channels to grow and where to cut cost.

Frequently asked questions

What do Business Analytics interviews for ₹15–20 LPA roles test?

At ₹15–20 LPA the focus is usually on: deep expertise in a specialisation, architecture-level reasoning, metrics and business impact, leading small initiatives. This page's set is weighted towards Case Studies and Guesstimates (7), Requirements and Agile (6), Product Analytics (6), Stakeholder Communication (5).

Which companies pay ₹15–20 LPA for Business Analytics roles?

Pay depends on company type, city, skills and negotiation, not only experience. Use the company-wise pages to practise for the specific employers you are targeting, and treat salary bands as a rough guide.

How should I prepare for a ₹15–20 LPA Business Analytics interview?

Solve every question here without looking at the answer first, mark the ones you miss, save them to Last-Minute Revision and revise them the night before. Prepare two project stories that show impact at the level expected for ₹15–20 LPA.