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

Business Analytics Interview Questions for Analytics Companies

40 questions weighted to the interview style of analytics companies — 5 easy, 28 medium, 7 hard.

How analytics companies interview for Business Analytics

Analytics and data-services firms test practical skill hard: SQL, Excel or Python tasks, statistics, and business cases where you turn data into a recommendation. Many run a take-home or live case round in addition to technical interviews.

This set focuses on Case Studies and Guesstimates (9), Requirements and Agile (6), Power BI and Tableau (5), SQL for Business Analysis (5).

HR round Technical interview Case or guesstimate round Technical round 1 Technical round 2 or case round
Solved — analytics companiesStart 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

How would you size the market for IT courses in Delhi NCR?

Case Studies and GuesstimatesMedium
Save to ▾
Show answer
Top-down: NCR population aged 18–30 × share of graduates × share wanting paid upskilling × average fee. Cross-check bottom-up with institutes × batches × students × fees. State your assumptions.
02

What is a spike in Agile and when would a business analyst request one?

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

A client's profits are falling. How do you structure the problem?

Case Studies and GuesstimatesMedium
Save to ▾
Show answer
Split into revenue and cost, then revenue into price, volume and mix, and cost into fixed and variable; check internal factors and external market factors.
04

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

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

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

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

How do you estimate the annual revenue of a coffee shop chain?

Case Studies and GuesstimatesHard
Save to ▾
Show answer
Number of outlets x daily customers x average bill x operating days, then validate using footfall, peak hours and similar chains.
07

What are the steps to publish and share a Power BI report with your team?

Power BI and TableauEasy
Save to ▾
Show answer
Save the .pbix and click Publish, choosing the team workspace. In the Service, set data source credentials and, for on-premises data, configure the gateway. Schedule refresh. Then share by giving workspace access to editors, or package it as an app for viewers, and apply row-level security roles if needed. Finally, check it on web and mobile and send the link with a short note on what each page answers.
08

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

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

How do sample size and minimum detectable effect affect an A/B test design?

Product AnalyticsHard
Save to ▾
Show answer
The minimum detectable effect is the smallest lift worth detecting, such as a 2 percent relative increase in conversion. Smaller effects, lower baseline rates and higher required power need much larger samples, roughly four times the users to detect half the effect. Calculate sample size before starting using the baseline rate, MDE, significance level and power, usually 80 percent, then fix the test duration and avoid stopping early.
10

After joining orders to a payments table, your total revenue doubled. What went wrong?

SQL for Business AnalysisMedium
Save to ▾
Show answer
The join created a fan-out: some orders have more than one payment row, such as split payments or retries, so each order amount is repeated. Check the grain by counting rows per order_id on both sides. Fix it by aggregating payments to one row per order in a CTE before joining, joining on the full key, or summing from the table whose grain matches the metric. Always compare row counts before and after a join.
11

How do you write a query to find users active in consecutive months?

SQL for Business AnalysisMedium
Save to ▾
Show answer
Get distinct user-month pairs, self-join or use LAG on month per user, and keep rows where the previous month is exactly one month earlier.
12

Five departments each build their own Power BI reports with different revenue numbers. How would you design a better BI setup?

Power BI and TableauHard
Save to ▾
Show answer
Create a shared, certified semantic model with one definition per KPI, built on a governed warehouse layer. Departments build thin reports on top of it through live connection instead of copying data. Set up workspaces by environment (dev, test, prod), deployment pipelines, naming standards, a KPI glossary and owners for each measure. Keep a small central team for the core model and let departments self-serve on top, which balances control and speed.
13

How do you approach a guesstimate question?

Case Studies and GuesstimatesEasy
Save to ▾
Show answer
Clarify the scope, break the problem into logical parts, state assumptions with round numbers, compute step by step and sanity-check the answer.
14

Write a SQL query to calculate the DAU to MAU stickiness ratio for a month.

Product AnalyticsMedium
Save to ▾
Show answer
WITH daily AS ( SELECT event_date, COUNT(DISTINCT user_id) AS dau FROM events WHERE event_date >= '2026-10-01' AND event_date < '2026-11-01' GROUP BY event_date ), monthly AS ( SELECT COUNT(DISTINCT user_id) AS mau FROM events WHERE event_date >= '2026-10-01' AND event_date < '2026-11-01' ) SELECT ROUND(AVG(d.dau) * 1.0 / MAX(m.mau), 3) AS stickiness FROM daily d CROSS JOIN monthly m;
15

