Skip to content

TCS Business Analytics Interview Questions & Answers

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

About TCS hiring for Business Analytics roles

Tata Consultancy Services is a Tata Group company and one of the largest IT services and consulting firms in the world. It delivers application development, testing, cloud, data and analytics services to clients in banking, retail, manufacturing and other industries. In India it hires freshers and experienced staff for software testing, data engineering, BI reporting and analytics roles across its delivery centres.

For Business Analytics roles, this TCS practice set focuses most on Requirements and Agile (7), Financial and Business Analysis (6), Business Metrics and KPIs (5), Case Studies and Guesstimates (5). It has 16 easy, 23 medium, 1 hard questions, so you can start easy and work up to the harder ones.

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

TCS Business Analytics interview process

  1. TCS NQT online assessment (aptitude + coding)
  2. Technical interview
  3. Managerial round
  4. HR round

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

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

A KPI on your dashboard dropped 40 percent overnight. What are your first steps?

Save to ▾
Show answer
Assume a data problem until proven otherwise, because real businesses rarely move 40 percent in a day. Check whether the refresh completed, whether source row counts look normal, and whether any tracking, pipeline or definition changed. Compare with a raw source query and a related metric, such as orders versus payments. If the data is fine, segment by channel, region and platform to locate the drop, then alert the owners quickly.
02

What steps would you follow to create a tracking plan for a new 'save for later' feature?

Save to ▾
Show answer
Start from the questions to answer: how many users discover it, use it and later buy saved items. Define events such as save_clicked, saved_item_viewed, saved_item_removed and saved_item_purchased, with properties like product ID, price, source screen and platform. Follow the existing naming convention, assign owners, review with developers, and test events in a staging build. Build the dashboard before launch so data is checked on day one.
03

In the middle of a sprint, a senior stakeholder asks to add an urgent feature. What do you do?

Save to ▾
Show answer
Understand the urgency and the business impact of waiting until the next sprint. Bring it to the product owner, who decides. If it truly cannot wait, the team agrees to swap out work of similar size so the sprint goal stays realistic, and the trade-off is made visible to the stakeholder. If it can wait, add it to the top of the backlog for the next sprint. Avoid silently adding scope.
04

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

Inventory days rose from 45 to 70 over two quarters. What could be the causes and what would you recommend?

Save to ▾
Show answer
Possible causes include falling sales against unchanged purchasing, poor demand forecasts, bulk buying for discounts, slow-moving or obsolete SKUs, or deliberate stock-building ahead of a festive season or expected price rise. Analyse by SKU, warehouse and age bucket to find where stock is stuck. Recommend clearing aged items, adjusting reorder points using recent demand, and reviewing supplier minimum order quantities. Also quantify the cash locked up and the carrying cost to show urgency.
06

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

What is a feasibility study?

Save to ▾
Show answer
An early assessment of whether a proposed solution is technically, economically, operationally and legally viable before committing budget.
08

What are dynamic array functions in Excel and how do they help analysts?

Save to ▾
Show answer
Dynamic array functions return several values that spill into neighbouring cells. UNIQUE lists distinct values, SORT and SORTBY order data, FILTER returns rows meeting conditions, SEQUENCE builds number series, and XLOOKUP can return whole rows. For example =SORT(UNIQUE(FILTER(Sales[Region], Sales[Year]=2026))) builds a live region list. They replace many helper columns and Ctrl+Shift+Enter array formulas, and the # operator references a full spill range.
09

What is a KPI and give examples for an e-commerce business?

Save to ▾
Show answer
A measurable value showing progress to a goal, such as conversion rate, average order value, cart abandonment rate and customer retention.
10

What is the difference between a chart and a dashboard?

Save to ▾
Show answer
A chart shows one view of data; a dashboard combines several charts and KPIs on one page for monitoring.
11

What is A/B testing?

Save to ▾
Show answer
A/B testing is a controlled experiment where users are randomly split into a control group that sees the current version and a treatment group that sees a change, such as a new checkout button. You compare a pre-decided primary metric, like conversion rate, between groups. Because assignment is random, a significant difference can be attributed to the change rather than to seasonality, marketing or user mix.
12

How is Kanban different from Scrum?

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

What is the cash conversion cycle?

