Business Analytics Interview Questions in Pune

Show answer

SUMIFS is faster and easier for sums with AND conditions on ranges. SUMPRODUCT multiplies arrays and sums the result, so it handles cases SUMIFS cannot: weighted totals like price times quantity, OR logic, conditions on calculated values such as MONTH(date)=4, or comparing two columns row by row. On very large sheets SUMPRODUCT is slower, so prefer SUMIFS or a helper column when possible.

Write non-functional requirements for an online payment page.

Show answer

NFR-01 Performance: the payment page loads within 2 seconds for 95 percent of requests at 500 concurrent users. NFR-02 Availability: 99.9 percent monthly uptime outside planned maintenance. NFR-03 Security: card data is never stored by the application, and all traffic uses TLS 1.2 or higher. NFR-04 Compliance: the flow meets PCI DSS and RBI payment guidelines. NFR-05 Usability: works on mobile screens from 360 pixels wide. NFR-06 Audit: every transaction attempt is logged with a timestamp.

What is the difference between a report and a dashboard in Power BI Service?

Power BI and TableauEasy

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.

Write a SQL query to get each customer's first order date and first order amount.

SQL for Business AnalysisMedium

Show answer

WITH ordered AS ( SELECT customer_id, order_date, amount, ROW_NUMBER() OVER (PARTITION BY customer_id ORDER BY order_date, order_id) AS rn FROM orders ) SELECT customer_id, order_date AS first_order_date, amount AS first_order_amount FROM ordered WHERE rn = 1;

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

Stakeholder CommunicationMedium

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 a break-even point?

Business Metrics and KPIsMedium

Show answer

The sales volume where total revenue equals total cost. It equals fixed cost divided by contribution margin per unit.

What steps would you follow to run a process discovery workshop?

Show answer

Before: agree scope and process boundaries, invite people who actually do the work, not only managers, and collect existing documents and sample cases. During: state the goal, map the happy path first on a wall or digital board, then add exceptions, pain points, handoffs and volumes, and park off-topic issues. Keep timing visible. After: convert the output to a clean BPMN diagram within two days, circulate it for validation, and record open questions with owners and dates.

Tell me about a time you received critical feedback on your work.

Stakeholder CommunicationEasy

Show answer

Situation: my manager said my first analysis deck was hard to follow. Task: improve it before it went to the client. Action: I asked for specific examples, learned that I had put twenty charts before any conclusion, and restructured it with the recommendation first, three supporting charts and an appendix. Result: the client meeting went well, and I now ask a colleague to review my storyline before every major presentation.

How do you prioritise requirements?

Show answer

