Skip to content

Amazon Business Analytics Interview Questions & Answers

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

About Amazon hiring for Business Analytics roles

Amazon is a global technology company spanning e-commerce, cloud computing through AWS, devices, advertising and streaming. In India it runs large engineering, operations and analytics teams supporting both Amazon.in and global businesses. It hires for software development engineers, SDETs, quality assurance engineers, business intelligence engineers, data engineers and data scientists.

For Business Analytics roles, this Amazon practice set focuses most on Product Analytics (7), Case Studies and Guesstimates (7), Excel for Business Analysts (5), Financial and Business Analysis (4). It has 1 easy, 30 medium, 9 hard questions, so you can start easy and work up to the harder ones.

Company type
Product
Headquarters
Seattle, USA
Main India offices
Bengaluru, Hyderabad, Chennai, Pune, Gurugram

Amazon Business Analytics interview process

  1. Online assessment (coding + work style survey)
  2. Technical round 1 (DSA)
  3. Technical round 2 (DSA or system design)
  4. Bar raiser round
  5. Hiring manager round

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

Solved for AmazonStart 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

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

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

How do you write an effective executive summary for an analysis report?

Save to ▾
Show answer
Put it first and keep it to one page or five lines on a slide. Start with the answer or recommendation, then the two or three key findings that support it, each with a number, then the impact in rupees or percentage, and finally the decision or action needed and by when. Avoid methodology details, which go in the appendix. Test it by asking whether a busy leader could act after reading only this section.
04

Write a SQL query that shows revenue, cost and gross margin percent by product category.

Save to ▾
Show answer
SELECT p.category, SUM(oi.quantity * oi.unit_price) AS revenue, SUM(oi.quantity * p.unit_cost) AS cost, ROUND(100.0 * (SUM(oi.quantity * oi.unit_price) - SUM(oi.quantity * p.unit_cost)) / NULLIF(SUM(oi.quantity * oi.unit_price), 0), 2) AS gross_margin_pct FROM order_items oi JOIN products p ON p.product_id = oi.product_id GROUP BY p.category ORDER BY gross_margin_pct DESC;
05

Write a SQL query for Day-7 retention by weekly sign-up cohort.

Save to ▾
Show answer
WITH cohort AS ( SELECT user_id, signup_date, DATE_TRUNC('week', signup_date) AS cohort_week FROM users ), ret AS ( SELECT DISTINCT c.user_id FROM cohort c JOIN events e ON e.user_id = c.user_id AND e.event_date = c.signup_date + INTERVAL '7 day' ) SELECT c.cohort_week, COUNT(*) AS users, ROUND(100.0 * COUNT(r.user_id) / COUNT(*), 1) AS d7_retention_pct FROM cohort c LEFT JOIN ret r ON r.user_id = c.user_id GROUP BY c.cohort_week ORDER BY c.cohort_week;
06

What are LOD expressions in Tableau and how do FIXED, INCLUDE and EXCLUDE differ?

Save to ▾
Show answer
Level of Detail expressions compute an aggregate at a granularity different from the view. FIXED computes at the stated dimensions regardless of the view, for example { FIXED [Customer ID] : MIN([Order Date]) } for first purchase date. INCLUDE adds a dimension to the view level, useful for average sales per customer by region. EXCLUDE removes a dimension, useful for comparing each month with the yearly total. FIXED ignores normal dimension filters unless they are context filters.
07

A product manager wants to stop an A/B test after three days because the variant is winning. What do you advise?

Save to ▾
Show answer
Advise against it. Checking results repeatedly and stopping at the first significant result inflates false positives, often far beyond the planned 5 percent. Three days also misses weekly patterns and novelty effects. Run the test for the pre-calculated sample size and duration. If speed is critical, the team can use a sequential testing method designed for early looks, but that must be planned before the test starts.
08

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

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
10

Your AS-IS map of a loan approval process shows 14 handoffs between teams. How do you identify improvements?

Save to ▾
Show answer
First measure each handoff: waiting time, rework rate and volume, using system timestamps where possible. Then classify steps as value-adding, required for compliance or waste. Look for patterns: repeated approvals, information re-entered in two systems, work bouncing back for missing documents. Typical fixes are merging roles, adding a checklist at intake so applications arrive complete, parallelising checks and automating rule-based approvals. Quantify the expected reduction in cycle time for each option.
11

What is a market entry strategy case?

Save to ▾
Show answer
Decide whether and how to enter a market by evaluating attractiveness, competition, capabilities and entry mode (build, buy, partner), then risks and next steps.
12

