01
XLOOKUP vs VLOOKUP?
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.
LTIMindtree Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About LTIMindtree hiring for Business Analytics roles
LTIMindtree is an Indian IT services and consulting company formed by the merger of Larsen and Toubro Infotech and Mindtree, and part of the L&T Group. It provides cloud, data, ERP, testing and digital engineering services for global clients. It hires for software engineers, test engineers, data analysts, data engineers and ERP consultants.
For Business Analytics roles, this LTIMindtree practice set focuses most on UAT and BA Documentation (6), Product Analytics (5), Power BI and Tableau (4), SQL for Business Analysis (4). It has 19 easy, 21 medium questions, so you can start easy and work up to the harder ones.
- Company type
- IT services
- Headquarters
- Mumbai, India
- Main India offices
- Mumbai, Pune, Bengaluru, Chennai, Hyderabad
LTIMindtree Business Analytics interview process
- Online assessment (aptitude + reasoning)
- Coding test
- Technical interview
- HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for LTIMindtreeStart 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
02
What is the difference between a calculated column and a measure in Power BI?
Show answer
A calculated column is computed row by row at refresh time and stored in the model, so it uses memory and can be used in slicers, rows and relationships. A measure is computed at query time based on the current filters, so it is not stored and responds to slicers. Use a column for attributes such as an age band, and a measure for aggregations such as Total Sales or Margin %.
03
What is horizontal and vertical analysis of financial statements?
Show answer
Horizontal analysis compares line items across periods, showing growth, for example revenue up 18 percent year on year while employee costs grew 30 percent. Vertical analysis expresses each item as a percentage of a base within one period, such as each expense as a percentage of revenue, or each asset as a percentage of total assets. Together they show both trends and structure, and vertical analysis also makes companies of different size comparable.
04
Write a SQL query to find requirements that have no linked UAT test case.
Show answer
SELECT r.req_id, r.title, r.priority
FROM requirements r
LEFT JOIN test_case_links l ON l.req_id = r.req_id
WHERE l.req_id IS NULL
AND r.status = 'APPROVED'
ORDER BY r.priority;
-- Run this before UAT starts: every approved requirement
-- should trace to at least one test case.
05
Write a SQL query to calculate the repeat purchase rate.
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;
06
What do statistical significance and p-value mean in an A/B test?
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.
07
What is working capital and why does it matter?
Show answer
Working capital is current assets minus current liabilities, mainly receivables plus inventory minus payables. It is the money tied up in running daily operations. Too little means the company may struggle to pay suppliers and salaries; too much means cash is locked in slow inventory or unpaid customer invoices. Analysts track it because a growing business often needs more working capital, so fast growth can create cash shortages even when the business is profitable.
08
What is Agile and how does Scrum work?
Show answer
Agile delivers value in small increments with feedback. Scrum organises work in sprints with planning, daily stand-ups, review and retrospective, led by a Scrum Master and Product Owner.
09
What is a market entry strategy case?
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
What is the difference between a process, a procedure and a work instruction?
Show answer
A process describes what happens end to end to achieve an outcome, across roles, such as customer onboarding. A procedure describes how one part of that process is carried out and who is responsible, such as the KYC verification procedure. A work instruction is the most detailed, step-by-step guide for a single task, often with screenshots, such as how to upload a document in the CRM. BAs usually model processes and reference the other two.
11
What techniques do you use to elicit requirements?
Show answer
Interviews, workshops, surveys, observation, document analysis, prototyping and brainstorming, chosen according to stakeholders and project stage.
12
What is Power Query and what is it used for?
Show answer
Power Query is the data preparation engine inside Power BI and Excel. It connects to sources like Excel, CSV, SQL databases and web APIs, then lets you clean and shape data with recorded steps: remove columns, change types, split, merge, unpivot, append and group. Each step is written in the M language and replays on every refresh, so a monthly cleanup job becomes repeatable instead of manual.
13
How would you size the market for IT courses in Delhi NCR?
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.
14
What is the use of the IFERROR function?
Show answer
It returns a custom value when a formula errors out, keeping reports clean, for example =IFERROR(VLOOKUP(...), "Not found").
15
Write an Excel formula for the NPV of a project with an initial investment today and five yearly cash inflows.
Show answer
# B1 = discount rate (for example 12%)
# B2 = initial investment entered as a negative number
# B3:B7 = cash inflows for years 1 to 5
=NPV(B1, B3:B7) + B2
# NPV() assumes the first value comes at the end of year 1,
# so the year-0 investment is added outside the function.
16
What is the difference between a test scenario and a test case?
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.
17
What is user activation and what is an 'aha moment'?
Show answer
Activation is the point at which a new user first experiences the product's core value, such as completing a first lesson, sending a first payment or creating a first project. The aha moment is the specific early action that strongly predicts long-term retention, found by comparing retained and churned users. Teams then design onboarding to get more new users to that action quickly and track the activation rate.
18
Write a SQL query to list customers who have never placed an order.
Show answer
SELECT c.customer_id, c.name
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.customer_id
WHERE o.order_id IS NULL;
-- alternative
SELECT customer_id, name FROM customers c
WHERE NOT EXISTS (
SELECT 1 FROM orders o WHERE o.customer_id = c.customer_id
);
19
How would you decide whether to launch a new product?
Show answer
Assess market size and demand, customer need, competition, unit economics, capabilities, risks and strategic fit, then test with a pilot before scale-up.
20
What is the difference between OLTP and OLAP systems?
Show answer
OLTP handles many small day-to-day transactions; OLAP supports analysis over large historical data with aggregates and reporting.
21
What is a Minimum Viable Product (MVP)?
Show answer
The smallest version of a product with enough features to deliver value and gather real user feedback before investing more.
22
Guesstimate: how many pizzas are sold in Mumbai on a weekend?
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.
23
Tell me about a time you mapped a process and discovered a major inefficiency.
Show answer
Situation: vendor onboarding at my company took around 18 days and procurement blamed finance. Task: I was asked to map the AS-IS process. Action: I interviewed five roles, traced 25 recent vendor records through system timestamps and built a swimlane map. It showed that bank details were collected twice and verified by two teams separately. Result: we merged the steps into one checklist at intake, cut onboarding to 9 days and reduced rework emails by about half.
24
What does expectation management mean for a business analyst?
Show answer
It means making sure stakeholders know realistically what will be delivered, when, and with what limits, before they form their own assumptions. A BA confirms scope in writing, states assumptions and dependencies, shares estimates with ranges, and flags risks early. When something changes, they update stakeholders immediately with options. Most stakeholder conflict comes from surprises, not from bad news itself.
25
Write a UAT test case for logging in to a banking app with OTP.
Show answer
Test case ID: UAT-LOGIN-03. Precondition: registered customer with a verified mobile number. Steps: 1. Open the app and enter the registered mobile number. 2. Tap Send OTP. 3. Enter the 6-digit OTP received by SMS within 3 minutes. 4. Tap Verify. Expected result: the customer lands on the account dashboard, and the login is recorded in the activity log. Related negative cases: wrong OTP shows an error, and three wrong attempts lock login for 30 minutes.
26
What is the difference between system testing, SIT and UAT?
Show answer
System testing is done by the QA team to verify that one system works against its functional and non-functional specifications. SIT (system integration testing) checks that connected systems exchange data correctly, such as CRM to billing to payment gateway. UAT (user acceptance testing) is done by business users to confirm the solution supports real business processes and is ready for go-live. UAT asks whether this is fit for our business, not just whether it matches the specification.
27
What is a primary key?
Show answer
A column or set of columns that uniquely identifies each row in a table and cannot contain NULL.
28
What is the difference between a task and a sub-process in BPMN?
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.
29
What is the difference between Power BI Desktop, Power BI Service and Power BI Mobile?
Show answer
Power BI Desktop is the free Windows app where you connect to data, model it, write DAX and design reports. Power BI Service is the cloud portal where you publish reports, schedule refresh, build dashboards, set permissions and share with users. Power BI Mobile is the phone app for viewing reports on the go. A typical flow is build in Desktop, publish to a Service workspace, and consume on web or mobile.
30
A ride-hailing app's ride cancellation rate rose from 8 to 14 percent. How would you structure the problem?
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.
31
What is ARPU and how is it calculated?
Show answer
ARPU, Average Revenue Per User, is total revenue in a period divided by the average number of users in that period. If a telecom-style app earns 50 lakh in a month from 25,000 average users, ARPU is 200 rupees. It is tracked to see whether growth comes from more users or more value per user. ARPPU, revenue per paying user, is used when only some users pay.
32
What does a Business Analyst do?
Show answer
A BA bridges business and technology: gathers requirements, analyses data and processes, documents BRD/FRD and makes sure the final solution actually solves the business problem.
33
What are DAU, WAU and MAU, and what is the stickiness ratio?
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.
34
What are functional and non-functional requirements?
Show answer
Functional requirements describe what the system does (login, reports); non-functional ones describe how well it does it (speed, security, availability, usability).
35
What is a date table in Power BI and why should you mark it as a date table?
Show answer
A date table has one row per day with no gaps, plus columns like Year, Quarter, Month, Week and Fiscal Period. It is related to the fact table date column. Marking it as a date table tells Power BI to use it for time intelligence functions like TOTALYTD, SAMEPERIODLASTYEAR and DATESINPERIOD, which require a continuous date range. It also gives consistent month sorting and fiscal calendars across every report.
36
What is Average Order Value and how can a business increase it?
Show answer
Average Order Value is total revenue divided by number of orders. If an online store earns 9 lakh from 1,500 orders, AOV is 600 rupees. Businesses increase it with bundles, cross-sell and upsell recommendations, free delivery above a threshold, volume discounts and premium options. Watch margin and conversion while doing so, because a high free-delivery threshold can raise AOV but reduce the number of orders.
37
Tell me about a time poor or outdated documentation caused a problem. How did you fix it?
Show answer
Situation: a new developer built a GST calculation from an old FRD version, and the error was caught only in UAT. Task: fix the defect and prevent repeats. Action: I moved all requirement documents into one shared space with version history, added a change log and status labels such as draft or approved, and linked each user story to the latest approved section. Result: in the next two releases we had no defects caused by outdated specifications.
38
What is a data dictionary and why does a business analyst maintain one?
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.
39
How do you write an effective executive summary for an analysis report?
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.
40
What is a balanced scorecard?
Show answer
A balanced scorecard is a strategic performance framework that tracks objectives and KPIs across four perspectives: financial (revenue growth, margin), customer (NPS, retention), internal processes (cycle time, defect rate) and learning and growth (training hours, employee engagement). The idea is that financial results are lagging, so leaders also need leading measures of what drives future performance. A strategy map links the objectives with cause-and-effect arrows from people to processes to customers to financial outcomes.
Tips to crack the LTIMindtree Business Analytics interview
- Practise aptitude, logical reasoning and basic coding questions, as the online assessment is usually the first filter.
- Revise SQL, OOP and testing fundamentals, plus any cloud or data tools you list on your resume.
- Learn about the L&T Group background and the LTI and Mindtree merger to answer company-related questions.
- 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; LTIMindtree interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the LTIMindtree Business Analytics interview?
Candidates usually go through 4 stages: Online assessment (aptitude + reasoning); 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 LTIMindtree Business Analytics interview?
This practice set leans on UAT and BA Documentation (6), Product Analytics (5), Power BI and Tableau (4), SQL for Business Analysis (4). Revise those first, then practise explaining one or two of your own projects end to end, because most LTIMindtree interviewers ask you to walk through real work.
Are these the exact questions asked at LTIMindtree?
No. These are curated practice questions that match the skills and difficulty usually tested in it services interviews like LTIMindtree's. They are not a leaked or verified list of past questions.
Where does LTIMindtree hire Business Analytics professionals in India?
LTIMindtree has large teams in Mumbai, Pune, Bengaluru, Chennai, Hyderabad. Openings and locations change often, so check the LTIMindtree careers page and filter by city and experience.
Business Analytics questions for similar companies
IT services
TCS
Business Analytics interview questions
Mumbai, Chennai, Pune +2
View questionsIT services
Birlasoft
Business Analytics interview questions
Pune, Noida, Bengaluru +1
View questionsIT services
L&T Technology Services
Business Analytics interview questions
Vadodara, Bengaluru, Chennai +2
View questionsIT services
Cyient
Business Analytics interview questions
Hyderabad, Bengaluru, Noida
View questionsIT services
NTT DATA
Business Analytics interview questions
Bengaluru, Pune, Noida +2
View questionsIT services
Tech Mahindra
Business Analytics interview questions
Pune, Hyderabad, Bengaluru +2
View questionsMore 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