Skip to content

Business Analytics Interview Questions for Experienced Professionals (₹10–12 LPA)

40 questions with answers for experienced professionals — 7 easy, 29 medium, 4 hard.

What ₹10–12 LPA interviews expect

End-to-end project ownership Performance and quality thinking Stakeholder communication Scenario-based questions

About ₹10–12 LPA Business Analytics roles

Roles in the ₹10–12 LPA band are typically for experienced professionals. Interviewers check whether you can already do the work expected at this level, so questions here are weighted towards Requirements and Agile (8), Power BI and Tableau (5), Process Modelling and BPMN (5), Product Analytics (4).

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

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

What are dimensions and measures in Tableau?

Save to ▾
Show answer
Dimensions are qualitative fields such as Region, Category or Customer Name; placing them on a shelf creates headers and splits the view into groups. Measures are numeric fields such as Sales or Quantity that Tableau aggregates, usually with SUM or AVG. Tableau also marks fields as discrete (blue pills, headers) or continuous (green pills, axes). A date can act as either, which changes whether you get separate bars or a continuous trend line.
03

Why do Agile teams estimate in story points rather than hours?

Save to ▾
Show answer
Story points measure relative effort, complexity and uncertainty compared with a reference story, using a scale like 1, 2, 3, 5, 8. People are better at comparing sizes than predicting exact hours, and points do not depend on who does the work. Over a few sprints the team's velocity, points completed per sprint, makes forecasting reliable. Points should never be used to compare productivity across teams.
04

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

A stakeholder keeps skipping review meetings and then rejects the deliverable at the end. How do you prevent this?

Save to ▾
Show answer
Talk to them one-to-one to understand why they skip, such as timing, relevance or workload. Offer shorter reviews, asynchronous reviews with a clear deadline, or a delegate with decision rights. Record sign-offs at each stage in writing so late changes become formal change requests. Share early drafts and mock-ups, because people react better to something visible. Escalate to the sponsor if the pattern risks the timeline.
06

What is the difference between a pool and a lane in BPMN?

Save to ▾
Show answer
A pool represents a separate participant in a process, such as the customer, your company or an external bank. A lane is a subdivision inside a pool, usually a department, role or system, such as Sales, Finance and Warehouse within your company. Sequence flows can cross lanes within one pool, but communication between two pools must be shown with message flows, because separate participants do not share one controlled flow.
07

What are wireframes and why are they useful for a BA?

Save to ▾
Show answer
Low-fidelity layouts of screens that help stakeholders visualise and agree on requirements before development starts.
08

CAC is 1,200 rupees, average monthly revenue per customer is 500 rupees and gross margin is 40 percent. What is the CAC payback period?

Save to ▾
Show answer
Monthly gross profit per customer is 500 times 40 percent, which is 200 rupees. Payback period equals CAC divided by monthly gross profit, so 1,200 divided by 200 gives 6 months. If customers churn on average before 6 months, the business loses money on acquisition. Using revenue instead of gross profit would wrongly suggest 2.4 months, which is why margin must be included.
09

How do you influence stakeholders when you have no direct authority?

Save to ▾
Show answer
Build credibility with accurate work and by understanding each stakeholder's goals and pressures. Frame proposals in terms of their outcomes, such as cost saved or targets met, and back them with data. Involve them early so ideas feel shared, find allies who already support the change, and pilot small to show results. Be transparent about trade-offs. Influence comes from trust built over time, not one meeting.
10

What are heatmaps and session recordings, and when would you use them alongside funnel analysis?

Save to ▾
Show answer
Heatmaps aggregate where users click, move and scroll on a page, while session recordings replay individual user sessions. Funnel analysis tells you where users drop off, for example 40 percent leave on the address page; heatmaps and recordings help explain why, such as a hidden Continue button or a confusing pin code field. They are qualitative, so use them to form hypotheses and then validate fixes with an A/B test. Personal data must be masked in recordings.
11

Your monthly Excel report takes a full day of manual work. How would you automate it?

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

A new TO-BE process went live three months ago. How do you prove that the improvement actually worked?

