Goldman Sachs Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Goldman Sachs hiring for Business Analytics roles
Goldman Sachs is a global investment banking, securities and asset management firm. Its Bengaluru and Hyderabad offices are major engineering and operations centres supporting trading, risk, compliance and consumer platforms. It hires in India for software engineers, quality engineers, data engineers, quantitative strategists and risk or operations analysts.
For Business Analytics roles, this Goldman Sachs practice set focuses most on Excel for Business Analysts (8), SQL for Business Analysis (5), Requirements and Agile (5), Case Studies and Guesstimates (4). It has 10 easy, 26 medium, 4 hard questions, so you can start easy and work up to the harder ones.
Company type
Banking & finance
Headquarters
New York, USA
Main India offices
Bengaluru, Hyderabad, Mumbai
Goldman Sachs Business Analytics interview process
Online assessment (coding + quant + aptitude)
Technical round 1 (DSA)
Technical round 2 (design or CS fundamentals)
Hiring manager round
HR or culture round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Goldman SachsStart 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
Write a SQL query to find requirements that have no linked UAT test case.
SELECT r.req_id, r.title, r.priority
FROM requirements r
LEFT JOIN test_case_links l ON l.req_id = r.req_id
WHERE l.req_id IS NULL
AND r.status = 'APPROVED'
ORDER BY r.priority;
-- Run this before UAT starts: every approved requirement
-- should trace to at least one test case.
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.
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'.
05
You receive two customer lists from sales and billing and must reconcile them. How do you do it?
Standardise both first: trim spaces, fix case, convert IDs to the same type and remove duplicates. Use a unique key like customer ID, or a combined key of phone and email if IDs differ. Then use XLOOKUP or COUNTIFS to mark each record as matched, only in sales or only in billing, or a Power Query merge with anti joins. Summarise mismatches by type and share the exception list with both owners.
06
Tell me about a time you had to learn a new analytics tool quickly for a project.
Situation: my team moved reporting from Excel to Power BI, and I had two weeks to rebuild the weekly sales report. Task: deliver it on time without errors. Action: I took a short online course, practised data modelling on a copy of our data, and asked a colleague to review my DAX measures. I reconciled every number with the old Excel report before launch. Result: the report went live on schedule, and refresh time dropped from half a day to minutes.
07
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.
08
Your monthly Excel report takes a full day of manual work. How would you automate it?
Map the steps first: which files arrive, what cleaning is done and which outputs are needed. Move the import and cleaning into Power Query so a refresh replaces copy-paste. Base calculations on Excel Tables and PivotTables that update automatically, and keep a fixed template for the output. Use a small macro or Office Script only for the remaining formatting or emailing. Add checks such as row counts and totals so errors surface quickly.
// 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)
11
Write an Excel formula for the NPV of a project with an initial investment today and five yearly cash inflows.
# B1 = discount rate (for example 12%)
# B2 = initial investment entered as a negative number
# B3:B7 = cash inflows for years 1 to 5
=NPV(B1, B3:B7) + B2
# NPV() assumes the first value comes at the end of year 1,
# so the year-0 investment is added outside the function.
12
What is Excel Solver and give a business example of using it.
Solver is an optimisation add-in that finds the best value of a target cell by changing decision cells within constraints. Unlike Goal Seek, it handles many variables and constraints. Example: choose how many units of three products to make to maximise profit, subject to machine hours, raw material and minimum order limits. You set the objective, the variable cells, constraints and a method such as Simplex LP for linear problems.
13
Write an Excel formula for working days between two dates excluding weekends and holidays.
// A2 = start, B2 = end, Holidays = named range of holiday dates
=NETWORKDAYS(A2, B2, Holidays)
// if the weekend is only Sunday (common in India)
=NETWORKDAYS.INTL(A2, B2, 11, Holidays)
14
After joining orders to a payments table, your total revenue doubled. What went wrong?
The join created a fan-out: some orders have more than one payment row, such as split payments or retries, so each order amount is repeated. Check the grain by counting rows per order_id on both sides. Fix it by aggregating payments to one row per order in a CTE before joining, joining on the full key, or summing from the table whose grain matches the metric. Always compare row counts before and after a join.
15
What is the difference between sequence flow and message flow in BPMN?
A sequence flow is a solid arrow that shows the order of activities inside one pool, so it represents work controlled by one participant. A message flow is a dashed arrow with an open circle at its start and shows communication between two different pools, such as an order email from a customer to a seller. A common modelling mistake is drawing sequence flows across pools, which wrongly implies one party controls the other's work.
16
Tell me about a dashboard you built that changed a business decision.
Situation: regional sales heads reviewed discount spend only at month end. Task: I was asked to give weekly visibility. Action: I built a Power BI report linking discounts to margin by product and region, with a drill-through to deal level and an alert when margin fell below target. Result: the team spotted two regions giving deep discounts on low-margin items, tightened approval rules, and margin improved by about two points the next quarter.
17
A feature launched two months ago is used by only 4 percent of users. What would you do?
Find out whether it is a discovery problem or a value problem. Check how many users saw the entry point, how many tried it and how many returned. If few saw it, test better placement or onboarding prompts. If many tried and few returned, interview users and review session recordings to understand why. Also check if the 4 percent are high-value users. Then decide to improve, reposition or remove it.
18
In the middle of a sprint, a senior stakeholder asks to add an urgent feature. What do you do?
Understand the urgency and the business impact of waiting until the next sprint. Bring it to the product owner, who decides. If it truly cannot wait, the team agrees to swap out work of similar size so the sprint goal stays realistic, and the trade-off is made visible to the stakeholder. If it can wait, add it to the top of the backlog for the next sprint. Avoid silently adding scope.
Compare options on fit, cost, time and risk. Buying a proven product is faster with lower risk and includes upgrades, but may need process changes and has recurring licence fees. Building fits unique processes exactly but needs a strong tech team, longer time and ongoing maintenance. Estimate five-year total cost of ownership, check whether processes are truly unique, and usually recommend buying and configuring unless warehousing is a core differentiator.
21
During UAT, users log 60 defects, but you suspect many are actually new requirements. How do you handle it?
Run a joint triage with the business owner, QA and development. Compare each item against the signed-off requirements and acceptance criteria. Real defects stay in the defect log; items not covered by requirements are reclassified as change requests and prioritised separately through change control. Keep the tone neutral so users do not feel dismissed. Also review why the gap happened, for example prototypes were not shown early enough, and fix that for the next release.
Understand the real need first: what decision is it for and what is the minimum that helps tomorrow? Offer a phased answer, such as a quick directional view with the top three numbers tomorrow, clearly labelled with caveats, and the full validated report in a week. Explain the trade-off between speed and accuracy. Confirm the agreed plan in writing so expectations are clear.
24
You added new rows to the source data, but your PivotTable does not show them even after refresh. Why?
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.
25
What is an issue tree and how does a hypothesis-driven approach work?
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.
26
Compare Import mode, DirectQuery and Live Connection in Power BI.
Import copies data into the compressed in-memory model, giving the fastest visuals and full DAX, but data is only as fresh as the last refresh and size is limited. DirectQuery sends queries to the source at view time, so data is near real time but visuals are slower and some DAX is restricted. Live Connection points to an existing published semantic model or Analysis Services model without its own model. Composite models mix Import and DirectQuery.
27
Write an Excel formula to calculate the monthly EMI for a loan of 10 lakh rupees at 9 percent annual interest for 5 years.
Monthly gross profit per customer is 500 times 40 percent, which is 200 rupees. Payback period equals CAC divided by monthly gross profit, so 1,200 divided by 200 gives 6 months. If customers churn on average before 6 months, the business loses money on acquisition. Using revenue instead of gross profit would wrongly suggest 2.4 months, which is why margin must be included.
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;
32
The CFO asks whether the company should lease or buy 50 delivery vans. How do you approach the analysis?
Build a discounted cash flow comparison over the vehicle life. For buying: purchase price, financing cost, maintenance, insurance, tax benefit of depreciation, and resale value. For leasing: lease rentals, what maintenance is included, tax treatment and end-of-term conditions. Discount both at the company's cost of borrowing and compare present value of costs. Then add qualitative factors: flexibility if volumes drop, technology risk such as a shift to electric vans, and impact on the balance sheet.
33
Two analysts report different monthly active user numbers from the same database. How do you resolve it?
Put both queries side by side and compare definitions: which events count as active, time zone, calendar versus rolling month, test and internal accounts, deleted users, and DISTINCT on user ID versus device ID. Run both on a single day to find where they diverge. Agree on one definition with the metric owner, document it, and publish it as a shared view or metric so everyone queries the same logic.
Drive it from vehicles. Assume about 2 crore new two-wheelers are sold a year, each with an average of 1.5 helmets bought (rider plus pillion), giving 3 crore. The existing fleet is around 25 crore vehicles; assume 60 percent are active and each active vehicle replaces one helmet every 3 years: 15 crore / 3 = 5 crore. Total is about 8 crore helmets a year. Sanity check: enforcement varies by state, so give a range of 6 to 9 crore.
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.
37
Write an Excel formula for the weighted average selling price across orders.
// B2:B200 = price per unit, C2:C200 = units sold
=SUMPRODUCT(B2:B200, C2:C200) / SUM(C2:C200)
// a simple AVERAGE(B2:B200) would wrongly give a small order
// the same weight as a large one
38
What is an index in a database and when can it hurt performance?
An index is a sorted lookup structure on one or more columns that lets the database find rows without scanning the whole table, much like a book index. It speeds up WHERE filters, joins and ORDER BY on those columns. It hurts when there are too many indexes, because every insert and update must maintain them, and it may not help on low-selectivity columns or when functions are applied to the indexed column.
39
Write a user story with acceptance criteria for password reset.
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
40
What is AS-IS and TO-BE process modelling, and where does BPMN fit in?
AS-IS modelling documents how a process works today, including pain points, delays and handoffs. TO-BE modelling shows the improved future process after changes or a new system. Comparing the two reveals the gaps and requirements. BPMN, Business Process Model and Notation, is the standard notation, using events, tasks, gateways for decisions and swimlanes for roles, so both business and IT read the diagrams the same way.
Tips to crack the Goldman Sachs Business Analytics interview
Practise probability and quantitative aptitude questions, which commonly appear in Goldman Sachs online assessments.
Learn basic financial concepts such as equities, bonds, derivatives and risk, especially for strats and data roles.
Prepare clear stories about teamwork and integrity, as Goldman Sachs emphasises its business principles and client focus.
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; Goldman Sachs interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Goldman Sachs Business Analytics interview?
Candidates usually go through 5 stages: Online assessment (coding + quant + aptitude); Technical round 1 (DSA); Technical round 2 (design or CS fundamentals); Hiring manager round; HR or culture 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 Goldman Sachs Business Analytics interview?
This practice set leans on Excel for Business Analysts (8), SQL for Business Analysis (5), Requirements and Agile (5), Case Studies and Guesstimates (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Goldman Sachs interviewers ask you to walk through real work.
Are these the exact questions asked at Goldman Sachs?
No. These are curated practice questions that match the skills and difficulty usually tested in banking & finance interviews like Goldman Sachs's. They are not a leaked or verified list of past questions.
Where does Goldman Sachs hire Business Analytics professionals in India?
Goldman Sachs has large teams in Bengaluru, Hyderabad, Mumbai. Openings and locations change often, so check the Goldman Sachs careers page and filter by city and experience.
Business Analytics questions for similar companies