Skip to content
Business Analytics
All courses OffersPlacement Report
‹ Back to previous sectionCourse homeAll page URLs

Business Analytics Interview Questions in Bangalore

36 practice questions with answers for Business Analytics interviews in Bangalore.

Business Analytics jobs in Bangalore

Bangalore (Bengaluru) is India's largest technology hub, with global product companies, engineering centres, unicorn start-ups and big IT-services campuses. Product-company interviews here are usually deeper, with more scenario, design and hands-on rounds.

Below are 36 questions that match the mix of service, product and domain employers hiring business analysts in Bangalore.

Solved for BangaloreStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
3 questions free Unlock the rest in seconds
01

Write a SQL query that groups customers into spend buckets using CASE WHEN.

SQL for Business AnalysisEasy
Save to ▾
Show answer
SELECT CASE WHEN total_spend >= 50000 THEN 'High' WHEN total_spend >= 10000 THEN 'Medium' ELSE 'Low' END AS segment, COUNT(*) AS customers FROM ( SELECT customer_id, SUM(amount) AS total_spend FROM orders GROUP BY customer_id ) t GROUP BY 1 ORDER BY customers DESC;
02

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

Product AnalyticsMedium
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.
03

What is a process flow and which tools do you use?

Requirements and AgileMedium
Save to ▾
Show answer
A diagram of steps, decisions and owners in a process, made using BPMN or flowcharts in tools like Visio, Lucidchart or draw.io.
04

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

Case Studies and GuesstimatesMedium
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.
05

A query using NOT IN to find customers without orders returns zero rows, although you know such customers exist. Why?

SQL for Business AnalysisHard
Save to ▾
Show answer
The subquery probably returns at least one NULL, for example SELECT customer_id FROM orders where some orders have a NULL customer_id. With NOT IN, comparing any value to NULL gives UNKNOWN, so no row passes the condition. Fix it by using NOT EXISTS with a correlated subquery, or a LEFT JOIN with WHERE o.customer_id IS NULL, or by adding WHERE customer_id IS NOT NULL inside the subquery. NOT EXISTS is the safest habit.
06

Revenue grew 20 percent this quarter but the number of active customers stayed flat. How do you interpret it?

Business Metrics and KPIsMedium
Save to ▾
Show answer
Growth came from more value per customer, not more customers. Break revenue into customers times orders per customer times average order value to see which moved. It could be price increases, larger baskets, a shift to premium products or a few large accounts. Then check risks: is new customer acquisition stalling, is churn being masked, and is growth concentrated in a small segment that could leave?
07

What is data storytelling and why does it matter for analysts?

Stakeholder CommunicationEasy
Save to ▾
Show answer
Data storytelling combines data, visuals and narrative so the audience understands what happened, why, and what to do. A good story has context, a clear insight, supporting evidence in one or two simple charts and a recommendation. Accurate numbers alone rarely change decisions; people act when they see the implication. Remove chart clutter, highlight the key point with colour and use titles that state the conclusion.
08

What is the novelty effect, and why should A/B tests run for full weeks?

Product AnalyticsHard
Save to ▾
Show answer
The novelty effect is a temporary lift because users are curious about something new, which fades after a few days; the opposite, change aversion, causes a temporary drop. Running tests for at least one or two full weeks covers weekday and weekend behaviour and lets these effects settle. You can also check whether the lift is stable over time and among new users who never saw the old version.
09

What is a market entry strategy case?

Case Studies and GuesstimatesMedium
Save to ▾
Show answer
Decide whether and how to enter a market by evaluating attractiveness, competition, capabilities and entry mode (build, buy, partner), then risks and next steps.
10

Two analysts report different monthly active user numbers from the same database. How do you resolve it?

SQL for Business AnalysisMedium
Save to ▾
Show answer
Put both queries side by side and compare definitions: which events count as active, time zone, calendar versus rolling month, test and internal accounts, deleted users, and DISTINCT on user ID versus device ID. Run both on a single day to find where they diverge. Agree on one definition with the metric owner, document it, and publish it as a shared view or metric so everyone queries the same logic.
11

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

Requirements and AgileMedium
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.
12

Write a SQL query that shows revenue, cost and gross margin percent by product category.