Save to ▾
Show answer
Compare against the baseline you measured before the change, using the same definitions: cycle time, first-time-right rate, cost per case, backlog and customer complaints. Pull data from system timestamps rather than surveys. Check that the gain is not explained by lower volumes or seasonality, ideally by comparing similar periods. Also check for side effects, such as faster processing but more rework downstream. Present the before-and-after with the business owner, and note where adoption is still incomplete.
13

Gross margin fell from 38 percent to 34 percent in one quarter. How do you investigate?

Save to ▾
Show answer
Break the change into drivers. Price: were discounts or promotions deeper? Mix: did sales shift towards lower-margin products, channels or regions? Cost: did raw material, freight or supplier prices rise, or did currency movements raise import costs? Also check one-offs like inventory write-offs and accounting reclassifications. Build a margin bridge showing how many percentage points each driver contributed, then take the biggest driver to the business owner with a specific action.
14

How do you analyse variance between budget and actual?

Save to ▾
Show answer
Variance = Actual - Budget, shown as amount and percentage, with conditional formatting to flag large gaps and comments on the drivers.
15

What are dynamic array functions in Excel and how do they help analysts?

Save to ▾
Show answer
Dynamic array functions return several values that spill into neighbouring cells. UNIQUE lists distinct values, SORT and SORTBY order data, FILTER returns rows meeting conditions, SEQUENCE builds number series, and XLOOKUP can return whole rows. For example =SORT(UNIQUE(FILTER(Sales[Region], Sales[Year]=2026))) builds a live region list. They replace many helper columns and Ctrl+Shift+Enter array formulas, and the # operator references a full spill range.
16

What are UAT entry and exit criteria? Give examples.

Save to ▾
Show answer
Entry criteria are conditions that must be met before UAT starts, for example system and integration testing completed, no open critical defects, UAT environment and test data ready, test cases reviewed and testers trained. Exit criteria define when UAT is complete, for example 100 percent of critical test cases executed, at least 95 percent passed, no open critical or high defects, and workarounds agreed for remaining medium ones. Clear criteria stop arguments about readiness near go-live.
17

The scheduled refresh failed overnight and leadership reviews the dashboard at 10 am. What do you do?

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

What Power Query steps would you use to clean a messy monthly sales file?

Save to ▾
Show answer
Promote the first row to headers and remove blank or total rows. Set correct data types for dates and amounts, and use locale settings for Indian date formats. Trim and clean text columns, replace errors and nulls, split combined fields like 'City-State', and unpivot month columns into rows. Remove duplicates on the order ID, then merge with the product master. Rename steps clearly so others can follow the logic.
19

What are the current ratio and the quick ratio?

Save to ▾
Show answer
Both measure short-term liquidity. The current ratio is current assets divided by current liabilities; around 1.5 to 2 is often comfortable, though it varies by industry. The quick ratio excludes inventory and prepaid items: (cash plus marketable securities plus receivables) divided by current liabilities. It is stricter because inventory may not sell quickly. A retailer with a current ratio of 1.8 but a quick ratio of 0.4 depends heavily on selling its stock to pay bills.
20

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

Write Given-When-Then acceptance criteria for applying a discount coupon at checkout.

Save to ▾
Show answer
Given a cart of 1,200 rupees and a valid coupon SAVE10 with a minimum order of 1,000 rupees, when the user applies it, then 10 percent is deducted and the new total is shown. Given an expired coupon, when applied, then the message 'This coupon has expired' appears and the total is unchanged. Given a cart below the minimum, when applied, then the user is told how much more to add.
22

Tell me about a time you discovered a missed requirement late in a project.

Save to ▾
Show answer
Situation: two weeks before go-live of a billing system, a finance user asked how GST credit notes would work, which we had not covered. Task: assess and recover. Action: I analysed the impact with developers, found a simple configuration path for most cases plus a manual step for rare ones, and presented both options with dates to the sponsor. Result: we went live on time with a documented workaround and delivered the full fix next sprint.
23

