01
KPI vs metric?
Show answer
Every KPI is a metric, but a KPI is tied directly to a strategic goal (e.g. monthly churn). A metric can be any measurement (e.g. page views).
Business Analytics Rapid-Fire Questions & Answers
50 questions for the rapid-fire stage — 35 easy, 15 medium.
About the rapid-fire round
Rapid-fire questions are quick definitions and one-line answers that interviewers fire at the start or end of a round to check your Business Analytics basics. Aim to answer each in under 20 seconds.
Tips for the rapid-fire round
- Answer in one or two sentences, then stop.
- If you don't know, say so quickly and move on; don't guess at length.
- Revise these the morning of the interview.
- Practise with a friend who reads them in random order.
Solved — rapid-fireStart 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
Which chart would you choose for trend, part-to-whole, comparison and distribution?
Show answer
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.
03
Which Excel functions do business analysts use daily?
Show answer
VLOOKUP or XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF, text functions, PivotTables and charts.
04
What is ARPU and how is it calculated?
Show answer
ARPU, Average Revenue Per User, is total revenue in a period divided by the average number of users in that period. If a telecom-style app earns 50 lakh in a month from 25,000 average users, ARPU is 200 rupees. It is tracked to see whether growth comes from more users or more value per user. ARPPU, revenue per paying user, is used when only some users pay.
05
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.
06
What is the difference between revenue and profit?
Show answer
Revenue is total money from sales; profit is what remains after subtracting all costs and expenses.
07
What is SQL and why do business analysts need it?
Show answer
A language for querying databases. BAs use it to pull data themselves, validate numbers, check reports and answer questions without waiting for engineers.
08
What is conditional formatting and how would you use it in a business report?
Show answer
Conditional formatting changes a cell's look based on rules or formulas. In reports you can highlight targets missed in red, use data bars for sales size, colour scales for a region heatmap, icon sets for trend direction, or a formula rule like =$E2<$F2 to colour an entire row. Use it sparingly and with a legend so the eye goes only to the exceptions that need action.
09
What is the difference between a calculated column and a measure in Power BI?
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 %.
10
What is Agile and how does Scrum work?
Show answer
Agile delivers value in small increments with feedback. Scrum organises work in sprints with planning, daily stand-ups, review and retrospective, led by a Scrum Master and Product Owner.
11
What is the difference between churn rate and retention rate?
Show answer
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.
12
What is scope creep and how do you control it?
Show answer
Uncontrolled growth of requirements. Control it with a clear scope statement, change control process, impact analysis and sponsor approval for additions.
13
Difference between INNER JOIN and LEFT JOIN?
Show answer
INNER returns only matching rows; LEFT returns all rows from the left table and NULLs where there is no match.
14
XLOOKUP vs VLOOKUP?
Show answer
XLOOKUP can look left or right, uses exact match by default, returns a custom value if nothing is found and doesn't break when columns move. VLOOKUP only looks right and needs a column number.
15
What is the difference between SQL and Excel for analysis?
Show answer
Excel suits small to medium data and quick ad-hoc work; SQL queries large databases directly and repeatably.
16
How do you handle large datasets in Excel?
Show answer
Use tables, Power Query, remove volatile functions, filter before calculating and move to Power Pivot or a database when rows reach the millions.
17
What is the time value of money?
Show answer
The time value of money means a rupee today is worth more than a rupee in the future, because today's rupee can be invested to earn a return and future money carries inflation and risk. Future cash is converted to present value using PV = FV / (1 + r)^n. At a 10 percent discount rate, 1,10,000 rupees received after one year is worth 1,00,000 rupees today. It is the basis of NPV, IRR, loan EMIs and valuation.
18
What is the use of the IFERROR function?
Show answer
It returns a custom value when a formula errors out, keeping reports clean, for example =IFERROR(VLOOKUP(...), "Not found").
19
What is the hierarchy of epic, feature and user story in Agile?
Show answer
An epic is a large body of work that delivers a major business goal and spans several sprints, such as 'Online loan application'. It is broken into features or capabilities, such as 'Document upload'. Each feature is split into user stories small enough to finish in one sprint, such as 'As an applicant, I want to upload my PAN card photo so that I do not need to visit a branch'.
20
Use case vs user story?
Show answer
A use case describes the full interaction between an actor and the system (main and alternate flows). A user story is a short statement of need from the user's point of view, refined with acceptance criteria.
21
What is a date table in Power BI and why should you mark it as a date table?
Show answer
A date table has one row per day with no gaps, plus columns like Year, Quarter, Month, Week and Fiscal Period. It is related to the fact table date column. Marking it as a date table tells Power BI to use it for time intelligence functions like TOTALYTD, SAMEPERIODLASTYEAR and DATESINPERIOD, which require a continuous date range. It also gives consistent month sorting and fiscal calendars across every report.
22
What is funnel analysis?
Show answer
Funnel analysis measures how many users move through a sequence of steps towards a goal, such as visit, product view, add to cart, checkout and payment, and the conversion and drop-off at each step. It shows where the biggest leak is so the team can focus fixes there. Break funnels down by device, channel and new versus returning users, and define a time window for completing the steps.
23
What is A/B testing?
Show answer
A/B testing is a controlled experiment where users are randomly split into a control group that sees the current version and a treatment group that sees a change, such as a new checkout button. You compare a pre-decided primary metric, like conversion rate, between groups. Because assignment is random, a significant difference can be attributed to the change rather than to seasonality, marketing or user mix.
24
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.
25
What is the difference between a Tableau extract and a live connection?
Show answer
A live connection queries the source database every time the view changes, so data is current but speed depends on the database. An extract (.hyper file) is a compressed snapshot stored by Tableau that is fast to query and can be refreshed on a schedule, but it is only as fresh as the last refresh. Extracts suit large, slow or remote sources; live suits fast warehouses and real-time needs.
26
What is Net Promoter Score (NPS) and what are its limitations?
Show answer
NPS asks customers how likely they are to recommend you on a 0 to 10 scale. Scores of 9 to 10 are promoters, 7 to 8 passives and 0 to 6 detractors. NPS equals percent promoters minus percent detractors, ranging from minus 100 to plus 100. Limitations: it is one question, sensitive to survey timing and sample bias, and does not explain why. Pair it with open-text reasons and behavioural metrics like retention.
27
What is cohort analysis and why is it useful?
Show answer
Cohort analysis groups users by a shared starting point, usually their sign-up or first purchase month, and tracks their behaviour over time, such as the percentage still active in month 1, 2 and 3. It separates the effect of growth from the effect of retention, so you can see whether newer cohorts retain better after a product change. It is typically shown as a triangle table or retention curves.
28
What is gap analysis?
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.
29
What are aggregate functions?
Show answer
Functions that summarise rows into a value, such as COUNT, SUM, AVG, MIN and MAX.
30
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.
31
What is a Minimum Viable Product (MVP)?
Show answer
The smallest version of a product with enough features to deliver value and gather real user feedback before investing more.
32
What are DAU, WAU and MAU, and what is the stickiness ratio?
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.
33
What is a feasibility study?
Show answer
An early assessment of whether a proposed solution is technically, economically, operationally and legally viable before committing budget.
34
What are wireframes and why are they useful for a BA?
Show answer
Low-fidelity layouts of screens that help stakeholders visualise and agree on requirements before development starts.
35
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.
36
How do you adapt your communication for executives versus technical teams?
Show answer
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.
37
What is a KPI and give examples for an e-commerce business?
Show answer
A measurable value showing progress to a goal, such as conversion rate, average order value, cart abandonment rate and customer retention.
38
Explain Porter's Five Forces.
Show answer
A model assessing industry attractiveness through supplier power, buyer power, threat of new entrants, threat of substitutes and rivalry among competitors.
39
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.
40
How do you evaluate a marketing campaign's ROI?
Show answer
ROI = (incremental profit - campaign cost) / campaign cost. Measure incremental sales using a control group or before-after comparison.
41
What is a stakeholder and who are the typical stakeholders in a project?
Show answer
Anyone affected by or influencing the project: sponsors, product owners, end users, developers, testers, operations and customers.
42
What is the difference between COUNT(*) and COUNT(column)?
Show answer
COUNT(*) counts all rows; COUNT(column) counts only rows where that column is not NULL.
43
What do interviewers evaluate in a business case interview?
Show answer
They assess how you think, not just the final answer. Key areas are clarifying the problem before solving, building a clear and MECE structure, handling numbers accurately with sanity checks, using business sense to prioritise, adapting to new information, and ending with a crisp recommendation with risks and next steps. Thinking aloud and communicating clearly matter as much as getting the right number.
44
What is the difference between Power BI Desktop, Power BI Service and Power BI Mobile?
Show answer
Power BI Desktop is the free Windows app where you connect to data, model it, write DAX and design reports. Power BI Service is the cloud portal where you publish reports, schedule refresh, build dashboards, set permissions and share with users. Power BI Mobile is the phone app for viewing reports on the go. A typical flow is build in Desktop, publish to a Service workspace, and consume on web or mobile.
45
What is row-level security in Power BI and how do you set it up?
Show answer
Row-level security restricts which rows a user can see in the same report. In Desktop you create roles under Manage Roles with a DAX filter, such as 'Region'[Manager Email] = USERPRINCIPALNAME() for dynamic RLS. You test with View as Role, publish, and then map users or groups to roles in the Service. Dynamic RLS with a mapping table scales better than creating one static role per region.
46
Do a quick SWOT analysis for an ed-tech company.
Show answer
Strengths and Weaknesses are internal; Opportunities and Threats are external. Example: S = strong faculty, W = low brand awareness, O = AI upskilling demand, T = free online content.
47
What is the difference between ROW_NUMBER, RANK and DENSE_RANK?
Show answer
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.
48
What is the difference between UNION and UNION ALL?
Show answer
Both stack the results of two queries with the same number and type of columns. UNION removes duplicate rows, which needs a sort or hash step and is slower. UNION ALL keeps every row and is faster. Use UNION ALL when combining data such as online and store sales where duplicates are genuine or impossible, and UNION only when you specifically need a distinct list, such as unique customer IDs from two sources.
49
How do you approach a guesstimate question?
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.
50
What is a foreign key and what is referential integrity?
Show answer
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.
Frequently asked questions
What happens in the Business Analytics rapid-fire round?
Rapid-fire questions are quick definitions and one-line answers that interviewers fire at the start or end of a round to check your Business Analytics basics. Aim to answer each in under 20 seconds.
How do I clear the rapid-fire round?
Answer in one or two sentences, then stop. If you don't know, say so quickly and move on; don't guess at length. Revise these the morning of the interview.
Which round comes next?
A typical order is online assessment, telephonic screening, one or two technical rounds, a managerial round and HR. Use the other round pages to practise each stage.
Practise every interview round
More 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