Skip to content

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

  1. Online assessment (coding + quant + aptitude)
  2. Technical round 1 (DSA)
  3. Technical round 2 (design or CS fundamentals)
  4. Hiring manager round
  5. 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.

Save to ▾
Show answer
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.
02

What is a PESTEL analysis?

Save to ▾
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

What is a RACI matrix?

Save to ▾
Show answer
A table assigning Responsible, Accountable, Consulted and Informed roles per task so ownership is clear.
04

How are OKRs different from KPIs?

Save to ▾
Show answer
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?

Save to ▾
Show answer
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.

Save to ▾
Show answer
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?

Save to ▾
Show answer
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?

Save to ▾
Show answer
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.
09

What is Power Pivot?

Save to ▾
Show answer
An Excel add-in for building data models with relationships and DAX measures over millions of rows, beyond normal worksheet limits.
10

Write Excel formulas to find the second-highest sales value and the name of the rep who achieved it.

Save to ▾
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)
11

Write an Excel formula for the NPV of a project with an initial investment today and five yearly cash inflows.

Save to ▾
Show answer
# 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.

Save to ▾
Show answer
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.

Save to ▾
Show answer
// 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?

Save to ▾
Show answer
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?

Save to ▾
Show answer
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.

Save to ▾
Show answer
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?

Save to ▾
Show answer
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?

Save to ▾
Show answer
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.
19

What is a stakeholder analysis?

Save to ▾
Show answer
Identifying everyone affected by the project and mapping their influence and interest to decide how to communicate with and involve each group.
20

A mid-size manufacturer must choose between building and buying a warehouse management system. How do you advise?

Save to ▾
Show answer
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?

Save to ▾
Show answer
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.
22

How do you create a dashboard in Excel?

Save to ▾
Show answer
Prepare clean data, build PivotTables and PivotCharts, add KPI cards and slicers, and arrange everything on one sheet with a clear layout.
23

A stakeholder asks for a detailed report by tomorrow, but it realistically needs a week. What do you do?

Save to ▾
Show answer
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?

Save to ▾
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.
25

What is an issue tree and how does a hypothesis-driven approach work?

Save to ▾
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.
26

Compare Import mode, DirectQuery and Live Connection in Power BI.

Save to ▾
Show answer
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.

Save to ▾
Show answer
=PMT(9%/12, 5*12, -1000000) # Returns about 20,758 rupees per month. # rate = annual rate / 12, nper = total months, # pv entered as negative so the EMI shows as positive. # Total interest = EMI * 60 - 1000000.
28

CAC is 1,200 rupees, average monthly revenue per customer is 500 rupees and gross margin is 40 percent. What is the CAC payback period?

Save to ▾
Show answer
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.
29

What is the role of a BA in Scrum?

Save to ▾
Show answer
They help the Product Owner refine the backlog, write stories and acceptance criteria, clarify details with developers and support testing and demos.
30

What is a traceability matrix?

Save to ▾
Show answer
A table linking each requirement to design, test cases and delivery status, ensuring nothing is missed and helping assess change impact.
31

Write a SQL query that shows revenue per region with one column per quarter.

Save to ▾
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;
32

The CFO asks whether the company should lease or buy 50 delivery vans. How do you approach the analysis?

Save to ▾
Show answer
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?

Save to ▾
Show answer
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.
34

What is a primary key?

Save to ▾
Show answer
A column or set of columns that uniquely identifies each row in a table and cannot contain NULL.
35

Guesstimate: how many new two-wheeler helmets are sold in India each year?

Save to ▾
Show answer
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.
36

What is a balanced scorecard?

Save to ▾
Show answer
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.

Save to ▾
Show answer
// 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?

Save to ▾
Show answer
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.

Save to ▾
Show answer
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?

Save to ▾
Show answer
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