01
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.
KPIT Technologies Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About KPIT Technologies hiring for Business Analytics roles
KPIT Technologies is a Pune-based software integration partner for the automotive and mobility industry. It works with vehicle makers and suppliers on embedded software, autonomous driving, electric powertrains, connected vehicles and AUTOSAR-based development. In India it hires software, embedded, testing and validation engineers, and many roles suit candidates from electronics, electrical, mechanical and computer science backgrounds with an interest in vehicles.
For Business Analytics roles, this KPIT Technologies practice set focuses most on Requirements and Agile (7), Case Studies and Guesstimates (6), UAT and BA Documentation (5), Product Analytics (4). It has 13 easy, 26 medium, 1 hard questions, so you can start easy and work up to the harder ones.
- Company type
- IT services
- Headquarters
- Pune, India
- Main India offices
- Pune, Bengaluru
KPIT Technologies Business Analytics interview process
- Online assessment (aptitude + programming)
- Technical interview
- Managerial round
- HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for KPIT TechnologiesStart 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 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.
03
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.
04
How would you build a simple financial model in Excel?
Show answer
Separate inputs, calculations and outputs, link all formulas to input cells, add scenarios and checks, and avoid hard-coded numbers inside formulas.
05
What is the difference between a Tableau extract and a live connection?
Show answer
A live connection queries the source database every time the view changes, so data is current but speed depends on the database. An extract (.hyper file) is a compressed snapshot stored by Tableau that is fast to query and can be refreshed on a schedule, but it is only as fresh as the last refresh. Extracts suit large, slow or remote sources; live suits fast warehouses and real-time needs.
06
A stakeholder's only requirement is 'make the app faster'. How do you turn this into clear requirements?
Show answer
Ask which screens or actions feel slow, for which users, on which devices and networks, and how it affects the business, such as checkout drop-off. Gather current timings from monitoring data. Then write measurable non-functional requirements, for example 'the search results page loads within 2 seconds for 95 percent of requests on a 4G connection'. Confirm targets with the stakeholder and agree how they will be tested.
07
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.
08
Write a defect report for an invoice that calculates GST incorrectly.
Show answer
Title: Invoice applies 12 percent GST instead of 18 percent for service items. Environment: UAT, build 2.4.1. Steps: create an order with service item SRV-101 at 1,000 rupees for a customer in Maharashtra and generate the invoice. Expected: CGST 90 and SGST 90, total 1,180. Actual: CGST 60 and SGST 60, total 1,120. Severity: high, as it affects tax compliance. Attachments: invoice PDF and screenshot. Linked requirement: FR-TAX-07.
09
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.
10
What are leading and lagging indicators? Give examples.
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.
11
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.
12
What is a traceability matrix?
Show answer
A table linking each requirement to design, test cases and delivery status, ensuring nothing is missed and helping assess change impact.
13
How do you find the top 5 customers by revenue?
Show answer
SELECT customer_id, SUM(amount) AS revenue FROM orders GROUP BY customer_id ORDER BY revenue DESC LIMIT 5;
14
Should a food-delivery app launch in a new city?
Show answer
Check market size (population, online ordering share), competition, restaurant supply, unit economics per order, CAC and payback period. Propose a pilot with clear success metrics.
15
SQL: total revenue per month.
Show answer
SELECT DATE_TRUNC('month', order_date) AS month, SUM(amount) AS revenue
FROM orders GROUP BY 1 ORDER BY 1;
-- MySQL: DATE_FORMAT(order_date, '%Y-%m')
16
Revenue grew 20 percent this quarter but the number of active customers stayed flat. How do you interpret it?
Show answer
Growth came from more value per customer, not more customers. Break revenue into customers times orders per customer times average order value to see which moved. It could be price increases, larger baskets, a shift to premium products or a few large accounts. Then check risks: is new customer acquisition stalling, is churn being masked, and is growth concentrated in a small segment that could leave?
17
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
);
18
What is the answer-first or pyramid principle approach to presenting analysis?
Show answer
Start with the main conclusion or recommendation, then give the two or three supporting reasons, and only then the detailed data. Senior stakeholders have little time, so a summary like 'Churn rose because of payment failures; fixing retries can save 4 lakh a month' should come first. Detail goes in the appendix. It is the opposite of a chronological walk through every step of the analysis.
19
How is a product owner's role different from a business analyst's role?
Show answer
The product owner owns the product vision and the backlog order, makes final priority decisions and accepts completed work on behalf of the business. The business analyst works on understanding problems in depth: eliciting and analysing requirements, modelling processes and data, writing detailed stories and acceptance criteria and supporting the team and testers. In smaller teams one person may do both, but the PO decides what, while the BA clarifies how it should work.
20
What Power Query steps would you use to clean a messy monthly sales file?
Show answer
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.
21
What does GROUP BY do and how is HAVING different from WHERE?
Show answer
GROUP BY aggregates rows by column; WHERE filters before grouping and HAVING filters after, using aggregate conditions.
22
Inventory days rose from 45 to 70 over two quarters. What could be the causes and what would you recommend?
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.
23
What are the current ratio and the quick ratio?
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.
24
Explain the defect life cycle.
Show answer
A defect is logged as New with steps, expected and actual results, and evidence. It is reviewed in triage and moves to Open or Assigned, or to Rejected, Duplicate or Deferred. The developer fixes it and marks it Fixed or Ready for retest. The tester retests: if it passes it moves to Closed, and if not it is Reopened. Tracking status and age helps the UAT lead report readiness and spot defects stuck too long.
25
What is the difference between correlation and causation in product analytics?
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.
26
What is gap analysis?
Show answer
Compare the current state (as-is) with the desired state (to-be), list the gaps in process, people or technology, and plan actions to close them.
27
What steps would you follow to create a tracking plan for a new 'save for later' feature?
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.
28
What is Net Promoter Score (NPS) and what are its limitations?
Show answer
NPS asks customers how likely they are to recommend you on a 0 to 10 scale. Scores of 9 to 10 are promoters, 7 to 8 passives and 0 to 6 detractors. NPS equals percent promoters minus percent detractors, ranging from minus 100 to plus 100. Limitations: it is one question, sensitive to survey timing and sample bias, and does not explain why. Pair it with open-text reasons and behavioural metrics like retention.
29
Tell me about yourself, for a business analyst role.
Show answer
Keep it to about 90 seconds in a present, past, future flow. For example: I am a commerce graduate working as an analyst intern, where I build Excel and Power BI reports and write SQL queries for the sales team. Earlier, my college project analysed customer churn for a local gym and recommended changes they adopted. I want to grow as a business analyst because I enjoy turning business problems into clear requirements and data-driven decisions.
30
Guesstimate: how many laptops are sold in India each year?
Show answer
Segment by buyer. Households: about 30 crore households, roughly 15 percent own a laptop, so 4.5 crore laptops, replaced every 5 years, gives about 90 lakh a year, plus around 20 lakh first-time student buyers. Businesses: assume 4 crore office workers using laptops, replaced every 4 years, giving 1 crore. Government and education schemes add around 10 lakh. Total is about 2.2 crore. Sanity check against industry trends and give a range of 1.5 to 2.5 crore.
31
UAT starts tomorrow, but the business has not nominated any testers. What do you do?
Show answer
Escalate immediately to the business sponsor with the impact: each day without testers delays sign-off and go-live. Ask for named testers with protected time, even part-time. Meanwhile, prepare so no time is lost: finalise test cases, check the environment and data, and plan a short tester briefing. If testers cannot be released, propose re-planning UAT dates rather than letting IT or the BA test on the business's behalf, because acceptance must come from the users.
32
What are the 4 Ps of marketing?
Show answer
Product, Price, Place and Promotion, the levers a business uses to bring an offering to market.
33
What is the difference between a sprint review and a sprint retrospective?
Show answer
A sprint review is held at the end of the sprint with stakeholders to demonstrate completed work, gather feedback and adjust the backlog; it is about the product. A sprint retrospective is an internal team meeting afterwards to discuss what went well, what did not and what to improve in the way of working; it is about the process. The BA often helps demo stories in the review.
34
The scheduled refresh failed overnight and leadership reviews the dashboard at 10 am. What do you do?
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.
35
A bank's mobile app logins increased, but digital transactions fell. What could explain this?
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.
36
How is Kanban different from Scrum?
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.
37
What is a UAT test plan and what does it contain?
Show answer
A UAT test plan defines how acceptance testing will be run. It covers scope and out-of-scope items, business processes to be tested, entry and exit criteria, roles such as testers, UAT lead and sign-off authority, test environment and test data, schedule and cycles, defect management process with severity definitions, communication and reporting, and risks. The BA usually drafts it with business owners so testers know exactly what they are accepting and when.
38
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").
39
What is value chain analysis?
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.
40
How do you approach a guesstimate question?
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.
Tips to crack the KPIT Technologies Business Analytics interview
- Revise C programming, pointers, embedded systems basics and microcontroller concepts, which are central to many KPIT engineering roles.
- Learn the basics of automotive software such as AUTOSAR, CAN communication and electric vehicle components to stand out in discussions.
- Prepare to explain any vehicle, robotics or embedded project in detail, including hardware used and how you tested it.
- 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; KPIT Technologies interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the KPIT Technologies Business Analytics interview?
Candidates usually go through 4 stages: Online assessment (aptitude + programming); 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 KPIT Technologies Business Analytics interview?
This practice set leans on Requirements and Agile (7), Case Studies and Guesstimates (6), UAT and BA Documentation (5), Product Analytics (4). Revise those first, then practise explaining one or two of your own projects end to end, because most KPIT Technologies interviewers ask you to walk through real work.
Are these the exact questions asked at KPIT Technologies?
No. These are curated practice questions that match the skills and difficulty usually tested in it services interviews like KPIT Technologies's. They are not a leaked or verified list of past questions.
Where does KPIT Technologies hire Business Analytics professionals in India?
KPIT Technologies has large teams in Pune, Bengaluru. Openings and locations change often, so check the KPIT Technologies careers page and filter by city and experience.
Business Analytics questions for similar companies
IT services
Quest Global
Business Analytics interview questions
Bengaluru, Thiruvananthapuram, Belagavi +1
View questionsIT services
Nagarro
Business Analytics interview questions
Gurugram, Jaipur
View questionsIT services
Birlasoft
Business Analytics interview questions
Pune, Noida, Bengaluru +1
View questionsIT services
Infogain
Business Analytics interview questions
Noida, Gurugram, Pune +1
View questionsIT services
Virtusa
Business Analytics interview questions
Hyderabad, Chennai, Bengaluru
View questionsIT services
Capgemini
Business Analytics interview questions
Mumbai, Bengaluru, Pune +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