Business Analytics Interview Questions for Fintech Companies

Show answer

Create a line or column chart of actuals and add the target as another series formatted as a line.

A manager says the dashboard total does not match the finance team's Excel sheet. What do you do?

Power BI and TableauMedium

Show answer

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.

How do you protect a worksheet or workbook?

Show answer

Review > Protect Sheet or Workbook with a password, lock cells, hide formulas and allow only selected cells to be edited.

How do you analyse variance between budget and actual?

Business Metrics and KPIsMedium

Show answer

Variance = Actual - Budget, shown as amount and percentage, with conditional formatting to flag large gaps and comments on the drivers.

What is a market entry strategy case?

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.

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

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.

What is an index in a database and when can it hurt performance?

SQL for Business AnalysisEasy

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.

Guesstimate: how many cars are sold in India every year?

Show answer

Structure it: households × car-owning share ÷ replacement cycle + first-time buyers + commercial fleet. State each assumption clearly and sanity-check the final number.

What is a process flow and which tools do you use?

Requirements and AgileMedium

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.

What are dynamic array functions in Excel and how do they help analysts?

Show answer

Dynamic array functions return several values that spill into neighbouring cells. UNIQUE lists distinct values, SORT and SORTBY order data, FILTER returns rows meeting conditions, SEQUENCE builds number series, and XLOOKUP can return whole rows. For example =SORT(UNIQUE(FILTER(Sales[Region], Sales[Year]=2026))) builds a live region list. They replace many helper columns and Ctrl+Shift+Enter array formulas, and the # operator references a full spill range.

Tell me about a time you received critical feedback on your work.

Stakeholder CommunicationEasy

Show answer

Situation: my manager said my first analysis deck was hard to follow. Task: improve it before it went to the client. Action: I asked for specific examples, learned that I had put twenty charts before any conclusion, and restructured it with the recommendation first, three supporting charts and an appendix. Result: the client meeting went well, and I now ask a colleague to review my storyline before every major presentation.

What is sensitivity analysis?

Show answer

Testing how changes in key inputs such as price or volume affect the output, in Excel using data tables or scenario manager.

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

Power BI and TableauMedium

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.

A bank's mobile app logins increased, but digital transactions fell. What could explain this?

Show answer

Users are coming but not completing transactions, so look at the gap. Possible causes: a release that broke a payment flow, new security steps like extra OTPs adding friction, logins driven by balance checks or offers, or transactions shifting to another channel. Compare the funnel from login to transaction by app version and device, check failure and error rates, and review support complaints before recommending fixes.

How do you find the top 5 customers by revenue?

Show answer

SELECT customer_id, SUM(amount) AS revenue FROM orders GROUP BY customer_id ORDER BY revenue DESC LIMIT 5;

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

Stakeholder CommunicationMedium

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.

BRD vs FRD?

Requirements and AgileEasy

Show answer

A BRD states what the business needs and why. An FRD details how the system should behave to meet those needs (functional specifications).

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.

What is the difference between a task and a sub-process in BPMN?

Process Modelling and BPMNEasy

Show answer

A task is an atomic unit of work that you do not break down further in the diagram, such as Verify PAN details. A sub-process is a compound activity that contains its own flow of tasks, events and gateways, shown with a small plus sign when collapsed. Sub-processes keep high-level diagrams readable: the main map shows Credit Check as one box, and a separate detailed view explains its internal steps.

Your analysis contradicts a strongly held belief of the vice president. How do you handle it?

Stakeholder CommunicationHard

Show answer

Double-check the data and method first, and ask a peer to review it. Then share it privately with the VP before any group meeting, so they are not surprised in public. Present it neutrally: what we expected, what the data shows, and possible reasons. Invite their context, as they may know factors you missed. Suggest a small test to settle it. Focus on the decision, not on being right.

What is the 80/20 rule in business analysis?

Show answer

Pareto principle: about 80% of outcomes come from 20% of causes, such as most revenue from a few customers or most defects from a few issues.

What is the difference between ROI, ROE and ROCE?

Financial and Business AnalysisMedium

Show answer

