Skip to content

Business Analytics Interview Questions for Junior Roles (₹4–6 LPA)

40 questions with answers for junior roles — 25 easy, 15 medium.

What ₹4–6 LPA interviews expect

Strong basics with small practical tasks Tools and syntax used day to day Explaining your project work Learning ability and teamwork

About ₹4–6 LPA Business Analytics roles

Roles in the ₹4–6 LPA band are typically for junior roles. Interviewers check whether you can already do the work expected at this level, so questions here are weighted towards Requirements and Agile (7), Excel for Business Analysts (6), Product Analytics (5), Financial and Business Analysis (5).

Salary bands are indicative only. The same skills can pay differently across cities, company types and negotiation.

Solved in this bandStart 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

Write an Excel formula that labels sales as High (100000 or more), Medium (50000 or more) or Low.

Save to ▾
Show answer
=IFS(B2>=100000, "High", B2>=50000, "Medium", TRUE, "Low") // older Excel versions: =IF(B2>=100000, "High", IF(B2>=50000, "Medium", "Low"))
02

What is the difference between correlation and causation in product analytics?

Save to ▾
Show answer
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.
03

Write a SQL query to find the second-highest salary in an employees table.

Save to ▾
Show answer
SELECT MAX(salary) AS second_highest FROM employees WHERE salary < (SELECT MAX(salary) FROM employees); -- or with a window function SELECT DISTINCT salary FROM ( SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS rk FROM employees ) t WHERE rk = 2;
04

What is the difference between accrual accounting and cash accounting?

Save to ▾
Show answer
Under accrual accounting, revenue is recorded when it is earned and expenses when they are incurred, regardless of when cash moves. Under cash accounting, transactions are recorded only when cash is received or paid. Companies in India report under accrual-based standards (Ind AS). Example: an annual software contract billed in April is recognised as revenue month by month over 12 months under accrual, even though all the cash came in April.
05

How do you create a dashboard in Excel?

Save to ▾
Show answer
Prepare clean data, build PivotTables and PivotCharts, add KPI cards and slicers, and arrange everything on one sheet with a clear layout.
06

Write an Excel formula to calculate the monthly EMI for a loan of 10 lakh rupees at 9 percent annual interest for 5 years.

Save to ▾
Show answer
=PMT(9%/12, 5*12, -1000000) # Returns about 20,758 rupees per month. # rate = annual rate / 12, nper = total months, # pv entered as negative so the EMI shows as positive. # Total interest = EMI * 60 - 1000000.
07

Tell me about a time you had to learn a new analytics tool quickly for a project.

Save to ▾
Show answer
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.
08

What is the difference between a test scenario and a test case?

Save to ▾
Show answer
A test scenario is a high-level statement of what to test, usually derived from a business process or user story, such as Customer applies a discount coupon at checkout. A test case is a detailed, executable set of steps with preconditions, test data, expected result and actual result, such as applying an expired coupon to a 1,000 rupee cart shows an expiry message. One scenario usually produces several test cases covering positive, negative and edge conditions.
09

What is a Minimum Viable Product (MVP)?

Save to ▾
Show answer
The smallest version of a product with enough features to deliver value and gather real user feedback before investing more.
10

What are DAU, WAU and MAU, and what is the stickiness ratio?

Save to ▾
Show answer
DAU, WAU and MAU count unique users active in a day, week and month, where 'active' must be clearly defined, such as completing a core action. The stickiness ratio is DAU divided by MAU and shows how often monthly users return. A ratio of 0.5 means the average monthly user is active about 15 days a month. Daily-use products like messaging aim high, while a travel app naturally has low stickiness.
11

What is an impact-effort matrix and how do you use it to prioritise recommendations in a case?

Save to ▾
Show answer
An impact-effort matrix is a 2x2 grid that plots options by expected business impact against effort, cost or time. High impact and low effort are quick wins to do first; high impact and high effort are major projects to plan; low impact and low effort are fill-ins; low impact and high effort should be dropped. In a case interview, it helps you end with a clear, prioritised recommendation rather than a long list of ideas.
12

