Skip to content
Business Analytics
All courses OffersPlacement Report
‹ Back to previous sectionCourse homeAll page URLs

Business Analytics Interview Questions in Noida

36 practice questions with answers for Business Analytics interviews in Noida.

Business Analytics jobs in Noida

Noida is a major IT and IT-services hub in Delhi NCR with large campuses of service companies, product firms and fast-growing start-ups along the Noida–Greater Noida Expressway. Freshers often find their first role here, and many teams run hybrid work.

Below are 36 questions that match the mix of service, product and domain employers hiring business analysts in Noida.

Solved for NoidaStart 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
01

What is User Acceptance Testing (UAT) and what is the BA's role in it?

Requirements and AgileMedium
Save to ▾
Show answer
UAT is the final testing phase where real business users check that the system supports their work and meets requirements before go-live. The BA helps plan UAT, prepares business scenarios and test cases from requirements, arranges test data, supports users during testing, triages defects versus change requests and tracks sign-off. UAT is not about finding code bugs, which earlier testing should have caught.
02

What is a data table in Excel?

Excel for Business AnalystsMedium
Save to ▾
Show answer
A what-if tool that recalculates a formula for different inputs, for example loan payments across different rates and tenures.
03

Explain exclusive, parallel and inclusive gateways in BPMN.

Process Modelling and BPMNMedium
Save to ▾
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.
04

A manager says the dashboard total does not match the finance team's Excel sheet. What do you do?

Power BI and TableauMedium
Save to ▾
Show answer
First agree on the definition: date range, gross or net, tax, returns, currency and which date (order or invoice) is used. Then reconcile at a small grain, such as one month and one region, comparing row counts and sums between the source query and the sheet. Common causes are filters on the page, missing relationships, duplicate rows after a join or a late refresh. Document the agreed definition in the report tooltip.
05

How do you handle changing requirements?

Requirements and AgileMedium
Save to ▾
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.
06

Write an Excel formula to calculate the monthly EMI for a loan of 10 lakh rupees at 9 percent annual interest for 5 years.

Financial and Business AnalysisEasy
Save to ▾
Show answer
=PMT(9%/12, 5*12, -1000000) # Returns about 20,758 rupees per month. # rate = annual rate / 12, nper = total months, # pv entered as negative so the EMI shows as positive. # Total interest = EMI * 60 - 1000000.
07

Your LEFT JOIN report should list all customers, but customers without orders are missing. Why?

SQL for Business AnalysisHard
Save to ▾
Show answer
A condition on the right table was probably placed in the WHERE clause, for example WHERE o.order_date >= '2026-01-01'. For customers with no orders, o.order_date is NULL, so WHERE removes them and the query behaves like an INNER JOIN. Move the condition into the ON clause, as in LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01', or explicitly allow NULLs.
08

What is a RACI matrix?

Stakeholder CommunicationMedium
Save to ▾
Show answer
A table assigning Responsible, Accountable, Consulted and Informed roles per task so ownership is clear.
09

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

Business Metrics and KPIsEasy
Save to ▾
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.
10

What is a star schema and why do BI tools prefer it?

Power BI and TableauMedium
Save to ▾
Show answer
A star schema has one central fact table holding numeric events (sales, orders) linked to surrounding dimension tables (date, product, customer, region). BI tools prefer it because filters flow cleanly from dimensions to facts, DAX and Tableau calculations stay simple, and compression and query performance improve. A flat single table repeats text values and gets slow, while a snowflake with many chained lookups makes filtering and maintenance harder.
11

How do you create a dashboard in Excel?

Excel for Business AnalystsEasy
Save to ▾
Show answer
Prepare clean data, build PivotTables and PivotCharts, add KPI cards and slicers, and arrange everything on one sheet with a clear layout.
12

A new onboarding flow increased sign-ups by 15 percent, but Day-7 retention fell. How do you analyse this?

Product AnalyticsMedium
Save to ▾
Show answer
Check whether the extra sign-ups are lower-intent users who would naturally retain less. Compare Day-7 retention for comparable users in both versions and count retained users in absolute terms, not just rates. If the new flow skips a step that led users to the aha moment, retention per user may truly fall. The decision depends on whether total retained, valuable users went up or down.
13

What does the LTV to CAC ratio tell you and what is a healthy value?

Business Metrics and KPIsMedium
Save to ▾
Show answer
LTV to CAC compares the lifetime gross profit from a customer with the cost of acquiring them. A ratio around 3 to 1 is commonly treated as healthy. Below 1 means you lose money on every customer. Far above 5 may mean you are underinvesting in growth. Always compute LTV on gross margin, not revenue, and check it by channel, because blended averages hide loss-making channels.
14