Use MoSCoW (Must, Should, Could, Won't), value versus effort scoring or the Kano model, agreed with stakeholders based on business value and risk.

What is the answer-first or pyramid principle approach to presenting analysis?

Stakeholder CommunicationMedium

Show answer

Start with the main conclusion or recommendation, then give the two or three supporting reasons, and only then the detailed data. Senior stakeholders have little time, so a summary like 'Churn rose because of payment failures; fixing retries can save 4 lakh a month' should come first. Detail goes in the appendix. It is the opposite of a chronological walk through every step of the analysis.

Daily active users dropped 10 percent week over week. How do you investigate?

Product AnalyticsMedium

Show answer

Rule out data issues first: tracking changes, app release bugs, pipeline delays or bot filters. Check whether the drop is seasonal by comparing with the same week last year or a festival calendar. Then segment by platform, app version, country or city, acquisition channel and new versus returning users to locate it. Look at the funnel for the core action. Connect findings to releases, outages or marketing changes, then recommend fixes.

A business tester raises a defect, and the developer closes it as 'works as designed'. How do you resolve it?

UAT and BA DocumentationMedium

Show answer

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.

How do you handle changing requirements?

Show answer

Log the change, assess impact on scope, cost and timeline, get approval through change control or backlog grooming, and update documents and stakeholders.

How do you handle NULL values when calculating averages?

SQL for Business AnalysisMedium

Show answer

AVG ignores NULLs; use COALESCE(col, 0) if NULLs should count as zero, depending on the business meaning.

A company reports a profit every quarter but is running out of cash. How do you explain and investigate it?

Financial and Business AnalysisMedium

Show answer

Profit is an accrual figure, while cash depends on timing. Check working capital first: receivables may be growing because customers pay late, inventory may be piling up, or suppliers may be demanding faster payment. Then look at large capex, loan repayments, and dividends. Review the cash flow statement and compute days sales outstanding and inventory days over time. Fixes include tighter credit terms, collection drives, inventory reduction and renegotiating supplier terms.

Describe a time you had to present disappointing numbers to leadership.

Business Metrics and KPIsMedium

Show answer

Situation: a new city launch was 30 percent below its order target after two months. Task: present the review to the leadership team. Action: I opened with the number directly, then broke the gap into traffic, conversion and repeat rate, showing repeat rate was the main problem. I came with three options with estimated impact and cost. Result: leadership approved a focused retention campaign instead of more ad spend, and repeat rate rose over the next quarter.

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

Case Studies and GuesstimatesMedium

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.

What is the difference between Power BI Desktop, Power BI Service and Power BI Mobile?

Power BI and TableauEasy

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.

Developers and testers interpret the same user story differently. How do you fix this?

Show answer

The story is ambiguous, so bring the three amigos together: BA or product owner, a developer and a tester. Walk through concrete examples, including edge cases and error cases, and write them as acceptance criteria, ideally in Given-When-Then format. Add business rules, sample data and mock-ups where needed. Update the story and use the same practice in refinement for future stories, so gaps are found before coding starts.

What is Average Order Value and how can a business increase it?

Business Metrics and KPIsEasy

Show answer

Average Order Value is total revenue divided by number of orders. If an online store earns 9 lakh from 1,500 orders, AOV is 600 rupees. Businesses increase it with bundles, cross-sell and upsell recommendations, free delivery above a threshold, volume discounts and premium options. Watch margin and conversion while doing so, because a high free-delivery threshold can raise AOV but reduce the number of orders.

What is the difference between release notes and a user manual?

UAT and BA DocumentationEasy

Show answer

Release notes describe what changed in a specific release: new features, enhancements, fixed defects, known issues and any actions users must take. They are short and version-specific. A user manual or user guide explains how to use the whole system to complete tasks, with step-by-step instructions and screenshots, and is updated as the product evolves. BAs often review both, because users rely on them in the first weeks after go-live.

What are dynamic array functions in Excel and how do they help analysts?

Show answer

Dynamic array functions return several values that spill into neighbouring cells. UNIQUE lists distinct values, SORT and SORTBY order data, FILTER returns rows meeting conditions, SEQUENCE builds number series, and XLOOKUP can return whole rows. For example =SORT(UNIQUE(FILTER(Sales[Region], Sales[Year]=2026))) builds a live region list. They replace many helper columns and Ctrl+Shift+Enter array formulas, and the # operator references a full spill range.

Write a user story with acceptance criteria for password reset.

Requirements and AgileEasy

Show answer

As a customer, I want to reset my password by email so that I can get back into my account. Acceptance criteria: • Reset link expires in 15 minutes • Password rules are shown while typing • A success message appears after reset

BRD vs FRD?

Requirements and AgileEasy

Show answer

A BRD states what the business needs and why. An FRD details how the system should behave to meet those needs (functional specifications).

A stakeholder's only requirement is 'make the app faster'. How do you turn this into clear requirements?

Show answer

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.

An order has a value of 600 rupees, product cost 360, delivery 60, payment fee 12 and a discount of 50. What is the contribution margin?

Business Metrics and KPIsMedium

Show answer

Net revenue after discount is 600 minus 50, which is 550 rupees. Variable costs are 360 plus 60 plus 12, totalling 432. Contribution margin is 550 minus 432, so 118 rupees per order, or about 21 percent of net revenue. This is what each order contributes towards fixed costs such as salaries and rent. If the discount were raised to 150, the order would contribute only 18 rupees.

What is the difference between accrual accounting and cash accounting?

Financial and Business AnalysisMedium

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.

Which chart would you choose for trend, part-to-whole, comparison and distribution?

Power BI and TableauEasy

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.

How do you build a forecast in Excel?

Show answer

Use historical data with FORECAST.ETS or trend lines, state assumptions, compare against actuals and show best, base and worst scenarios.

How do you build a PivotTable to analyse sales by region and product?

Show answer

Create a table, insert a PivotTable, drag region to rows, product to columns, sales to values, and add slicers for month or channel.

Your process diagram has grown to 80 shapes on one page and stakeholders say they cannot read it. What do you do?

Show answer

Restructure it into levels. Create a high-level map with 7 to 10 main steps, then collapse detailed parts into sub-processes with their own diagrams. Move complex decision logic into a decision table rather than chains of gateways. Show the happy path first and handle exceptions in separate views. Use consistent naming in verb-noun form and remove duplicated steps. Finally, test readability by asking a stakeholder to explain the diagram back to you.

After many sprints, project documentation is out of date and new team members are confused. What do you do?

UAT and BA DocumentationMedium

Show answer

Identify which documents are actually used: usually a product overview, process maps, business rules, data dictionary and integration details. Update those first rather than everything. Make documentation part of the Definition of Done, so a story is not complete until related docs are updated. Keep living documents in a shared wiki with owners and last-reviewed dates, and archive outdated files clearly. Test the result by having a new joiner use it during onboarding.

Write an Excel formula for working days between two dates excluding weekends and holidays.

Excel for Business AnalystsEasy

Show answer

// A2 = start, B2 = end, Holidays = named range of holiday dates =NETWORKDAYS(A2, B2, Holidays) // if the weekend is only Sunday (common in India) =NETWORKDAYS.INTL(A2, B2, 11, Holidays)

You need to explain the results of a sales forecast model to a non-technical sales team. How do you do it?

Stakeholder CommunicationEasy

Show answer

Skip the formulas and talk about what drives the forecast, such as seasonality, past trend and pipeline, in plain words. Show one chart of actuals versus forecast with a range rather than a single number, and explain that the range reflects uncertainty. Translate it into their terms: what it means for their targets and stock. Invite questions and share an example of where it would be wrong.

What checklist do you apply to a BPMN diagram before sharing it with stakeholders?

Show answer

Every diagram has clear start and end events and a title with version and owner. Activities use verb-noun names such as Approve invoice. Each gateway is labelled with a question and its outgoing flows with answers. Splits and joins use matching gateway types. Message flows only connect separate pools. No dangling or crossing arrows where avoidable. The happy path reads left to right. Exceptions are handled, and complex rules are referenced to decision tables rather than drawn as gateways.

A new TO-BE process went live three months ago. How do you prove that the improvement actually worked?