Write a SQL query to find the percentage of orders delivered late in each city.

Save to ▾
Show answer
-- late = delivered after the promised date SELECT city, COUNT(*) AS total_orders, SUM(CASE WHEN delivered_at > promised_at THEN 1 ELSE 0 END) AS late_orders, ROUND(100.0 * SUM(CASE WHEN delivered_at > promised_at THEN 1 ELSE 0 END) / COUNT(*), 2) AS late_pct FROM orders WHERE status = 'DELIVERED' GROUP BY city ORDER BY late_pct DESC;
13

Your A/B test was meant to split traffic 50/50, but the actual split is 52/48 on 200,000 users. What do you do?

Save to ▾
Show answer
This is a sample ratio mismatch. With 200,000 users, a 52/48 split is far outside random chance, which a chi-square test will confirm. It means the assignment or logging is broken, for example the variant page crashing before the tracking event fires, bots filtered unevenly or a redirect losing users. Do not trust the results. Investigate by segment, platform and day to find the cause, fix it and rerun the test.
14

Guesstimate: how many weddings take place in India in a year?

Save to ▾
Show answer
Assume a population of about 144 crore and an average life expectancy of about 70 years, so roughly 2 crore people reach a typical marriage age each year. If about 95 percent of them marry at some point, that is around 1.9 crore people, or about 95 lakh weddings, since each wedding involves two people. A reasonable estimate is around 1 crore weddings per year, concentrated in the winter wedding season.
15

How do you compute CAGR in Excel?

Save to ▾
Show answer
CAGR = (End value / Start value)^(1/years) - 1, entered as =(B2/A2)^(1/n)-1.
16

Tell me about a time you solved an ambiguous problem with limited data.

Save to ▾
Show answer
Situation: my manager asked why customer complaints were rising, but complaints were stored as free text with no categories. Task: give an answer within a week. Action: I sampled 300 complaints, created categories, tagged them manually and used keyword rules in Excel to classify the rest, then validated with the support lead. Result: late refunds were 40 percent of complaints, the refund process was fixed, and categorised tagging was added to the support tool.
17

A bank wants to reduce customer churn. What would you do?

Save to ▾
Show answer
Define churn, analyse who leaves and why, segment customers, find drivers through data and surveys, design retention offers and measure uplift with a control group.
18

How do you find the top 5 customers by revenue?

Save to ▾
Show answer
SELECT customer_id, SUM(amount) AS revenue FROM orders GROUP BY customer_id ORDER BY revenue DESC LIMIT 5;
19

Leadership wants to automate an invoice approval process with RPA. What do you check in the process model before agreeing?

Save to ▾
Show answer
Check that the process is stable, rule-based and high volume, with structured digital inputs. Look at the variant rate: if half the cases are exceptions handled by judgement, a bot will fail often. Verify that the underlying systems and screens will not change soon. Fix the process first, because automating a broken flow only makes errors faster. Finally estimate hours saved against bot build and maintenance cost, and define how exceptions get routed to people.
20

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
21

Guesstimate: how many pizzas are sold in Mumbai on a weekend?

Save to ▾
Show answer
About 20 million people, roughly 10% order pizza on a weekend, about 1 pizza per 2 people in an order. This gives roughly 1 million pizzas, adjusted for outlets and delivery capacity.
22

What is the difference between Definition of Ready and Definition of Done?

Save to ▾
Show answer
Definition of Ready is a checklist a story must meet before the team pulls it into a sprint: clear description, acceptance criteria, dependencies identified, designs attached and estimated. Definition of Done is the checklist for calling work complete: coded, reviewed, tested, acceptance criteria passed, documented and deployable. The BA mostly drives readiness, while the whole team owns done. Both reduce rework and arguments at sprint end.
23

In UAT cycle 2, a feature that passed in cycle 1 is now broken after a defect fix. What does this tell you and what should change?

Save to ▾
Show answer
It is a regression: the fix for one defect broke existing functionality, which usually means changes were not impact-analysed and there is no regression suite. Log it as a new high-priority defect linked to the fix. Agree with the team that every UAT build comes with release notes listing the changes, and that QA runs an automated or core manual regression pack before handing the build to business testers. Also add the broken flow to the UAT regression checklist.
24

How do you validate that a report's numbers are correct?

Save to ▾
Show answer
Reconcile totals with source tables using SQL, check filters and joins for duplication, compare with prior periods and verify with business owners.
25

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

How do you build a PivotTable to analyse sales by region and product?

Save to ▾
Show answer
Create a table, insert a PivotTable, drag region to rows, product to columns, sales to values, and add slicers for month or channel.
27

