01
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.
Business Analytics Telephonic Interview Questions & Answers
30 questions for the telephonic interview stage — 13 easy, 17 medium.
About the telephonic interview round
The telephonic or screening round is a 15-30 minute call with a recruiter or engineer. It checks your basics, your CV and whether you can explain Business Analytics concepts clearly without a screen to point at.
Tips for the telephonic interview round
- Keep your CV in front of you and be ready to explain every line on it.
- Answer in short, clear sentences; there is no whiteboard, so structure matters.
- Take the call somewhere quiet and confirm the time in advance.
- Prepare one question to ask the interviewer at the end.
Solved — telephonic interviewStart 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
What is a use case diagram?
Show answer
A UML diagram showing actors and the actions (use cases) they perform with the system, giving a quick view of scope.
03
Control has 10,000 users with 400 purchases and the variant has 10,000 users with 460 purchases. Calculate the lift.
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.
04
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.
05
What is BPMN and why do business analysts use it?
Show answer
BPMN (Business Process Model and Notation) is a standard graphical notation, maintained by the OMG, for drawing business processes. Business analysts use it because business users, developers and process owners can all read the same diagram. It shows who does what, in which order, with which decisions and messages. A BPMN 2.0 model can also be executed by workflow engines, so the same diagram can move from analysis to automation with less rework.
06
Managers want to click a region on a summary report page and jump to a detail page for only that region. How do you build it in Power BI?
Show answer
Use drill-through. Create a detail page, add the Region field to the page's drill-through filter well, and design visuals for orders, products and trends. Power BI adds a back button automatically. On the summary page, users right-click a region and choose Drill through. Keep all filters on so date selections carry over. For guided navigation, you can also add buttons with bookmarks, but drill-through is the cleanest way to pass the selected region.
07
What is the debt-to-equity ratio and how do you interpret it?
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.
08
What is user activation and what is an 'aha moment'?
Show answer
Activation is the point at which a new user first experiences the product's core value, such as completing a first lesson, sending a first payment or creating a first project. The aha moment is the specific early action that strongly predicts long-term retention, found by comparing retained and churned users. Teams then design onboarding to get more new users to that action quickly and track the activation rate.
09
What does GROUP BY do and how is HAVING different from WHERE?
Show answer
GROUP BY aggregates rows by column; WHERE filters before grouping and HAVING filters after, using aggregate conditions.
10
What is the difference between a pool and a lane in BPMN?
Show answer
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.
11
What is EBITDA and why is it widely used?
Show answer
EBITDA is earnings before interest, taxes, depreciation and amortisation. It approximates operating profit generated by the core business before financing choices, tax rules and non-cash accounting charges. It is useful for comparing companies with different debt levels or asset ages and is used in valuation multiples such as EV/EBITDA. Its weakness is that it ignores capital expenditure and working capital needs, so a company can show strong EBITDA and still burn cash.
12
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.
13
What does a Business Analyst do?
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.
14
What is a self join? Give a business example.
Show answer
A self join joins a table to itself using two aliases, so you can compare rows within the same table. A classic business example is an employees table with a manager_id column: joining employees e to employees m on e.manager_id = m.employee_id lists each employee with their manager's name. Another example is finding customers who placed two orders on the same day by joining orders to orders on customer_id and date with different order IDs.
15
What is an event tracking plan and why does it matter?
Show answer
A tracking plan is a document listing every event the product should log, such as 'checkout_started', with its trigger, properties like price, plan or source, naming rules and owner. It keeps data consistent across web, Android and iOS, prevents duplicate or vague events and makes analysis trustworthy. Without one, teams end up with events like 'click1' and 'buttonClick' meaning the same thing, and analysis becomes guesswork.
16
What is the difference between a report and a dashboard in Power BI Service?
Show answer
A report is a multi-page, interactive view built in Power BI Desktop from one semantic model, with slicers, drill-through and cross-filtering. A dashboard is a single-page canvas in the Service made of tiles pinned from one or more reports, and is meant for monitoring key numbers at a glance. Dashboards support data alerts on card and KPI tiles, but have limited interactivity; clicking a tile opens the underlying report for detailed exploration.
17
How do you chart a trend with a target line?
Show answer
Create a line or column chart of actuals and add the target as another series formatted as a line.
18
What are acceptance criteria?
Show answer
Clear, testable conditions a story must meet to be accepted, often written as Given-When-Then scenarios.
19
Describe how you would model an employee leave approval process in BPMN.
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.
20
Inventory days rose from 45 to 70 over two quarters. What could be the causes and what would you recommend?
Show answer
Possible causes include falling sales against unchanged purchasing, poor demand forecasts, bulk buying for discounts, slow-moving or obsolete SKUs, or deliberate stock-building ahead of a festive season or expected price rise. Analyse by SKU, warehouse and age bucket to find where stock is stuck. Recommend clearing aged items, adjusting reorder points using recent demand, and reviewing supplier minimum order quantities. Also quantify the cash locked up and the carrying cost to show urgency.
21
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.
22
Describe a time you explained a complex technical topic to a non-technical audience.
Show answer
Situation: operations managers did not trust a new demand forecast that drove staffing. Task: explain it so they would use it. Action: I avoided model terms and showed how it used last year's same week, recent trend and festival calendar, with a chart of past forecasts against actuals. I compared the forecast range to a weather forecast. Result: managers started using it for rosters and gave feedback that improved it further.
23
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.
24
What is a CTE?
Show answer
A named temporary result introduced with WITH that makes long queries readable and reusable in the same statement.
25
How is a product owner's role different from a business analyst's role?
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.
26
Split the epic 'Customers can track their order online' into user stories.
Show answer
Possible stories: As a customer, I want to see my order status (placed, packed, shipped, delivered) so that I know its progress. As a customer, I want an SMS or email when the status changes so that I do not have to check. As a customer, I want the expected delivery date so that I can plan. As a customer, I want a courier tracking link once shipped. As support staff, I want to see the same timeline so that I can answer queries.
27
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.
28
Guesstimate: how many pizzas are sold in Mumbai on a weekend?
Show answer
About 20 million people, roughly 10% order pizza on a weekend, about 1 pizza per 2 people in an order. This gives roughly 1 million pizzas, adjusted for outlets and delivery capacity.
29
Tell me about a time you had to learn a new analytics tool quickly for a project.
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.
30
How do you calculate the percentage contribution of each category?
Show answer
SUM(sales) per category divided by SUM(SUM(sales)) OVER () and multiplied by 100 gives each category's share of the total.
Frequently asked questions
What happens in the Business Analytics telephonic interview round?
The telephonic or screening round is a 15-30 minute call with a recruiter or engineer. It checks your basics, your CV and whether you can explain Business Analytics concepts clearly without a screen to point at.
How do I clear the telephonic interview round?
Keep your CV in front of you and be ready to explain every line on it. Answer in short, clear sentences; there is no whiteboard, so structure matters. Take the call somewhere quiet and confirm the time in advance.
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