01
What is a BRD review and who signs it off?
Show answer
Stakeholders and the sponsor review the Business Requirements Document for completeness and accuracy, and the business owner gives formal sign-off before design begins.
Axis Bank Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Axis Bank hiring for Business Analytics roles
Axis Bank is one of India's large private sector banks, offering retail banking, corporate banking, credit cards, loans and digital payment services. It acquired Citibank's India consumer business in 2023. It hires for branch banking, relationship management, operations, risk, analytics and technology roles, and also runs young professional and campus programmes.
For Business Analytics roles, this Axis Bank practice set focuses most on Requirements and Agile (8), Case Studies and Guesstimates (6), Power BI and Tableau (5), Excel for Business Analysts (5). It has 3 easy, 34 medium, 3 hard questions, so you can start easy and work up to the harder ones.
- Company type
- Banking & finance
- Headquarters
- Mumbai, India
- Main India offices
- Mumbai, Bengaluru
Axis Bank Business Analytics interview process
- Online assessment (aptitude + banking awareness)
- Functional or technical interview
- Managerial round
- HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Axis BankStart 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
02
The scheduled refresh failed overnight and leadership reviews the dashboard at 10 am. What do you do?
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.
03
What is Power Pivot?
Show answer
An Excel add-in for building data models with relationships and DAX measures over millions of rows, beyond normal worksheet limits.
04
Your process diagram has grown to 80 shapes on one page and stakeholders say they cannot read it. What do you do?
Show answer
Restructure it into levels. Create a high-level map with 7 to 10 main steps, then collapse detailed parts into sub-processes with their own diagrams. Move complex decision logic into a decision table rather than chains of gateways. Show the happy path first and handle exceptions in separate views. Use consistent naming in verb-noun form and remove duplicated steps. Finally, test readability by asking a stakeholder to explain the diagram back to you.
05
What are acceptance criteria?
Show answer
Clear, testable conditions a story must meet to be accepted, often written as Given-When-Then scenarios.
06
Write DAX measures for Total Sales, Sales Last Year and Year-over-Year growth percent.
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
07
A new TO-BE process went live three months ago. How do you prove that the improvement actually worked?
Show answer
Compare against the baseline you measured before the change, using the same definitions: cycle time, first-time-right rate, cost per case, backlog and customer complaints. Pull data from system timestamps rather than surveys. Check that the gain is not explained by lower volumes or seasonality, ideally by comparing similar periods. Also check for side effects, such as faster processing but more rework downstream. Present the before-and-after with the business owner, and note where adoption is still incomplete.
08
What steps would you follow to create an AS-IS process map for a customer refund process?
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.
09
What are leading and lagging indicators? Give examples.
Show answer
Lagging indicators measure outcomes after they happen, such as monthly revenue, profit or churn. They confirm results but are hard to influence directly. Leading indicators move earlier and predict outcomes, such as demo bookings, trial activations, cart additions or support ticket backlog. A good KPI set pairs them: a sales team tracks qualified pipeline (leading) along with closed revenue (lagging) so it can act before the quarter ends.
10
Write a DAX measure that shows each category's percent share of total sales.
Show answer
Category Share % =
DIVIDE(
[Total Sales],
CALCULATE([Total Sales], ALL('Product'[Category]))
)
-- ALLSELECTED instead of ALL respects slicers on the page
11
Write an Excel formula for month-to-date sales up to today.
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
12
What are TAM, SAM and SOM?
Show answer
TAM, Total Addressable Market, is total demand for the product if every possible customer bought it. SAM, Serviceable Available Market, is the part you can reach with your model, geography and channels. SOM, Serviceable Obtainable Market, is the share you can realistically capture in the next few years given competition. For an online tutoring startup in India, TAM is all school students, SAM those online in target cities, SOM a small share of that.
13
Push notifications increased weekly engagement, but app uninstalls also rose. What do you recommend?
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
A business tester raises a defect, and the developer closes it as 'works as designed'. How do you resolve it?
Show answer
Go back to the requirement and acceptance criteria. If the system matches the agreed requirement, the developer is right, and the business need is a change request. If the requirement is unclear or the design misread it, it is a defect, and the requirement wording should be fixed. Discuss it in triage with both parties, using examples. Either way, close the loop with the tester so they understand the outcome and keep trusting the process.
15
A stakeholder asks for a detailed report by tomorrow, but it realistically needs a week. What do you do?
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.
16
What sections does a good software requirements specification (SRS) contain?
Show answer
A typical SRS includes purpose, scope and definitions; overall description with users, operating environment, assumptions and constraints; functional requirements, each with a unique ID, description, priority and acceptance criteria; external interface requirements for UI, APIs and integrations; non-functional requirements such as performance, security, availability and compliance; data requirements; and appendices with diagrams and a traceability reference. Each requirement should be clear, testable and traceable to a business need.
17
What is the difference between absolute, relative and mixed cell references in Excel?
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.
18
What is a user story and what makes it good?
Show answer
A short requirement written as 'As a user, I want X so that Y', backed by acceptance criteria. Good stories follow INVEST: independent, negotiable, valuable, estimable, small and testable.
19
Guesstimate: how many cups of tea are sold in Delhi per day?
Show answer
Population about 20 million, adult tea drinkers about 50%, cups bought outside per person around 1 on average. This gives roughly 10 million cups, then adjust for offices and stalls.
20
What is the difference between a sprint review and a sprint retrospective?
Show answer
A sprint review is held at the end of the sprint with stakeholders to demonstrate completed work, gather feedback and adjust the backlog; it is about the product. A sprint retrospective is an internal team meeting afterwards to discuss what went well, what did not and what to improve in the way of working; it is about the process. The BA often helps demo stories in the review.
21
How do you handle NULL values when calculating averages?
Show answer
AVG ignores NULLs; use COALESCE(col, 0) if NULLs should count as zero, depending on the business meaning.
22
A company reports a profit every quarter but is running out of cash. How do you explain and investigate it?
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.
23
Why do Agile teams estimate in story points rather than hours?
Show answer
Story points measure relative effort, complexity and uncertainty compared with a reference story, using a scale like 1, 2, 3, 5, 8. People are better at comparing sizes than predicting exact hours, and points do not depend on who does the work. Over a few sprints the team's velocity, points completed per sprint, makes forecasting reliable. Points should never be used to compare productivity across teams.
24
Guesstimate: how many smartphones are sold in India each year?
Show answer
Use a replacement plus new-buyer approach. India has about 144 crore people; assume around 60 crore active smartphone users. If people replace phones every 4 years on average, replacements are about 15 crore a year. Add first-time buyers, say 2 to 3 percent of the remaining adult population, roughly 1.5 crore. The estimate is about 16 to 17 crore phones a year, which is close to reported industry numbers of around 15 crore.
25
An order has a value of 600 rupees, product cost 360, delivery 60, payment fee 12 and a discount of 50. What is the contribution margin?
Show answer
Net revenue after discount is 600 minus 50, which is 550 rupees. Variable costs are 360 plus 60 plus 12, totalling 432. Contribution margin is 550 minus 432, so 118 rupees per order, or about 21 percent of net revenue. This is what each order contributes towards fixed costs such as salaries and rent. If the discount were raised to 150, the order would contribute only 18 rupees.
26
A hospital chain's average patient waiting time has risen from 30 to 50 minutes. How would you approach the case?
Show answer
Clarify where the wait is measured: registration, consultation, diagnostics or billing. Split the problem into demand and capacity. On demand, check patient volume, peak-hour mix, walk-ins versus appointments and new departments. On capacity, check doctor availability, no-shows of staff, consultation time per patient and process bottlenecks such as manual billing. Identify the biggest stage and suggest fixes like slot-based appointments, triage and digital billing.
27
What steps would you follow to run a process discovery workshop?
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.
28
Write a DAX measure for a running total of sales by date.
Show answer
Running Sales =
CALCULATE(
[Total Sales],
FILTER(
ALL('Date'[Date]),
'Date'[Date] <= MAX('Date'[Date])
)
)
-- for a yearly reset use TOTALYTD([Total Sales], 'Date'[Date])
29
Revenue grew 20 percent this quarter but the number of active customers stayed flat. How do you interpret it?
Show answer
Growth came from more value per customer, not more customers. Break revenue into customers times orders per customer times average order value to see which moved. It could be price increases, larger baskets, a shift to premium products or a few large accounts. Then check risks: is new customer acquisition stalling, is churn being masked, and is growth concentrated in a small segment that could leave?
30
Gross margin fell from 38 percent to 34 percent in one quarter. How do you investigate?
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.
31
How can LET and LAMBDA make complex Excel formulas easier to maintain? Give an example.
Show answer
// LET names intermediate values so they are calculated once
=LET(rev, SUM(C2:C100), cost, SUM(D2:D100),
IF(rev=0, 0, (rev - cost) / rev))
// LAMBDA saved in Name Manager as MARGIN
=LAMBDA(rev, cost, IF(rev=0, 0, (rev - cost) / rev))
// then use =MARGIN(C2, D2) anywhere in the workbook
32
What is an issue tree and how does a hypothesis-driven approach work?
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.
33
Which what-if analysis tools does Excel have?
Show answer
Goal Seek (find the input for a target output), Data Tables (see outputs for many inputs) and Scenario Manager (save best, base and worst cases).
34
What is the profit equation and how do you use it in cases?
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.
35
The totals in your Excel report differ from the finance system by a few rupees. What could cause this?
Show answer
Usually rounding. Excel may display rounded values while summing the full-precision numbers, or line items were rounded individually in the source system and the total was computed differently. Check whether finance rounds each invoice line before summing, and apply ROUND at the same level in Excel. Other causes include floating-point artifacts, values stored as text being skipped by SUM, or hidden filtered rows. Agree and document one rounding rule with finance.
36
Tell me about a time you said no to a stakeholder.
Show answer
Situation: a regional manager wanted a custom report changed daily, which would have taken half my week. Task: support him without blocking other priorities. Action: I asked which decisions the report fed and found he needed only four numbers. I said no to the custom version, explained the impact on other work, and added those four metrics with a filter to the existing dashboard. Result: he got his numbers the same day and the team kept its capacity.
37
A new onboarding flow increased sign-ups by 15 percent, but Day-7 retention fell. How do you analyse this?
Show answer
Check whether the extra sign-ups are lower-intent users who would naturally retain less. Compare Day-7 retention for comparable users in both versions and count retained users in absolute terms, not just rates. If the new flow skips a step that led users to the aha moment, retention per user may truly fall. The decision depends on whether total retained, valuable users went up or down.
38
What is a spike in Agile and when would a business analyst request one?
Show answer
A spike is a time-boxed story used for research or experimentation to reduce uncertainty, not to deliver a feature. Its output is knowledge, such as a recommendation or a prototype. A BA might request one when the team cannot estimate a story because an external API, a data source or a regulation is unclear, for example checking whether a payment gateway supports partial refunds. The time box, often one to three days, prevents open-ended investigation.
39
What is a boundary event in BPMN, and how do interrupting and non-interrupting boundary events differ?
Show answer
A boundary event is attached to the edge of an activity and reacts to something that happens while that activity is running. An interrupting boundary event (solid double border) cancels the activity and takes the exception path, for example a 24-hour timeout cancelling manual approval. A non-interrupting one (dashed border) starts a parallel path while the activity continues, for example sending a reminder email after 12 hours without stopping the approval task.
40
What is a process flow and which tools do you use?
Show answer
A diagram of steps, decisions and owners in a process, made using BPMN or flowcharts in tools like Visio, Lucidchart or draw.io.
Tips to crack the Axis Bank Business Analytics interview
- Prepare banking awareness topics such as repo rate, CASA, NPAs, KYC and digital payment systems like UPI.
- For analytics and technology roles, revise SQL, Excel and data visualisation, and be ready with project examples.
- Practise clear communication and customer-handling answers, since many bank roles involve direct interaction with customers.
- 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; Axis Bank interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Axis Bank Business Analytics interview?
Candidates usually go through 4 stages: Online assessment (aptitude + banking awareness); Functional or technical interview; 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 Axis Bank Business Analytics interview?
This practice set leans on Requirements and Agile (8), Case Studies and Guesstimates (6), 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 Axis Bank interviewers ask you to walk through real work.
Are these the exact questions asked at Axis Bank?
No. These are curated practice questions that match the skills and difficulty usually tested in banking & finance interviews like Axis Bank's. They are not a leaked or verified list of past questions.
Where does Axis Bank hire Business Analytics professionals in India?
Axis Bank has large teams in Mumbai, Bengaluru. Openings and locations change often, so check the Axis Bank careers page and filter by city and experience.
Business Analytics questions for similar companies
Banking & finance
BNY
Business Analytics interview questions
Pune, Chennai
View questionsBanking & finance
Morgan Stanley
Business Analytics interview questions
Mumbai, Bengaluru
View questionsBanking & finance
HSBC
Business Analytics interview questions
Hyderabad, Pune, Bengaluru
View questionsBanking & finance
HDFC Bank
Business Analytics interview questions
Mumbai, Chennai, Bengaluru
View questionsBanking & finance
Citi
Business Analytics interview questions
Pune, Chennai, Mumbai +2
View questionsBanking & finance
Standard Chartered
Business Analytics interview questions
Chennai, Bengaluru, Mumbai
View questionsMore ways to practise
Company-wise Business Analytics questionsPackage-wise Business Analytics questionsExperience-wise Business Analytics questionsRole-wise Business Analytics questionsCity-wise Business Analytics questionsMost asked Business Analytics questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsBusiness Analytics mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsBusiness Analytics topic sheets