ROI (return on investment) is the gain from a specific investment divided by its cost and is used to judge projects or campaigns. ROE (return on equity) is net profit divided by shareholders' equity and shows the return to owners; high debt can inflate it. ROCE (return on capital employed) is EBIT divided by equity plus long-term debt and shows how efficiently all long-term capital is used. ROCE is better for comparing companies with different debt levels.

How do you evaluate a marketing campaign's ROI?

Business Metrics and KPIsMedium

Show answer

ROI = (incremental profit - campaign cost) / campaign cost. Measure incremental sales using a control group or before-after comparison.

How do sample size and minimum detectable effect affect an A/B test design?

Product AnalyticsHard

Show answer

The minimum detectable effect is the smallest lift worth detecting, such as a 2 percent relative increase in conversion. Smaller effects, lower baseline rates and higher required power need much larger samples, roughly four times the users to detect half the effect. Calculate sample size before starting using the baseline rate, MDE, significance level and power, usually 80 percent, then fix the test duration and avoid stopping early.

Describe a time when stakeholders resisted a process change you proposed. How did you handle it?

Process Modelling and BPMNHard

Show answer

Situation: I proposed removing a manual second approval for low-value expense claims, and team leads resisted, fearing fraud. Task: get agreement without weakening control. Action: I analysed six months of claims and showed the second approver rejected less than 0.5 percent below 5,000 rupees. I suggested a pilot with random audits of 10 percent of claims and agreed a reversal trigger. Result: the pilot ran for two months with no extra fraud, approval time fell by 3 days and the change was adopted.

A quick-commerce company wants to expand into Tier-2 cities. What would you analyse before recommending it?

Show answer

Demand: population density, smartphone and digital payment penetration, average basket size and how often people buy groceries. Supply: dark store rent, rider availability and local sourcing. Unit economics: orders per store per day needed to break even, given lower average order values. Competition: local kirana delivery and other apps. Then propose a pilot in two or three cities with clear success metrics such as orders per day, contribution margin per order and repeat rate before scaling.

How do you build a forecast in Excel?

Show answer

Use historical data with FORECAST.ETS or trend lines, state assumptions, compare against actuals and show best, base and worst scenarios.

What is the answer-first or pyramid principle approach to presenting analysis?

Stakeholder CommunicationMedium

Show answer

Start with the main conclusion or recommendation, then give the two or three supporting reasons, and only then the detailed data. Senior stakeholders have little time, so a summary like 'Churn rose because of payment failures; fixing retries can save 4 lakh a month' should come first. Detail goes in the appendix. It is the opposite of a chronological walk through every step of the analysis.

How do you write a query to find users active in consecutive months?

Show answer

Get distinct user-month pairs, self-join or use LAG on month per user, and keep rows where the previous month is exactly one month earlier.

Write a SQL query to find requirements that have no linked UAT test case.

UAT and BA DocumentationMedium

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.

Describe a BPMN model for a purchase order process where credit check and stock check happen at the same time.

Process Modelling and BPMNHard

Show answer

Start event: purchase order received. Task: validate order details. A parallel gateway then splits into two paths: Finance lane runs Check customer credit, Warehouse lane runs Check stock. A second parallel gateway joins them, waiting for both to complete. An exclusive gateway then decides: credit OK and stock available goes to Confirm order and Schedule dispatch; otherwise go to Notify customer with reason. Using a parallel join here is correct because both results are always needed.

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

Process Modelling and BPMNMedium

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.

Tell me about a time you mapped a process and discovered a major inefficiency.

Process Modelling and BPMNMedium

Show answer

Situation: vendor onboarding at my company took around 18 days and procurement blamed finance. Task: I was asked to map the AS-IS process. Action: I interviewed five roles, traced 25 recent vendor records through system timestamps and built a swimlane map. It showed that bank details were collected twice and verified by two teams separately. Result: we merged the steps into one checklist at intake, cut onboarding to 9 days and reduced rework emails by about half.

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?

Product AnalyticsHard

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.

How would you prioritise 10 features with a limited budget?

Requirements and AgileMedium

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.

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

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.

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

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;

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

Power BI and TableauEasy

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

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