Business Analytics Managerial Round Questions &amp; Answers

Show answer

Situation: a regional manager wanted a custom report changed daily, which would have taken half my week. Task: support him without blocking other priorities. Action: I asked which decisions the report fed and found he needed only four numbers. I said no to the custom version, explained the impact on other work, and added those four metrics with a filter to the existing dashboard. Result: he got his numbers the same day and the team kept its capacity.

An online learning platform finds that only 12 percent of learners complete paid courses. How do you analyse it?

Show answer

Define completion and see where learners drop: first week, a specific module or before assessments. Segment by course, length, learner background, device and acquisition channel. Look at causes in content difficulty, video length, lack of deadlines, mentor support and job relevance. Recommend tests such as shorter modules, cohort-based deadlines, progress nudges and live doubt sessions, and measure completion and referral impact.

Tell me about a dashboard you built that changed a business decision.

Power BI and TableauMedium

Show answer

Situation: regional sales heads reviewed discount spend only at month end. Task: I was asked to give weekly visibility. Action: I built a Power BI report linking discounts to margin by product and region, with a drill-through to deal level and an alert when margin fell below target. Result: the team spotted two regions giving deep discounts on low-margin items, tightened approval rules, and margin improved by about two points the next quarter.

Tell me about a time you worked with stakeholders in a different time zone or culture.

Show answer

Situation: I worked on a reporting project where the business owners were in the UK and the development team was in Pune. Task: gather and confirm requirements without long delays. Action: I fixed a daily 30-minute overlap call, sent written summaries with decisions and open questions after each meeting, and used recorded walkthroughs of prototypes. I also learned that the UK team preferred direct written feedback. Result: we closed requirements in three weeks instead of the planned five.

What is the Ansoff matrix and how is it used in growth cases?

Show answer

The Ansoff matrix maps four growth strategies by product and market. Market penetration sells existing products to existing markets, the lowest risk. Product development offers new products to existing customers. Market development takes existing products to new markets, such as new cities. Diversification launches new products in new markets, the highest risk. In a growth case it structures the options before you evaluate each one's size, cost and fit.

A query using NOT IN to find customers without orders returns zero rows, although you know such customers exist. Why?

SQL for Business AnalysisHard

Show answer

The subquery probably returns at least one NULL, for example SELECT customer_id FROM orders where some orders have a NULL customer_id. With NOT IN, comparing any value to NULL gives UNKNOWN, so no row passes the condition. Fix it by using NOT EXISTS with a correlated subquery, or a LEFT JOIN with WHERE o.customer_id IS NULL, or by adding WHERE customer_id IS NOT NULL inside the subquery. NOT EXISTS is the safest habit.

Three departments describe the same order process in three different ways during workshops. How do you arrive at the true AS-IS?

Process Modelling and BPMNMedium

Show answer

Treat each version as a hypothesis. Walk the process physically or observe real cases end to end, and pull a sample of 20 to 30 recent orders from the system to trace what actually happened. Compare timestamps and status changes with each department's story. Then hold a joint session, show the evidence-based map and mark the variants openly. Often all three are partly right because different order types follow different paths, which should be modelled explicitly.

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.

What are UAT entry and exit criteria? Give examples.

UAT and BA DocumentationMedium

Show answer

Entry criteria are conditions that must be met before UAT starts, for example system and integration testing completed, no open critical defects, UAT environment and test data ready, test cases reviewed and testers trained. Exit criteria define when UAT is complete, for example 100 percent of critical test cases executed, at least 95 percent passed, no open critical or high defects, and workarounds agreed for remaining medium ones. Clear criteria stop arguments about readiness near go-live.

What is Excel Solver and give a business example of using it.

Excel for Business AnalystsHard

Show answer

Solver is an optimisation add-in that finds the best value of a target cell by changing decision cells within constraints. Unlike Goal Seek, it handles many variables and constraints. Example: choose how many units of three products to make to maximise profit, subject to machine hours, raw material and minimum order limits. You set the objective, the variable cells, constraints and a method such as Simplex LP for linear problems.

A bank wants to reduce customer churn. What would you do?

Show answer

Define churn, analyse who leaves and why, segment customers, find drivers through data and surveys, design retention offers and measure uplift with a control group.

You must gather requirements to replace a 15-year-old legacy system with no documentation. How do you approach it?

Requirements and AgileHard

Show answer

Combine several sources. Interview and observe users doing real tasks, and review screens, reports and outputs to infer business rules. Analyse the database and logs to see which data and functions are actually used. Work with long-serving staff and IT support for hidden rules and workarounds. Build AS-IS process maps, decide what to keep, drop or improve, and validate the findings with users. Plan data migration requirements early.

Revenue grew but profit fell. Why could that happen?

Show answer

Look at the cost side: heavier discounts, higher CAC, logistics costs, product mix shifting to low-margin items, one-time expenses or pricing changes. Break contribution margin down by segment.

Should a supermarket chain launch its own private-label products?

Show answer

Evaluate attractiveness and ability. Attractiveness: private labels usually earn higher margins, so check category size, how price-sensitive customers are, and whether brand loyalty is weak in categories like staples and cleaning. Ability: supplier availability, quality control, shelf space and brand trust. Estimate the margin gain against cannibalisation of branded sales and supplier relationships. Recommend starting with a few high-volume, low-loyalty categories and measuring repeat purchase.