Save to ▾
Show answer
The cash conversion cycle measures how many days cash is tied up in operations. It equals days inventory outstanding plus days sales outstanding minus days payables outstanding. Example: inventory sits 40 days, customers pay in 30 days and suppliers are paid in 45 days, so the cycle is 40 + 30 - 45 = 25 days. A shorter cycle means less working capital is needed. Some marketplaces have a negative cycle because they collect from customers before paying sellers.
14

Guesstimate: how many pizzas are sold in Mumbai on a weekend?

Save to ▾
Show answer
About 20 million people, roughly 10% order pizza on a weekend, about 1 pizza per 2 people in an order. This gives roughly 1 million pizzas, adjusted for outlets and delivery capacity.
15

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

What is a data dictionary and why does a business analyst maintain one?

Save to ▾
Show answer
A data dictionary is a catalogue of data elements used in a system or report: field name, business definition, data type, length, allowed values, mandatory or optional, source system, owner and example values. A BA maintains it so business users, developers and testers use one definition, for example what counts as an active customer. It prevents mapping errors in integrations and migrations, speeds up testing and reduces disputes about why reports do not match.
17

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

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

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

What is AS-IS and TO-BE process modelling, and where does BPMN fit in?

Save to ▾
Show answer
AS-IS modelling documents how a process works today, including pain points, delays and handoffs. TO-BE modelling shows the improved future process after changes or a new system. Comparing the two reveals the gaps and requirements. BPMN, Business Process Model and Notation, is the standard notation, using events, tasks, gateways for decisions and swimlanes for roles, so both business and IT read the diagrams the same way.
20

What is the difference between bookings, billings and revenue?

Save to ▾
Show answer
Bookings are the value of contracts signed in a period, showing future commitment. Billings are the amounts invoiced to customers in the period. Revenue is what is earned and recognised under accounting rules as the service is delivered. Example: a 3-year contract worth 36 lakh signed in April is 36 lakh in bookings, 12 lakh in billings if invoiced annually, and only 1 lakh in revenue for April. Confusing them is common when reporting sales performance.
21

What is the difference between revenue and profit?

Save to ▾
Show answer
Revenue is total money from sales; profit is what remains after subtracting all costs and expenses.
22

What are the current ratio and the quick ratio?

Save to ▾
Show answer
Both measure short-term liquidity. The current ratio is current assets divided by current liabilities; around 1.5 to 2 is often comfortable, though it varies by industry. The quick ratio excludes inventory and prepaid items: (cash plus marketable securities plus receivables) divided by current liabilities. It is stricter because inventory may not sell quickly. A retailer with a current ratio of 1.8 but a quick ratio of 0.4 depends heavily on selling its stock to pay bills.
23

What is the difference between ROI, ROE and ROCE?

Save to ▾
Show answer
ROI (return on investment) is the gain from a specific investment divided by its cost and is used to judge projects or campaigns. ROE (return on equity) is net profit divided by shareholders' equity and shows the return to owners; high debt can inflate it. ROCE (return on capital employed) is EBIT divided by equity plus long-term debt and shows how efficiently all long-term capital is used. ROCE is better for comparing companies with different debt levels.
24

What are fixed costs and variable costs?

Save to ▾
Show answer
Fixed costs stay constant regardless of volume, such as rent; variable costs change with volume, such as raw materials.
25

XLOOKUP vs VLOOKUP?

Save to ▾
Show answer
XLOOKUP can look left or right, uses exact match by default, returns a custom value if nothing is found and doesn't break when columns move. VLOOKUP only looks right and needs a column number.
26

What is the difference between correlation and causation in product analytics?

Save to ▾
Show answer
Correlation means two metrics move together; causation means one actually changes the other. Users who use the wishlist feature may retain better, but they may simply be more engaged users already. Acting on correlation alone can waste effort, such as forcing everyone into the wishlist. To establish causation, run an A/B test, or use quasi-experimental methods such as difference-in-differences when a test is not possible, and always check for confounders like user tenure or acquisition channel.
27

Compare Import mode, DirectQuery and Live Connection in Power BI.

Save to ▾
Show answer
Import copies data into the compressed in-memory model, giving the fastest visuals and full DAX, but data is only as fresh as the last refresh and size is limited. DirectQuery sends queries to the source at view time, so data is near real time but visuals are slower and some DAX is restricted. Live Connection points to an existing published semantic model or Analysis Services model without its own model. Composite models mix Import and DirectQuery.
28

What are the three main financial statements and how are they linked?

