Skip to content

Infosys Business Analytics Interview Questions & Answers

Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.

About Infosys hiring for Business Analytics roles

Infosys is an Indian multinational IT services and consulting company offering digital transformation, cloud, application management, testing and data services to global clients. It is known for its Mysuru training campus where new hires go through foundation programmes. In India it recruits for roles such as systems engineer, test engineer, data analyst and data engineer, often through campus and off-campus drives.

For Business Analytics roles, this Infosys practice set focuses most on Case Studies and Guesstimates (7), Excel for Business Analysts (5), SQL for Business Analysis (5), Business Metrics and KPIs (5). It has 17 easy, 22 medium, 1 hard questions, so you can start easy and work up to the harder ones.

Company type
IT services
Headquarters
Bengaluru, India
Main India offices
Bengaluru, Mysuru, Pune, Hyderabad, Chennai

Infosys Business Analytics interview process

  1. Online assessment (aptitude, reasoning + pseudocode)
  2. Coding test
  3. Technical interview
  4. HR round

Typical pattern based on public candidate experiences. Rounds vary by role, team and year.

Solved for InfosysStart 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

What is the BCG growth-share matrix?

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

What is a RACI matrix?

Save to ▾
Show answer
A table assigning Responsible, Accountable, Consulted and Informed roles per task so ownership is clear.
03

How do you protect a worksheet or workbook?

Save to ▾
Show answer
Review > Protect Sheet or Workbook with a password, lock cells, hide formulas and allow only selected cells to be edited.
04

Write an Excel formula for working days between two dates excluding weekends and holidays.

Save to ▾
Show answer
// A2 = start, B2 = end, Holidays = named range of holiday dates =NETWORKDAYS(A2, B2, Holidays) // if the weekend is only Sunday (common in India) =NETWORKDAYS.INTL(A2, B2, 11, Holidays)
05

What is the difference between accrual accounting and cash accounting?

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

What are aggregate functions?

Save to ▾
Show answer
Functions that summarise rows into a value, such as COUNT, SUM, AVG, MIN and MAX.
07
Save to ▾
Show answer
Every KPI is a metric, but a KPI is tied directly to a strategic goal (e.g. monthly churn). A metric can be any measurement (e.g. page views).
08

What is the difference between top-down and bottom-up market sizing?

Save to ▾
Show answer
Top-down starts from a large known number, such as population or total industry size, and narrows it with percentages to the target segment. Bottom-up starts from a unit, such as one store's daily sales or one customer's purchase frequency, and multiplies up by the number of units. Top-down is fast; bottom-up is more grounded in operations. Doing both and comparing results is a strong sanity check.
09

What is a use case diagram?

Save to ▾
Show answer
A UML diagram showing actors and the actions (use cases) they perform with the system, giving a quick view of scope.
10

How are OKRs different from KPIs?

Save to ▾
Show answer
KPIs are ongoing health measures of the business, like monthly revenue, churn or on-time delivery, tracked continuously. OKRs are a goal-setting method: an Objective is a qualitative ambition for a quarter, and Key Results are two to four measurable outcomes that show it was achieved. A KPI that is off track often becomes the subject of an OKR, for example 'reduce churn from 5 to 3 percent this quarter'.
11

What are leading and lagging indicators? Give examples.

Save to ▾
Show answer
Lagging indicators measure outcomes after they happen, such as monthly revenue, profit or churn. They confirm results but are hard to influence directly. Leading indicators move earlier and predict outcomes, such as demo bookings, trial activations, cart additions or support ticket backlog. A good KPI set pairs them: a sales team tracks qualified pipeline (leading) along with closed revenue (lagging) so it can act before the quarter ends.
12

What is SQL and why do business analysts need it?

Save to ▾
Show answer
A language for querying databases. BAs use it to pull data themselves, validate numbers, check reports and answer questions without waiting for engineers.
13

What are DAU, WAU and MAU, and what is the stickiness ratio?