What is value stream mapping and how is it different from BPMN?

Save to ▾
Show answer
Value stream mapping is a Lean technique that maps the end-to-end flow of material and information to deliver value to a customer, along with timing data such as process time, wait time and inventory between steps. Its focus is finding waste and calculating lead time. BPMN focuses on precise logic: roles, decisions, events and messages, often detailed enough for automation. Many teams use VSM to find where to improve and BPMN to design the new process.
24

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

After many sprints, project documentation is out of date and new team members are confused. What do you do?

Save to ▾
Show answer
Identify which documents are actually used: usually a product overview, process maps, business rules, data dictionary and integration details. Update those first rather than everything. Make documentation part of the Definition of Done, so a story is not complete until related docs are updated. Keep living documents in a shared wiki with owners and last-reviewed dates, and archive outdated files clearly. Test the result by having a new joiner use it during onboarding.
26

Your AS-IS map of a loan approval process shows 14 handoffs between teams. How do you identify improvements?

Save to ▾
Show answer
First measure each handoff: waiting time, rework rate and volume, using system timestamps where possible. Then classify steps as value-adding, required for compliance or waste. Look for patterns: repeated approvals, information re-entered in two systems, work bouncing back for missing documents. Typical fixes are merging roles, adding a checklist at intake so applications arrive complete, parallelising checks and automating rule-based approvals. Quantify the expected reduction in cycle time for each option.
27

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

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

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
30

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

A product manager wants to stop an A/B test after three days because the variant is winning. What do you advise?

Save to ▾
Show answer
Advise against it. Checking results repeatedly and stopping at the first significant result inflates false positives, often far beyond the planned 5 percent. Three days also misses weekly patterns and novelty effects. Run the test for the pre-calculated sample size and duration. If speed is critical, the team can use a sequential testing method designed for early looks, but that must be planned before the test starts.
32

What is AS-IS and TO-BE process modelling, and where does BPMN fit in?

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

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

Revenue grew but profit fell. Why could that happen?

Save to ▾
Show answer
Look at the cost side: heavier discounts, higher CAC, logistics costs, product mix shifting to low-margin items, one-time expenses or pricing changes. Break contribution margin down by segment.
35

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

What are data objects and data stores in BPMN?

Save to ▾
Show answer
A data object (page shape with a folded corner) represents information that an activity needs or produces during one process instance, such as an invoice or an application form. It is linked with dotted associations. A data store (cylinder) represents information that persists beyond the process instance, such as the customer database or ERP. Showing them helps developers see which systems are read or updated at each step and helps spot missing integrations.
37

The totals in your Excel report differ from the finance system by a few rupees. What could cause this?

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

What is the difference between Power BI Desktop, Power BI Service and Power BI Mobile?

Save to ▾
Show answer
Power BI Desktop is the free Windows app where you connect to data, model it, write DAX and design reports. Power BI Service is the cloud portal where you publish reports, schedule refresh, build dashboards, set permissions and share with users. Power BI Mobile is the phone app for viewing reports on the go. A typical flow is build in Desktop, publish to a Service workspace, and consume on web or mobile.
39

What is a change request and how does change control work?

Save to ▾
Show answer
A change request is a formal proposal to modify agreed scope, requirements, timeline or budget. In change control, the request is logged, the BA analyses impact on effort, cost, schedule, risk and other requirements, and a decision body such as the sponsor or change board approves, rejects or defers it. Approved changes update the requirements, plan and traceability. In Agile, most changes go through backlog reprioritisation instead.
40

A manager says the dashboard total does not match the finance team's Excel sheet. What do you do?

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

Frequently asked questions

What do Business Analytics interviews for ₹10–12 LPA roles test?

At ₹10–12 LPA the focus is usually on: end-to-end project ownership, performance and quality thinking, stakeholder communication, scenario-based questions. This page's set is weighted towards Requirements and Agile (8), Power BI and Tableau (5), Process Modelling and BPMN (5), Product Analytics (4).

Which companies pay ₹10–12 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 ₹10–12 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 ₹10–12 LPA.