Business Analytics Interview Questions & Answers
All 416 unique questions in one place — 117 easy, 216 medium, 83 hard — grouped by topic.
Practise by topic
Practise the way your interview works
Do a quick SWOT analysis for an ed-tech company.
Show answer
What is the MECE principle in case interviews?
Show answer
What are TAM, SAM and SOM?
Show answer
What is the BCG growth-share matrix?
Show answer
What do interviewers evaluate in a business case interview?
Show answer
What is a PESTEL analysis?
Show answer
What is an impact-effort matrix and how do you use it to prioritise recommendations in a case?
Show answer
What is the 80/20 rule in business analysis?
Show answer
Explain Porter's Five Forces.
Show answer
A food delivery company's orders fell 15%. How do you investigate?
Show answer
What are the 4 Ps of marketing?
Show answer
What is a market entry strategy case?
Show answer
Guesstimate: how many cups of tea are sold in Delhi per day?
Show answer
Guesstimate: how many cars are sold in India every year?
Show answer
How would you estimate the market size for an electric scooter in India?
Show answer
How would you analyse the declining sales of a retail store?
Show answer
Guesstimate: how many pizzas are sold in Mumbai on a weekend?
Show answer
A client's profits are falling. How do you structure the problem?
Show answer
What is the profit equation and how do you use it in cases?
Show answer
How would you size the market for IT courses in Delhi NCR?
Show answer
What is a SWOT analysis?
Show answer
What is the difference between top-down and bottom-up market sizing?
Show answer
What is an issue tree and how does a hypothesis-driven approach work?
Show answer
What is the Ansoff matrix and how is it used in growth cases?
Show answer
What is value chain analysis?
Show answer
A hospital chain's average patient waiting time has risen from 30 to 50 minutes. How would you approach the case?
Show answer
An online learning platform finds that only 12 percent of learners complete paid courses. How do you analyse it?
Show answer
A bank's mobile app logins increased, but digital transactions fell. What could explain this?
Show answer
A ride-hailing app's ride cancellation rate rose from 8 to 14 percent. How would you structure the problem?
Show answer
Guesstimate: how many smartphones are sold in India each year?
Show answer
Guesstimate: how many weddings take place in India in a year?
Show answer
Tell me about a time you solved an ambiguous problem with limited data.
Show answer
A quick-commerce company wants to expand into Tier-2 cities. What would you analyse before recommending it?
Show answer
Guesstimate: how many laptops are sold in India each year?
Show answer
A bank wants to reduce customer churn. What would you do?
Show answer
Revenue grew but profit fell. Why could that happen?
Show answer
How would you price a new subscription product?
Show answer
How do you estimate the annual revenue of a coffee shop chain?
Show answer
Should a food-delivery app launch in a new city?
Show answer
What is root cause analysis and which techniques do you know?
Show answer
How do you use NPV and payback period to evaluate an investment in a case?
Show answer
Should a supermarket chain launch its own private-label products?
Show answer
A mid-size manufacturer must choose between building and buying a warehouse management system. How do you advise?
Show answer
Guesstimate: what is the annual revenue of one multiplex screen in a large Indian city?
Show answer
Guesstimate: how many new two-wheeler helmets are sold in India each year?
Show answer
How do you create a dashboard in Excel?
Show answer
Which Excel functions do business analysts use daily?
Show answer
XLOOKUP vs VLOOKUP?
Show answer
What is the difference between absolute, relative and mixed cell references in Excel?
Show answer
What are Excel Tables (Ctrl+T) and why should analysts use them?
Show answer
What is conditional formatting and how would you use it in a business report?
Show answer
A lookup formula returns #N/A for some rows even though the values look present. What could be wrong?
Show answer
Write an Excel formula that labels sales as High (100000 or more), Medium (50000 or more) or Low.
Show answer
Write an Excel formula to extract the domain from an email address.
Show answer
Write an Excel formula for working days between two dates excluding weekends and holidays.
Show answer
Write an Excel formula for the weighted average selling price across orders.
Show answer
Users in a shared Excel tracker keep typing region names with different spellings. How do you stop this?
Show answer
Write an Excel formula that lists all North region orders above 50,000 rupees.
Show answer
You added new rows to the source data, but your PivotTable does not show them even after refresh. Why?
Show answer
What is a data table in Excel?
Show answer
How do you build a PivotTable to analyse sales by region and product?
Show answer
How do you compute CAGR in Excel?
Show answer
What is sensitivity analysis?
Show answer
How do you chart a trend with a target line?
Show answer
Build a break-even analysis in Excel.
Show answer
How do you build a forecast in Excel?
Show answer
How would you forecast next quarter's sales in Excel?
Show answer
Which what-if analysis tools does Excel have?
Show answer
What is the use of the IFERROR function?
Show answer
How do you handle large datasets in Excel?
Show answer
How do you calculate the percentage contribution of each category?
Show answer
What is the difference between XLOOKUP and INDEX-MATCH?
Show answer
How do you use Excel's Scenario Manager?
Show answer
How do you protect a worksheet or workbook?
Show answer
How would you build a simple financial model in Excel?
Show answer
When would you use SUMPRODUCT instead of SUMIFS?
Show answer
What are dynamic array functions in Excel and how do they help analysts?
Show answer
You receive two customer lists from sales and billing and must reconcile them. How do you do it?
Show answer
Your monthly Excel report takes a full day of manual work. How would you automate it?
Show answer
Write Excel formulas to find the second-highest sales value and the name of the rep who achieved it.
Show answer
Write an Excel formula to count the number of unique customers in a column.
Show answer
Write an Excel formula for a two-way lookup that finds sales for a given product and month.
Show answer
Write an Excel formula for month-to-date sales up to today.
Show answer
Tell me about a time you found an error in a spreadsheet just before it went to management.
Show answer
The totals in your Excel report differ from the finance system by a few rupees. What could cause this?
Show answer
What is Excel Solver and give a business example of using it.
Show answer
Finance asks you to build a monthly cohort retention table in Excel from raw order data. How do you approach it?
Show answer
How can LET and LAMBDA make complex Excel formulas easier to maintain? Give an example.
Show answer
Agile vs Waterfall?
Show answer
What are wireframes and why are they useful for a BA?
Show answer
BRD vs FRD?
Show answer
What is Agile and how does Scrum work?
Show answer
What are functional and non-functional requirements?
Show answer
What is scope creep and how do you control it?
Show answer
What does a Business Analyst do?
Show answer
What is a use case diagram?
Show answer
Write a user story with acceptance criteria for password reset.
Show answer
What is gap analysis?
Show answer
What is the hierarchy of epic, feature and user story in Agile?
Show answer
What is backlog refinement and what is the BA's role in it?
Show answer
What is the difference between a sprint review and a sprint retrospective?
Show answer
How is Kanban different from Scrum?
Show answer
Use case vs user story?
Show answer
What is a traceability matrix?
Show answer
How do you prioritise requirements?
Show answer
What techniques do you use to elicit requirements?
Show answer
What is Kano model in prioritisation?
Show answer
How do you handle changing requirements?
Show answer
What is a BRD review and who signs it off?
Show answer
What are acceptance criteria?
Show answer
What is the role of a BA in Scrum?
Show answer
How would you prioritise 10 features with a limited budget?
Show answer
What is a product backlog vs a sprint backlog?
Show answer
What is a process flow and which tools do you use?
Show answer
What is a feasibility study?
Show answer
What is a user story and what makes it good?
Show answer
What is the difference between Definition of Ready and Definition of Done?
Show answer
Why do Agile teams estimate in story points rather than hours?
Show answer
What is AS-IS and TO-BE process modelling, and where does BPMN fit in?
Show answer
What is User Acceptance Testing (UAT) and what is the BA's role in it?
Show answer
What is a change request and how does change control work?
Show answer
How is a product owner's role different from a business analyst's role?
Show answer
In the middle of a sprint, a senior stakeholder asks to add an urgent feature. What do you do?
Show answer
A stakeholder's only requirement is 'make the app faster'. How do you turn this into clear requirements?
Show answer
Developers and testers interpret the same user story differently. How do you fix this?
Show answer
Write Given-When-Then acceptance criteria for applying a discount coupon at checkout.
Show answer
Split the epic 'Customers can track their order online' into user stories.
Show answer
What steps would you follow to create an AS-IS process map for a customer refund process?
Show answer
Tell me about a time you discovered a missed requirement late in a project.
Show answer
What is a spike in Agile and when would a business analyst request one?
Show answer
What is user story mapping and how does it help plan releases?
Show answer
Write non-functional requirements for an online payment page.
Show answer
You must gather requirements to replace a 15-year-old legacy system with no documentation. How do you approach it?
Show answer
A release passed all system testing, but business users reject it during UAT. What went wrong and what do you do?
Show answer
Describe a time you led the requirements phase of a large project.
Show answer
What is the difference between SQL and Excel for analysis?
Show answer
What is a primary key?
Show answer
SQL: total revenue per month.
Show answer
What is SQL and why do business analysts need it?
Show answer
Difference between INNER JOIN and LEFT JOIN?
Show answer
SQL: top 5 customers by spend.
Show answer
What are aggregate functions?
Show answer
What is the difference between UNION and UNION ALL?
Show answer
What is a foreign key and what is referential integrity?
Show answer
What is an index in a database and when can it hurt performance?
Show answer
Write a SQL query to find the second-highest salary in an employees table.
Show answer
Write a SQL query to list customers who have never placed an order.
Show answer
Write a SQL query that groups customers into spend buckets using CASE WHEN.
Show answer
What is the difference between DELETE, TRUNCATE and DROP in SQL?
Show answer
What is COALESCE in SQL and how does it differ from ISNULL or IFNULL?
Show answer
What is the difference between COUNT(*) and COUNT(column)?
Show answer
What is a subquery and when would you use it?
Show answer
How do you find duplicate customers?
Show answer
How do you write a query to find users active in consecutive months?
Show answer
What does GROUP BY do and how is HAVING different from WHERE?
Show answer
What is the difference between OLTP and OLAP systems?
Show answer
How do you validate data before analysis?
Show answer
How do you calculate monthly revenue growth in SQL?
Show answer
What is a CTE?
Show answer
How do you find the top 5 customers by revenue?
Show answer
How do you handle NULL values when calculating averages?
Show answer
What are window functions in SQL and how are they different from GROUP BY?
Show answer
What is the difference between ROW_NUMBER, RANK and DENSE_RANK?
Show answer
After joining orders to a payments table, your total revenue doubled. What went wrong?
Show answer
Two analysts report different monthly active user numbers from the same database. How do you resolve it?
Show answer
Write a SQL query for the top 3 products by revenue in each category.
Show answer
Write a SQL query to calculate the repeat purchase rate.
Show answer
Write a SQL query to get each customer's first order date and first order amount.
Show answer
Write a SQL query to show cumulative revenue by month.
Show answer
Write a SQL query that shows revenue per region with one column per quarter.
Show answer
Tell me about a time a SQL query you wrote gave wrong results. How did you catch it?
Show answer
What is a self join? Give a business example.
Show answer
Write a SQL query to find the percentage of orders delivered late in each city.
Show answer
SQL: month-over-month revenue growth.
Show answer
What is normalisation, and why are analytics tables often denormalised?
Show answer
What is the logical order in which a SQL SELECT query is executed?
Show answer
A report query on a 200 million row table takes 15 minutes. How do you optimise it?
Show answer
Your LEFT JOIN report should list all customers, but customers without orders are missing. Why?
Show answer
Write a SQL query for a 7-day rolling average of daily revenue.
Show answer
Write a SQL query for a signup to purchase funnel from an events table.
Show answer
A query using NOT IN to find customers without orders returns zero rows, although you know such customers exist. Why?
Show answer
What is the difference between a chart and a dashboard?
Show answer
What is the difference between Power BI Desktop, Power BI Service and Power BI Mobile?
Show answer
What is the difference between a calculated column and a measure in Power BI?
Show answer
What is Power Query and what is it used for?
Show answer
What are dimensions and measures in Tableau?
Show answer
Which chart would you choose for trend, part-to-whole, comparison and distribution?
Show answer
What Power Query steps would you use to clean a messy monthly sales file?
Show answer
Write Tableau calculated fields for profit ratio and a flag for loss-making orders.
Show answer
What are the steps to publish and share a Power BI report with your team?
Show answer
What is the difference between a report and a dashboard in Power BI Service?
Show answer
Tell me about a time you had to learn a new analytics tool quickly for a project.
Show answer
What is Power Pivot?
Show answer
What is a star schema and why do BI tools prefer it?
Show answer
What does the CALCULATE function do in DAX?
Show answer
Compare Import mode, DirectQuery and Live Connection in Power BI.
Show answer
What is row-level security in Power BI and how do you set it up?
Show answer
What is a date table in Power BI and why should you mark it as a date table?
Show answer
What is the difference between a Tableau extract and a live connection?
Show answer
A manager says the dashboard total does not match the finance team's Excel sheet. What do you do?
Show answer
Your measure shows the same value on every row of a matrix. Why might that happen?
Show answer
A business head wants 25 charts on one dashboard page. How do you respond?
Show answer
The scheduled refresh failed overnight and leadership reviews the dashboard at 10 am. What do you do?
Show answer
Write DAX measures for Total Sales, Sales Last Year and Year-over-Year growth percent.
Show answer
Write a DAX measure that shows each category's percent share of total sales.
Show answer
Tell me about a dashboard you built that changed a business decision.
Show answer
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?
Show answer
Write a DAX measure for the product return rate that avoids divide-by-zero errors.
Show answer
Explain row context and filter context in DAX.
Show answer
What are LOD expressions in Tableau and how do FIXED, INCLUDE and EXCLUDE differ?
Show answer
Why should you avoid bidirectional relationships in a Power BI model?
Show answer
What is incremental refresh and when do you need it?
Show answer
Your Power BI report takes 30 seconds to load. How do you speed it up?
Show answer
Five departments each build their own Power BI reports with different revenue numbers. How would you design a better BI setup?
Show answer
A Tableau dashboard on a 50 million row data source responds slowly to filters. How do you fix it?
Show answer
Write a DAX measure for a running total of sales by date.
Show answer
Write a DAX measure to count distinct active customers in the last 30 days.
Show answer
What is a KPI and give examples for an e-commerce business?
Show answer
KPI vs metric?
Show answer
What is the difference between revenue and profit?
Show answer
What is the difference between gross margin and net margin?
Show answer
What is the difference between churn rate and retention rate?
Show answer
What is ARPU and how is it calculated?
Show answer
What is Average Order Value and how can a business increase it?
Show answer
What is the difference between a vanity metric and an actionable metric?
Show answer
What is Net Promoter Score (NPS) and what are its limitations?
Show answer
A subscription app starts the month with 8,000 customers, gains 1,200 and loses 400. Calculate churn and net growth.
Show answer
How do you analyse variance between budget and actual?
Show answer
What is customer lifetime value?
Show answer
What are fixed costs and variable costs?
Show answer
What is a break-even point?
Show answer
How do you validate that a report's numbers are correct?
Show answer
How do you evaluate a marketing campaign's ROI?
Show answer
What is Customer Acquisition Cost (CAC) and what is CAC payback period?
Show answer
What does the LTV to CAC ratio tell you and what is a healthy value?
Show answer
What are leading and lagging indicators? Give examples.
Show answer
How are OKRs different from KPIs?
Show answer
Revenue grew 20 percent this quarter but the number of active customers stayed flat. How do you interpret it?
Show answer
Monthly subscription churn jumped from 3 percent to 5 percent. How do you investigate?
Show answer
The CEO wants one KPI to judge the customer support team. What would you propose?
Show answer
A KPI on your dashboard dropped 40 percent overnight. What are your first steps?
Show answer
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?
Show answer
An order has a value of 600 rupees, product cost 360, delivery 60, payment fee 12 and a discount of 50. What is the contribution margin?
Show answer
Describe a time you had to present disappointing numbers to leadership.
Show answer
What is a balanced scorecard?
Show answer
What is a KPI tree?
Show answer
What is a North Star metric and how do you choose one?
Show answer
What are unit economics and why do investors and leaders focus on them?
Show answer
Marketing and product teams define 'active user' differently and report conflicting numbers. How do you fix this?
Show answer
The sales team keeps hitting its revenue target, but company margins are falling. What would you recommend?
Show answer
A lender is launching a new personal loan product. What KPIs would you set up?
Show answer
Tell me about a time you challenged how a metric was defined.
Show answer
What is the difference between bookings, billings and revenue?
Show answer
What are MRR and ARR, and how do you calculate net revenue retention?
Show answer
Write a SQL query to calculate monthly customer churn rate for a subscription business.
Show answer
What is a stakeholder and who are the typical stakeholders in a project?
Show answer
What is a power-interest grid and how do you use it?
Show answer
How do you adapt your communication for executives versus technical teams?
Show answer
What is data storytelling and why does it matter for analysts?
Show answer
You need to explain the results of a sales forecast model to a non-technical sales team. How do you do it?
Show answer
How would you structure a weekly project status update for stakeholders?
Show answer
Tell me about yourself, for a business analyst role.
Show answer
Why do you want to become a business analyst?
Show answer
Tell me about a time you worked under a tight deadline.
Show answer
Tell me about a time you received critical feedback on your work.
Show answer
Where do you see yourself in five years as a business analyst?
Show answer
Tell me about a time careful listening helped you uncover a hidden requirement.
Show answer
What is a RACI matrix?
Show answer
Tell me about a time you handled a difficult stakeholder.
Show answer
Stakeholders give conflicting requirements. What do you do?
Show answer
What is a stakeholder analysis?
Show answer
What is the answer-first or pyramid principle approach to presenting analysis?
Show answer
What is a communication plan in a project and what does it include?
Show answer
What does expectation management mean for a business analyst?
Show answer
How do you run an effective stakeholder meeting?
Show answer
A stakeholder asks for a detailed report by tomorrow, but it realistically needs a week. What do you do?
Show answer
A stakeholder keeps skipping review meetings and then rejects the deliverable at the end. How do you prevent this?
Show answer
Your project is going to miss its deadline by two weeks. How do you communicate this?
Show answer
Tell me about a time you said no to a stakeholder.
Show answer
Tell me about a time you misunderstood a requirement. What did you learn?
Show answer
Describe a time you explained a complex technical topic to a non-technical audience.
Show answer
How do you write an effective executive summary for an analysis report?
Show answer
Tell me about a time you worked with stakeholders in a different time zone or culture.
Show answer
How do you manage conflicting requirements from two senior stakeholders?
Show answer
How do you influence stakeholders when you have no direct authority?
Show answer
Your analysis contradicts a strongly held belief of the vice president. How do you handle it?
Show answer
Developers say a requirement is not technically feasible, but the business insists on it. How do you mediate?
Show answer
Finance and sales blame each other for wrong numbers in a monthly report. How do you resolve it as the analyst?
Show answer
Describe a time you influenced an important decision without having authority.
Show answer
Tell me about a time you led or mentored a team of analysts.
Show answer
What is a Minimum Viable Product (MVP)?
Show answer
What is product analytics and how is it different from business reporting?
Show answer
What are DAU, WAU and MAU, and what is the stickiness ratio?
Show answer
What is cohort analysis and why is it useful?
Show answer
What is funnel analysis?
Show answer
What is A/B testing?
Show answer
What is feature adoption rate and how do you measure it?
Show answer
Control has 10,000 users with 400 purchases and the variant has 10,000 users with 460 purchases. Calculate the lift.
Show answer
What is the difference between correlation and causation in product analytics?
Show answer
What are heatmaps and session recordings, and when would you use them alongside funnel analysis?
Show answer
How would you decide whether to launch a new product?
Show answer
How would you improve a company's low app conversion rate?
Show answer
How would you measure the success of a new feature?
Show answer
What do statistical significance and p-value mean in an A/B test?
Show answer
What is user activation and what is an 'aha moment'?
Show answer
What is the AARRR or pirate metrics framework?
Show answer
What is an event tracking plan and why does it matter?
Show answer
What are guardrail metrics in experiments?
Show answer
Daily active users dropped 10 percent week over week. How do you investigate?
Show answer
A new onboarding flow increased sign-ups by 15 percent, but Day-7 retention fell. How do you analyse this?
Show answer
A feature launched two months ago is used by only 4 percent of users. What would you do?
Show answer
After a redesign, average time spent in the app increased. Is that good?
Show answer
Push notifications increased weekly engagement, but app uninstalls also rose. What do you recommend?
Show answer
Write a SQL query to calculate the DAU to MAU stickiness ratio for a month.
Show answer
What steps would you follow to create a tracking plan for a new 'save for later' feature?
Show answer
Tell me about a time your analysis changed a product decision.
Show answer
How do sample size and minimum detectable effect affect an A/B test design?
Show answer
What is the novelty effect, and why should A/B tests run for full weeks?
Show answer
An A/B test shows a 5 percent higher conversion rate, but revenue per user is lower. Should you ship it?
Show answer
A product manager wants to stop an A/B test after three days because the variant is winning. What do you advise?
Show answer
A feature was launched to all users at once without an A/B test. How would you measure its impact?
Show answer
Overall conversion fell this month, yet conversion improved for both mobile and desktop users. How is that possible?
Show answer
Write a SQL query for Day-7 retention by weekly sign-up cohort.
Show answer
Tell me about an experiment that failed and what you learned.
Show answer
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?
Show answer
What is BPMN and why do business analysts use it?
Show answer
What are the four basic categories of elements in BPMN?
Show answer
What is the difference between a pool and a lane in BPMN?
Show answer
What are start, intermediate and end events in BPMN?
Show answer
What is the difference between a task and a sub-process in BPMN?
Show answer
What is a swimlane diagram and how is it different from a simple flowchart?
Show answer
What is the difference between a process, a procedure and a work instruction?
Show answer
What is the difference between sequence flow and message flow in BPMN?
Show answer
Explain exclusive, parallel and inclusive gateways in BPMN.
Show answer
What is a SIPOC diagram and when do you use it before detailed process mapping?
Show answer
What are process levels such as L0 to L4 in a process architecture?
Show answer
What are data objects and data stores in BPMN?
Show answer
Your AS-IS map of a loan approval process shows 14 handoffs between teams. How do you identify improvements?
Show answer
Three departments describe the same order process in three different ways during workshops. How do you arrive at the true AS-IS?
Show answer
Your process diagram has grown to 80 shapes on one page and stakeholders say they cannot read it. What do you do?
Show answer
A new TO-BE process went live three months ago. How do you prove that the improvement actually worked?
Show answer
Describe how you would model an employee leave approval process in BPMN.
Show answer
What steps would you follow to run a process discovery workshop?
Show answer
How do you calculate cycle time, touch time and process efficiency? Give an example.
Show answer
What checklist do you apply to a BPMN diagram before sharing it with stakeholders?
Show answer
Tell me about a time you mapped a process and discovered a major inefficiency.
Show answer
What is an event-based gateway and when would you use it?
Show answer
What is a boundary event in BPMN, and how do interrupting and non-interrupting boundary events differ?
Show answer
What is value stream mapping and how is it different from BPMN?
Show answer
What is process mining and how does it help a business analyst?
Show answer
What is DMN and how does it relate to BPMN?
Show answer
Leadership wants to automate an invoice approval process with RPA. What do you check in the process model before agreeing?
Show answer
Your TO-BE process cuts the account-opening cycle time by half, but the compliance team rejects it. How do you handle it?
Show answer
Describe a BPMN model for a purchase order process where credit check and stock check happen at the same time.
Show answer
Describe a time when stakeholders resisted a process change you proposed. How did you handle it?
Show answer
What are the three main financial statements and how are they linked?
Show answer
What is EBITDA and why is it widely used?
Show answer
What is working capital and why does it matter?
Show answer
What are the current ratio and the quick ratio?
Show answer
What is the difference between capex and opex?
Show answer
What is the time value of money?
Show answer
What is the debt-to-equity ratio and how do you interpret it?
Show answer
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
Write an Excel formula to calculate the monthly EMI for a loan of 10 lakh rupees at 9 percent annual interest for 5 years.
Show answer
What is the difference between accrual accounting and cash accounting?
Show answer
What is the difference between ROI, ROE and ROCE?
Show answer
What is the cash conversion cycle?
Show answer
What is horizontal and vertical analysis of financial statements?
Show answer
What is a business case document and what does it contain?
Show answer
A company reports a profit every quarter but is running out of cash. How do you explain and investigate it?
Show answer
Gross margin fell from 38 percent to 34 percent in one quarter. How do you investigate?
Show answer
Inventory days rose from 45 to 70 over two quarters. What could be the causes and what would you recommend?
Show answer
Write an Excel formula for the NPV of a project with an initial investment today and five yearly cash inflows.
Show answer
Write Excel formulas for IRR with yearly cash flows and XIRR with irregular dates.
Show answer
Write a SQL query that shows revenue, cost and gross margin percent by product category.
Show answer
Prepare a simple cost-benefit analysis for automating invoice processing.
Show answer
Tell me about a time you built a business case for a project. Was it approved?
Show answer
Describe a time your analysis found a cost-saving opportunity.
Show answer
What is IRR and how is it different from NPV?
Show answer
What is operating leverage and why does it matter in business analysis?
Show answer
Vendor A has a lower licence price, but Vendor B has lower running costs. How do you compare them?
Show answer
What is the difference between zero-based budgeting and incremental budgeting?
Show answer
A product line shows a loss after allocated overheads. Leadership wants to shut it down. How do you advise?
Show answer
The CFO asks whether the company should lease or buy 50 delivery vans. How do you approach the analysis?
Show answer
A project's business case promised 30 percent cost savings, but after go-live only 10 percent is realised. What do you do?
Show answer
What is the difference between system testing, SIT and UAT?
Show answer
What is the difference between a test scenario and a test case?
Show answer
What is UAT sign-off and who should give it?
Show answer
What is the difference between defect severity and defect priority?
Show answer
What is the difference between alpha testing and beta testing?
Show answer
What is the difference between release notes and a user manual?
Show answer
Write a UAT test case for logging in to a banking app with OTP.
Show answer
What is a UAT test plan and what does it contain?
Show answer
What are UAT entry and exit criteria? Give examples.
Show answer
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
What sections does a good software requirements specification (SRS) contain?
Show answer
What is a data dictionary and why does a business analyst maintain one?
Show answer
What is a RAID log and how does a BA use it?
Show answer
Tell me about a time poor or outdated documentation caused a problem. How did you fix it?
Show answer
Explain the defect life cycle.
Show answer
UAT starts tomorrow, but the business has not nominated any testers. What do you do?
Show answer
During UAT, users log 60 defects, but you suspect many are actually new requirements. How do you handle it?
Show answer
A business tester raises a defect, and the developer closes it as 'works as designed'. How do you resolve it?
Show answer
After many sprints, project documentation is out of date and new team members are confused. What do you do?
Show answer
Write a defect report for an invoice that calculates GST incorrectly.
Show answer
What steps do you follow to plan and run a UAT cycle?
Show answer
Write a SQL query to find requirements that have no linked UAT test case.
Show answer
Tell me about a time UAT revealed a major issue that earlier testing missed.
Show answer
How do you plan test data for UAT?
Show answer
What is a cutover plan and a go-live readiness checklist?
Show answer
What is operational acceptance testing and how is it different from UAT?
Show answer
A critical defect is found on the last day of UAT, and the go-live date cannot move. What do you do?
Show answer
Because of a tight deadline, the business sponsor wants to skip UAT and go live directly. How do you respond?
Show answer
Write SQL checks to validate a customer data migration between the legacy and new systems during UAT.
Show answer
Describe a time you recommended delaying a go-live.
Show answer
Frequently asked questions
What skills do companies in India test in business analyst interviews?
Most interviews test four areas: Excel and SQL for data work, requirement gathering and Agile basics, business understanding through cases, guesstimates and KPIs, and communication through behavioural questions. Product and digital companies add product analytics and A/B testing, while IT services firms focus more on BRDs, user stories and UAT. Power BI or Tableau is increasingly expected, especially for analyst roles that own reporting.
Do business analyst interviews include coding?
Usually not general programming, but SQL is very common, often as a live query writing round or an online test with joins, aggregations and window functions. Excel formula questions are also asked live. Python is rarely required for BA roles, though product and data-heavy analyst roles may ask basic pandas. Focus on writing clean, correct SQL and explaining your logic aloud.
How should a fresher prepare for a business analyst role without work experience?
Build two or three projects that show the full BA cycle: understand a problem, gather data, analyse it in Excel or SQL, build a Power BI dashboard and write recommendations. Write sample user stories and a process map for a familiar app. Practise guesstimates and simple cases aloud. Use internships, college projects or volunteer work as STAR stories for behavioural questions. Certifications help a little, but projects matter more.
How are case and guesstimate rounds evaluated?
Interviewers look at your process more than the final number. They expect you to clarify the question, state assumptions, build a clear MECE structure, calculate accurately with round numbers and sanity check the result against something known. For business cases they want a prioritised hypothesis, use of data given during the case and a crisp recommendation with risks. Thinking aloud and staying calm under ambiguity matter a lot.
Is Power BI or Tableau more important for business analyst jobs in India?
Power BI appears in more Indian job postings, especially in IT services, BFSI and companies already standardised on Excel and Office tools, while Tableau is common in some analytics firms and global capability centres. Concepts transfer well between them: data modelling, measures, filters, chart choice and dashboard design. Learn one deeply, preferably Power BI with DAX, and understand the other's basics such as Tableau LOD expressions.
What salary can a business analyst expect in India?
Ranges vary widely by city, company type and skills. Freshers and interns typically start around 3 to 6 lakh per year, mid-level analysts with two to five years often earn 7 to 15 lakh, and senior business analysts or leads can earn 15 to 30 lakh or more, with product companies and global capability centres usually paying higher. Strong SQL, BI tools and domain knowledge in areas like banking or supply chain raise offers.