Skip to content

Business Analytics Interview Questions for Lead Roles (₹20–25 LPA)

40 questions with answers for lead roles — 26 medium, 14 hard.

What ₹20–25 LPA interviews expect

Leading and reviewing others’ work Planning and estimation Strategy and roadmap input Cross-team collaboration

About ₹20–25 LPA Business Analytics roles

Roles in the ₹20–25 LPA band are typically for lead roles. Interviewers check whether you can already do the work expected at this level, so questions here are weighted towards Case Studies and Guesstimates (10), Business Metrics and KPIs (5), Power BI and Tableau (5), Requirements and Agile (3).

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

What is a feasibility study?

Save to ▾
Show answer
An early assessment of whether a proposed solution is technically, economically, operationally and legally viable before committing budget.
02

Explain Porter's Five Forces.

Save to ▾
Show answer
A model assessing industry attractiveness through supplier power, buyer power, threat of new entrants, threat of substitutes and rivalry among competitors.
03

A food delivery company's orders fell 15%. How do you investigate?

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

What is an event-based gateway and when would you use it?

Save to ▾
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 quick-commerce company wants to expand into Tier-2 cities. What would you analyse before recommending it?

Save to ▾
Show answer
Demand: population density, smartphone and digital payment penetration, average basket size and how often people buy groceries. Supply: dark store rent, rider availability and local sourcing. Unit economics: orders per store per day needed to break even, given lower average order values. Competition: local kirana delivery and other apps. Then propose a pilot in two or three cities with clear success metrics such as orders per day, contribution margin per order and repeat rate before scaling.
06

In the middle of a sprint, a senior stakeholder asks to add an urgent feature. What do you do?

Save to ▾
Show answer
Understand the urgency and the business impact of waiting until the next sprint. Bring it to the product owner, who decides. If it truly cannot wait, the team agrees to swap out work of similar size so the sprint goal stays realistic, and the trade-off is made visible to the stakeholder. If it can wait, add it to the top of the backlog for the next sprint. Avoid silently adding scope.
07

Tell me about a time you built a business case for a project. Was it approved?

Save to ▾
Show answer
Situation: our support team handled order-status queries manually, about 9,000 a month. Task: I was asked to evaluate a self-service tracking page. Action: I measured handling time from ticket data, estimated deflection conservatively at 40 percent, worked with IT on build and run costs and showed best, base and worst cases with payback. Result: leadership approved the base case. Six months after launch, deflection reached 46 percent, and I presented the benefits review to the same committee.
08

Push notifications increased weekly engagement, but app uninstalls also rose. What do you recommend?

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

Should a supermarket chain launch its own private-label products?

Save to ▾
Show answer
Evaluate attractiveness and ability. Attractiveness: private labels usually earn higher margins, so check category size, how price-sensitive customers are, and whether brand loyalty is weak in categories like staples and cleaning. Ability: supplier availability, quality control, shelf space and brand trust. Estimate the margin gain against cannibalisation of branded sales and supplier relationships. Recommend starting with a few high-volume, low-loyalty categories and measuring repeat purchase.
10

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.
11

What is value chain analysis?

Save to ▾
Show answer
Value chain analysis breaks a business into the activities that create value: primary activities such as inbound logistics, operations, outbound logistics, marketing and sales, and service, plus support activities like procurement, technology, HR and infrastructure. For each activity you look at cost and differentiation. In cases it helps locate where costs are rising or where a competitive advantage can be built, for example in last-mile delivery.
12

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.
13

How do you evaluate a marketing campaign's ROI?

Save to ▾
Show answer
ROI = (incremental profit - campaign cost) / campaign cost. Measure incremental sales using a control group or before-after comparison.
14

Guesstimate: how many new two-wheeler helmets are sold in India each year?

Save to ▾
Show answer
Drive it from vehicles. Assume about 2 crore new two-wheelers are sold a year, each with an average of 1.5 helmets bought (rider plus pillion), giving 3 crore. The existing fleet is around 25 crore vehicles; assume 60 percent are active and each active vehicle replaces one helmet every 3 years: 15 crore / 3 = 5 crore. Total is about 8 crore helmets a year. Sanity check: enforcement varies by state, so give a range of 6 to 9 crore.
15

What does the CALCULATE function do in DAX?

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

Managers want to click a region on a summary report page and jump to a detail page for only that region. How do you build it in Power BI?

Save to ▾
Show answer
Use drill-through. Create a detail page, add the Region field to the page's drill-through filter well, and design visuals for orders, products and trends. Power BI adds a back button automatically. On the summary page, users right-click a region and choose Drill through. Keep all filters on so date selections carry over. For guided navigation, you can also add buttons with bookmarks, but drill-through is the cleanest way to pass the selected region.
17

What is user activation and what is an 'aha moment'?

Save to ▾
Show answer
Activation is the point at which a new user first experiences the product's core value, such as completing a first lesson, sending a first payment or creating a first project. The aha moment is the specific early action that strongly predicts long-term retention, found by comparing retained and churned users. Teams then design onboarding to get more new users to that action quickly and track the activation rate.
18

Guesstimate: how many laptops are sold in India each year?

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

A bank's mobile app logins increased, but digital transactions fell. What could explain this?