What is the role of a BA in Scrum?

Requirements and AgileMedium
Save to ▾
Show answer
They help the Product Owner refine the backlog, write stories and acceptance criteria, clarify details with developers and support testing and demos.
15

What is data storytelling and why does it matter for analysts?

Stakeholder CommunicationEasy
Save to ▾
Show answer
Data storytelling combines data, visuals and narrative so the audience understands what happened, why, and what to do. A good story has context, a clear insight, supporting evidence in one or two simple charts and a recommendation. Accurate numbers alone rarely change decisions; people act when they see the implication. Remove chart clutter, highlight the key point with colour and use titles that state the conclusion.
16

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

Stakeholder CommunicationEasy
Save to ▾
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.
17

How would you decide whether to launch a new product?

Product AnalyticsMedium
Save to ▾
Show answer
Assess market size and demand, customer need, competition, unit economics, capabilities, risks and strategic fit, then test with a pilot before scale-up.
18

What is sensitivity analysis?

Excel for Business AnalystsMedium
Save to ▾
Show answer
Testing how changes in key inputs such as price or volume affect the output, in Excel using data tables or scenario manager.
19

What is the difference between ROI, ROE and ROCE?

Financial and Business AnalysisMedium
Save to ▾
Show answer
ROI (return on investment) is the gain from a specific investment divided by its cost and is used to judge projects or campaigns. ROE (return on equity) is net profit divided by shareholders' equity and shows the return to owners; high debt can inflate it. ROCE (return on capital employed) is EBIT divided by equity plus long-term debt and shows how efficiently all long-term capital is used. ROCE is better for comparing companies with different debt levels.
20

How do you handle NULL values when calculating averages?

SQL for Business AnalysisMedium
Save to ▾
Show answer
AVG ignores NULLs; use COALESCE(col, 0) if NULLs should count as zero, depending on the business meaning.
21

How do you use Excel's Scenario Manager?

Excel for Business AnalystsMedium
Save to ▾
Show answer
Define named scenarios such as best, base and worst with different input values and compare the outputs in a summary report.
22

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

Product AnalyticsMedium
Save to ▾
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.
23

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

Business Metrics and KPIsMedium
Save to ▾
Show answer
Reconcile totals with source tables using SQL, check filters and joins for duplication, compare with prior periods and verify with business owners.
24

What is Kano model in prioritisation?

Requirements and AgileMedium
Save to ▾
Show answer
A model classifying features as basic, performance or delight attributes based on how they affect customer satisfaction, helping decide what to build first.
25

How do you run an effective stakeholder meeting?

Stakeholder CommunicationMedium
Save to ▾
Show answer
Send an agenda with the goal and the decisions needed beforehand, along with any pre-read. Invite only people who contribute or decide. Start by restating the goal, keep to time, park off-topic issues and confirm decisions aloud. End by summarising actions with owners and dates. Send minutes within a day. A meeting without a clear decision or output usually could have been an email.
26

What is a user story and what makes it good?

Requirements and AgileMedium
Save to ▾
Show answer
A short requirement written as 'As a user, I want X so that Y', backed by acceptance criteria. Good stories follow INVEST: independent, negotiable, valuable, estimable, small and testable.
27

What is the difference between UNION and UNION ALL?

SQL for Business AnalysisEasy
Save to ▾
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.
28

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

Process Modelling and BPMNMedium
Save to ▾
Show answer
Compare against the baseline you measured before the change, using the same definitions: cycle time, first-time-right rate, cost per case, backlog and customer complaints. Pull data from system timestamps rather than surveys. Check that the gain is not explained by lower volumes or seasonality, ideally by comparing similar periods. Also check for side effects, such as faster processing but more rework downstream. Present the before-and-after with the business owner, and note where adoption is still incomplete.
29

What is SQL and why do business analysts need it?

SQL for Business AnalysisEasy
Save to ▾
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.
30

What do interviewers evaluate in a business case interview?

Case Studies and GuesstimatesEasy
Save to ▾
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.
31

A KPI on your dashboard dropped 40 percent overnight. What are your first steps?

Business Metrics and KPIsMedium
Save to ▾
Show answer
Assume a data problem until proven otherwise, because real businesses rarely move 40 percent in a day. Check whether the refresh completed, whether source row counts look normal, and whether any tracking, pipeline or definition changed. Compare with a raw source query and a related metric, such as orders versus payments. If the data is fine, segment by channel, region and platform to locate the drop, then alert the owners quickly.
32

What is customer lifetime value?