Financial and Business AnalysisMedium
Save to ▾
Show answer
SELECT p.category, SUM(oi.quantity * oi.unit_price) AS revenue, SUM(oi.quantity * p.unit_cost) AS cost, ROUND(100.0 * (SUM(oi.quantity * oi.unit_price) - SUM(oi.quantity * p.unit_cost)) / NULLIF(SUM(oi.quantity * oi.unit_price), 0), 2) AS gross_margin_pct FROM order_items oi JOIN products p ON p.product_id = oi.product_id GROUP BY p.category ORDER BY gross_margin_pct DESC;
13

How do you analyse variance between budget and actual?

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

Write an Excel formula for month-to-date sales up to today.

Excel for Business AnalystsMedium
Save to ▾
Show answer
// Dates in Sales[Date], amounts in Sales[Amount] =SUMIFS(Sales[Amount], Sales[Date], ">=" & EOMONTH(TODAY(), -1) + 1, Sales[Date], "<=" & TODAY()) // EOMONTH(TODAY(),-1)+1 gives the first day of the current month
15

Write a defect report for an invoice that calculates GST incorrectly.

UAT and BA DocumentationMedium
Save to ▾
Show answer
Title: Invoice applies 12 percent GST instead of 18 percent for service items. Environment: UAT, build 2.4.1. Steps: create an order with service item SRV-101 at 1,000 rupees for a customer in Maharashtra and generate the invoice. Expected: CGST 90 and SGST 90, total 1,180. Actual: CGST 60 and SGST 60, total 1,120. Severity: high, as it affects tax compliance. Attachments: invoice PDF and screenshot. Linked requirement: FR-TAX-07.
16

Your process diagram has grown to 80 shapes on one page and stakeholders say they cannot read it. What do you do?

Process Modelling and BPMNMedium
Save to ▾
Show answer
Restructure it into levels. Create a high-level map with 7 to 10 main steps, then collapse detailed parts into sub-processes with their own diagrams. Move complex decision logic into a decision table rather than chains of gateways. Show the happy path first and handle exceptions in separate views. Use consistent naming in verb-noun form and remove duplicated steps. Finally, test readability by asking a stakeholder to explain the diagram back to you.
17

How do you write an effective executive summary for an analysis report?

Stakeholder CommunicationMedium
Save to ▾
Show answer
Put it first and keep it to one page or five lines on a slide. Start with the answer or recommendation, then the two or three key findings that support it, each with a number, then the impact in rupees or percentage, and finally the decision or action needed and by when. Avoid methodology details, which go in the appendix. Test it by asking whether a busy leader could act after reading only this section.
18

What steps would you follow to create an AS-IS process map for a customer refund process?

Requirements and AgileMedium
Save to ▾
Show answer
Define the scope: where the process starts, such as a refund request, and where it ends, such as money credited. Identify the roles involved and draw swimlanes. Interview and observe each role, capturing steps, decisions, systems used, handoffs and time taken. Draw the flow in BPMN, mark pain points like rework loops and waiting time, and add measures such as average refund time. Validate the map with the people who do the work.
19

How do you plan test data for UAT?

UAT and BA DocumentationHard
Save to ▾
Show answer
Start from the test cases and list the data each needs: customer types, product variants, edge values and historical records. Decide whether to use masked copies of production data, synthetic data or both, because real personal data must be anonymised under data protection rules such as the DPDP Act. Prepare data for negative and boundary cases, keep a refresh plan for repeated cycles, and assign owners. Poor test data is one of the most common causes of blocked UAT days.
20

What is a subquery and when would you use it?

SQL for Business AnalysisMedium
Save to ▾
Show answer
A query nested inside another, used for filtering or calculating values such as customers whose spend is above the average.
21

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

Product AnalyticsMedium
Save to ▾
Show answer
The p-value is the probability of seeing a difference at least as large as observed if the change truly had no effect. If it is below the chosen threshold, often 0.05, the result is called statistically significant. It does not mean there is a 95 percent chance the variant is better, and significance is not the same as business importance. Always report the confidence interval of the lift as well.
22

A company reports a profit every quarter but is running out of cash. How do you explain and investigate it?

Financial and Business AnalysisMedium
Save to ▾
Show answer
Profit is an accrual figure, while cash depends on timing. Check working capital first: receivables may be growing because customers pay late, inventory may be piling up, or suppliers may be demanding faster payment. Then look at large capex, loan repayments, and dividends. Review the cash flow statement and compute days sales outstanding and inventory days over time. Fixes include tighter credit terms, collection drives, inventory reduction and renegotiating supplier terms.
23

