01
How do you handle changing requirements?
Show answer
Log the change, assess impact on scope, cost and timeline, get approval through change control or backlog grooming, and update documents and stakeholders.
Quantiphi Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Quantiphi hiring for Business Analytics roles
Quantiphi is an AI-first digital engineering company that builds machine learning, data engineering, cloud and applied AI solutions for enterprises. It is known for close partnerships with major cloud providers and works with clients in healthcare, banking, media and retail. In India it hires machine learning engineers, data engineers, cloud engineers and software developers for global projects.
For Business Analytics roles, this Quantiphi practice set focuses most on Excel for Business Analysts (7), Requirements and Agile (6), Case Studies and Guesstimates (6), SQL for Business Analysis (5). It has 3 easy, 34 medium, 3 hard questions, so you can start easy and work up to the harder ones.
- Company type
- Analytics
- Headquarters
- Marlborough, Massachusetts, USA
- Main India offices
- Mumbai, Bengaluru
Quantiphi Business Analytics interview process
- Online assessment (aptitude + coding + ML basics)
- Technical interview 1
- Technical interview 2
- HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for QuantiphiStart 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
How do you calculate cycle time, touch time and process efficiency? Give an example.
Show answer
Cycle time (lead time) is the total elapsed time from the start to the end of a case. Touch time is the time someone actually works on it. Process cycle efficiency is touch time divided by cycle time. Example: a refund takes 5 working days (40 working hours) end to end, but the agents spend only 2 hours in total working on it. Efficiency is 2 / 40 = 5 percent, so 95 percent of the time is waiting, and queues are the main target.
03
Write a SQL query to show cumulative revenue by month.
Show answer
WITH monthly AS (
SELECT DATE_TRUNC('month', order_date) AS month,
SUM(amount) AS revenue
FROM orders
GROUP BY 1
)
SELECT month, revenue,
SUM(revenue) OVER (ORDER BY month) AS cumulative_revenue
FROM monthly
ORDER BY month;
-- add PARTITION BY EXTRACT(YEAR FROM month) to reset each year
04
What is the difference between top-down and bottom-up market sizing?
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.
05
How would you forecast next quarter's sales in Excel?
Show answer
Use FORECAST.ETS or a trendline on monthly history, check seasonality, compare with a simple moving average and present a range, not a single number.
06
What is the cash conversion cycle?
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.
07
How do you prioritise requirements?
Show answer
Use MoSCoW (Must, Should, Could, Won't), value versus effort scoring or the Kano model, agreed with stakeholders based on business value and risk.
08
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").
09
How would you prioritise 10 features with a limited budget?
Show answer
Score them with RICE or value-vs-effort, align with goals, consider dependencies and risks, validate with stakeholders, then use MoSCoW for the release plan.
10
Tell me about a time you discovered a missed requirement late in a project.
Show answer
Situation: two weeks before go-live of a billing system, a finance user asked how GST credit notes would work, which we had not covered. Task: assess and recover. Action: I analysed the impact with developers, found a simple configuration path for most cases plus a manual step for rare ones, and presented both options with dates to the sponsor. Result: we went live on time with a documented workaround and delivered the full fix next sprint.
11
The totals in your Excel report differ from the finance system by a few rupees. What could cause this?
Show answer
Usually rounding. Excel may display rounded values while summing the full-precision numbers, or line items were rounded individually in the source system and the total was computed differently. Check whether finance rounds each invoice line before summing, and apply ROUND at the same level in Excel. Other causes include floating-point artifacts, values stored as text being skipped by SUM, or hidden filtered rows. Agree and document one rounding rule with finance.
12
Write a DAX measure that shows each category's percent share of total sales.
Show answer
Category Share % =
DIVIDE(
[Total Sales],
CALCULATE([Total Sales], ALL('Product'[Category]))
)
-- ALLSELECTED instead of ALL respects slicers on the page
13
What is Power Pivot?
Show answer
An Excel add-in for building data models with relationships and DAX measures over millions of rows, beyond normal worksheet limits.
14
Tell me about a time UAT revealed a major issue that earlier testing missed.
Show answer
Situation: a new claims system passed QA, but in UAT a claims officer tried a real scenario with two policies on one claim. Task: as BA I had to assess and resolve it quickly. Action: I confirmed the requirement never covered multi-policy claims, quantified that 8 percent of claims were affected, and agreed a manual workaround while the change was built. Result: we went live on time, delivered the fix in the next release, and I added real case samples to future test design.
15
Write a SQL query that shows revenue per region with one column per quarter.
Show answer
SELECT region,
SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 1 THEN amount ELSE 0 END) AS q1,
SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 2 THEN amount ELSE 0 END) AS q2,
SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 3 THEN amount ELSE 0 END) AS q3,
SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 4 THEN amount ELSE 0 END) AS q4
FROM orders
WHERE EXTRACT(YEAR FROM order_date) = 2026
GROUP BY region;
16
What is the difference between alpha testing and beta testing?
Show answer
Alpha testing is done internally, by employees or a selected group, in a controlled environment before the product is released to outsiders, and aims to catch major issues early. Beta testing releases the product to a limited group of real external users in real conditions to gather feedback on usability, performance and missing features before general release. For a mobile app, beta often uses store testing tracks, and feedback is fed into the final release backlog.
17
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.
18
What are dynamic array functions in Excel and how do they help analysts?
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.
19
A quick-commerce company wants to expand into Tier-2 cities. What would you analyse before recommending it?
Show answer
Demand: population density, smartphone and digital payment penetration, average basket size and how often people buy groceries. Supply: dark store rent, rider availability and local sourcing. Unit economics: orders per store per day needed to break even, given lower average order values. Competition: local kirana delivery and other apps. Then propose a pilot in two or three cities with clear success metrics such as orders per day, contribution margin per order and repeat rate before scaling.
20
How would you measure the success of a new feature?
Show answer
Define a goal metric, a baseline and guardrail metrics, run an experiment or before-after comparison and review adoption, retention and revenue impact.
21
What are window functions in SQL and how are they different from GROUP BY?
Show answer
A window function calculates across a set of related rows using OVER(), but it keeps every original row instead of collapsing them. GROUP BY returns one row per group. For example, SUM(amount) OVER (PARTITION BY region) shows each order next to its region total, which helps compute share of total, rankings, running totals and month-over-month change. Common window functions are ROW_NUMBER, RANK, LAG, LEAD and SUM.
22
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.
23
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.
24
Write a DAX measure for the product return rate that avoids divide-by-zero errors.
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.
25
Build a break-even analysis in Excel.
Show answer
Break-even units = Fixed costs ÷ (Price − Variable cost per unit).
Add a data table to test different price and volume scenarios.
26
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.
27
What is a data table in Excel?
Show answer
A what-if tool that recalculates a formula for different inputs, for example loan payments across different rates and tenures.
28
Write Excel formulas to find the second-highest sales value and the name of the rep who achieved it.
Show answer
// second highest value
=LARGE(C2:C100, 2)
// rep name for that value
=INDEX(B2:B100, MATCH(LARGE(C2:C100, 2), C2:C100, 0))
// with ties, SORTBY gives a clean list:
=TAKE(SORTBY(B2:C100, C2:C100, -1), 2)
29
A lender is launching a new personal loan product. What KPIs would you set up?
Show answer
Cover the full funnel and risk. Acquisition: applications, approval rate, cost per disbursed loan and time to disbursal. Value: disbursed amount, average ticket size and net interest margin. Risk: delinquency rates at 30 and 90 days past due by cohort, and early default rate. Customer: drop-off by application step, complaint rate and repeat borrowing. Track risk by monthly disbursal cohort, because defaults show up months later.
30
What is an issue tree and how does a hypothesis-driven approach work?
Show answer
An issue tree breaks the main question into smaller, MECE sub-questions until each can be answered with data, such as 'why are profits down?' into revenue and cost branches. A hypothesis-driven approach starts with a likely answer, for example 'profit fell because delivery costs rose', and uses the tree to decide which data proves or disproves it first. It focuses effort and keeps the case structured and fast.
31
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.
32
A KPI on your dashboard dropped 40 percent overnight. What are your first steps?
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.
33
Because of a tight deadline, the business sponsor wants to skip UAT and go live directly. How do you respond?
Show answer
Explain the risks in business terms: without UAT, there is no evidence that real processes work, and production defects cost far more to fix and can affect customers and compliance. Offer alternatives: a shortened UAT covering only critical business flows, parallel running with the old system, a phased rollout to one branch or user group, or extended hypercare. If the sponsor still decides to skip it, record the decision and accepted risks formally.
34
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.
35
A company reports a profit every quarter but is running out of cash. How do you explain and investigate it?
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.
36
What is a feasibility study?
Show answer
An early assessment of whether a proposed solution is technically, economically, operationally and legally viable before committing budget.
37
How do you handle NULL values when calculating averages?
Show answer
AVG ignores NULLs; use COALESCE(col, 0) if NULLs should count as zero, depending on the business meaning.
38
What steps would you follow to run a process discovery workshop?
Show answer
Before: agree scope and process boundaries, invite people who actually do the work, not only managers, and collect existing documents and sample cases. During: state the goal, map the happy path first on a wall or digital board, then add exceptions, pain points, handoffs and volumes, and park off-topic issues. Keep timing visible. After: convert the output to a clean BPMN diagram within two days, circulate it for validation, and record open questions with owners and dates.
39
What are TAM, SAM and SOM?
Show answer
TAM, Total Addressable Market, is total demand for the product if every possible customer bought it. SAM, Serviceable Available Market, is the part you can reach with your model, geography and channels. SOM, Serviceable Obtainable Market, is the share you can realistically capture in the next few years given competition. For an online tutoring startup in India, TAM is all school students, SAM those online in target cities, SOM a small share of that.
40
An order has a value of 600 rupees, product cost 360, delivery 60, payment fee 12 and a discount of 50. What is the contribution margin?
Show answer
Net revenue after discount is 600 minus 50, which is 550 rupees. Variable costs are 360 plus 60 plus 12, totalling 432. Contribution margin is 550 minus 432, so 118 rupees per order, or about 21 percent of net revenue. This is what each order contributes towards fixed costs such as salaries and rent. If the discount were raised to 150, the order would contribute only 18 rupees.
Tips to crack the Quantiphi Business Analytics interview
- Revise machine learning fundamentals such as regression, classification, evaluation metrics and overfitting, with clear intuitive explanations.
- Get hands-on with at least one cloud platform and mention any cloud certifications, since much client work runs on cloud services.
- Prepare a deep explanation of one ML or data project, including dataset, model choice, results and deployment approach.
- 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; Quantiphi interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Quantiphi Business Analytics interview?
Candidates usually go through 4 stages: Online assessment (aptitude + coding + ML basics); Technical interview 1; Technical interview 2; 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 Quantiphi Business Analytics interview?
This practice set leans on Excel for Business Analysts (7), Requirements and Agile (6), Case Studies and Guesstimates (6), SQL for Business Analysis (5). Revise those first, then practise explaining one or two of your own projects end to end, because most Quantiphi interviewers ask you to walk through real work.
Are these the exact questions asked at Quantiphi?
No. These are curated practice questions that match the skills and difficulty usually tested in analytics interviews like Quantiphi's. They are not a leaked or verified list of past questions.
Where does Quantiphi hire Business Analytics professionals in India?
Quantiphi has large teams in Mumbai, Bengaluru. Openings and locations change often, so check the Quantiphi careers page and filter by city and experience.
Business Analytics questions for similar companies
Analytics
Affine
Business Analytics interview questions
Bengaluru
View questionsAnalytics
Tiger Analytics
Business Analytics interview questions
Chennai, Bengaluru, Hyderabad
View questionsAnalytics
NielsenIQ
Business Analytics interview questions
Vadodara, Chennai, Pune
View questionsAnalytics
Tredence
Business Analytics interview questions
Bengaluru, Chennai, Gurugram
View questionsAnalytics
Fractal Analytics
Business Analytics interview questions
Mumbai, Bengaluru, Gurugram +1
View questionsAnalytics
EXL
Business Analytics interview questions
Noida, Gurugram, Bengaluru +1
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