Business Analytics Interview Questions for 2 Years Experience
40 questions with answers for candidates with 2 years of experience — 4 easy, 34 medium, 2 hard.
What interviewers expect: 2 years experience
At two years, you should work fairly independently. Interviews test window functions in SQL, DAX measures or Tableau calculations, end-to-end requirement handling and how you manage changing priorities. Expect scenario questions like numbers not matching across reports or a stakeholder adding scope mid-sprint, and examples of business impact from your analysis.
This set is weighted towards UAT and BA Documentation (5), SQL for Business Analysis (5), Requirements and Agile (5), Process Modelling and BPMN (4).
SQL window functions DAX and data modelling Change and scope management Quantified business impact
Solved at this levelStart 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.
A RAID log tracks Risks, Assumptions, Issues and Dependencies for a project. Each entry has an ID, description, owner, impact, status, mitigation or action, and due date. A risk is something that may happen, an issue is something that has already happened, an assumption is believed true but unverified, and a dependency is something the project needs from others. A BA uses it to record requirement assumptions and dependencies, and reviews it weekly so nothing is silently forgotten.
02
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.
03
Monthly subscription churn jumped from 3 percent to 5 percent. How do you investigate?
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.
04
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.
05
A stakeholder keeps skipping review meetings and then rejects the deliverable at the end. How do you prevent this?
Talk to them one-to-one to understand why they skip, such as timing, relevance or workload. Offer shorter reviews, asynchronous reviews with a clear deadline, or a delegate with decision rights. Record sign-offs at each stage in writing so late changes become formal change requests. Share early drafts and mock-ups, because people react better to something visible. Escalate to the sponsor if the pattern risks the timeline.
06
What are window functions in SQL and how are they different from GROUP BY?
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.
07
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.
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.
09
Write a SQL query to find the percentage of orders delivered late in each city.
-- 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;
10
Which chart would you choose for trend, part-to-whole, comparison and distribution?
For a trend over time use a line chart. For part-to-whole use a stacked bar or a 100 percent bar; a pie or donut only works with two to four slices. For comparing categories use a sorted horizontal bar chart. For distribution use a histogram or box plot. For correlation between two measures use a scatter plot. Choosing by the question being answered, not by looks, keeps dashboards readable.
11
Write Excel formulas for IRR with yearly cash flows and XIRR with irregular dates.
# Yearly cash flows in B2:B7, year 0 investment negative
=IRR(B2:B7)
# Irregular dates: cash flows in B2:B7, dates in C2:C7
=XIRR(B2:B7, C2:C7)
# XIRR returns an annualised rate based on actual dates,
# which suits SIP returns or projects with uneven payments.
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.
13
Your LEFT JOIN report should list all customers, but customers without orders are missing. Why?
A condition on the right table was probably placed in the WHERE clause, for example WHERE o.order_date >= '2026-01-01'. For customers with no orders, o.order_date is NULL, so WHERE removes them and the query behaves like an INNER JOIN. Move the condition into the ON clause, as in LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01', or explicitly allow NULLs.
14
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.
15
What is the difference between DELETE, TRUNCATE and DROP in SQL?
DELETE removes selected rows using a WHERE clause, logs each row and can usually be rolled back inside a transaction. TRUNCATE removes all rows quickly by deallocating data pages, keeps the table structure and normally resets identity counters; rollback behaviour depends on the database. DROP removes the whole table, including its structure, indexes and permissions. Analysts mostly use DELETE carefully on staging tables and should rarely need TRUNCATE or DROP on production data.
16
What is a data dictionary and why does a business analyst maintain one?
A data dictionary is a catalogue of data elements used in a system or report: field name, business definition, data type, length, allowed values, mandatory or optional, source system, owner and example values. A BA maintains it so business users, developers and testers use one definition, for example what counts as an active customer. It prevents mapping errors in integrations and migrations, speeds up testing and reduces disputes about why reports do not match.
17
Managers want to click a region on a summary report page and jump to a detail page for only that region. How do you build it in Power BI?
Use drill-through. Create a detail page, add the Region field to the page's drill-through filter well, and design visuals for orders, products and trends. Power BI adds a back button automatically. On the summary page, users right-click a region and choose Drill through. Keep all filters on so date selections carry over. For guided navigation, you can also add buttons with bookmarks, but drill-through is the cleanest way to pass the selected region.
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.
20
Guesstimate: how many pizzas are sold in Mumbai on a weekend?
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.
Assess market size and demand, customer need, competition, unit economics, capabilities, risks and strategic fit, then test with a pilot before scale-up.
Ask which screens or actions feel slow, for which users, on which devices and networks, and how it affects the business, such as checkout drop-off. Gather current timings from monitoring data. Then write measurable non-functional requirements, for example 'the search results page loads within 2 seconds for 95 percent of requests on a 4G connection'. Confirm targets with the stakeholder and agree how they will be tested.
26
How do you adapt your communication for executives versus technical teams?
Executives want outcomes, impact, risk and decisions needed, in a one-page summary or a few slides with clear numbers. Technical teams need precise details: data fields, business rules, edge cases, acceptance criteria and dependencies. Operations users need process steps and what changes in their daily work. Same facts, different depth and vocabulary. Ask each group how they prefer to receive updates and adjust.
27
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.
28
Because of a tight deadline, the business sponsor wants to skip UAT and go live directly. How do you respond?
Explain the risks in business terms: without UAT, there is no evidence that real processes work, and production defects cost far more to fix and can affect customers and compliance. Offer alternatives: a shortened UAT covering only critical business flows, parallel running with the old system, a phased rollout to one branch or user group, or extended hypercare. If the sponsor still decides to skip it, record the decision and accepted risks formally.
29
What are UAT entry and exit criteria? Give examples.
Entry criteria are conditions that must be met before UAT starts, for example system and integration testing completed, no open critical defects, UAT environment and test data ready, test cases reviewed and testers trained. Exit criteria define when UAT is complete, for example 100 percent of critical test cases executed, at least 95 percent passed, no open critical or high defects, and workarounds agreed for remaining medium ones. Clear criteria stop arguments about readiness near go-live.
30
Prepare a simple cost-benefit analysis for automating invoice processing.
Costs: software 12 lakh in year 1 plus 3 lakh per year support, and 4 lakh for implementation and training. Benefits: 60,000 invoices a year at 10 minutes saved each is 10,000 hours; at 400 rupees per hour that is 40 lakh, plus around 5 lakh from fewer late-payment penalties. Year-1 net benefit is 45 - 16 = 29 lakh and payback is under six months. Then test sensitivity, for example if only half the time saving is realised.
31
What is Customer Acquisition Cost (CAC) and what is CAC payback period?
CAC is total sales and marketing spend in a period divided by new customers acquired in that period. If you spend 10 lakh and gain 2,000 customers, CAC is 500 rupees. CAC payback period is how many months of gross profit from a customer it takes to recover that CAC. A shorter payback means the business can reinvest faster; many subscription businesses aim for under 12 months.
32
Write a SQL query that shows revenue per region with one column per quarter.
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;
33
Three departments describe the same order process in three different ways during workshops. How do you arrive at the true AS-IS?
Treat each version as a hypothesis. Walk the process physically or observe real cases end to end, and pull a sample of 20 to 30 recent orders from the system to trace what actually happened. Compare timestamps and status changes with each department's story. Then hold a joint session, show the evidence-based map and mark the variants openly. Often all three are partly right because different order types follow different paths, which should be modelled explicitly.
34
A manager says the dashboard total does not match the finance team's Excel sheet. What do you do?
First agree on the definition: date range, gross or net, tax, returns, currency and which date (order or invoice) is used. Then reconcile at a small grain, such as one month and one region, comparing row counts and sums between the source query and the sheet. Common causes are filters on the page, missing relationships, duplicate rows after a join or a late refresh. Document the agreed definition in the report tooltip.
35
What are process levels such as L0 to L4 in a process architecture?
Process levels organise models from broad to detailed. L0 shows the value chain or main process areas, such as Order to Cash. L1 and L2 break these into process groups and end-to-end processes, such as Credit Management. L3 shows the detailed BPMN flow with roles and decisions. L4 covers work instructions or system steps. A level structure keeps hundreds of diagrams consistent, avoids duplicates and lets executives and operators each read the right depth.
36
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)
37
A food delivery company's orders fell 15%. How do you investigate?
Check data accuracy, then segment by city, restaurant, time and user type; look at supply, delivery time, pricing, competitors and seasonality before proposing fixes.
38
Write a SQL query to calculate the DAU to MAU stickiness ratio for a month.
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;
39
A company reports a profit every quarter but is running out of cash. How do you explain and investigate it?
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.
40
What is the difference between churn rate and retention rate?
Churn rate is the percentage of customers who leave in a period: customers lost divided by customers at the start. Retention rate is the percentage who stay, roughly 100 minus churn for the same cohort. If you start a month with 1,000 subscribers and 50 cancel, churn is 5 percent and retention 95 percent. Count new customers separately, otherwise growth hides churn. Revenue churn can differ from customer churn.
Frequently asked questions
What is asked in Business Analytics interviews for 2 years of experience?
At two years, you should work fairly independently. Interviews test window functions in SQL, DAX measures or Tableau calculations, end-to-end requirement handling and how you manage changing priorities. Expect scenario questions like numbers not matching across reports or a stakeholder adding scope mid-sprint, and examples of business impact from your analysis.
How many questions should I practise before a Business Analytics interview?
Work through all 40 questions here, then the company-wise sets for the employers you are targeting. Quality matters more than count: be able to explain why each answer is right.
Which topics matter most for 2 years of experience?
Focus first on SQL window functions, DAX and data modelling, Change and scope management, Quantified business impact.