Skip to content

DE Shaw Business Analytics Interview Questions & Answers

Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.

About DE Shaw hiring for Business Analytics roles

The D. E. Shaw group is a global investment and technology development firm known for quantitative and computational approaches to investing. Its India entity, D. E. Shaw India, has offices in Hyderabad, Bengaluru and Gurugram supporting software development, quantitative analysis and operations. It hires for software developers, quality engineers, quant analysts and finance or data analysts.

For Business Analytics roles, this DE Shaw practice set focuses most on SQL for Business Analysis (6), Product Analytics (5), Power BI and Tableau (5), Excel for Business Analysts (5). It has 6 easy, 30 medium, 4 hard questions, so you can start easy and work up to the harder ones.

Company type
Fintech
Headquarters
New York, USA
Main India offices
Hyderabad, Bengaluru, Gurugram

DE Shaw Business Analytics interview process

  1. Online assessment (coding + aptitude + technical MCQs)
  2. Technical round 1 (DSA)
  3. Technical round 2 (DSA + CS fundamentals)
  4. Technical or managerial round
  5. HR round

Typical pattern based on public candidate experiences. Rounds vary by role, team and year.

Solved for DE ShawStart 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

What is feature adoption rate and how do you measure it?

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

Gross margin fell from 38 percent to 34 percent in one quarter. How do you investigate?

Save to ▾
Show answer
Break the change into drivers. Price: were discounts or promotions deeper? Mix: did sales shift towards lower-margin products, channels or regions? Cost: did raw material, freight or supplier prices rise, or did currency movements raise import costs? Also check one-offs like inventory write-offs and accounting reclassifications. Build a margin bridge showing how many percentage points each driver contributed, then take the biggest driver to the business owner with a specific action.
03

What are heatmaps and session recordings, and when would you use them alongside funnel analysis?

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

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.
05

A business head wants 25 charts on one dashboard page. How do you respond?

Save to ▾
Show answer
Ask what decisions they make weekly and which three to five KPIs drive them. Propose a summary page with those KPIs, trends and one breakdown, then drill-through or separate pages for detail. Show a quick mock-up of both versions so they see the clutter and the load time. Use bookmarks or a field parameter to let them switch views without adding charts. Agree on the layout before building.
06

A company reports a profit every quarter but is running out of cash. How do you explain and investigate it?

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

What is IRR and how is it different from NPV?

Save to ▾
Show answer
IRR (internal rate of return) is the discount rate at which a project's NPV becomes zero, so it expresses the return as a percentage. NPV gives the value created in rupees at a chosen discount rate. Accept a project if IRR exceeds the cost of capital or NPV is positive. When comparing projects of different size or timing, NPV is more reliable, because IRR ignores scale and can give multiple answers when cash flows change sign more than once.
08

What is a data table in Excel?

Save to ▾
Show answer
A what-if tool that recalculates a formula for different inputs, for example loan payments across different rates and tenures.
09

Tell me about a time UAT revealed a major issue that earlier testing missed.

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

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.
11

What steps would you follow to run a process discovery workshop?

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

Write Tableau calculated fields for profit ratio and a flag for loss-making orders.

Save to ▾
Show answer
// Profit Ratio (aggregate so it works at any level) SUM([Profit]) / SUM([Sales]) // Loss Flag (row level) IF [Profit] < 0 THEN "Loss" ELSE "Profit" END // Put Loss Flag on Color to highlight loss-making orders
13

Push notifications increased weekly engagement, but app uninstalls also rose. What do you recommend?

Save to ▾
Show answer
Quantify both effects: extra sessions and revenue from notifications versus users lost through uninstalls and notification opt-outs, including their lifetime value. Segment by notification type and frequency to find which ones annoy users. Recommend frequency caps, personalised timing, relevance rules and easy preference settings, then test them with uninstall rate and opt-out rate as guardrails. Short-term engagement should not cost long-term users.
14

Tell me about a time you challenged how a metric was defined.

Save to ▾
Show answer
Situation: our team reported 'conversion' as orders divided by sessions, and it looked healthy while revenue was flat. Task: understand the gap. Action: I showed that repeated sessions from bots and app refreshes inflated the denominator inconsistently, and proposed user-level conversion excluding internal and bot traffic. I presented both definitions with a month of data to the product head. Result: the new definition was adopted, and it exposed a checkout drop that the team then fixed.
15

What steps would you follow to create an AS-IS process map for a customer refund process?

Save to ▾
Show answer
Define the scope: where the process starts, such as a refund request, and where it ends, such as money credited. Identify the roles involved and draw swimlanes. Interview and observe each role, capturing steps, decisions, systems used, handoffs and time taken. Draw the flow in BPMN, mark pain points like rework loops and waiting time, and add measures such as average refund time. Validate the map with the people who do the work.
16

Write a SQL query to calculate the repeat purchase rate.

Save to ▾
Show answer
WITH per_customer AS ( SELECT customer_id, COUNT(DISTINCT order_id) AS orders FROM orders GROUP BY customer_id ) SELECT ROUND(100.0 * SUM(CASE WHEN orders >= 2 THEN 1 ELSE 0 END) / COUNT(*), 2) AS repeat_rate_pct FROM per_customer;
17

Write an Excel formula for month-to-date sales up to today.

Save to ▾
Show answer
// Dates in Sales[Date], amounts in Sales[Amount] =SUMIFS(Sales[Amount], Sales[Date], ">=" & EOMONTH(TODAY(), -1) + 1, Sales[Date], "<=" & TODAY()) // EOMONTH(TODAY(),-1)+1 gives the first day of the current month
18

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.
19