Business Metrics and KPIsMedium
Save to ▾
Show answer
The total profit expected from a customer over the relationship, roughly average margin x purchase frequency x lifespan, compared with acquisition cost.
33

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

Business Metrics and KPIsMedium
Save to ▾
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.
34

What are process levels such as L0 to L4 in a process architecture?

Process Modelling and BPMNMedium
Save to ▾
Show answer
Process levels organise models from broad to detailed. L0 shows the value chain or main process areas, such as Order to Cash. L1 and L2 break these into process groups and end-to-end processes, such as Credit Management. L3 shows the detailed BPMN flow with roles and decisions. L4 covers work instructions or system steps. A level structure keeps hundreds of diagrams consistent, avoids duplicates and lets executives and operators each read the right depth.
35

What are dimensions and measures in Tableau?

Power BI and TableauEasy
Save to ▾
Show answer
Dimensions are qualitative fields such as Region, Category or Customer Name; placing them on a shelf creates headers and splits the view into groups. Measures are numeric fields such as Sales or Quantity that Tableau aggregates, usually with SUM or AVG. Tableau also marks fields as discrete (blue pills, headers) or continuous (green pills, axes). A date can act as either, which changes whether you get separate bars or a continuous trend line.
36

Write an Excel formula that labels sales as High (100000 or more), Medium (50000 or more) or Low.

Excel for Business AnalystsEasy
Save to ▾
Show answer
=IFS(B2>=100000, "High", B2>=50000, "Medium", TRUE, "Low") // older Excel versions: =IF(B2>=100000, "High", IF(B2>=50000, "Medium", "Low"))

Companies with offices in Noida (22)

Product

Microsoft

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Hyderabad, Bengaluru, Noida +2

View questions
Product

Adobe

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Noida, Bengaluru, Gurugram

View questions
Product

Oracle

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Bengaluru, Hyderabad, Noida +2

View questions
Fintech

Paytm

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Noida, Bengaluru, Mumbai

View questions
Banking & finance

Barclays

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Pune, Chennai, Noida +1

View questions
IT services

HCLTech

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Noida, Chennai, Bengaluru +2

View questions
IT services

Tech Mahindra

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Pune, Hyderabad, Bengaluru +2

View questions
IT services

Hexaware

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Navi Mumbai, Chennai, Pune +2

View questions
IT services

Coforge

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Noida, Greater Noida, Bengaluru +2

View questions
IT services

Birlasoft

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Pune, Noida, Bengaluru +1

View questions
Consulting

Publicis Sapient

Business Analytics interview questions

  • 40 questions
  • 5 rounds

Gurugram, Noida, Bengaluru

View questions
IT services

GlobalLogic

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Noida, Bengaluru, Gurugram +2

View questions
IT services

NTT DATA

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Bengaluru, Pune, Noida +2

View questions
IT services

Genpact

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Gurugram, Hyderabad, Bengaluru +2

View questions
Analytics

EXL

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Noida, Gurugram, Bengaluru +1

View questions
Hardware & semiconductors

Samsung

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Bengaluru, Noida, Delhi

View questions
IT services

Cyient

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Hyderabad, Bengaluru, Noida

View questions
IT services

Happiest Minds Technologies

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Bengaluru, Noida

View questions
IT services

Infogain

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Noida, Gurugram, Pune +1

View questions
Fintech

Pine Labs

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Noida, Bengaluru

View questions
Telecom

Ericsson

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Gurugram, Bengaluru, Chennai +2

View questions
Telecom

Nokia

Business Analytics interview questions

  • 40 questions
  • 4 rounds

Bengaluru, Chennai, Noida +1

View questions

Frequently asked questions

Which companies hire Business Analytics professionals in Noida?

Companies with large offices in Noida include Microsoft, Adobe, Oracle, Paytm, Barclays, HCLTech, Tech Mahindra, Hexaware, Coforge, Birlasoft. Use their company pages below to practise employer-specific sets.

Are Business Analytics interviews in Noida different from other cities?

The questions depend more on the company than the city. Noida's mix of employers decides the style: Freshers often find their first role here, and many teams run hybrid work

How do I find Business Analytics jobs in Noida?

Shortlist companies with Noida offices, keep your CV focused on Business Analytics projects, apply on company career pages and job portals with the Noida filter, and practise the questions on this page before each interview.

Other cities

DelhiGurgaonBangaloreHyderabadPuneChennaiMumbaiKolkataAhmedabadJaipurLucknowChandigarhIndoreKochiCoimbatoreBhubaneswarNagpurVisakhapatnamThiruvananthapuram

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