A feature was launched to all users at once without an A/B test. How would you measure its impact?

Save to ▾
Show answer
Use quasi-experimental methods. Compare before and after with enough history to account for trend and seasonality. If it rolled out at different times in regions or platforms, use difference-in-differences between early and late groups. Compare users who adopted with similar non-adopters using matching, while being careful about self-selection. For future launches, recommend keeping a small holdout group so impact can be measured cleanly.
28

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

Write a SQL query to calculate the DAU to MAU stickiness ratio for a month.

Save to ▾
Show answer
WITH daily AS ( SELECT event_date, COUNT(DISTINCT user_id) AS dau FROM events WHERE event_date >= '2026-10-01' AND event_date < '2026-11-01' GROUP BY event_date ), monthly AS ( SELECT COUNT(DISTINCT user_id) AS mau FROM events WHERE event_date >= '2026-10-01' AND event_date < '2026-11-01' ) SELECT ROUND(AVG(d.dau) * 1.0 / MAX(m.mau), 3) AS stickiness FROM daily d CROSS JOIN monthly m;
30

Explain Porter's Five Forces.

Save to ▾
Show answer
A model assessing industry attractiveness through supplier power, buyer power, threat of new entrants, threat of substitutes and rivalry among competitors.
31

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

How do you manage conflicting requirements from two senior stakeholders?

Save to ▾
Show answer
Clarify the underlying goals, present data and trade-offs, facilitate a joint session, escalate to the sponsor if needed and document the agreed decision.
33

How would you prioritise 10 features with a limited budget?

Save to ▾
Show answer
Score them with RICE or value-vs-effort, align with goals, consider dependencies and risks, validate with stakeholders, then use MoSCoW for the release plan.
34

Monthly subscription churn jumped from 3 percent to 5 percent. How do you investigate?

Save to ▾
Show answer
Confirm the data first: definition changes, failed-payment handling or a billing date shift. Then segment churn by plan, tenure, acquisition channel, city and device to find where it concentrates. Separate voluntary cancellations from involuntary card failures. Look at events before the jump, like a price change, app release or competitor offer, and read cancellation reasons. Recommend targeted fixes, such as payment retries or win-back offers, and track the affected cohort.
35

Should a food-delivery app launch in a new city?

Save to ▾
Show answer
Check market size (population, online ordering share), competition, restaurant supply, unit economics per order, CAC and payback period. Propose a pilot with clear success metrics.
36

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

What is cohort analysis and why is it useful?

Save to ▾
Show answer
Cohort analysis groups users by a shared starting point, usually their sign-up or first purchase month, and tracks their behaviour over time, such as the percentage still active in month 1, 2 and 3. It separates the effect of growth from the effect of retention, so you can see whether newer cohorts retain better after a product change. It is typically shown as a triangle table or retention curves.
38

How do you use Excel's Scenario Manager?

Save to ▾
Show answer
Define named scenarios such as best, base and worst with different input values and compare the outputs in a summary report.
39

Tell me about a time you built a business case for a project. Was it approved?

Save to ▾
Show answer
Situation: our support team handled order-status queries manually, about 9,000 a month. Task: I was asked to evaluate a self-service tracking page. Action: I measured handling time from ticket data, estimated deflection conservatively at 40 percent, worked with IT on build and run costs and showed best, base and worst cases with payback. Result: leadership approved the base case. Six months after launch, deflection reached 46 percent, and I presented the benefits review to the same committee.
40

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.

Tips to crack the Amazon Business Analytics interview

  • Prepare STAR-format stories for each Amazon Leadership Principle, such as Customer Obsession, Ownership and Dive Deep.
  • Practise medium-level DSA problems on arrays, trees, graphs and dynamic programming, explaining time and space complexity aloud.
  • For BIE or data roles, practise SQL window functions and metric-driven case questions on e-commerce funnels and delivery operations.
  • 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; Amazon interviewers usually ask follow-ups on your first answer.

Frequently asked questions

How many rounds are there in the Amazon Business Analytics interview?

Candidates usually go through 5 stages: Online assessment (coding + work style survey); Technical round 1 (DSA); Technical round 2 (DSA or system design); Bar raiser round; Hiring manager 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 Amazon Business Analytics interview?

This practice set leans on Product Analytics (7), Case Studies and Guesstimates (7), Excel for Business Analysts (5), Financial and Business Analysis (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Amazon interviewers ask you to walk through real work.

Are these the exact questions asked at Amazon?

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

Where does Amazon hire Business Analytics professionals in India?

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

Business Analytics questions for similar companies