Save to ▾
Show answer
Users are coming but not completing transactions, so look at the gap. Possible causes: a release that broke a payment flow, new security steps like extra OTPs adding friction, logins driven by balance checks or offers, or transactions shifting to another channel. Compare the funnel from login to transaction by app version and device, check failure and error rates, and review support complaints before recommending fixes.
20

How do you find the top 5 customers by revenue?

Save to ▾
Show answer
SELECT customer_id, SUM(amount) AS revenue FROM orders GROUP BY customer_id ORDER BY revenue DESC LIMIT 5;
21

The sales team keeps hitting its revenue target, but company margins are falling. What would you recommend?

Save to ▾
Show answer
The incentive rewards revenue regardless of profitability, so reps are likely discounting heavily or pushing low-margin products. Analyse deal-level discount, product mix and margin by rep and region to confirm. Then recommend changing the target to gross margin or contribution, or adding discount approval limits and a margin floor to commission. Pilot the new plan with one region and track revenue, margin and win rate together.
22

What is Power Pivot?

Save to ▾
Show answer
An Excel add-in for building data models with relationships and DAX measures over millions of rows, beyond normal worksheet limits.
23

Marketing and product teams define 'active user' differently and report conflicting numbers. How do you fix this?

Save to ▾
Show answer
Bring both teams together and list each definition, its purpose and its numbers. Agree on one company-wide definition tied to real value, such as a user who completed a core action in the last 7 days, and allow clearly named secondary metrics like 'visitors' for marketing. Assign an owner, document it in a metric glossary, implement it once in the warehouse or semantic model, and retire the duplicate dashboards.
24

Tell me about a time you solved an ambiguous problem with limited data.

Save to ▾
Show answer
Situation: my manager asked why customer complaints were rising, but complaints were stored as free text with no categories. Task: give an answer within a week. Action: I sampled 300 complaints, created categories, tagged them manually and used keyword rules in Excel to classify the rest, then validated with the support lead. Result: late refunds were 40 percent of complaints, the refund process was fixed, and categorised tagging was added to the support tool.
25

Your measure shows the same value on every row of a matrix. Why might that happen?

Save to ▾
Show answer
The filter from the row field is not reaching the fact table. Usually there is no relationship between that dimension and the fact, the relationship is inactive, or it filters in the wrong direction. It can also happen when the measure uses ALL or REMOVEFILTERS on that column, or when the row field comes from the fact table of a different grain. Check the model view and test the measure with a simple SUM.
26

What is operational acceptance testing and how is it different from UAT?

Save to ▾
Show answer
Operational acceptance testing (OAT) checks whether the operations and support teams can run the system in production: backup and restore, failover, monitoring and alerts, batch job scheduling, performance under expected load, security patching and support procedures. UAT checks whether business users can do their work. Both are needed before go-live. A system can pass UAT and still fail in production if nobody tested that the nightly batch finishes before the business opens.
27

What is a KPI tree?

Save to ▾
Show answer
It breaks a top metric into drivers: Revenue = Users × Conversion × AOV; Users = New + Returning, and so on. It shows which lever to pull and where a drop came from.
28

You receive two customer lists from sales and billing and must reconcile them. How do you do it?

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

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.
30

Describe a time you influenced an important decision without having authority.

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

What is a data table in Excel?

Save to ▾
Show answer
A what-if tool that recalculates a formula for different inputs, for example loan payments across different rates and tenures.
32

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.
33

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.
34

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?

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

What is a stakeholder analysis?

Save to ▾
Show answer
Identifying everyone affected by the project and mapping their influence and interest to decide how to communicate with and involve each group.
36

How are OKRs different from KPIs?

Save to ▾
Show answer
KPIs are ongoing health measures of the business, like monthly revenue, churn or on-time delivery, tracked continuously. OKRs are a goal-setting method: an Objective is a qualitative ambition for a quarter, and Key Results are two to four measurable outcomes that show it was achieved. A KPI that is off track often becomes the subject of an OKR, for example 'reduce churn from 5 to 3 percent this quarter'.
37

A feature was launched to all users at once without an A/B test. How would you measure its impact?

Save to ▾
Show answer
Use quasi-experimental methods. Compare before and after with enough history to account for trend and seasonality. If it rolled out at different times in regions or platforms, use difference-in-differences between early and late groups. Compare users who adopted with similar non-adopters using matching, while being careful about self-selection. For future launches, recommend keeping a small holdout group so impact can be measured cleanly.
38

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.
39

Explain row context and filter context in DAX.

Save to ▾
Show answer
Row context means DAX is evaluating one row at a time, as in a calculated column or inside iterators like SUMX. Filter context is the set of filters coming from slicers, visuals, rows, columns and CALCULATE that decides which rows a measure sees. Row context does not filter other tables by itself; context transition through CALCULATE converts it into filter context. Most wrong-number bugs in DAX come from misunderstanding these two.
40

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.

Frequently asked questions

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

At ₹20–25 LPA the focus is usually on: leading and reviewing others’ work, planning and estimation, strategy and roadmap input, cross-team collaboration. This page's set is weighted towards Case Studies and Guesstimates (10), Business Metrics and KPIs (5), Power BI and Tableau (5), Requirements and Agile (3).

Which companies pay ₹20–25 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 ₹20–25 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 ₹20–25 LPA.