Business Analytics Interview Questions in Mumbai

Show answer

A table linking each requirement to design, test cases and delivery status, ensuring nothing is missed and helping assess change impact.

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

Financial and Business AnalysisMedium

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.

What is the Ansoff matrix and how is it used in growth cases?

Case Studies and GuesstimatesMedium

Show answer

The Ansoff matrix maps four growth strategies by product and market. Market penetration sells existing products to existing markets, the lowest risk. Product development offers new products to existing customers. Market development takes existing products to new markets, such as new cities. Diversification launches new products in new markets, the highest risk. In a growth case it structures the options before you evaluate each one's size, cost and fit.

Tell me about a time you found an error in a spreadsheet just before it went to management.

Show answer

Situation: an hour before a quarterly review I noticed regional totals were higher than the company total. Task: find the issue without delaying the meeting. Action: I traced it to a SUMIFS range that stopped at row 5000 while new data went beyond it, plus one duplicated region. I fixed both, converted the data to an Excel Table, and added a check cell comparing totals. Result: the correct deck went out on time and the check became part of our template.

How do you handle large datasets in Excel?

Show answer

Use tables, Power Query, remove volatile functions, filter before calculating and move to Power Pivot or a database when rows reach the millions.

What is the BCG growth-share matrix?

Case Studies and GuesstimatesEasy

Show answer

The BCG matrix classifies business units or products by market growth rate and relative market share. Stars have high share in high-growth markets and need investment. Cash cows have high share in slow markets and fund the rest. Question marks have low share in fast markets and need a decision to invest or exit. Dogs have low share in slow markets and are candidates to divest. It guides portfolio resource allocation.

Write an Excel formula that labels sales as High (100000 or more), Medium (50000 or more) or Low.

Excel for Business AnalystsEasy

Show answer

=IFS(B2>=100000, "High", B2>=50000, "Medium", TRUE, "Low") // older Excel versions: =IF(B2>=100000, "High", IF(B2>=50000, "Medium", "Low"))

What is the difference between system testing, SIT and UAT?

UAT and BA DocumentationEasy

Show answer

System testing is done by the QA team to verify that one system works against its functional and non-functional specifications. SIT (system integration testing) checks that connected systems exchange data correctly, such as CRM to billing to payment gateway. UAT (user acceptance testing) is done by business users to confirm the solution supports real business processes and is ready for go-live. UAT asks whether this is fit for our business, not just whether it matches the specification.

How do you calculate cycle time, touch time and process efficiency? Give an example.

Show answer

Cycle time (lead time) is the total elapsed time from the start to the end of a case. Touch time is the time someone actually works on it. Process cycle efficiency is touch time divided by cycle time. Example: a refund takes 5 working days (40 working hours) end to end, but the agents spend only 2 hours in total working on it. Efficiency is 2 / 40 = 5 percent, so 95 percent of the time is waiting, and queues are the main target.

Three departments describe the same order process in three different ways during workshops. How do you arrive at the true AS-IS?

Show answer

Treat each version as a hypothesis. Walk the process physically or observe real cases end to end, and pull a sample of 20 to 30 recent orders from the system to trace what actually happened. Compare timestamps and status changes with each department's story. Then hold a joint session, show the evidence-based map and mark the variants openly. Often all three are partly right because different order types follow different paths, which should be modelled explicitly.

After a redesign, average time spent in the app increased. Is that good?

Product AnalyticsMedium

Show answer

It depends on the product's goal. For a content or learning app, more time may mean more engagement. For a payments or banking app, more time can mean users struggle to complete tasks. Check task completion rate, time to complete key actions, errors, support tickets and retention. A metric is good only when it moves in line with the value users came for.

What is the logical order in which a SQL SELECT query is executed?

SQL for Business AnalysisHard

Show answer

Logically the database processes FROM and JOIN first, then WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY and finally LIMIT or TOP. This explains common errors: you cannot use a SELECT alias in WHERE because WHERE runs earlier, aggregate conditions must go in HAVING, and window functions cannot be filtered in WHERE, so you wrap them in a CTE or subquery. The optimiser may physically reorder steps, but the result follows this order.

Developers and testers interpret the same user story differently. How do you fix this?

Show answer

