01
What are wireframes and why are they useful for a BA?
Show answer
Low-fidelity layouts of screens that help stakeholders visualise and agree on requirements before development starts.
Quest Global Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Quest Global hiring for Business Analytics roles
Quest Global is an engineering services company headquartered in Singapore with large engineering centres in India. It provides mechanical design, embedded software, digital engineering and manufacturing support to clients in aerospace, energy, healthcare, automotive and semiconductors. In India it hires mechanical, electrical, electronics and software engineers, with centres in cities such as Bengaluru, Thiruvananthapuram and Belagavi.
For Business Analytics roles, this Quest Global practice set focuses most on Excel for Business Analysts (8), Requirements and Agile (7), Case Studies and Guesstimates (4), Product Analytics (4). It has 25 easy, 15 medium questions, so you can start easy and work up to the harder ones.
- Company type
- IT services
- Headquarters
- Singapore
- Main India offices
- Bengaluru, Thiruvananthapuram, Belagavi, Pune
Quest Global Business Analytics interview process
- Online assessment (aptitude + technical MCQs)
- Technical interview
- Managerial round
- HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Quest GlobalStart 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 a PESTEL analysis?
Show answer
PESTEL scans the external environment across Political, Economic, Social, Technological, Environmental and Legal factors. For an electric vehicle maker in India it would cover subsidies and policy, fuel prices and interest rates, consumer attitudes, battery technology, emission targets and safety regulations. It is useful in market entry and strategy cases to spot opportunities and risks beyond the company's control, and pairs well with SWOT.
03
How do you write a query to find users active in consecutive months?
Show answer
Get distinct user-month pairs, self-join or use LAG on month per user, and keep rows where the previous month is exactly one month earlier.
04
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.
05
What is a use case diagram?
Show answer
A UML diagram showing actors and the actions (use cases) they perform with the system, giving a quick view of scope.
06
What are heatmaps and session recordings, and when would you use them alongside funnel analysis?
Show answer
Heatmaps aggregate where users click, move and scroll on a page, while session recordings replay individual user sessions. Funnel analysis tells you where users drop off, for example 40 percent leave on the address page; heatmaps and recordings help explain why, such as a hidden Continue button or a confusing pin code field. They are qualitative, so use them to form hypotheses and then validate fixes with an A/B test. Personal data must be masked in recordings.
07
Why do you want to become a business analyst?
Show answer
Link your answer to real experience. For example: during my internship I noticed reports were rebuilt manually every week, so I mapped the process and automated it with Power Query, saving the team a day each week. I enjoyed understanding the problem, talking to users and seeing the result used. A BA role combines that problem solving, communication and data work, which is where my strengths are, and I want to build deeper domain knowledge.
08
What is the difference between gross margin and net margin?
Show answer
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.
09
What is the hierarchy of epic, feature and user story in Agile?
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'.
10
What is a RACI matrix?
Show answer
A table assigning Responsible, Accountable, Consulted and Informed roles per task so ownership is clear.
11
What are start, intermediate and end events in BPMN?
Show answer
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.
12
What are acceptance criteria?
Show answer
Clear, testable conditions a story must meet to be accepted, often written as Given-When-Then scenarios.
13
What is Customer Acquisition Cost (CAC) and what is CAC payback period?
Show answer
CAC is total sales and marketing spend in a period divided by new customers acquired in that period. If you spend 10 lakh and gain 2,000 customers, CAC is 500 rupees. CAC payback period is how many months of gross profit from a customer it takes to recover that CAC. A shorter payback means the business can reinvest faster; many subscription businesses aim for under 12 months.
14
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.
15
What checklist do you apply to a BPMN diagram before sharing it with stakeholders?
Show answer
Every diagram has clear start and end events and a title with version and owner. Activities use verb-noun names such as Approve invoice. Each gateway is labelled with a question and its outgoing flows with answers. Splits and joins use matching gateway types. Message flows only connect separate pools. No dangling or crossing arrows where avoidable. The happy path reads left to right. Exceptions are handled, and complex rules are referenced to decision tables rather than drawn as gateways.
16
Write an Excel formula that lists all North region orders above 50,000 rupees.
Show answer
=FILTER(Orders[[OrderID]:[Amount]],
(Orders[Region]="North") * (Orders[Amount]>50000),
"No matching orders")
# Multiplying the two conditions acts as AND.
# Use + instead of * for OR logic.
# Wrap with SORT(..., 3, -1) to sort by the third column descending.
17
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.
18
What is an event tracking plan and why does it matter?
Show answer
A tracking plan is a document listing every event the product should log, such as 'checkout_started', with its trigger, properties like price, plan or source, naming rules and owner. It keeps data consistent across web, Android and iOS, prevents duplicate or vague events and makes analysis trustworthy. Without one, teams end up with events like 'click1' and 'buttonClick' meaning the same thing, and analysis becomes guesswork.
19
What is the debt-to-equity ratio and how do you interpret it?
Show answer
Debt-to-equity equals total borrowings divided by shareholders' equity. It shows how much the company relies on borrowed money versus owners' funds. A ratio of 0.5 means 50 paise of debt for every rupee of equity. Higher leverage can boost returns but raises interest burden and risk in downturns. Acceptable levels depend on the industry: utilities and infrastructure carry more debt than software firms. Always read it with interest coverage, which is EBIT divided by interest expense.
20
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.
21
How do you chart a trend with a target line?
Show answer
Create a line or column chart of actuals and add the target as another series formatted as a line.
22
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.
23
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')
24
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.
25
Which Excel functions do business analysts use daily?
Show answer
VLOOKUP or XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF, text functions, PivotTables and charts.
26
Control has 10,000 users with 400 purchases and the variant has 10,000 users with 460 purchases. Calculate the lift.
Show answer
Control conversion is 400 divided by 10,000, which is 4.0 percent. Variant conversion is 460 divided by 10,000, which is 4.6 percent. The absolute lift is 0.6 percentage points and the relative lift is 0.6 divided by 4.0, which is 15 percent. Before calling it a win, run a two-proportion significance test and check the confidence interval and guardrail metrics.
27
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.
28
Users in a shared Excel tracker keep typing region names with different spellings. How do you stop this?
Show answer
Use Data Validation with a List rule. Keep the allowed regions in a separate sheet as an Excel Table, name it, and set the validation source to that range so the dropdown grows when you add a region. Turn on an error alert so free text is rejected. Then clean existing entries once with Find and Replace or a mapping lookup. For stronger control, protect the sheet and unlock only the input cells, so the list cannot be edited by mistake.
29
What is the difference between accrual accounting and cash accounting?
Show answer
Under accrual accounting, revenue is recorded when it is earned and expenses when they are incurred, regardless of when cash moves. Under cash accounting, transactions are recorded only when cash is received or paid. Companies in India report under accrual-based standards (Ind AS). Example: an annual software contract billed in April is recognised as revenue month by month over 12 months under accrual, even though all the cash came in April.
30
What is scope creep and how do you control it?
Show answer
Uncontrolled growth of requirements. Control it with a clear scope statement, change control process, impact analysis and sponsor approval for additions.
31
What is the difference between XLOOKUP and INDEX-MATCH?
Show answer
Both look up values flexibly; XLOOKUP is simpler with built-in not-found handling, while INDEX-MATCH works in older Excel versions.
32
KPI vs metric?
Show answer
Every KPI is a metric, but a KPI is tied directly to a strategic goal (e.g. monthly churn). A metric can be any measurement (e.g. page views).
33
How do you create a dashboard in Excel?
Show answer
Prepare clean data, build PivotTables and PivotCharts, add KPI cards and slicers, and arrange everything on one sheet with a clear layout.
34
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.
35
You added new rows to the source data, but your PivotTable does not show them even after refresh. Why?
Show answer
The PivotTable source is probably a fixed range such as A1:F500, so rows added below 500 are outside it. The fix is to convert the data to an Excel Table with Ctrl+T and change the pivot's data source to the table name, so it expands automatically. Also check for blank header cells, filters on the pivot hiding new items, and whether the new rows are actually text values in a numeric column, which can change grouping.
36
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.
37
Tell me about a time careful listening helped you uncover a hidden requirement.
Show answer
Situation: during interviews for a new order system, a warehouse supervisor kept mentioning that Friday evenings were chaotic. Task: understand whether this mattered for the requirements. Action: instead of moving on, I asked what happened on Fridays and learned that bulk orders were split manually because of truck capacity limits. Result: we added an automatic order-splitting rule that nobody had listed, which saved the team about four hours a week and avoided a likely UAT failure.
38
What is feature adoption rate and how do you measure it?
Show answer
Feature adoption rate is the share of eligible active users who used a feature in a period. For example, if 4,000 of 20,000 monthly active users used saved searches, adoption is 20 percent. Measure it against eligible users only, track first use and repeat use separately, and compare retention of adopters versus non-adopters. High first use with low repeat use often means the feature is discoverable but not valuable.
39
What is the difference between absolute, relative and mixed cell references in Excel?
Show answer
A relative reference like A1 shifts when the formula is copied. An absolute reference like $A$1 stays fixed, useful for a tax rate or target cell. A mixed reference fixes only the column ($A1) or only the row (A$1), which is handy in multiplication grids or when copying a formula across months and products. Press F4 to cycle through the four options while editing a formula.
40
What does the CALCULATE function do in DAX?
Show answer
CALCULATE evaluates an expression under a modified filter context. You pass a measure plus filter arguments that add, replace or remove filters, for example CALCULATE([Sales], 'Region'[Name] = "North") or CALCULATE([Sales], ALL('Product')). It is the basis of time intelligence, percent-of-total and comparison measures. It also triggers context transition when used inside a row context, which is powerful but a common source of confusion.
Tips to crack the Quest Global Business Analytics interview
- Revise core subjects from your engineering branch, such as machine design, electronics or programming, depending on the role applied for.
- Be ready to discuss tools you have used, such as CAD software, MATLAB or a programming language, with concrete project examples.
- Read about Quest Global's industries like aerospace and energy so you can explain why engineering services appeal to you.
- 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; Quest Global interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Quest Global Business Analytics interview?
Candidates usually go through 4 stages: Online assessment (aptitude + technical MCQs); 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 Quest Global Business Analytics interview?
This practice set leans on Excel for Business Analysts (8), Requirements and Agile (7), Case Studies and Guesstimates (4), Product Analytics (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Quest Global interviewers ask you to walk through real work.
Are these the exact questions asked at Quest Global?
No. These are curated practice questions that match the skills and difficulty usually tested in it services interviews like Quest Global's. They are not a leaked or verified list of past questions.
Where does Quest Global hire Business Analytics professionals in India?
Quest Global has large teams in Bengaluru, Thiruvananthapuram, Belagavi, Pune. Openings and locations change often, so check the Quest Global careers page and filter by city and experience.
Business Analytics questions for similar companies
IT services
L&T Technology Services
Business Analytics interview questions
Vadodara, Bengaluru, Chennai +2
View questionsIT services
IBM
Business Analytics interview questions
Bengaluru, Pune, Hyderabad +2
View questionsIT services
Hexaware
Business Analytics interview questions
Navi Mumbai, Chennai, Pune +2
View questionsIT services
Zensar Technologies
Business Analytics interview questions
Pune, Hyderabad, Bengaluru
View questionsIT services
Mastek
Business Analytics interview questions
Mumbai, Pune
View questionsIT services
Cognizant
Business Analytics interview questions
Chennai, 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