UAT starts tomorrow, but the business has not nominated any testers. What do you do?

Save to ▾
Show answer
Escalate immediately to the business sponsor with the impact: each day without testers delays sign-off and go-live. Ask for named testers with protected time, even part-time. Meanwhile, prepare so no time is lost: finalise test cases, check the environment and data, and plan a short tester briefing. If testers cannot be released, propose re-planning UAT dates rather than letting IT or the BA test on the business's behalf, because acceptance must come from the users.
13

What is the difference between absolute, relative and mixed cell references in Excel?

Save to ▾
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.
14

You added new rows to the source data, but your PivotTable does not show them even after refresh. Why?

Save to ▾
Show answer
The PivotTable source is probably a fixed range such as A1:F500, so rows added below 500 are outside it. The fix is to convert the data to an Excel Table with Ctrl+T and change the pivot's data source to the table name, so it expands automatically. Also check for blank header cells, filters on the pivot hiding new items, and whether the new rows are actually text values in a numeric column, which can change grouping.
15

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

How is a product owner's role different from a business analyst's role?

Save to ▾
Show answer
The product owner owns the product vision and the backlog order, makes final priority decisions and accepts completed work on behalf of the business. The business analyst works on understanding problems in depth: eliciting and analysing requirements, modelling processes and data, writing detailed stories and acceptance criteria and supporting the team and testers. In smaller teams one person may do both, but the PO decides what, while the BA clarifies how it should work.
17

What is Kano model in prioritisation?

Save to ▾
Show answer
A model classifying features as basic, performance or delight attributes based on how they affect customer satisfaction, helping decide what to build first.
18

Tell me about a time poor or outdated documentation caused a problem. How did you fix it?

Save to ▾
Show answer
Situation: a new developer built a GST calculation from an old FRD version, and the error was caught only in UAT. Task: fix the defect and prevent repeats. Action: I moved all requirement documents into one shared space with version history, added a change log and status labels such as draft or approved, and linked each user story to the latest approved section. Result: in the next two releases we had no defects caused by outdated specifications.
19

What does a Business Analyst do?

Save to ▾
Show answer
A BA bridges business and technology: gathers requirements, analyses data and processes, documents BRD/FRD and makes sure the final solution actually solves the business problem.
20

What is the difference between a calculated column and a measure in Power BI?

Save to ▾
Show answer
A calculated column is computed row by row at refresh time and stored in the model, so it uses memory and can be used in slicers, rows and relationships. A measure is computed at query time based on the current filters, so it is not stored and responds to slicers. Use a column for attributes such as an age band, and a measure for aggregations such as Total Sales or Margin %.
21

What is gap analysis?

Save to ▾
Show answer
Compare the current state (as-is) with the desired state (to-be), list the gaps in process, people or technology, and plan actions to close them.
22

A hospital chain's average patient waiting time has risen from 30 to 50 minutes. How would you approach the case?

Save to ▾
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.
23

What is User Acceptance Testing (UAT) and what is the BA's role in it?

Save to ▾
Show answer
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.
24

A stakeholder keeps skipping review meetings and then rejects the deliverable at the end. How do you prevent this?

Save to ▾
Show answer
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.
25

Control has 10,000 users with 400 purchases and the variant has 10,000 users with 460 purchases. Calculate the lift.

Save to ▾
Show answer
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.
26

What is a star schema and why do BI tools prefer it?

Save to ▾
Show answer
A star schema has one central fact table holding numeric events (sales, orders) linked to surrounding dimension tables (date, product, customer, region). BI tools prefer it because filters flow cleanly from dimensions to facts, DAX and Tableau calculations stay simple, and compression and query performance improve. A flat single table repeats text values and gets slow, while a snowflake with many chained lookups makes filtering and maintenance harder.
27

What is Power Query and what is it used for?

Save to ▾
Show answer
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.
28

What are aggregate functions?

Save to ▾
Show answer
Functions that summarise rows into a value, such as COUNT, SUM, AVG, MIN and MAX.
29

What are process levels such as L0 to L4 in a process architecture?

