GlobalLogic Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About GlobalLogic hiring for Business Analytics roles
GlobalLogic, a Hitachi Group company, is a digital engineering services firm working on product development, embedded software, cloud and data for clients in automotive, healthcare, media and telecom. Its India engineering centres are among its largest. It hires for software engineers, test engineers, data engineers and embedded developers.
For Business Analytics roles, this GlobalLogic practice set focuses most on Excel for Business Analysts (7), Business Metrics and KPIs (7), Requirements and Agile (6), SQL for Business Analysis (6). It has 18 easy, 21 medium, 1 hard questions, so you can start easy and work up to the harder ones.
Company type
IT services
Headquarters
San Jose, California, USA
Main India offices
Noida, Bengaluru, Gurugram, Hyderabad, Nagpur
GlobalLogic Business Analytics interview process
Online assessment (aptitude + coding)
Technical round 1
Technical round 2
HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for GlobalLogicStart 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.
Waterfall runs fixed phases one after another with requirements frozen early. Agile delivers in short sprints with continuous feedback, so requirements can change. In Agile, BAs maintain the backlog and user stories.
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.
04
What is the difference between a pool and a lane in BPMN?
A pool represents a separate participant in a process, such as the customer, your company or an external bank. A lane is a subdivision inside a pool, usually a department, role or system, such as Sales, Finance and Warehouse within your company. Sequence flows can cross lanes within one pool, but communication between two pools must be shown with message flows, because separate participants do not share one controlled flow.
05
How would you build a simple financial model in Excel?
Capex (capital expenditure) is spending on long-term assets that benefit several years, such as machinery, buildings or capitalised software development. It goes on the balance sheet and is expensed gradually through depreciation or amortisation. Opex (operating expenditure) covers day-to-day running costs such as salaries, rent and cloud subscriptions, and is expensed in the period it occurs. Moving from owned servers to cloud services shifts IT spending from capex to opex, which changes how budgets and business cases look.
07
Write Excel formulas to find the second-highest sales value and the name of the rep who achieved it.
// 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)
A data object (page shape with a folded corner) represents information that an activity needs or produces during one process instance, such as an invoice or an application form. It is linked with dotted associations. A data store (cylinder) represents information that persists beyond the process instance, such as the customer database or ERP. Showing them helps developers see which systems are read or updated at each step and helps spot missing integrations.
SUMIFS is faster and easier for sums with AND conditions on ranges. SUMPRODUCT multiplies arrays and sums the result, so it handles cases SUMIFS cannot: weighted totals like price times quantity, OR logic, conditions on calculated values such as MONTH(date)=4, or comparing two columns row by row. On very large sheets SUMPRODUCT is slower, so prefer SUMIFS or a helper column when possible.
10
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.
11
Explain exclusive, parallel and inclusive gateways in BPMN.
An exclusive gateway (diamond with X) sends the flow down exactly one path based on a condition, for example approved or rejected. A parallel gateway (diamond with +) splits into all paths at once and, when joining, waits for every path to finish. An inclusive gateway (diamond with O) activates one or more paths whose conditions are true and joins only those that were activated. Choosing the wrong one causes deadlocks or duplicated work in automated processes.
12
What is the difference between defect severity and defect priority?
Severity describes the impact of a defect on the system or business, such as critical when payments fail or low for a spelling mistake. Priority describes how urgently it must be fixed, which is a business decision. They can differ: a wrong company logo on the login page is low severity but high priority before a launch, while a crash in a rarely used year-end report may be high severity but lower priority if the report is months away.
13
What is an impact-effort matrix and how do you use it to prioritise recommendations in a case?
An impact-effort matrix is a 2x2 grid that plots options by expected business impact against effort, cost or time. High impact and low effort are quick wins to do first; high impact and high effort are major projects to plan; low impact and low effort are fill-ins; low impact and high effort should be dropped. In a case interview, it helps you end with a clear, prioritised recommendation rather than a long list of ideas.
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.
19
What is a stakeholder and who are the typical stakeholders in a project?
All three number rows within a window ordered by a column. ROW_NUMBER gives a unique sequence 1, 2, 3 even for ties. RANK gives ties the same number and then skips, so 1, 1, 3. DENSE_RANK gives ties the same number without gaps, so 1, 1, 2. Use ROW_NUMBER to pick exactly one row per group, such as the latest order, and DENSE_RANK for 'top 3 distinct salary levels' type questions.
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.
It breaks a top metric into drivers: Revenue = Users × Conversion × AOV; Users = New + Returning, and so on. It shows which lever to pull and where a drop came from.
24
What does expectation management mean for a business analyst?
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 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.
27
Write an Excel formula to extract the domain from an email address.
Release notes describe what changed in a specific release: new features, enhancements, fixed defects, known issues and any actions users must take. They are short and version-specific. A user manual or user guide explains how to use the whole system to complete tasks, with step-by-step instructions and screenshots, and is updated as the product evolves. BAs often review both, because users rely on them in the first weeks after go-live.
29
A KPI on your dashboard dropped 40 percent overnight. What are your first steps?
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.
30
What is the difference between a process, a procedure and a work instruction?
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.
31
Describe how you would model an employee leave approval process in BPMN.
Use one pool for the company with lanes for Employee, Manager and HR system. Start event: leave request submitted. Task: system checks leave balance. Exclusive gateway: balance sufficient? If no, end event that notifies the employee. If yes, user task: manager reviews. Add an interrupting timer boundary event of 3 days that escalates to the skip-level manager. Gateway: approved or rejected. Approved path updates the leave balance and calendar, then both paths notify the employee and end.
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.
33
What is the difference between a vanity metric and an actionable metric?
A vanity metric looks impressive but does not guide decisions, such as total app downloads, page views or social followers that only ever go up. An actionable metric links clearly to a decision and behaviour, such as Day-7 retention, conversion rate by channel or revenue per active user. A good test: if the number changes, do you know what to do differently? If not, it is probably vanity.
34
Inventory days rose from 45 to 70 over two quarters. What could be the causes and what would you recommend?
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.
LTV to CAC compares the lifetime gross profit from a customer with the cost of acquiring them. A ratio around 3 to 1 is commonly treated as healthy. Below 1 means you lose money on every customer. Far above 5 may mean you are underinvesting in growth. Always compute LTV on gross margin, not revenue, and check it by channel, because blended averages hide loss-making channels.
38
Write an Excel formula that labels sales as High (100000 or more), Medium (50000 or more) or Low.
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.
Tips to crack the GlobalLogic Business Analytics interview
Revise OOP, data structures and one programming language in depth, as GlobalLogic interviews focus on engineering fundamentals.
Learn about its Hitachi Group ownership and work in automotive and embedded software if you have that interest.
Prepare to discuss testing practices, including unit tests and automation, for both developer and QA roles.
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; GlobalLogic interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the GlobalLogic Business Analytics interview?
Candidates usually go through 4 stages: Online assessment (aptitude + coding); Technical round 1; Technical round 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 GlobalLogic Business Analytics interview?
This practice set leans on Excel for Business Analysts (7), Business Metrics and KPIs (7), Requirements and Agile (6), SQL for Business Analysis (6). Revise those first, then practise explaining one or two of your own projects end to end, because most GlobalLogic interviewers ask you to walk through real work.
Are these the exact questions asked at GlobalLogic?
No. These are curated practice questions that match the skills and difficulty usually tested in it services interviews like GlobalLogic's. They are not a leaked or verified list of past questions.
Where does GlobalLogic hire Business Analytics professionals in India?
GlobalLogic has large teams in Noida, Bengaluru, Gurugram, Hyderabad, Nagpur. Openings and locations change often, so check the GlobalLogic careers page and filter by city and experience.
Business Analytics questions for similar companies