How do you influence stakeholders when you have no direct authority?

Stakeholder CommunicationHard

Show answer

Build credibility with accurate work and by understanding each stakeholder's goals and pressures. Frame proposals in terms of their outcomes, such as cost saved or targets met, and back them with data. Involve them early so ideas feel shared, find allies who already support the change, and pilot small to show results. Be transparent about trade-offs. Influence comes from trust built over time, not one meeting.

A critical defect is found on the last day of UAT, and the go-live date cannot move. What do you do?

UAT and BA DocumentationHard

Show answer

Confirm the impact and reproduce it quickly. Work with development to estimate a fix and its regression effort. Then present options to the business owner with risks: fix and do targeted retesting before go-live, go live with a temporary workaround or manual process, go live with the affected feature switched off, or delay. The decision belongs to the business, documented at the go or no-go meeting. Never hide a critical defect to protect a date.

What are MRR and ARR, and how do you calculate net revenue retention?

Business Metrics and KPIsHard

Show answer

MRR is monthly recurring revenue from active subscriptions; ARR is the annualised figure, usually MRR times 12. Net revenue retention measures revenue kept from an existing customer cohort over 12 months: (starting MRR + expansion - contraction - churned MRR) / starting MRR. Example: 100 lakh start, plus 15 expansion, minus 5 contraction, minus 8 churn gives 102 percent. Above 100 percent means existing customers grow revenue even without new sales.

A Tableau dashboard on a 50 million row data source responds slowly to filters. How do you fix it?

Power BI and TableauHard

Show answer

Use an extract with only the needed columns and rows, aggregated to the visible grain where possible. Replace quick filters showing all values with fewer filters, use context filters wisely and avoid 'only relevant values' on large fields. Move complex calculations into the data source, reduce marks per view and the number of sheets per dashboard. Use the Performance Recorder to find the slowest queries and fix those first.

Marketing and product teams define 'active user' differently and report conflicting numbers. How do you fix this?

Business Metrics and KPIsHard

Show answer

Bring both teams together and list each definition, its purpose and its numbers. Agree on one company-wide definition tied to real value, such as a user who completed a core action in the last 7 days, and allow clearly named secondary metrics like 'visitors' for marketing. Assign an owner, document it in a metric glossary, implement it once in the warehouse or semantic model, and retire the duplicate dashboards.

How do you manage conflicting requirements from two senior stakeholders?

Stakeholder CommunicationHard

Show answer

Clarify the underlying goals, present data and trade-offs, facilitate a joint session, escalate to the sponsor if needed and document the agreed decision.

Tell me about an experiment that failed and what you learned.

Product AnalyticsHard

Show answer

Situation: we tested a simplified pricing page expecting higher paid conversion. Task: I owned the experiment design and analysis. Action: after two weeks the variant showed no significant change, and segment checks revealed that heavy users missed the plan comparison table. I documented the result and shared it openly rather than searching for a winning segment. Result: the next version kept the simple layout with an optional comparison, and we learned to interview users before testing.

Should a food-delivery app launch in a new city?

Show answer

Check market size (population, online ordering share), competition, restaurant supply, unit economics per order, CAC and payback period. Propose a pilot with clear success metrics.

Five departments each build their own Power BI reports with different revenue numbers. How would you design a better BI setup?

Power BI and TableauHard

Show answer

Create a shared, certified semantic model with one definition per KPI, built on a governed warehouse layer. Departments build thin reports on top of it through live connection instead of copying data. Set up workspaces by environment (dev, test, prod), deployment pipelines, naming standards, a KPI glossary and owners for each measure. Keep a small central team for the core model and let departments self-serve on top, which balances control and speed.

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.

How can LET and LAMBDA make complex Excel formulas easier to maintain? Give an example.

Excel for Business AnalystsHard

Show answer

// LET names intermediate values so they are calculated once =LET(rev, SUM(C2:C100), cost, SUM(D2:D100), IF(rev=0, 0, (rev - cost) / rev)) // LAMBDA saved in Name Manager as MARGIN =LAMBDA(rev, cost, IF(rev=0, 0, (rev - cost) / rev)) // then use =MARGIN(C2, D2) anywhere in the workbook

Explain exclusive, parallel and inclusive gateways in BPMN.

Process Modelling and BPMNMedium

Show answer

An exclusive gateway (diamond with X) sends the flow down exactly one path based on a condition, for example approved or rejected. A parallel gateway (diamond with +) splits into all paths at once and, when joining, waits for every path to finish. An inclusive gateway (diamond with O) activates one or more paths whose conditions are true and joins only those that were activated. Choosing the wrong one causes deadlocks or duplicated work in automated processes.

The CFO asks whether the company should lease or buy 50 delivery vans. How do you approach the analysis?

Financial and Business AnalysisHard

Show answer

Build a discounted cash flow comparison over the vehicle life. For buying: purchase price, financing cost, maintenance, insurance, tax benefit of depreciation, and resale value. For leasing: lease rentals, what maintenance is included, tax treatment and end-of-term conditions. Discount both at the company's cost of borrowing and compare present value of costs. Then add qualitative factors: flexibility if volumes drop, technology risk such as a shift to electric vans, and impact on the balance sheet.

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.

What is a RACI matrix?