Save to ▾
Show answer
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.
30

How do you approach a guesstimate question?

Save to ▾
Show answer
Clarify the scope, break the problem into logical parts, state assumptions with round numbers, compute step by step and sanity-check the answer.
31

Revenue is 50 crore, cost of goods sold 30 crore, operating expenses 12 crore and depreciation 2 crore. Calculate EBITDA and EBITDA margin.

Save to ▾
Show answer
Operating expenses here exclude depreciation. Gross profit is 50 - 30 = 20 crore. EBITDA is gross profit minus operating expenses: 20 - 12 = 8 crore. EBITDA margin is 8 / 50 = 16 percent. EBIT is EBITDA minus depreciation, 8 - 2 = 6 crore, which is a 12 percent operating margin. In an interview, state your assumption about whether operating expenses include depreciation, because that changes the answer.
32

What are the current ratio and the quick ratio?

Save to ▾
Show answer
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.
33

What does expectation management mean for a business analyst?

Save to ▾
Show answer
It means making sure stakeholders know realistically what will be delivered, when, and with what limits, before they form their own assumptions. A BA confirms scope in writing, states assumptions and dependencies, shares estimates with ranges, and flags risks early. When something changes, they update stakeholders immediately with options. Most stakeholder conflict comes from surprises, not from bad news itself.
34

What is the debt-to-equity ratio and how do you interpret it?

Save to ▾
Show answer
Debt-to-equity equals total borrowings divided by shareholders' equity. It shows how much the company relies on borrowed money versus owners' funds. A ratio of 0.5 means 50 paise of debt for every rupee of equity. Higher leverage can boost returns but raises interest burden and risk in downturns. Acceptable levels depend on the industry: utilities and infrastructure carry more debt than software firms. Always read it with interest coverage, which is EBIT divided by interest expense.
35

What sections does a good software requirements specification (SRS) contain?

Save to ▾
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.
36

How do you build a forecast in Excel?

Save to ▾
Show answer
Use historical data with FORECAST.ETS or trend lines, state assumptions, compare against actuals and show best, base and worst scenarios.
37

What are heatmaps and session recordings, and when would you use them alongside funnel analysis?

Save to ▾
Show answer
Heatmaps aggregate where users click, move and scroll on a page, while session recordings replay individual user sessions. Funnel analysis tells you where users drop off, for example 40 percent leave on the address page; heatmaps and recordings help explain why, such as a hidden Continue button or a confusing pin code field. They are qualitative, so use them to form hypotheses and then validate fixes with an A/B test. Personal data must be masked in recordings.
38

Agile vs Waterfall?

Save to ▾
Show answer
Waterfall runs fixed phases one after another with requirements frozen early. Agile delivers in short sprints with continuous feedback, so requirements can change. In Agile, BAs maintain the backlog and user stories.
39

What is a power-interest grid and how do you use it?

Save to ▾
Show answer
A power-interest grid maps stakeholders by how much influence they have over the project and how interested or affected they are. High power and high interest: manage closely with regular involvement. High power, low interest: keep satisfied with concise updates. Low power, high interest: keep informed, for example end users. Low power, low interest: monitor. It helps a BA decide who to consult, how often and in what format.
40

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.

Frequently asked questions

What do Business Analytics interviews for ₹4–6 LPA roles test?

At ₹4–6 LPA the focus is usually on: strong basics with small practical tasks, tools and syntax used day to day, explaining your project work, learning ability and teamwork. This page's set is weighted towards Requirements and Agile (7), Excel for Business Analysts (6), Product Analytics (5), Financial and Business Analysis (5).

Which companies pay ₹4–6 LPA for Business Analytics roles?

Pay depends on company type, city, skills and negotiation, not only experience. Use the company-wise pages to practise for the specific employers you are targeting, and treat salary bands as a rough guide.

How should I prepare for a ₹4–6 LPA Business Analytics interview?

Solve every question here without looking at the answer first, mark the ones you miss, save them to Last-Minute Revision and revise them the night before. Prepare two project stories that show impact at the level expected for ₹4–6 LPA.