The scheduled refresh failed overnight and leadership reviews the dashboard at 10 am. What do you do?

Save to ▾
Show answer
Check the refresh history error first: expired credentials, gateway offline, source schema change or timeout. Fix the quick cause and trigger a manual refresh. If it cannot be fixed in time, inform the stakeholders early, state the last refreshed date clearly on the report and share the key numbers from a direct query if needed. Afterwards add refresh failure alerts and a data-as-of label so it never surprises anyone.
20

What is the profit equation and how do you use it in cases?

Save to ▾
Show answer
Profit = Revenue minus Cost, where revenue = price x volume and cost = fixed + variable. Split each part to find which one explains a change.
21

What is the difference between absolute, relative and mixed cell references in Excel?

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

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.
23

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;
24

Revenue grew but profit fell. Why could that happen?

Save to ▾
Show answer
Look at the cost side: heavier discounts, higher CAC, logistics costs, product mix shifting to low-margin items, one-time expenses or pricing changes. Break contribution margin down by segment.
25

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.
26

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.
27

What is a break-even point?

Save to ▾
Show answer
The sales volume where total revenue equals total cost. It equals fixed cost divided by contribution margin per unit.
28

What is a product backlog vs a sprint backlog?

Save to ▾
Show answer
The product backlog is the ordered list of all desired work; the sprint backlog is the subset the team commits to in the current sprint.
29

Write a SQL query to get each customer's first order date and first order amount.

Save to ▾
Show answer
WITH ordered AS ( SELECT customer_id, order_date, amount, ROW_NUMBER() OVER (PARTITION BY customer_id ORDER BY order_date, order_id) AS rn FROM orders ) SELECT customer_id, order_date AS first_order_date, amount AS first_order_amount FROM ordered WHERE rn = 1;
30

Describe how you would model an employee leave approval process in BPMN.

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

How do you handle changing requirements?

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

Guesstimate: how many laptops are sold in India each year?

Save to ▾
Show answer
Segment by buyer. Households: about 30 crore households, roughly 15 percent own a laptop, so 4.5 crore laptops, replaced every 5 years, gives about 90 lakh a year, plus around 20 lakh first-time student buyers. Businesses: assume 4 crore office workers using laptops, replaced every 4 years, giving 1 crore. Government and education schemes add around 10 lakh. Total is about 2.2 crore. Sanity check against industry trends and give a range of 1.5 to 2.5 crore.
33

How would you analyse the declining sales of a retail store?

Save to ▾
Show answer
Break sales into footfall, conversion and average basket, compare with last year and competitors, and check stock, pricing, staffing and local events.
34

Write DAX measures for Total Sales, Sales Last Year and Year-over-Year growth percent.

Save to ▾
Show answer
Total Sales = SUM(Sales[Amount]) Sales LY = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date])) YoY % = DIVIDE([Total Sales] - [Sales LY], [Sales LY]) -- needs a marked date table; DIVIDE avoids divide-by-zero errors
35

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.
36

What are window functions in SQL and how are they different from GROUP BY?

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

A product line shows a loss after allocated overheads. Leadership wants to shut it down. How do you advise?

Save to ▾
Show answer
Separate contribution from allocation. If the product's revenue exceeds its variable and directly attributable fixed costs, it contributes to covering shared overheads, which will not disappear if it is closed and will be reallocated to other products. Check whether the overhead allocation key, such as revenue share, is fair. Also consider strategic links, like customers who buy it alongside profitable products. Recommend shutting it only if contribution is negative or the freed capacity has a better use.
38

Stakeholders give conflicting requirements. What do you do?

Save to ▾
Show answer
Clarify the goal behind each request, map them to business objectives, prioritise with MoSCoW, run a joint session, then document the decision and get sign-off.
39

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)
40

What is the difference between SQL and Excel for analysis?

Save to ▾
Show answer
Excel suits small to medium data and quick ad-hoc work; SQL queries large databases directly and repeatably.

Tips to crack the DE Shaw Business Analytics interview

  • Practise challenging DSA problems and be strong in OOP, operating systems and DBMS fundamentals.
  • Prepare probability and quantitative aptitude questions, which commonly appear in DE Shaw online tests.
  • Be ready for in-depth questions on your projects, including design decisions and trade-offs you made.
  • 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; DE Shaw interviewers usually ask follow-ups on your first answer.

Frequently asked questions

How many rounds are there in the DE Shaw Business Analytics interview?

Candidates usually go through 5 stages: Online assessment (coding + aptitude + technical MCQs); Technical round 1 (DSA); Technical round 2 (DSA + CS fundamentals); Technical or 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 DE Shaw Business Analytics interview?

This practice set leans on SQL for Business Analysis (6), Product Analytics (5), Power BI and Tableau (5), Excel for Business Analysts (5). Revise those first, then practise explaining one or two of your own projects end to end, because most DE Shaw interviewers ask you to walk through real work.

Are these the exact questions asked at DE Shaw?

No. These are curated practice questions that match the skills and difficulty usually tested in fintech interviews like DE Shaw's. They are not a leaked or verified list of past questions.

Where does DE Shaw hire Business Analytics professionals in India?

DE Shaw has large teams in Hyderabad, Bengaluru, Gurugram. Openings and locations change often, so check the DE Shaw careers page and filter by city and experience.

Business Analytics questions for similar companies