Tata Elxsi Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Tata Elxsi hiring for Business Analytics roles
Tata Elxsi is a Tata Group design and technology services company that works on product engineering for the automotive, media and communications, and healthcare industries. Its teams build embedded software, set-top box and streaming solutions, medical device software and user experience designs. In India it hires software, embedded, testing and design engineers, with a notable development centre in Thiruvananthapuram's Technopark.
For Business Analytics roles, this Tata Elxsi practice set focuses most on SQL for Business Analysis (7), Power BI and Tableau (6), Product Analytics (5), Requirements and Agile (5). It has 18 easy, 22 medium questions, so you can start easy and work up to the harder ones.
Company type
IT services
Headquarters
Bengaluru, India
Main India offices
Bengaluru, Thiruvananthapuram, Chennai, Pune
Tata Elxsi Business Analytics interview process
Online assessment (aptitude + technical)
Technical interview
Managerial round
HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Tata ElxsiStart 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 sections does a good software requirements specification (SRS) contain?
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.
AARRR breaks the customer lifecycle into five stages: Acquisition, how users find you; Activation, their first good experience; Retention, whether they come back; Referral, whether they recommend you; and Revenue, whether they pay. Each stage gets one or two metrics, such as sign-ups by channel, activation rate, Day-30 retention, invite rate and conversion to paid. It helps find which stage is the weakest bottleneck.
03
What is product analytics and how is it different from business reporting?
Product analytics studies how users behave inside a digital product, using event data such as sign-ups, clicks, feature use and purchases, to improve activation, engagement and retention. Business reporting usually summarises outcomes like revenue, cost and orders by period. Product analytics answers questions like where users drop off, which features retained users adopt, and whether a change worked, often through funnels, cohorts and experiments.
04
Write DAX measures for Total Sales, Sales Last Year and Year-over-Year growth percent.
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.
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.
08
What are the four basic categories of elements in BPMN?
BPMN groups its shapes into four categories. Flow objects are events (circles), activities (rounded rectangles) and gateways (diamonds). Connecting objects are sequence flows, message flows and associations. Swimlanes are pools and lanes that show participants and roles. Artifacts are data objects, groups and text annotations that add context without changing the flow. Knowing these four groups lets you read almost any BPMN diagram quickly.
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.
WITH ranked AS (
SELECT category, product_id, SUM(amount) AS revenue,
DENSE_RANK() OVER (PARTITION BY category
ORDER BY SUM(amount) DESC) AS rk
FROM sales
GROUP BY category, product_id
)
SELECT category, product_id, revenue
FROM ranked
WHERE rk <= 3
ORDER BY category, rk;
12
Write an Excel formula that labels sales as High (100000 or more), Medium (50000 or more) or Low.
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.
14
What are start, intermediate and end events in BPMN?
Events are circles that show something happening. A start event (thin border) triggers the process, such as a form submitted or a timer firing on the first of the month. An intermediate event (double border) happens during the process, such as waiting for a payment message or a 48-hour timer. An end event (thick border) marks where a path finishes and can carry a result such as a message, an error or termination of all paths.
A short requirement written as 'As a user, I want X so that Y', backed by acceptance criteria. Good stories follow INVEST: independent, negotiable, valuable, estimable, small and testable.
16
In UAT cycle 2, a feature that passed in cycle 1 is now broken after a defect fix. What does this tell you and what should change?
It is a regression: the fix for one defect broke existing functionality, which usually means changes were not impact-analysed and there is no regression suite. Log it as a new high-priority defect linked to the fix. Agree with the team that every UAT build comes with release notes listing the changes, and that QA runs an automated or core manual regression pack before handing the build to business testers. Also add the broken flow to the UAT regression checklist.
17
What is the difference between SQL and Excel for analysis?
A report is a multi-page, interactive view built in Power BI Desktop from one semantic model, with slicers, drill-through and cross-filtering. A dashboard is a single-page canvas in the Service made of tiles pinned from one or more reports, and is meant for monitoring key numbers at a glance. Dashboards support data alerts on card and KPI tiles, but have limited interactivity; clicking a tile opens the underlying report for detailed exploration.
21
A business tester raises a defect, and the developer closes it as 'works as designed'. How do you resolve it?
Go back to the requirement and acceptance criteria. If the system matches the agreed requirement, the developer is right, and the business need is a change request. If the requirement is unclear or the design misread it, it is a defect, and the requirement wording should be fixed. Discuss it in triage with both parties, using examples. Either way, close the loop with the tester so they understand the outcome and keep trusting the process.
22
What is the difference between correlation and causation in product analytics?
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.
23
What is a foreign key and what is referential integrity?
A foreign key is a column in one table that refers to the primary key of another, such as orders.customer_id pointing to customers.customer_id. Referential integrity means every foreign key value must exist in the parent table, so you cannot have an order for a customer who does not exist. The database enforces it on insert, update and delete, which keeps joins reliable for reporting.
24
What is a data dictionary and why does a business analyst maintain one?
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.
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'.
As a customer, I want to reset my password by email so that I can get back into my account.
Acceptance criteria:
• Reset link expires in 15 minutes
• Password rules are shown while typing
• A success message appears after reset
A language for querying databases. BAs use it to pull data themselves, validate numbers, check reports and answer questions without waiting for engineers.
29
Write a DAX measure for the product return rate that avoids divide-by-zero errors.
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.
30
What is the difference between Power BI Desktop, Power BI Service and Power BI Mobile?
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.
31
What is the difference between gross margin and net margin?
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.
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
);
Funnel analysis measures how many users move through a sequence of steps towards a goal, such as visit, product view, add to cart, checkout and payment, and the conversion and drop-off at each step. It shows where the biggest leak is so the team can focus fixes there. Break funnels down by device, channel and new versus returning users, and define a time window for completing the steps.
37
What Power Query steps would you use to clean a messy monthly sales file?
Promote the first row to headers and remove blank or total rows. Set correct data types for dates and amounts, and use locale settings for Indian date formats. Trim and clean text columns, replace errors and nulls, split combined fields like 'City-State', and unpivot month columns into rows. Remove duplicates on the order ID, then merge with the product master. Rename steps clearly so others can follow the logic.
38
After a redesign, average time spent in the app increased. Is that good?
It depends on the product's goal. For a content or learning app, more time may mean more engagement. For a payments or banking app, more time can mean users struggle to complete tasks. Check task completion rate, time to complete key actions, errors, support tickets and retention. A metric is good only when it moves in line with the value users came for.
UAT is the final testing phase where real business users check that the system supports their work and meets requirements before go-live. The BA helps plan UAT, prepares business scenarios and test cases from requirements, arranges test data, supports users during testing, triages defects versus change requests and tracks sign-off. UAT is not about finding code bugs, which earlier testing should have caught.
Tips to crack the Tata Elxsi Business Analytics interview
Revise C, C++ or Python fundamentals along with operating systems and networking basics for embedded and media engineering roles.
Prepare a crisp walkthrough of your best project, focusing on the problem, your contribution and what you would improve now.
Read about Tata Elxsi's work in automotive software, video streaming and medical devices to show real interest in its domains.
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; Tata Elxsi interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Tata Elxsi Business Analytics interview?
Candidates usually go through 4 stages: Online assessment (aptitude + technical); 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 Tata Elxsi Business Analytics interview?
This practice set leans on SQL for Business Analysis (7), Power BI and Tableau (6), Product Analytics (5), Requirements and Agile (5). Revise those first, then practise explaining one or two of your own projects end to end, because most Tata Elxsi interviewers ask you to walk through real work.
Are these the exact questions asked at Tata Elxsi?
No. These are curated practice questions that match the skills and difficulty usually tested in it services interviews like Tata Elxsi's. They are not a leaked or verified list of past questions.
Where does Tata Elxsi hire Business Analytics professionals in India?
Tata Elxsi has large teams in Bengaluru, Thiruvananthapuram, Chennai, Pune. Openings and locations change often, so check the Tata Elxsi careers page and filter by city and experience.
Business Analytics questions for similar companies