Tell me about a time careful listening helped you uncover a hidden requirement.

Stakeholder CommunicationEasy
Save to ▾
Show answer
Situation: during interviews for a new order system, a warehouse supervisor kept mentioning that Friday evenings were chaotic. Task: understand whether this mattered for the requirements. Action: instead of moving on, I asked what happened on Fridays and learned that bulk orders were split manually because of truck capacity limits. Result: we added an automatic order-splitting rule that nobody had listed, which saved the team about four hours a week and avoided a likely UAT failure.
24

What is the profit equation and how do you use it in cases?

Case Studies and GuesstimatesMedium
Save to ▾
Show answer
Profit = Revenue minus Cost, where revenue = price x volume and cost = fixed + variable. Split each part to find which one explains a change.
25

Describe how you would model an employee leave approval process in BPMN.

Process Modelling and BPMNMedium
Save to ▾
Show answer
Use one pool for the company with lanes for Employee, Manager and HR system. Start event: leave request submitted. Task: system checks leave balance. Exclusive gateway: balance sufficient? If no, end event that notifies the employee. If yes, user task: manager reviews. Add an interrupting timer boundary event of 3 days that escalates to the skip-level manager. Gateway: approved or rejected. Approved path updates the leave balance and calendar, then both paths notify the employee and end.
26

What is a boundary event in BPMN, and how do interrupting and non-interrupting boundary events differ?

Process Modelling and BPMNHard
Save to ▾
Show answer
A boundary event is attached to the edge of an activity and reacts to something that happens while that activity is running. An interrupting boundary event (solid double border) cancels the activity and takes the exception path, for example a 24-hour timeout cancelling manual approval. A non-interrupting one (dashed border) starts a parallel path while the activity continues, for example sending a reminder email after 12 hours without stopping the approval task.
27

What is a break-even point?

Business Metrics and KPIsMedium
Save to ▾
Show answer
The sales volume where total revenue equals total cost. It equals fixed cost divided by contribution margin per unit.
28

Write non-functional requirements for an online payment page.

Requirements and AgileMedium
Save to ▾
Show answer
NFR-01 Performance: the payment page loads within 2 seconds for 95 percent of requests at 500 concurrent users. NFR-02 Availability: 99.9 percent monthly uptime outside planned maintenance. NFR-03 Security: card data is never stored by the application, and all traffic uses TLS 1.2 or higher. NFR-04 Compliance: the flow meets PCI DSS and RBI payment guidelines. NFR-05 Usability: works on mobile screens from 360 pixels wide. NFR-06 Audit: every transaction attempt is logged with a timestamp.
29

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

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

What is a RAID log and how does a BA use it?

UAT and BA DocumentationMedium
Save to ▾
Show answer
A RAID log tracks Risks, Assumptions, Issues and Dependencies for a project. Each entry has an ID, description, owner, impact, status, mitigation or action, and due date. A risk is something that may happen, an issue is something that has already happened, an assumption is believed true but unverified, and a dependency is something the project needs from others. A BA uses it to record requirement assumptions and dependencies, and reviews it weekly so nothing is silently forgotten.
31

What is the difference between accrual accounting and cash accounting?

Financial and Business AnalysisMedium
Save to ▾
Show answer
Under accrual accounting, revenue is recorded when it is earned and expenses when they are incurred, regardless of when cash moves. Under cash accounting, transactions are recorded only when cash is received or paid. Companies in India report under accrual-based standards (Ind AS). Example: an annual software contract billed in April is recognised as revenue month by month over 12 months under accrual, even though all the cash came in April.
32

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?

Power BI and TableauMedium
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.
33

What is EBITDA and why is it widely used?

Financial and Business AnalysisEasy
Save to ▾
Show answer
EBITDA is earnings before interest, taxes, depreciation and amortisation. It approximates operating profit generated by the core business before financing choices, tax rules and non-cash accounting charges. It is useful for comparing companies with different debt levels or asset ages and is used in valuation multiples such as EV/EBITDA. Its weakness is that it ignores capital expenditure and working capital needs, so a company can show strong EBITDA and still burn cash.
34

What is the answer-first or pyramid principle approach to presenting analysis?