Save to ▾
Show answer
The income statement shows revenue, expenses and profit over a period. The balance sheet shows assets, liabilities and equity at a point in time. The cash flow statement shows cash from operating, investing and financing activities. They link together: net profit flows into retained earnings on the balance sheet and is the starting point of operating cash flow, and the closing cash balance from the cash flow statement equals cash on the balance sheet.
29

What is UAT sign-off and who should give it?

Save to ▾
Show answer
UAT sign-off is the formal acceptance by the business that the solution meets agreed requirements and is fit to go live, often with a list of known open defects and agreed workarounds. It should be given by the accountable business owner or product owner, not by the IT team or the BA. The BA prepares the evidence: test execution summary, defect status and traceability to requirements. Sign-off is recorded in writing, usually by email or in the test management tool.
30

Do a quick SWOT analysis for an ed-tech company.

Save to ▾
Show answer
Strengths and Weaknesses are internal; Opportunities and Threats are external. Example: S = strong faculty, W = low brand awareness, O = AI upskilling demand, T = free online content.
31

Agile vs Waterfall?

Save to ▾
Show answer
Waterfall runs fixed phases one after another with requirements frozen early. Agile delivers in short sprints with continuous feedback, so requirements can change. In Agile, BAs maintain the backlog and user stories.
32

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

A ride-hailing app's ride cancellation rate rose from 8 to 14 percent. How would you structure the problem?

Save to ▾
Show answer
First split by who cancels: riders or drivers. For rider cancellations, check wait times, pickup accuracy, price surges and changes in ETA. For driver cancellations, check trip distance, payment mode, low fares, destination visibility and incentive changes. Then segment by city, time of day and area. Link to recent changes like a new pricing rule. Recommend fixes for the largest driver, such as better matching or adjusted incentives.
34

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

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

What are aggregate functions?

Save to ▾
Show answer
Functions that summarise rows into a value, such as COUNT, SUM, AVG, MIN and MAX.
36

What is the hierarchy of epic, feature and user story in Agile?

Save to ▾
Show answer
An epic is a large body of work that delivers a major business goal and spans several sprints, such as 'Online loan application'. It is broken into features or capabilities, such as 'Document upload'. Each feature is split into user stories small enough to finish in one sprint, such as 'As an applicant, I want to upload my PAN card photo so that I do not need to visit a branch'.
37

The scheduled refresh failed overnight and leadership reviews the dashboard at 10 am. What do you do?

Save to ▾
Show answer
Check the refresh history error first: expired credentials, gateway offline, source schema change or timeout. Fix the quick cause and trigger a manual refresh. If it cannot be fixed in time, inform the stakeholders early, state the last refreshed date clearly on the report and share the key numbers from a direct query if needed. Afterwards add refresh failure alerts and a data-as-of label so it never surprises anyone.
38

What is the difference between a task and a sub-process in BPMN?

Save to ▾
Show answer
A task is an atomic unit of work that you do not break down further in the diagram, such as Verify PAN details. A sub-process is a compound activity that contains its own flow of tasks, events and gateways, shown with a small plus sign when collapsed. Sub-processes keep high-level diagrams readable: the main map shows Credit Check as one box, and a separate detailed view explains its internal steps.
39

Write a SQL query to calculate the repeat purchase rate.

Save to ▾
Show answer
WITH per_customer AS ( SELECT customer_id, COUNT(DISTINCT order_id) AS orders FROM orders GROUP BY customer_id ) SELECT ROUND(100.0 * SUM(CASE WHEN orders >= 2 THEN 1 ELSE 0 END) / COUNT(*), 2) AS repeat_rate_pct FROM per_customer;
40

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.

Tips to crack the TCS Business Analytics interview

  • Practise TCS NQT style numerical, verbal and reasoning sections along with two basic coding problems under strict time limits.
  • Be ready to explain your final-year project, SQL basics and core concepts like OOP, DBMS and software testing life cycle.
  • Read about TCS service lines such as BFSI and its iON and Ignio platforms to answer why you want to join.
  • 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; TCS interviewers usually ask follow-ups on your first answer.

Frequently asked questions

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

Candidates usually go through 4 stages: TCS NQT online assessment (aptitude + coding); Technical interview; Managerial round; 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 TCS Business Analytics interview?

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

Are these the exact questions asked at TCS?

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

Where does TCS hire Business Analytics professionals in India?

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

Business Analytics questions for similar companies