Business Analytics Interview Questions for Freshers
40 questions with answers for candidates with Freshers — 25 easy, 15 medium.
What interviewers expect: freshers
Interviews check fundamentals and learning ability rather than depth. Expect Excel formulas and PivotTables, basic SQL joins and aggregations, simple guesstimates, definitions like KPI, margin and user story, and a few behavioural questions about college projects or internships. Clear thinking aloud, structured answers and genuine curiosity about the business often matter more than tool knowledge.
This set is weighted towards Requirements and Agile (6), Business Metrics and KPIs (6), Excel for Business Analysts (5), SQL for Business Analysis (5).
Excel lookups, SUMIFS and PivotTables Basic SQL joins and GROUP BY Guesstimate structure Projects explained with STAR
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.
✓ 3 questions free • Unlock the rest in seconds
01
What is the difference between a task and a sub-process in BPMN?
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.
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.
04
Your AS-IS map of a loan approval process shows 14 handoffs between teams. How do you identify improvements?
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.
Power Query is the data preparation engine inside Power BI and Excel. It connects to sources like Excel, CSV, SQL databases and web APIs, then lets you clean and shape data with recorded steps: remove columns, change types, split, merge, unpivot, append and group. Each step is written in the M language and replays on every refresh, so a monthly cleanup job becomes repeatable instead of manual.
06
What is a swimlane diagram and how is it different from a simple flowchart?
A simple flowchart shows the sequence of steps and decisions but not who performs them. A swimlane diagram divides the chart into horizontal or vertical lanes, one per role, team or system, and places each step in the lane of its owner. This makes handoffs visible, because every arrow crossing a lane boundary is a handoff where delays, errors and unclear ownership often occur. BPMN lanes are a standardised form of swimlanes.
07
A lookup formula returns #N/A for some rows even though the values look present. What could be wrong?
Usually the values only look the same. Common causes are trailing or leading spaces, numbers stored as text in one sheet and as numbers in the other, non-breaking spaces from web exports, or different spellings. Check with =LEN() and =ISNUMBER(), clean with TRIM, CLEAN or VALUE, and confirm the lookup range covers all rows and uses exact match. Wrap the final formula in IFNA to label true misses.
08
A quick-commerce company wants to expand into Tier-2 cities. What would you analyse before recommending it?
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.
09
What is the difference between COUNT(*) and COUNT(column)?
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?
12
What is the difference between a vanity metric and an actionable metric?
A vanity metric looks impressive but does not guide decisions, such as total app downloads, page views or social followers that only ever go up. An actionable metric links clearly to a decision and behaviour, such as Day-7 retention, conversion rate by channel or revenue per active user. A good test: if the number changes, do you know what to do differently? If not, it is probably vanity.
PESTEL scans the external environment across Political, Economic, Social, Technological, Environmental and Legal factors. For an electric vehicle maker in India it would cover subsidies and policy, fuel prices and interest rates, consumer attitudes, battery technology, emission targets and safety regulations. It is useful in market entry and strategy cases to spot opportunities and risks beyond the company's control, and pairs well with SWOT.
15
A stakeholder's only requirement is 'make the app faster'. How do you turn this into clear requirements?
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.
16
What is the difference between a pool and a lane in BPMN?
A pool represents a separate participant in a process, such as the customer, your company or an external bank. A lane is a subdivision inside a pool, usually a department, role or system, such as Sales, Finance and Warehouse within your company. Sequence flows can cross lanes within one pool, but communication between two pools must be shown with message flows, because separate participants do not share one controlled flow.
17
CAC is 1,200 rupees, average monthly revenue per customer is 500 rupees and gross margin is 40 percent. What is the CAC payback period?
Monthly gross profit per customer is 500 times 40 percent, which is 200 rupees. Payback period equals CAC divided by monthly gross profit, so 1,200 divided by 200 gives 6 months. If customers churn on average before 6 months, the business loses money on acquisition. Using revenue instead of gross profit would wrongly suggest 2.4 months, which is why margin must be included.
18
What is a foreign key and what is referential integrity?
A foreign key is a column in one table that refers to the primary key of another, such as orders.customer_id pointing to customers.customer_id. Referential integrity means every foreign key value must exist in the parent table, so you cannot have an order for a customer who does not exist. The database enforces it on insert, update and delete, which keeps joins reliable for reporting.
19
What is the difference between absolute, relative and mixed cell references in Excel?
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.
20
What Power Query steps would you use to clean a messy monthly sales file?
Promote the first row to headers and remove blank or total rows. Set correct data types for dates and amounts, and use locale settings for Indian date formats. Trim and clean text columns, replace errors and nulls, split combined fields like 'City-State', and unpivot month columns into rows. Remove duplicates on the order ID, then merge with the product master. Rename steps clearly so others can follow the logic.
21
Write an Excel formula to extract the domain from an email address.
SELECT
CASE
WHEN total_spend >= 50000 THEN 'High'
WHEN total_spend >= 10000 THEN 'Medium'
ELSE 'Low'
END AS segment,
COUNT(*) AS customers
FROM (
SELECT customer_id, SUM(amount) AS total_spend
FROM orders GROUP BY customer_id
) t
GROUP BY 1
ORDER BY customers DESC;
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.
25
What is the difference between correlation and causation in product analytics?
Correlation means two metrics move together; causation means one actually changes the other. Users who use the wishlist feature may retain better, but they may simply be more engaged users already. Acting on correlation alone can waste effort, such as forcing everyone into the wishlist. To establish causation, run an A/B test, or use quasi-experimental methods such as difference-in-differences when a test is not possible, and always check for confounders like user tenure or acquisition channel.
26
What is horizontal and vertical analysis of financial statements?
Horizontal analysis compares line items across periods, showing growth, for example revenue up 18 percent year on year while employee costs grew 30 percent. Vertical analysis expresses each item as a percentage of a base within one period, such as each expense as a percentage of revenue, or each asset as a percentage of total assets. Together they show both trends and structure, and vertical analysis also makes companies of different size comparable.
27
Tell me about yourself, for a business analyst role.
Keep it to about 90 seconds in a present, past, future flow. For example: I am a commerce graduate working as an analyst intern, where I build Excel and Power BI reports and write SQL queries for the sales team. Earlier, my college project analysed customer churn for a local gym and recommended changes they adopted. I want to grow as a business analyst because I enjoy turning business problems into clear requirements and data-driven decisions.
28
A subscription app starts the month with 8,000 customers, gains 1,200 and loses 400. Calculate churn and net growth.
Churn rate uses customers at the start: 400 divided by 8,000 gives 5 percent. Ending customers are 8,000 plus 1,200 minus 400, which is 8,800. Net growth is 800 divided by 8,000, or 10 percent. Do not divide churned customers by the ending count, since new joiners who have not had a chance to churn would understate the churn rate.
29
A business tester raises a defect, and the developer closes it as 'works as designed'. How do you resolve it?
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.
30
Control has 10,000 users with 400 purchases and the variant has 10,000 users with 460 purchases. Calculate the lift.
Control conversion is 400 divided by 10,000, which is 4.0 percent. Variant conversion is 460 divided by 10,000, which is 4.6 percent. The absolute lift is 0.6 percentage points and the relative lift is 0.6 divided by 4.0, which is 15 percent. Before calling it a win, run a two-proportion significance test and check the confidence interval and guardrail metrics.
31
Write a UAT test case for logging in to a banking app with OTP.
Test case ID: UAT-LOGIN-03. Precondition: registered customer with a verified mobile number. Steps: 1. Open the app and enter the registered mobile number. 2. Tap Send OTP. 3. Enter the 6-digit OTP received by SMS within 3 minutes. 4. Tap Verify. Expected result: the customer lands on the account dashboard, and the login is recorded in the activity log. Related negative cases: wrong OTP shows an error, and three wrong attempts lock login for 30 minutes.
32
Tell me about a time you had to learn a new analytics tool quickly for a project.
Situation: my team moved reporting from Excel to Power BI, and I had two weeks to rebuild the weekly sales report. Task: deliver it on time without errors. Action: I took a short online course, practised data modelling on a copy of our data, and asked a colleague to review my DAX measures. I reconciled every number with the old Excel report before launch. Result: the report went live on schedule, and refresh time dropped from half a day to minutes.
UAT is the final testing phase where real business users check that the system supports their work and meets requirements before go-live. The BA helps plan UAT, prepares business scenarios and test cases from requirements, arranges test data, supports users during testing, triages defects versus change requests and tracks sign-off. UAT is not about finding code bugs, which earlier testing should have caught.
35
What is the difference between ROW_NUMBER, RANK and DENSE_RANK?
All three number rows within a window ordered by a column. ROW_NUMBER gives a unique sequence 1, 2, 3 even for ties. RANK gives ties the same number and then skips, so 1, 1, 3. DENSE_RANK gives ties the same number without gaps, so 1, 1, 2. Use ROW_NUMBER to pick exactly one row per group, such as the latest order, and DENSE_RANK for 'top 3 distinct salary levels' type questions.
Working capital is current assets minus current liabilities, mainly receivables plus inventory minus payables. It is the money tied up in running daily operations. Too little means the company may struggle to pay suppliers and salaries; too much means cash is locked in slow inventory or unpaid customer invoices. Analysts track it because a growing business often needs more working capital, so fast growth can create cash shortages even when the business is profitable.
37
What is the difference between a chart and a dashboard?
Both measure short-term liquidity. The current ratio is current assets divided by current liabilities; around 1.5 to 2 is often comfortable, though it varies by industry. The quick ratio excludes inventory and prepaid items: (cash plus marketable securities plus receivables) divided by current liabilities. It is stricter because inventory may not sell quickly. A retailer with a current ratio of 1.8 but a quick ratio of 0.4 depends heavily on selling its stock to pay bills.
39
Write Given-When-Then acceptance criteria for applying a discount coupon at checkout.
Given a cart of 1,200 rupees and a valid coupon SAVE10 with a minimum order of 1,000 rupees, when the user applies it, then 10 percent is deducted and the new total is shown. Given an expired coupon, when applied, then the message 'This coupon has expired' appears and the total is unchanged. Given a cart below the minimum, when applied, then the user is told how much more to add.
Use MoSCoW (Must, Should, Could, Won't), value versus effort scoring or the Kano model, agreed with stakeholders based on business value and risk.
Frequently asked questions
What is asked in Business Analytics interviews for Freshers?
Interviews check fundamentals and learning ability rather than depth. Expect Excel formulas and PivotTables, basic SQL joins and aggregations, simple guesstimates, definitions like KPI, margin and user story, and a few behavioural questions about college projects or internships. Clear thinking aloud, structured answers and genuine curiosity about the business often matter more than tool knowledge.
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 Freshers?
Focus first on Excel lookups, SUMIFS and PivotTables, Basic SQL joins and GROUP BY, Guesstimate structure, Projects explained with STAR.