Stakeholder CommunicationMedium
Save to ▾
Show answer
Start with the main conclusion or recommendation, then give the two or three supporting reasons, and only then the detailed data. Senior stakeholders have little time, so a summary like 'Churn rose because of payment failures; fixing retries can save 4 lakh a month' should come first. Detail goes in the appendix. It is the opposite of a chronological walk through every step of the analysis.
35

What sections does a good software requirements specification (SRS) contain?

UAT and BA DocumentationMedium
Save to ▾
Show answer
A typical SRS includes purpose, scope and definitions; overall description with users, operating environment, assumptions and constraints; functional requirements, each with a unique ID, description, priority and acceptance criteria; external interface requirements for UI, APIs and integrations; non-functional requirements such as performance, security, availability and compliance; data requirements; and appendices with diagrams and a traceability reference. Each requirement should be clear, testable and traceable to a business need.
36

What techniques do you use to elicit requirements?

Requirements and AgileMedium
Save to ▾
Show answer
Interviews, workshops, surveys, observation, document analysis, prototyping and brainstorming, chosen according to stakeholders and project stage.

Companies with offices in Bangalore (134)

IT services

TCS

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Mumbai, Chennai, Pune +2

View questions
IT services

Infosys

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Bengaluru, Mysuru, Pune +2

View questions
IT services

Wipro

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Bengaluru, Hyderabad, Pune +2

View questions
Consulting

Accenture

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Bengaluru, Hyderabad, Pune +2

View questions
IT services

Cognizant

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Chennai, Bengaluru, Pune +2

View questions
IT services

Capgemini

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Mumbai, Bengaluru, Pune +2

View questions
Consulting

Deloitte

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Hyderabad, Bengaluru, Mumbai +2

View questions
Product

Amazon

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Bengaluru, Hyderabad, Chennai +2

View questions
Product

Google

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Bengaluru, Hyderabad, Gurugram +2

View questions
Product

Meta

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Gurugram, Bengaluru, Hyderabad +1

View questions
Product

Microsoft

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Hyderabad, Bengaluru, Noida +2

View questions
Hardware & semiconductors

Apple

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Hyderabad, Bengaluru, Mumbai +1

View questions
Product

Adobe

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Noida, Bengaluru, Gurugram

View questions
Product

Oracle

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Bengaluru, Hyderabad, Noida +2

View questions
Product

Salesforce

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Hyderabad, Bengaluru, Mumbai +1

View questions
Product

ServiceNow

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Hyderabad, Bengaluru

View questions
Product

Atlassian

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Bengaluru

View questions
Fintech

Intuit

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Bengaluru

View questions
Hardware & semiconductors

Cisco

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Bengaluru, Pune, Chennai

View questions
Product

LinkedIn

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Bengaluru, Gurugram, Mumbai

View questions
Product

Uber

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Bengaluru, Hyderabad, Gurugram

View questions
E-commerce & consumer tech

Walmart

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Bengaluru, Chennai, Gurugram

View questions
E-commerce & consumer tech

Flipkart

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Bengaluru, Hyderabad

View questions
E-commerce & consumer tech

Swiggy

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Bengaluru, Hyderabad

View questions
+ 110 more companies — see all 155

Frequently asked questions

Which companies hire Business Analytics professionals in Bangalore?

Companies with large offices in Bangalore include TCS, Infosys, Wipro, Accenture, Cognizant, Capgemini, Deloitte, Amazon, Google, Meta. Use their company pages below to practise employer-specific sets.

Are Business Analytics interviews in Bangalore different from other cities?

The questions depend more on the company than the city. Bangalore's mix of employers decides the style: Product-company interviews here are usually deeper, with more scenario, design and hands-on rounds

How do I find Business Analytics jobs in Bangalore?

Shortlist companies with Bangalore offices, keep your CV focused on Business Analytics projects, apply on company career pages and job portals with the Bangalore filter, and practise the questions on this page before each interview.

Other cities

DelhiNoidaGurgaonHyderabadPuneChennaiMumbaiKolkataAhmedabadJaipurLucknowChandigarhIndoreKochiCoimbatoreBhubaneswarNagpurVisakhapatnamThiruvananthapuram

More ways to practise

Company-wise Business Analytics questionsPackage-wise Business Analytics questionsExperience-wise Business Analytics questionsRole-wise Business Analytics questionsCity-wise Business Analytics questionsMost asked Business Analytics questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsBusiness Analytics mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsBusiness Analytics topic sheets