Business Analytics Interview Questions in Gurgaon

Show answer

KPIs are ongoing health measures of the business, like monthly revenue, churn or on-time delivery, tracked continuously. OKRs are a goal-setting method: an Objective is a qualitative ambition for a quarter, and Key Results are two to four measurable outcomes that show it was achieved. A KPI that is off track often becomes the subject of an OKR, for example 'reduce churn from 5 to 3 percent this quarter'.

Guesstimate: how many cars are sold in India every year?

Show answer

Structure it: households × car-owning share ÷ replacement cycle + first-time buyers + commercial fleet. State each assumption clearly and sanity-check the final number.

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.

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.

Stakeholders give conflicting requirements. What do you do?

Stakeholder CommunicationMedium

Show answer

Clarify the goal behind each request, map them to business objectives, prioritise with MoSCoW, run a joint session, then document the decision and get sign-off.

Guesstimate: how many weddings take place in India in a year?

Show answer

Assume a population of about 144 crore and an average life expectancy of about 70 years, so roughly 2 crore people reach a typical marriage age each year. If about 95 percent of them marry at some point, that is around 1.9 crore people, or about 95 lakh weddings, since each wedding involves two people. A reasonable estimate is around 1 crore weddings per year, concentrated in the winter wedding season.

What are the current ratio and the quick ratio?

Financial and Business AnalysisEasy

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.

What is UAT sign-off and who should give it?

UAT and BA DocumentationEasy

Show answer

UAT sign-off is the formal acceptance by the business that the solution meets agreed requirements and is fit to go live, often with a list of known open defects and agreed workarounds. It should be given by the accountable business owner or product owner, not by the IT team or the BA. The BA prepares the evidence: test execution summary, defect status and traceability to requirements. Sign-off is recorded in writing, usually by email or in the test management tool.

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.

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

SQL for Business AnalysisEasy

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;

Monthly subscription churn jumped from 3 percent to 5 percent. How do you investigate?

Show answer

Confirm the data first: definition changes, failed-payment handling or a billing date shift. Then segment churn by plan, tenure, acquisition channel, city and device to find where it concentrates. Separate voluntary cancellations from involuntary card failures. Look at events before the jump, like a price change, app release or competitor offer, and read cancellation reasons. Recommend targeted fixes, such as payment retries or win-back offers, and track the affected cohort.

What is a data table in Excel?

Excel for Business AnalystsMedium

Show answer

A what-if tool that recalculates a formula for different inputs, for example loan payments across different rates and tenures.

What is a date table in Power BI and why should you mark it as a date table?

Power BI and TableauMedium

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.

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

Excel for Business AnalystsMedium

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.

How do you validate data before analysis?

Show answer

Check row counts against the source, nulls, duplicates on keys, value ranges, date coverage and that totals reconcile with finance reports.

What are LOD expressions in Tableau and how do FIXED, INCLUDE and EXCLUDE differ?

Power BI and TableauHard

Show answer

Level of Detail expressions compute an aggregate at a granularity different from the view. FIXED computes at the stated dimensions regardless of the view, for example { FIXED [Customer ID] : MIN([Order Date]) } for first purchase date. INCLUDE adds a dimension to the view level, useful for average sales per customer by region. EXCLUDE removes a dimension, useful for comparing each month with the yearly total. FIXED ignores normal dimension filters unless they are context filters.

How do you validate that a report's numbers are correct?

Show answer

Reconcile totals with source tables using SQL, check filters and joins for duplication, compare with prior periods and verify with business owners.

Guesstimate: how many laptops are sold in India each year?

Show answer

Segment by buyer. Households: about 30 crore households, roughly 15 percent own a laptop, so 4.5 crore laptops, replaced every 5 years, gives about 90 lakh a year, plus around 20 lakh first-time student buyers. Businesses: assume 4 crore office workers using laptops, replaced every 4 years, giving 1 crore. Government and education schemes add around 10 lakh. Total is about 2.2 crore. Sanity check against industry trends and give a range of 1.5 to 2.5 crore.

A client's profits are falling. How do you structure the problem?

Show answer

Split into revenue and cost, then revenue into price, volume and mix, and cost into fixed and variable; check internal factors and external market factors.

How would you analyse the declining sales of a retail store?

Show answer

Break sales into footfall, conversion and average basket, compare with last year and competitors, and check stock, pricing, staffing and local events.

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.

Write a DAX measure that shows each category's percent share of total sales.

Power BI and TableauMedium

Show answer

Category Share % = DIVIDE( [Total Sales], CALCULATE([Total Sales], ALL('Product'[Category])) ) -- ALLSELECTED instead of ALL respects slicers on the page

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.

How do you calculate monthly revenue growth in SQL?

Show answer

Aggregate revenue per month and use LAG(revenue) OVER (ORDER BY month) to compute (revenue - previous) / previous.

What are acceptance criteria?

Show answer

Clear, testable conditions a story must meet to be accepted, often written as Given-When-Then scenarios.

Describe how you would model an employee leave approval process in BPMN.

Process Modelling and BPMNMedium

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.

Tell me about a time you misunderstood a requirement. What did you learn?

Stakeholder CommunicationMedium

Show answer

Situation: I was asked for 'monthly active customers' and built it on login data. Task: deliver the report for a review. Action: in the demo, the stakeholder said active meant customers who purchased, not logged in. I owned the mistake, rebuilt the measure in two days and wrote down the definition for sign-off. Result: the report was accepted, and now I always confirm definitions and sample outputs with stakeholders before building anything.

What are leading and lagging indicators? Give examples.

Show answer

Lagging indicators measure outcomes after they happen, such as monthly revenue, profit or churn. They confirm results but are hard to influence directly. Leading indicators move earlier and predict outcomes, such as demo bookings, trial activations, cart additions or support ticket backlog. A good KPI set pairs them: a sales team tracks qualified pipeline (leading) along with closed revenue (lagging) so it can act before the quarter ends.

What is the difference between OLTP and OLAP systems?

Show answer

OLTP handles many small day-to-day transactions; OLAP supports analysis over large historical data with aggregates and reporting.

Two analysts report different monthly active user numbers from the same database. How do you resolve it?

Show answer

Put both queries side by side and compare definitions: which events count as active, time zone, calendar versus rolling month, test and internal accounts, deleted users, and DISTINCT on user ID versus device ID. Run both on a single day to find where they diverge. Agree on one definition with the metric owner, document it, and publish it as a shared view or metric so everyone queries the same logic.

After a redesign, average time spent in the app increased. Is that good?

Product AnalyticsMedium

Show answer

It depends on the product's goal. For a content or learning app, more time may mean more engagement. For a payments or banking app, more time can mean users struggle to complete tasks. Check task completion rate, time to complete key actions, errors, support tickets and retention. A metric is good only when it moves in line with the value users came for.

What is value stream mapping and how is it different from BPMN?

Process Modelling and BPMNHard

Show answer

Value stream mapping is a Lean technique that maps the end-to-end flow of material and information to deliver value to a customer, along with timing data such as process time, wait time and inventory between steps. Its focus is finding waste and calculating lead time. BPMN focuses on precise logic: roles, decisions, events and messages, often detailed enough for automation. Many teams use VSM to find where to improve and BPMN to design the new process.

Write Given-When-Then acceptance criteria for applying a discount coupon at checkout.