What is a star schema and why do BI tools prefer it?

Power BI and TableauMedium
Save to ▾
Show answer
A star schema has one central fact table holding numeric events (sales, orders) linked to surrounding dimension tables (date, product, customer, region). BI tools prefer it because filters flow cleanly from dimensions to facts, DAX and Tableau calculations stay simple, and compression and query performance improve. A flat single table repeats text values and gets slow, while a snowflake with many chained lookups makes filtering and maintenance harder.
16

What are fixed costs and variable costs?

Business Metrics and KPIsMedium
Save to ▾
Show answer
Fixed costs stay constant regardless of volume, such as rent; variable costs change with volume, such as raw materials.
17

How do you run an effective stakeholder meeting?

Stakeholder CommunicationMedium
Save to ▾
Show answer
Send an agenda with the goal and the decisions needed beforehand, along with any pre-read. Invite only people who contribute or decide. Start by restating the goal, keep to time, park off-topic issues and confirm decisions aloud. End by summarising actions with owners and dates. Send minutes within a day. A meeting without a clear decision or output usually could have been an email.
18

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

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

A feature launched two months ago is used by only 4 percent of users. What would you do?

Product AnalyticsMedium
Save to ▾
Show answer
Find out whether it is a discovery problem or a value problem. Check how many users saw the entry point, how many tried it and how many returned. If few saw it, test better placement or onboarding prompts. If many tried and few returned, interview users and review session recordings to understand why. Also check if the 4 percent are high-value users. Then decide to improve, reposition or remove it.
20

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

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

How do you validate data before analysis?

SQL for Business AnalysisMedium
Save to ▾
Show answer
Check row counts against the source, nulls, duplicates on keys, value ranges, date coverage and that totals reconcile with finance reports.
22

Guesstimate: what is the annual revenue of one multiplex screen in a large Indian city?

Case Studies and GuesstimatesHard
Save to ▾
Show answer
Assume 5 shows a day and 200 seats with 30 percent average occupancy, giving 300 tickets a day. At an average ticket of 250 rupees, ticket revenue is 75,000 rupees a day. Food and beverage adds about 40 percent of ticket revenue, around 30,000, and screen ads maybe 5,000. That is about 1.1 lakh a day, or around 4 crore a year. Weekends and blockbuster releases push occupancy higher.
23

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

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

Split the epic 'Customers can track their order online' into user stories.

Requirements and AgileMedium
Save to ▾
Show answer
Possible stories: As a customer, I want to see my order status (placed, packed, shipped, delivered) so that I know its progress. As a customer, I want an SMS or email when the status changes so that I do not have to check. As a customer, I want the expected delivery date so that I can plan. As a customer, I want a courier tracking link once shipped. As support staff, I want to see the same timeline so that I can answer queries.
25

Use case vs user story?

Requirements and AgileMedium
Save to ▾
Show answer
A use case describes the full interaction between an actor and the system (main and alternate flows). A user story is a short statement of need from the user's point of view, refined with acceptance criteria.
26

What are the 4 Ps of marketing?

Case Studies and GuesstimatesMedium
Save to ▾
Show answer
Product, Price, Place and Promotion, the levers a business uses to bring an offering to market.
27

What is the difference between SQL and Excel for analysis?

SQL for Business AnalysisEasy
Save to ▾
Show answer
Excel suits small to medium data and quick ad-hoc work; SQL queries large databases directly and repeatably.
28

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

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

Financial and Business AnalysisMedium
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.
30

What are UAT entry and exit criteria? Give examples.

UAT and BA DocumentationMedium
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.
31

How do you build a forecast in Excel?

Excel for Business AnalystsMedium
Save to ▾
Show answer
Use historical data with FORECAST.ETS or trend lines, state assumptions, compare against actuals and show best, base and worst scenarios.
32

Guesstimate: how many cups of tea are sold in Delhi per day?

Case Studies and GuesstimatesMedium
Save to ▾
Show answer
Population about 20 million, adult tea drinkers about 50%, cups bought outside per person around 1 on average. This gives roughly 10 million cups, then adjust for offices and stalls.
33

What does the CALCULATE function do in DAX?