Save to ▾
Show answer
DAU, WAU and MAU count unique users active in a day, week and month, where 'active' must be clearly defined, such as completing a core action. The stickiness ratio is DAU divided by MAU and shows how often monthly users return. A ratio of 0.5 means the average monthly user is active about 15 days a month. Daily-use products like messaging aim high, while a travel app naturally has low stickiness.
14

What is the difference between a test scenario and a test case?

Save to ▾
Show answer
A test scenario is a high-level statement of what to test, usually derived from a business process or user story, such as Customer applies a discount coupon at checkout. A test case is a detailed, executable set of steps with preconditions, test data, expected result and actual result, such as applying an expired coupon to a 1,000 rupee cart shows an expiry message. One scenario usually produces several test cases covering positive, negative and edge conditions.
15

What is a SWOT analysis?

Save to ▾
Show answer
A framework listing internal Strengths and Weaknesses and external Opportunities and Threats to assess a project or business position.
16

What steps do you follow to plan and run a UAT cycle?

Save to ▾
Show answer
Plan: agree scope, entry and exit criteria, testers and schedule with the business owner. Prepare: write scenarios and test cases from requirements, set up the environment and test data, and brief testers. Execute: run test cases in daily sessions, log defects with evidence and hold a daily triage. Monitor: report progress, pass rate and open defects by severity. Close: check exit criteria, get the business sign-off with known issues documented, and hold a short lessons-learned review.
17

What is the 80/20 rule in business analysis?

Save to ▾
Show answer
Pareto principle: about 80% of outcomes come from 20% of causes, such as most revenue from a few customers or most defects from a few issues.
18

Write a SQL query for a 7-day rolling average of daily revenue.