The story is ambiguous, so bring the three amigos together: BA or product owner, a developer and a tester. Walk through concrete examples, including edge cases and error cases, and write them as acceptance criteria, ideally in Given-When-Then format. Add business rules, sample data and mock-ups where needed. Update the story and use the same practice in refinement for future stories, so gaps are found before coding starts.

Describe a time you explained a complex technical topic to a non-technical audience.

Stakeholder CommunicationMedium

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.

What is the difference between gross margin and net margin?

Business Metrics and KPIsEasy

Show answer

Gross margin is revenue minus cost of goods sold, divided by revenue, and shows how profitable the product itself is. Net margin is net profit after all expenses, including salaries, rent, marketing, interest and tax, divided by revenue. A company can have a healthy 60 percent gross margin but a negative net margin if it overspends on marketing or overheads, which tells you where to look for fixes.

What are UAT entry and exit criteria? Give examples.

UAT and BA DocumentationMedium

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.

How is Kanban different from Scrum?

Requirements and AgileEasy

Show answer

Scrum works in fixed sprints with defined roles such as product owner and scrum master, planned sprint goals and ceremonies like planning, review and retrospective. Kanban has no sprints: work flows continuously across a board, and work-in-progress limits on each column prevent overload. Kanban measures cycle time and throughput. Scrum suits product development with planned increments; Kanban suits support, operations and reporting requests that arrive unpredictably.

What is a BRD review and who signs it off?

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.

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

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.

What is the difference between OLTP and OLAP systems?

SQL for Business AnalysisMedium

Show answer

OLTP handles many small day-to-day transactions; OLAP supports analysis over large historical data with aggregates and reporting.

Tell me about a time UAT revealed a major issue that earlier testing missed.

UAT and BA DocumentationMedium

Show answer

Situation: a new claims system passed QA, but in UAT a claims officer tried a real scenario with two policies on one claim. Task: as BA I had to assess and resolve it quickly. Action: I confirmed the requirement never covered multi-policy claims, quantified that 8 percent of claims were affected, and agreed a manual workaround while the change was built. Result: we went live on time, delivered the fix in the next release, and I added real case samples to future test design.

Write a SQL query that shows revenue per region with one column per quarter.

SQL for Business AnalysisMedium

Show answer

SELECT region, SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 1 THEN amount ELSE 0 END) AS q1, SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 2 THEN amount ELSE 0 END) AS q2, SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 3 THEN amount ELSE 0 END) AS q3, SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 4 THEN amount ELSE 0 END) AS q4 FROM orders WHERE EXTRACT(YEAR FROM order_date) = 2026 GROUP BY region;

What is a data table in Excel?

Show answer

A what-if tool that recalculates a formula for different inputs, for example loan payments across different rates and tenures.

Agile vs Waterfall?

Requirements and AgileEasy

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.

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

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.

How is a product owner's role different from a business analyst's role?

Show answer

The product owner owns the product vision and the backlog order, makes final priority decisions and accepts completed work on behalf of the business. The business analyst works on understanding problems in depth: eliciting and analysing requirements, modelling processes and data, writing detailed stories and acceptance criteria and supporting the team and testers. In smaller teams one person may do both, but the PO decides what, while the BA clarifies how it should work.

What is Customer Acquisition Cost (CAC) and what is CAC payback period?

Business Metrics and KPIsMedium

Show answer

CAC is total sales and marketing spend in a period divided by new customers acquired in that period. If you spend 10 lakh and gain 2,000 customers, CAC is 500 rupees. CAC payback period is how many months of gross profit from a customer it takes to recover that CAC. A shorter payback means the business can reinvest faster; many subscription businesses aim for under 12 months.

What is a SIPOC diagram and when do you use it before detailed process mapping?

Show answer

SIPOC stands for Suppliers, Inputs, Process, Outputs and Customers. It is a one-page, high-level table that lists 4 to 7 main process steps along with who supplies what and who receives the outputs. A BA uses it at the start of a process improvement project to agree on scope and boundaries with stakeholders before spending time on a detailed BPMN map. It prevents arguments later about where the process starts and ends.

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.

What is conditional formatting and how would you use it in a business report?

Excel for Business AnalystsEasy

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.

How do you calculate the percentage contribution of each category?