Power BI and TableauMedium
Save to ▾
Show answer
CALCULATE evaluates an expression under a modified filter context. You pass a measure plus filter arguments that add, replace or remove filters, for example CALCULATE([Sales], 'Region'[Name] = "North") or CALCULATE([Sales], ALL('Product')). It is the basis of time intelligence, percent-of-total and comparison measures. It also triggers context transition when used inside a row context, which is powerful but a common source of confusion.
34

What is the difference between gross margin and net margin?

Business Metrics and KPIsEasy
Save to ▾
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.
35

What are data objects and data stores in BPMN?

Process Modelling and BPMNMedium
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.
36

Tell me about a time a SQL query you wrote gave wrong results. How did you catch it?

SQL for Business AnalysisMedium
Save to ▾
Show answer
Situation: my weekly sales report showed a 12 percent jump that no one could explain. Task: verify the number before it reached leadership. Action: I compared row counts before and after each join and found a new promotions table had multiple rows per order, duplicating revenue. I aggregated promotions per order first and added a test comparing totals with the source. Result: the corrected report went out the same day, and I now check grain on every new join.
37

A critical defect is found on the last day of UAT, and the go-live date cannot move. What do you do?

UAT and BA DocumentationHard
Save to ▾
Show answer
Confirm the impact and reproduce it quickly. Work with development to estimate a fix and its regression effort. Then present options to the business owner with risks: fix and do targeted retesting before go-live, go live with a temporary workaround or manual process, go live with the affected feature switched off, or delay. The decision belongs to the business, documented at the go or no-go meeting. Never hide a critical defect to protect a date.
38

Because of a tight deadline, the business sponsor wants to skip UAT and go live directly. How do you respond?

UAT and BA DocumentationHard
Save to ▾
Show answer
Explain the risks in business terms: without UAT, there is no evidence that real processes work, and production defects cost far more to fix and can affect customers and compliance. Offer alternatives: a shortened UAT covering only critical business flows, parallel running with the old system, a phased rollout to one branch or user group, or extended hypercare. If the sponsor still decides to skip it, record the decision and accepted risks formally.
39

Build a break-even analysis in Excel.

Excel for Business AnalystsMedium
Save to ▾
Show answer
Break-even units = Fixed costs ÷ (Price − Variable cost per unit). Add a data table to test different price and volume scenarios.
40

Where do you see yourself in five years as a business analyst?

Stakeholder CommunicationEasy
Save to ▾
Show answer
Show ambition that fits the role. For example: in five years I see myself as a senior business analyst who owns a business domain, such as payments or supply chain, leads requirement and analytics work for major initiatives and mentors juniors. To get there I am building strong SQL and Power BI skills, learning the domain deeply and taking on more stakeholder-facing work. I would like to grow that path within this organisation.

Analytics companies (11)

Analytics

EXL

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Noida, Gurugram, Bengaluru +1

View questions
Analytics

Mu Sigma

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Bengaluru

View questions
Analytics

Fractal Analytics

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Mumbai, Bengaluru, Gurugram +1

View questions
Analytics

LatentView Analytics

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Chennai, Bengaluru

View questions
Analytics

Tiger Analytics

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Chennai, Bengaluru, Hyderabad

View questions
Analytics

Tredence

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Bengaluru, Chennai, Gurugram

View questions
Analytics

Sigmoid

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Bengaluru, Pune

View questions
Analytics

Quantiphi

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Mumbai, Bengaluru

View questions
Analytics

Affine

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Bengaluru

View questions
Analytics

NielsenIQ

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Vadodara, Chennai, Pune

View questions
Analytics

Course5 Intelligence

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Mumbai, Bengaluru

View questions

Frequently asked questions

How are Business Analytics interviews at analytics companies different?

Analytics and data-services firms test practical skill hard: SQL, Excel or Python tasks, statistics, and business cases where you turn data into a recommendation. Many run a take-home or live case round in addition to technical interviews.

Which analytics companies are covered?

This page links to 11 analytics companies, including EXL, Mu Sigma, Fractal Analytics, LatentView Analytics, Tiger Analytics, Tredence, Sigmoid, Quantiphi. Each has its own page with rounds and a separate practice set.

What rounds should I expect?

Common rounds at these companies include: HR round; Technical interview; Case or guesstimate round; Technical round 1; Technical round 2 or case round. The exact process varies by company and role.

Other company types

IT services companiesConsulting companiesProduct companiesE-commerce & consumer tech companiesFintech companiesBanking & finance companiesHardware & semiconductors companiesTelecom companies

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