Save to ▾
Show answer
WITH daily AS ( SELECT order_date, SUM(amount) AS revenue FROM orders GROUP BY order_date ) SELECT order_date, revenue, AVG(revenue) OVER (ORDER BY order_date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS rolling_7d FROM daily ORDER BY order_date; -- fill missing dates from a calendar table first, or gaps skew the average
19

What is the difference between gross margin and net margin?

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

Write a DAX measure for the product return rate that avoids divide-by-zero errors.

Save to ▾
Show answer
Return Rate % = VAR ReturnedQty = SUM ( Returns[Quantity] ) VAR SoldQty = SUM ( Sales[Quantity] ) RETURN DIVIDE ( ReturnedQty, SoldQty, 0 ) // DIVIDE returns the third argument (0) when SoldQty is zero or blank. // Format the measure as a percentage in the model.
21

What is a break-even point?

Save to ▾
Show answer
The sales volume where total revenue equals total cost. It equals fixed cost divided by contribution margin per unit.
22

What is EBITDA and why is it widely used?

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

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

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

What is the difference between sequence flow and message flow in BPMN?

Save to ▾
Show answer
A sequence flow is a solid arrow that shows the order of activities inside one pool, so it represents work controlled by one participant. A message flow is a dashed arrow with an open circle at its start and shows communication between two different pools, such as an order email from a customer to a seller. A common modelling mistake is drawing sequence flows across pools, which wrongly implies one party controls the other's work.
25

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

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

You added new rows to the source data, but your PivotTable does not show them even after refresh. Why?

Save to ▾
Show answer
The PivotTable source is probably a fixed range such as A1:F500, so rows added below 500 are outside it. The fix is to convert the data to an Excel Table with Ctrl+T and change the pivot's data source to the table name, so it expands automatically. Also check for blank header cells, filters on the pivot hiding new items, and whether the new rows are actually text values in a numeric column, which can change grouping.
27

Which what-if analysis tools does Excel have?

Save to ▾
Show answer
Goal Seek (find the input for a target output), Data Tables (see outputs for many inputs) and Scenario Manager (save best, base and worst cases).
28

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

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

Write a SQL query to find the second-highest salary in an employees table.

Save to ▾
Show answer
SELECT MAX(salary) AS second_highest FROM employees WHERE salary < (SELECT MAX(salary) FROM employees); -- or with a window function SELECT DISTINCT salary FROM ( SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS rk FROM employees ) t WHERE rk = 2;
30

What is the difference between UNION and UNION ALL?

Save to ▾
Show answer
Both stack the results of two queries with the same number and type of columns. UNION removes duplicate rows, which needs a sort or hash step and is slower. UNION ALL keeps every row and is faster. Use UNION ALL when combining data such as online and store sales where duplicates are genuine or impossible, and UNION only when you specifically need a distinct list, such as unique customer IDs from two sources.
31

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

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

Control has 10,000 users with 400 purchases and the variant has 10,000 users with 460 purchases. Calculate the lift.

Save to ▾
Show answer
Control conversion is 400 divided by 10,000, which is 4.0 percent. Variant conversion is 460 divided by 10,000, which is 4.6 percent. The absolute lift is 0.6 percentage points and the relative lift is 0.6 divided by 4.0, which is 15 percent. Before calling it a win, run a two-proportion significance test and check the confidence interval and guardrail metrics.
33

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

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

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

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

What is scope creep and how do you control it?

Save to ▾
Show answer
Uncontrolled growth of requirements. Control it with a clear scope statement, change control process, impact analysis and sponsor approval for additions.
36

Tell me about a time you said no to a stakeholder.

Save to ▾
Show answer
Situation: a regional manager wanted a custom report changed daily, which would have taken half my week. Task: support him without blocking other priorities. Action: I asked which decisions the report fed and found he needed only four numbers. I said no to the custom version, explained the impact on other work, and added those four metrics with a filter to the existing dashboard. Result: he got his numbers the same day and the team kept its capacity.
37

How do you handle large datasets in Excel?

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

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

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

Which chart would you choose for trend, part-to-whole, comparison and distribution?

Save to ▾
Show answer
For a trend over time use a line chart. For part-to-whole use a stacked bar or a 100 percent bar; a pie or donut only works with two to four slices. For comparing categories use a sorted horizontal bar chart. For distribution use a histogram or box plot. For correlation between two measures use a scatter plot. Choosing by the question being answered, not by looks, keeps dashboards readable.
40

What is value chain analysis?

Save to ▾
Show answer
Value chain analysis breaks a business into the activities that create value: primary activities such as inbound logistics, operations, outbound logistics, marketing and sales, and service, plus support activities like procurement, technology, HR and infrastructure. For each activity you look at cost and differentiation. In cases it helps locate where costs are rising or where a competitive advantage can be built, for example in last-mile delivery.

Tips to crack the Infosys Business Analytics interview

  • Practise pseudocode output questions and puzzle-style reasoning, which commonly appear in Infosys online tests and HackWithInfy style contests.
  • Revise SQL joins, normalisation and one programming language well enough to write and explain simple programs on paper.
  • Mention willingness to learn new technologies and relocate, since Infosys emphasises its training programme and flexible project allocation.
  • Keep a one-minute story ready for every project on your CV: problem, your part, tools, result.
  • Practise the hard questions on this page aloud; Infosys interviewers usually ask follow-ups on your first answer.

Frequently asked questions

How many rounds are there in the Infosys Business Analytics interview?

Candidates usually go through 4 stages: Online assessment (aptitude, reasoning + pseudocode); Coding test; Technical interview; HR round. The exact rounds change with the role, team, location and your experience, so confirm the process with the recruiter.

Which topics should I prepare for the Infosys Business Analytics interview?

This practice set leans on Case Studies and Guesstimates (7), Excel for Business Analysts (5), SQL for Business Analysis (5), Business Metrics and KPIs (5). Revise those first, then practise explaining one or two of your own projects end to end, because most Infosys interviewers ask you to walk through real work.

Are these the exact questions asked at Infosys?

No. These are curated practice questions that match the skills and difficulty usually tested in it services interviews like Infosys's. They are not a leaked or verified list of past questions.

Where does Infosys hire Business Analytics professionals in India?

Infosys has large teams in Bengaluru, Mysuru, Pune, Hyderabad, Chennai. Openings and locations change often, so check the Infosys careers page and filter by city and experience.

Business Analytics questions for similar companies