Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

The purpose of business analysis is to identify and articulate the need for change in the way organizations work, as well as to facilitate that change. Business analysts identify and define the solutions that will maximize the value delivered by an organization to its stakeholders.

The role of a business analyst spans all levels of an organization, including defining strategy, creating the enterprise architecture, and taking a leadership role by defining the program and project goals and requirements, as well as supporting continuous improvement of technology and processes within an organization.

Questions pertaining to business analysis may range from behavioral questions designed to test your reactions to certain business problems or technical questions regarding your knowledge of different business models.

Technical Questions

1. What do business analysts do for an organization or what is the role of Business Analysts in an organization?

During your interview, you will likely be asked this question.

An organization's business analyst serves as a liaison or a link between stakeholders belonging to various domains. Ideally, a business analyst should be able to meet business objectives while simultaneously balancing stakeholder needs.

2. What's INVEST?

INVEST is a condensation of Independent, Negotiable, Valuable, Estimable, Sized meetly, and Testable. This term is used by business judges and design directors to deliver quality services and products.

Free workshop by Jobaaj Learnings

3. What do you imply with the aid of using task deliverables?

These are the set of measurable products and services introduced to the quit purchaser after task completion. It is the final result of the task.

4. What are the numerous degrees of an enterprise venture?

The principal degrees of any enterprise or IT venture are Initiation, Planning, Execution, Monitoring, and Closure.

5. What is UML and how is it used?

Unified Modeling Language, also known as UML, is a general-purpose, developmental modeling language that offers a consistent manner to conceptualize the system. It helps identify and get rid of faults and bottlenecks by rationalizing how the system behaves.

6. What do you apprehend through Gap Analysis, and what are the forms of gaps that may arise for the duration of an evaluation?

Gap Analysis approaches the evaluation of the variations among the functionalities of a current and a central system. The whole approach adjustments can be required to perform the proposed result.

The profit Gap is the alternative between the real and anticipated earnings of a company.

A manpower Gap is an alternative between the real and required group of workers' power in a company.

The performance Gap is the distinction between the predicted and real performances.

The market Gap is the version among anticipated real sales.

7. Do you think a business analyst should be involved in testing?

There isn't any one-size-fits-all solution to this question, as the extent of involvement of Business analysts in being involved in testing will range relying on the precise assignment and organization. However, in general, it's miles useful for commercial enterprise analysts to be concerned in checking out, as they are able to offer precious insights into the necessities and assist in making certain that the very last product meets the wishes of the commercial enterprise.

8. What is BPMN and what are its primary elements?

BPMN, brief for Business Process Model and Notation, is a widespread graphical notation used to version enterprise processes. BPMN became created to offer a not-unusual place language that each enterprise customer and technical builder ought to use to report and talk about enterprise processes.

9. In what ways do you think you are suited to the role of a business analyst?

During this type of business analyst interview question, the interviewer wants to determine how well you understand the job role and whether you match the company's expectations.

The answer to this question can be broken down into two parts:

  • The first step is to highlight your education by stating relevant coursework. 
  • Next, demonstrate how your experience, attitude, and skills make you a good company fit. 

Show the interviewer what benefits you will bring to the company by providing examples from your previous work. You should include an explanation of the problem and the solution you came up with in your answer.


10. As a business analyst, what do you consider to be your core competencies?

Business analyst interviews often include this question. It is pertinent to note that although every company is different, the core requirements of a business analyst profile are significantly the same. Be sure to read the job description in detail to understand the essential skills.

You can answer this by stating that a business analyst must have exceptional communication and negotiation skills. Analytical thinking, problem-solving, and decision-making are also vital attributes. A business analyst should have industry knowledge, business process management skills along with technical proficiency.



11. List a number of the competencies and equipment utilized by Business Analysts.

Answer this query via way of means of combining each the technical and non-technical equipment/competencies utilized by enterprise analysts.

Technical competencies/tools – MS Office Suite, Google Docs, database knowledge, ERP systems, SQL, and more.

Non-Technical/enterprise Analysis competencies – Documentation, requirement elicitation, enterprise technique management, and more.



12. Do you've got any technical abilities? Can you list your database abilities or commercial enterprise intelligence abilities?

Your technical abilities are immediately proportional to your fee withinside the organization.

It isn't always obligatory to have superior technical abilities like relational databases and SQL, however, the extra technically gifted you're as a commercial enterprise analyst, the better. These abilities are maximum ideal and extensively used, so when you have a few.

who enjoy the usage of those technologies, make certain you provide an explanation for them for your interviewer.

13. What is commercial enterprise modeling?

Business modeling is a step-by-step technique for figuring out the cost proposition for working the commercial enterprise.

The key attributes of commercial enterprise modeling to broaden a strategic plan for a corporation are:

  • Vision
  • Mission
  • Objectives
  • Strategies
  • Action plan


14. What is the task/project lifestyles cycle? Which models will you employ, and why?

A Project lifestyles cycle is a framework applied with the aid of using a commercial enterprise analyst to break up a task into achievable levels and represent the choice factors.

in the course of the task lifespan. The specific fashions are the Waterfall version, Spiral version, Iterative version, Agile version, and V-formed version.

You can solution with the aid of using declaring that deciding on a lifestyles cycle version is solely primarily based totally on the type, scope, and boundaries of the task. You can deliver an instance of any version that you utilized in a task.



15. What files are wanted via way of means of an enterprise/Business analyst? Which files /documents have you ever organized to your preceding works?

An assignment/Project lifecycle makes use of many files, and it relies upon the usage manner of an enterprise analyst or a Business Analyst.

  • Initiation report
  • System Requirements Specifications report
  • Business requirement report
  • Functional requirement report
  • Requirements Traceability Matrix
  • Use case Specifications report
  • Change Request Document
  • Gap Analysis Document

With this question, the hiring supervisor desires to apprehend when you have used numerous varieties of files and examine your functionality of turning in each enterprise and technical specifications.


16. What are the main requirements elicitation techniques, and how do you decide which one to use?

Elicitation is drawing out information from stakeholders and other sources to understand needs. No single technique is enough; a good BA combines several and chooses based on the stakeholders, the problem and the time available.

TechniqueBest used when
One-to-one interviewsYou need depth from key stakeholders or subject matter experts, or the topic is sensitive
Workshops (including JAD sessions)Several groups must agree quickly and resolve conflicts together
Observation or job shadowingUsers struggle to describe what they do, or real practice differs from the documented process
Surveys and questionnairesYou need input from a large or spread-out user base
Document analysisExisting policies, manuals, reports or legacy system specs describe current rules
Brainstorming and focus groupsYou want a wide range of ideas or reactions to a concept
PrototypingUsers can react to something visual more easily than to abstract questions
Interface analysisThe solution must integrate with other systems

How to choose, with an example: for a new claims portal at an insurer, you might start with document analysis of the current claim forms and SOPs, run interviews with the claims head and a few senior handlers, observe the team for a day to see workarounds, then hold a workshop to agree the TO-BE process, and finally validate screens with a clickable prototype.

Good practice across all techniques:

  • Prepare an agenda and questions in advance, but stay open to follow-ups.
  • Ask open questions and probe the “why” behind each request.
  • Confirm understanding by playing back what you heard, then document and share notes promptly.
  • Look for tacit knowledge: the things experts do without thinking to mention.

Note: Interviewers like hearing that elicitation is iterative. You elicit, analyse, find gaps, then go back for more, rather than collecting requirements once at the start.

17. What is the difference between a BRD, an FRD and an SRS, and who is the audience for each?

These are three common requirement documents at different levels of detail. Exact names and templates vary between organisations, but the distinction interviewers look for is why versus what versus how the system must behave in full.

BRDFRDSRS
Full nameBusiness Requirements DocumentFunctional Requirements DocumentSoftware Requirements Specification
FocusThe business need, objectives and high-level requirementsHow the solution must function to meet those needsComplete specification of the system, functional and non-functional
Typical contentBackground, problem statement, objectives, scope, stakeholders, high-level requirements, assumptions, constraints, success measuresFeatures, use cases, screen behaviour, business rules, data requirements, workflowsFunctional requirements, performance, security, availability, interfaces, constraints, often in a standard structure
AudienceSponsor, business owners, senior stakeholdersSolution designers, developers, testers, business SMEsArchitects, developers, testers, vendors
Written byUsually the BABA, often with solution inputBA or system analyst, often with technical leads

Example: for a bank’s new loan origination system, the BRD says the bank wants to cut loan approval time from seven days to two and reduce manual data entry. The FRD describes the application form, credit check integration, the approval workflow and the eligibility rules. The SRS adds that the system must support 2,000 concurrent users, encrypt personal data and integrate with the core banking system via specified APIs.

In agile teams the same information often lives in a product vision, epics, user stories with acceptance criteria and a set of non-functional requirements, rather than large signed-off documents.

Note: Always ask which templates the organisation uses. Some firms merge the FRD and SRS, and IT services companies often follow the client’s format.

18. How do you write acceptance criteria using the Gherkin Given-When-Then format? Can you give an example?

Acceptance criteria are the conditions a user story must satisfy to be accepted by the product owner. Gherkin is a structured, plain-language format from behaviour-driven development (BDD) that makes criteria unambiguous and easy to turn into tests.

  • Given — the starting context or precondition.
  • When — the action or event.
  • Then — the expected, observable outcome.
  • And / But — extend any of the above.

Example story: As a savings account holder, I want to withdraw cash from an ATM so that I can access my money without visiting a branch.

Scenario: Withdrawal within the available balance
  Given my account balance is 10,000 rupees
  And my card is valid and not blocked
  When I request a withdrawal of 2,000 rupees
  Then the ATM dispenses 2,000 rupees
  And my account balance becomes 8,000 rupees

Scenario: Withdrawal above the available balance
  Given my account balance is 1,500 rupees
  When I request a withdrawal of 2,000 rupees
  Then the withdrawal is declined
  And I see the message Insufficient funds
  And my balance is unchanged

Good practice:

  • Cover the happy path and the important negative and edge cases.
  • Write declaratively in business language (“I request a withdrawal”) rather than UI steps (“I click the third button”), so criteria survive design changes.
  • One behaviour per scenario, with concrete example values.
  • Use a Scenario Outline with an Examples table when the same rule applies to many data combinations.
  • Agree criteria with the product owner, a developer and a tester together (the “three amigos”) during refinement.

Tools such as Cucumber and SpecFlow can execute Gherkin scenarios directly as automated tests, so the criteria become living documentation.

Note: Gherkin is not mandatory. A simple checklist of rule-based criteria works well for straightforward stories; Gherkin shines when behaviour depends on conditions and data.

19. What is the difference between a requirement, a user story and a use case, and when would you use each?

All three describe what a solution must do, but at different levels of formality and for different ways of working.

Requirement statementUser storyUse case
Form“The system shall…” statementAs a [user], I want [goal] so that [benefit]Structured narrative of actor and system interaction
DetailOne specific capability or constraintDeliberately brief; detail emerges through conversation and acceptance criteriaDetailed: preconditions, main flow, alternate and exception flows, postconditions
Typical contextTraditional or regulated projects, contracts, SRS documentsAgile teams and product backlogsComplex interactions, integration-heavy or regulated systems, either method

Example on one topic, a bill payment feature:

  • Requirement: “The system shall allow customers to schedule a bill payment up to 90 days in advance.”
  • User story: “As a customer, I want to schedule my electricity bill payment in advance so that I never miss a due date.” Acceptance criteria then define the 90-day limit, reminders and failure handling.
  • Use case: “Schedule Bill Payment”, with the customer as actor, preconditions (logged in, biller registered), numbered steps for the main flow, and alternate flows for insufficient balance or a biller being unavailable.

User stories follow the 3 Cs: the Card (short written statement), the Conversation (discussion that fills in detail) and the Confirmation (acceptance criteria). A story is a placeholder for a conversation, not a full specification.

When to choose: stories suit incremental delivery and frequent feedback; use cases are valuable when many paths and exceptions must be thought through; formal “shall” statements suit contracts, audits and compliance.

Note: They are not mutually exclusive. Many agile BAs sketch a use case to understand a complex flow, then slice it into several user stories for the backlog.

20. What are the main components of a use case specification, and how do include and extend relationships work?

A use case describes how an actor interacts with a system to achieve a specific goal. A written use case specification captures that interaction in a consistent structure.

Typical components:

  • Name and ID — a verb-noun goal, such as “Book Train Ticket”.
  • Actors — the primary actor who initiates the use case to achieve a goal, and secondary actors such as a payment gateway.
  • Description and goal — one or two sentences.
  • Trigger — the event that starts it.
  • Preconditions — what must be true beforehand, such as the user being logged in.
  • Main success scenario — numbered steps for the normal path.
  • Alternate flows — valid variations, such as choosing a different class of travel.
  • Exception flows — error conditions, such as payment failure or no seats available.
  • Postconditions — the state of the system after success, such as the ticket being booked and confirmation sent.
  • Business rules and non-functional notes — for example a limit on tickets per user, or a response-time target.

Short main flow example:

  1. Passenger searches for trains between two stations on a date.
  2. System displays available trains and classes.
  3. Passenger selects a train and enters passenger details.
  4. System calculates the fare and requests payment.
  5. Passenger pays through the payment gateway.
  6. System confirms the booking and sends the ticket.

Relationships in a use case diagram:

  • Include — behaviour that is always part of the base use case and reused by several, such as “Authenticate User” included in both “Book Ticket” and “Cancel Ticket”.
  • Extend — optional behaviour added only under certain conditions, such as “Apply Concession” extending “Book Ticket” when the passenger is a senior citizen.
  • Generalisation — a specialised actor or use case inherits from a general one.

Note: Keep the steps at the level of user intent and system response, not screen clicks. That keeps the use case valid even if the interface is redesigned.

21. What are AS-IS and TO-BE process models, and how do you create them on a project?

AS-IS (current state) models show how a process actually works today. TO-BE (future state) models show how it should work once the change is delivered. The difference between them defines the changes the project must make.

Building the AS-IS model:

  1. Agree the process boundaries: where it starts and ends, and which variants are in scope.
  2. Gather information through interviews, workshops, observation and existing SOPs. Observation matters because documented procedures often differ from what people really do.
  3. Map it, usually in BPMN with swimlanes per role or system, showing tasks, decisions, handoffs and systems used.
  4. Capture pain points and data: cycle time, waiting time, rework, error rates, manual re-keying and the number of handoffs.
  5. Validate the map with the people who do the work.

Designing the TO-BE model:

  • Start from the business objectives and the pain points found.
  • Remove non-value-adding steps, reduce handoffs, automate repetitive checks and move decisions closer to the work.
  • Check against constraints: regulation, budget, technology and people capability.
  • Estimate improved metrics so the business case can be tracked.

Example: in a loan approval process, the AS-IS map shows the application passing between five teams by email, with documents re-scanned twice and an average of seven days end to end. The TO-BE design introduces a single digital application, automated credit bureau checks and parallel verification, targeting two days.

Common tools: Visio, Lucidchart, Draw.io, Bizagi and Signavio.

Pitfalls to avoid: documenting the ideal process instead of the real one, spending months perfecting the AS-IS, and jumping to technology before understanding the problem.

Note: Comparing AS-IS with TO-BE naturally leads into gap analysis and transition planning: what must change in process, people, data and systems to get from one to the other.

22. How do you perform stakeholder analysis, and how do you use a power-interest grid to plan engagement?

Stakeholder analysis identifies everyone who affects or is affected by a change, understands their influence and attitude, and plans how to engage each of them. Missing a key stakeholder is one of the most common reasons requirements are later rejected.

Step 1: Identify. Use org charts, the project charter, brainstorming with the sponsor and questions such as “who approves, who uses, who supports, who pays, who is regulated by this?” Remember indirect stakeholders: compliance, IT operations, customer support, vendors and regulators. An onion diagram helps show layers from the core team outward.

Step 2: Analyse. For each stakeholder, record their role, interest in the change, influence or power, current attitude (supporter, neutral, resistor), key concerns and preferred communication style.

Step 3: Map on a power-interest grid.

Low interestHigh interest
High powerKeep satisfied: concise updates, consult on major decisionsManage closely: involve actively, frequent engagement
Low powerMonitor: light-touch, general communicationsKeep informed: regular updates, use them for detailed input

Step 4: Plan engagement and communication. Decide what each group needs to know, how often, through which channel and who owns the relationship.

Example: for a new HR payroll system, the CFO is high power and high interest (manage closely), the CEO is high power but low interest (keep satisfied), payroll clerks are low power but high interest (keep informed and involve in requirements and UAT), and the canteen vendor is monitored.

Note: Stakeholder positions change as a project progresses, so revisit the analysis at each phase. Also mention the RACI matrix, which complements the grid by clarifying who is responsible, accountable, consulted and informed for each activity.

23. How do you build a RACI matrix for a project, and what rules keep it useful?

A RACI matrix maps activities or deliverables against people or roles, showing who does what. It prevents confusion over ownership and decision rights.

  • R — Responsible: does the work. There can be more than one.
  • A — Accountable: owns the outcome, approves it and answers for it. Exactly one per activity.
  • C — Consulted: gives input before or during the work. Two-way communication.
  • I — Informed: kept updated on progress or decisions. One-way communication.

How to build one:

  1. List the key activities or deliverables as rows.
  2. List roles (preferably roles rather than names) as columns.
  3. Fill in the letters with the team, then review with the sponsor.
  4. Check each row and each column against the rules below.
  5. Share it and revisit when the team or scope changes.
ActivitySponsorBADev leadTest leadOps head
Elicit requirementsIA/RCCC
Approve BRDARIIC
Plan UATIRCCA

Rules that keep it useful:

  • One, and only one, A per row; two people accountable means no one is.
  • At least one R per row, otherwise nobody does the work.
  • Too many Cs slow decisions; consult only those whose input is really needed.
  • Scan each column: a person with many Rs may be overloaded, and a person with no letters may not need to attend meetings.

Variants: RASCI adds S for Supportive, and DACI (Driver, Approver, Contributors, Informed) is popular for decision-making.

Note: The RACI is only valuable if it reflects reality. Revisit it when disputes over ownership arise, because those disputes usually reveal a row that was never agreed.

24. How does MoSCoW prioritisation work, and which other prioritisation techniques can a business analyst use?

MoSCoW, from the DSDM agile method, sorts requirements into four categories for a given release or timebox:

  • Must have — without it the solution is unworkable, unsafe or illegal. A useful test: would we cancel the release if this were missing?
  • Should have — important, but a workaround exists for now.
  • Could have — desirable; included if time and budget allow.
  • Won’t have (this time) — explicitly agreed as out of scope for this release, which manages expectations.

Making MoSCoW work: stakeholders tend to label everything a Must, so agree the criteria up front and limit the proportion of effort that can be Must. DSDM guidance suggests keeping Musts to around 60 percent of effort, so Coulds provide contingency.

Other techniques worth knowing:

TechniqueHow it worksBest for
Kano modelClassifies features as basic (expected), performance (more is better) or delighters (unexpected pleasure)Product and customer experience decisions
Value versus effort matrixPlots business value against effort to find quick winsQuick visual prioritisation in workshops
WSJFCost of delay divided by job size, used in SAFeSequencing large items when timing matters
RICEReach × Impact × Confidence ÷ EffortProduct teams comparing many ideas
100-point methodStakeholders distribute 100 points across itemsRevealing true preferences among many stakeholders

Example: in a food delivery app release, live order tracking and payment are Musts, saved addresses a Should, a dark mode a Could, and a loyalty programme a Won’t for this release.

Note: Prioritisation must link back to business objectives and be revisited as information changes. Record the rationale so decisions are not re-litigated every sprint.

25. What is the role of a business analyst in a Scrum team, and how does it differ from the Product Owner’s role?

The Scrum Guide defines only three accountabilities: Product Owner, Scrum Master and Developers. There is no formal “business analyst” role, yet analysis work is essential, so BAs usually work as part of the Developers or closely alongside the Product Owner.

The Product Owner is accountable for:

  • Maximising the value of the product.
  • Defining the product goal and ordering the product backlog.
  • Making final decisions on priority and scope, and accepting work.

The business analyst typically:

  • Elicits needs from users and stakeholders and analyses processes, data and rules.
  • Breaks epics into well-formed user stories and writes clear acceptance criteria.
  • Leads or supports backlog refinement, making sure stories are ready before sprint planning.
  • Creates just-enough models: story maps, process flows, wireframes, data mappings.
  • Answers developers’ questions during the sprint and clarifies edge cases quickly.
  • Helps testers derive scenarios and supports sprint reviews and UAT.
  • Analyses feedback and data after release to suggest the next improvements.

A simple way to explain the difference: the PO decides what is most valuable and in what order; the BA ensures everyone understands what exactly each item means and that it genuinely solves the business problem.

How the role changes from waterfall: instead of a large upfront specification, the BA works just in time, refining detail one or two sprints ahead, and documentation lives in the backlog and acceptance criteria. Collaboration and speed of feedback matter more than document completeness.

Variations in practice: in some organisations the BA acts as a proxy PO for a busy business owner; in scaled frameworks such as SAFe, BAs often support Product Management on features and epics.

Note: A strong answer avoids territorial language. Describe the PO and BA as partners: the PO owns decisions, the BA supplies the analysis that makes those decisions sound.

26. How does a business analyst plan and run user acceptance testing, and what are typical entry and exit criteria?

User acceptance testing (UAT) is the final check that the solution supports real business processes, carried out by business users in realistic conditions before go-live. It answers “does this work for us?” rather than “does the code work?”, which system and integration testing have already addressed.

The BA’s role in planning:

  1. Define scope and approach — which processes, roles and requirements are covered, often traced from the requirements traceability matrix.
  2. Identify and brief testers — real end users from each affected team, with time released by their managers.
  3. Write UAT scenarios based on end-to-end business processes and acceptance criteria, including negative and exception cases, such as a rejected payment or a missing document.
  4. Prepare test data and environment — realistic, masked data and a stable, production-like environment.
  5. Agree the schedule, defect process and communication plan.

During execution: support testers, log and triage defects by severity and priority, separate genuine defects from change requests or training issues, track progress daily and report to stakeholders.

Typical entry criteria:

  • System and integration testing complete, with no open critical defects.
  • UAT environment and test data ready.
  • Scenarios reviewed and testers trained.

Typical exit criteria:

  • All critical business scenarios executed and passed.
  • No open severity 1 or 2 defects; minor ones have agreed workarounds and fix dates.
  • Formal sign-off from the business owner.

Example: for a new GST invoicing module, accountants test raising, amending and cancelling invoices, including inter-state and intra-state tax calculations, and reconcile totals with the finance report before signing off.

Note: Do not let UAT become the first time users see the system. Regular demos and early prototype reviews prevent UAT from turning into a flood of new requirements.

27. What is a requirements traceability matrix, and how does it help with coverage, impact analysis and scope control?

A requirements traceability matrix (RTM) links each requirement to where it came from and to everything built and tested because of it. It gives a single view of whether every requirement is delivered and verified.

Directions of traceability:

  • Backward traceability — from a requirement back to its source: a business objective, regulation or stakeholder request. This shows why it exists.
  • Forward traceability — from a requirement to design elements, code or user stories, test cases and defects. This shows it was built and tested.
  • Bidirectional — both, which is the usual goal.
Req IDRequirementBusiness objectiveStory or designTest casesStatus
FR-012Send an SMS alert for transactions above ₹10,000BO-3 Reduce fraud lossesUS-145TC-301, TC-302Passed
FR-013Allow users to set their own alert thresholdBO-3US-146TC-303Open defect D-88

Why it matters:

  • Coverage — spot requirements with no test cases, or tests that trace to no requirement.
  • Impact analysis — when a requirement changes, you instantly see the affected stories, designs and tests, which makes change requests easier to estimate.
  • Scope control — anything built that does not trace to an approved requirement is scope creep or gold plating.
  • Compliance and audit — regulated sectors such as banking, insurance and healthcare often need evidence that each regulatory requirement was implemented and tested.
  • Go-live readiness — status columns show exactly what is complete.

Maintaining it: assign unique IDs from the start, update the matrix whenever requirements or tests change, and use tool links in Jira, Azure DevOps or a test management tool rather than a spreadsheet on larger projects.

Note: An RTM that is only filled in at the end, for audit purposes, delivers little value. Keeping it current throughout is what makes impact analysis fast.

28. What is the difference between a SWOT analysis and a PESTLE analysis, and how can a business analyst use them together?

Both are strategy analysis tools, but they look in different directions.

SWOT assesses an organisation, product or initiative:

  • Strengths and Weaknesses — internal factors the organisation controls, such as brand, skills, cost base, technology or processes.
  • Opportunities and Threats — external factors it does not control, such as market trends, competitors and regulation.

PESTLE scans only the external macro-environment:

  • Political — government policy, stability, trade policy.
  • Economic — interest rates, inflation, growth, exchange rates.
  • Social — demographics, behaviour, attitudes and lifestyle trends.
  • Technological — new platforms, automation, digital infrastructure.
  • Legal — laws and regulations, such as data protection or consumer protection.
  • Environmental — climate, sustainability expectations, resource constraints.

Using them together: run a PESTLE first to understand the environment systematically, then feed its findings into the Opportunities and Threats quadrants of the SWOT. That grounds the SWOT in evidence rather than guesswork.

Example: a fintech planning small-ticket digital loans for tier-2 and tier-3 cities.

  • PESTLE findings: RBI rules on digital lending (legal and political); interest-rate movements (economic); rising smartphone and UPI adoption in smaller towns (social and technological); India’s DPDP Act on consent for personal data (legal).
  • SWOT: strengths are a fast mobile onboarding flow and low operating costs; weaknesses are limited brand awareness and a small collections team; opportunities are underserved borrowers and account-aggregator data for underwriting; threats are regulatory tightening and competition from large banks’ apps.

Going further: a TOWS matrix turns SWOT into strategies, for example using strengths to exploit opportunities (S-O) or reducing weaknesses to avoid threats (W-T).

Note: A common mistake is listing external trends as strengths. Keep the internal and external split strict, and prioritise the few factors that really matter rather than filling every box.

29. How do you define KPIs for a business initiative, and what is the difference between leading and lagging indicators?

A KPI (key performance indicator) is a measurable value that shows how effectively an organisation is achieving a specific objective. Every KPI is a metric, but not every metric is a KPI; KPIs are the few measures tied directly to strategic goals.

A structured way to define a KPI:

  1. Start with the objective, such as “improve the speed of insurance claim settlement”.
  2. Choose the measure that best reflects progress: average claim settlement time.
  3. Define the formula precisely: from claim registration to payment, in calendar days, excluding claims under investigation.
  4. Establish the baseline: currently 9 days.
  5. Set a target and timeframe: 4 days by the end of the financial year.
  6. Identify the data source, owner and reporting frequency.

Targets should be SMART: specific, measurable, achievable, relevant and time-bound.

Leading versus lagging indicators:

LaggingLeading
What it showsOutcomes that have already happenedEarly signals that predict future outcomes
ExamplesRevenue, customer churn, claims settled per quarterDemo requests, first-week app activations, claims pending more than 3 days
StrengthEasy to measure, confirms resultsAllows corrective action before it is too late

A balanced set uses both: leading indicators to steer, lagging indicators to confirm success.

Pitfalls:

  • Vanity metrics such as app downloads that do not reflect value.
  • Too many KPIs, which dilutes focus.
  • Measures that can be gamed. Goodhart’s law warns that when a measure becomes a target, it stops being a good measure; pair speed with a quality measure, such as settlement time with claim reopen rate.

Note: BAs often include KPIs in the business case and then define the reporting requirements needed to track them after go-live, so benefits can actually be proven.

30. Which SQL skills does a business analyst need, and can you explain the difference between WHERE and HAVING with an example?

BAs use SQL to validate requirements with real data, profile data quality, reconcile reports and answer stakeholder questions without waiting for a developer. You do not need to be a database engineer, but you should be comfortable with:

  • SELECT, WHERE, ORDER BY and DISTINCT to retrieve and filter data.
  • JOINs — INNER JOIN for matching records only, LEFT JOIN to keep all records from the left table (useful for finding customers with no orders).
  • Aggregation with COUNT, SUM, AVG, MIN and MAX, using GROUP BY.
  • CASE expressions for categorising data.
  • Subqueries and CTEs (WITH clauses) to break complex logic into steps.
  • Window functions such as ROW_NUMBER, RANK and running totals.
  • Data quality checks: finding NULLs, duplicates and orphan records.

WHERE versus HAVING: WHERE filters individual rows before they are grouped; HAVING filters groups after aggregation. You cannot use an aggregate such as COUNT in a WHERE clause.

SELECT c.customer_id,
       c.city,
       COUNT(o.order_id) AS orders,
       SUM(o.amount)     AS revenue
FROM customers c
JOIN orders o ON o.customer_id = c.customer_id
WHERE o.order_date >= '2025-04-01'
GROUP BY c.customer_id, c.city
HAVING COUNT(o.order_id) > 5
ORDER BY revenue DESC;

Here, WHERE keeps only orders from this financial year, GROUP BY totals them per customer, and HAVING keeps only customers with more than five orders.

Typical BA uses:

  • Checking how many records would be affected by a proposed business rule.
  • Validating that a dashboard figure matches the source system.
  • Profiling legacy data before a migration, such as counting missing mobile numbers.
  • Verifying UAT results directly in the database.

Note: Always run analysis queries on a reporting replica or test copy, not on a live production database, and never share raw personal data outside approved channels.

31. Which Excel skills are most useful for a business analyst, and how would you use them in day-to-day analysis?

Excel remains the most common analysis tool in Indian and global businesses, and many BA tasks, such as reconciling data, building quick models and preparing stakeholder summaries, start there.

Core skills interviewers expect:

  • Lookups — XLOOKUP (or INDEX with MATCH in older versions) to bring data from one table into another. XLOOKUP can look left, defaults to an exact match and is not broken by inserted columns, unlike VLOOKUP.
  • Pivot tables and pivot charts — summarise thousands of rows by region, product or month in seconds, and drill into detail.
  • Conditional aggregation — SUMIFS, COUNTIFS and AVERAGEIFS for totals that meet several criteria.
  • Logical functions — IF, IFS, AND, OR and IFERROR to apply business rules.
  • Text and date functions — TRIM, LEFT, TEXTJOIN, TEXT, EOMONTH and NETWORKDAYS for cleaning and time calculations.
  • Data tools — remove duplicates, data validation drop-downs, conditional formatting to highlight exceptions, and filters.
  • Power Query — repeatable import, cleaning and merging of data from several files or systems without manual copy-paste.
  • What-if analysis — Goal Seek, data tables and scenario manager for business case sensitivity.

Day-to-day examples:

  • Reconciliation: compare a CRM customer extract against the billing system using XLOOKUP to flag customers missing from either list.
  • Requirements sizing: use COUNTIFS on transaction data to show that 70 percent of refund requests fall below ₹500, supporting an auto-approval rule.
  • Stakeholder reporting: build a pivot of defect counts by severity and module for a weekly UAT status report.
  • Business case modelling: build a cost-benefit model with payback period and test best-case and worst-case assumptions.

Note: Mention when you would move beyond Excel: very large datasets, repeatable dashboards or many users call for SQL and BI tools such as Power BI or Tableau. Knowing the limit is as valuable as knowing the formulas.

32. What is the difference between a wireframe, a mockup and a prototype, and how does a business analyst use them?

All three are visual representations of a user interface, but they differ in fidelity (how close they look to the final product) and interactivity.

WireframeMockupPrototype
FidelityLow: boxes, placeholders, basic layoutHigh: real colours, fonts, imagesLow to high, depending on purpose
Interactive?NoNo, staticYes, clickable or simulated flow
Main purposeStructure, content and layoutVisual design and brandingTest the flow and usability
Typical stageEarly elicitationAfter structure is agreedValidation before build
Common toolsBalsamiq, paper sketches, FigmaFigma, Adobe XDFigma, Axure

How a BA uses them:

  • To elicit requirements. Showing a rough wireframe of a loan application page prompts stakeholders to say “we also need the co-applicant’s income here”, which rarely surfaces in abstract interviews.
  • To validate understanding. Walking users through a clickable prototype of an onboarding flow reveals confusing steps before any code is written.
  • To annotate business rules. Notes on a wireframe can explain field validations, mandatory fields, conditional displays and error messages.
  • To align the team. Developers, testers and designers share a common picture of scope.

Why start low fidelity: grey boxes keep discussion on content and flow. A polished mockup too early invites debates about colours and fonts, and can make stakeholders think the product is nearly finished.

Collaboration with design: in many teams a UX designer owns high-fidelity work; the BA contributes the requirements, rules and data behind each screen.

Note: A prototype is a communication tool, not a commitment to the final design. Label it clearly so stakeholders do not treat every pixel as a signed-off requirement.

33. How do you handle a change request after the requirements have been signed off?

Change is normal; uncontrolled change is the problem. Once requirements are baselined, a BA should route every change through a clear change control process so its impact is understood and the right people decide.

A typical process:

  1. Log the request — who asked, what exactly is wanted, why, and how urgent it is. Clarify the underlying business need; sometimes the need can be met without a change.
  2. Analyse the impact — use the traceability matrix to find affected requirements, designs, test cases, integrations and documents. Estimate effect on cost, timeline, resources, risk and other features, working with developers and testers.
  3. Present options — for example, include it now and move the release date, include it now and drop a lower-priority item, or defer it to the next release.
  4. Get a decision from the sponsor or change control board, as defined in the RACI.
  5. Update the baseline — requirements, RTM, test cases and plans — and version the documents.
  6. Communicate the decision and its consequences to everyone affected.

Example: two weeks before UAT, the sales head asks to add WhatsApp notifications to an order management system. Impact analysis shows a new vendor integration, two extra sprints and additional consent requirements under data protection rules. The sponsor chooses to defer it to phase two and launch on time with SMS and email notifications.

In agile teams the mechanics differ: new requests go into the product backlog and the Product Owner reprioritises them against existing items. Change within the sprint is avoided, but change between sprints is welcomed.

What to avoid: accepting “small” changes informally in corridor conversations. Individually minor changes add up to scope creep and missed deadlines, and they are invisible in the plan.

Note: Stay neutral. Your job is not to refuse or approve changes but to make their impact visible so the accountable person can make an informed decision.

34. How do you carry out root cause analysis using the 5 Whys and a fishbone diagram? Can you give an example?

Root cause analysis (RCA) looks beyond symptoms to find the underlying cause of a problem, so the fix prevents recurrence rather than repeatedly treating the same issue.

General approach: define the problem precisely with data, gather evidence, identify possible causes, verify the true cause with data, fix it, and monitor that the fix works.

The 5 Whys asks “why?” repeatedly until you reach a cause you can act on. Example for an e-commerce firm:

  1. Why are customers complaining? Deliveries are arriving late.
  2. Why are they late? Orders leave the warehouse a day after they are placed.
  3. Why? Picking lists are only generated once a day, in the evening.
  4. Why? The warehouse system receives orders in a nightly batch file.
  5. Why? The integration was built as a batch job when volumes were low and was never redesigned.

The root cause is the batch integration design, not warehouse staff performance, and the fix is a near real-time order feed.

The fishbone (Ishikawa) diagram is better when many factors may contribute. The problem is the “head”, and causes are grouped on “bones” by category. In manufacturing the 6Ms are common: Methods, Machines, Materials, Manpower (people), Measurement and Mother Nature (environment). Service settings often use categories such as policies, processes, people, systems and customers. Teams brainstorm causes under each category, then test the most likely ones with data.

Supporting tools:

  • Pareto analysis — often around 80 percent of problems come from 20 percent of causes, so fix the biggest categories first.
  • Process maps to locate where in the flow the problem arises.
  • Data analysis in Excel or SQL to verify a hypothesis before acting.

Note: The 5 Whys can lead to a single, simplistic chain or to blaming a person. Stop when you reach a process or system cause the organisation can change, and verify it with evidence rather than opinion.

35. What is the difference between functional and non-functional requirements, and how do you make non-functional requirements measurable?

Functional requirements describe what the system must do: behaviours, features and business rules. Examples: “The system shall generate a GST-compliant invoice when an order is dispatched” or “Users shall be able to reset their password using a one-time code.”

Non-functional requirements (NFRs) describe how well the system must perform those functions, and the constraints it must operate within. They are often called quality attributes.

Common NFR categories:

  • Performance — response time, throughput.
  • Scalability — growth in users, data or transactions.
  • Availability and reliability — uptime, recovery objectives.
  • Security — authentication, encryption, audit logging.
  • Usability and accessibility — ease of use, accessibility standards.
  • Maintainability and portability.
  • Compliance — legal, regulatory and data residency requirements.

Frameworks such as FURPS+ and the ISO/IEC 25010 quality model provide checklists so categories are not missed.

Making NFRs measurable: vague NFRs cannot be designed for or tested.

VagueMeasurable
The site should be fast95 percent of product searches return results within 2 seconds with 5,000 concurrent users
The system must always be available99.9 percent availability per calendar month, excluding pre-announced maintenance windows
The app must be secureAll personal data encrypted in transit with TLS 1.2 or higher and at rest with AES-256; admin access requires MFA
It should be easy to use80 percent of first-time users complete registration in under 3 minutes without help

For context, 99.9 percent availability allows roughly 43 minutes of downtime in a 30-day month, which helps stakeholders understand what they are asking for and what it will cost.

Note: NFRs are frequently missed because business users rarely mention them. Ask about them explicitly, involve architects and security teams early, and make sure each NFR has a test or monitoring method attached.

36. What goes into a business case, and how are ROI, payback period and NPV used to evaluate options?

A business case justifies an investment by showing that its expected benefits outweigh its costs and risks, and that it is the best of the available options. BAs often help build it and later track whether the benefits were delivered.

Typical contents:

  1. Executive summary and recommendation.
  2. Problem or opportunity statement, with evidence.
  3. Strategic alignment — how it supports organisational goals.
  4. Options considered, always including “do nothing” as a baseline.
  5. Costs — one-off (capex) and ongoing (opex): licences, build, training, support.
  6. Benefits — tangible (cost savings, revenue) and intangible (customer satisfaction, compliance).
  7. Financial analysis.
  8. Risks, assumptions, dependencies and constraints.
  9. High-level implementation plan and benefit measures (KPIs).

Key financial measures:

  • ROI = (total benefits − total costs) ÷ total costs × 100. Simple and popular, but ignores timing.
  • Payback period — how long until cumulative benefits cover the investment. Easy to explain, but ignores benefits after payback.
  • NPV (net present value) — discounts future cash flows back to today’s value using a discount rate, then subtracts the investment. A positive NPV means the investment creates value. It is the most rigorous of the three.
  • IRR — the discount rate at which NPV equals zero, compared against the organisation’s hurdle rate.

Example: automating invoice processing costs ₹50 lakh upfront and saves ₹20 lakh a year. The payback period is 2.5 years. Over five years the benefits total ₹1 crore, giving an undiscounted ROI of 100 percent. Discounting at the company’s cost of capital gives the NPV, which decision-makers compare with competing projects.

Note: Be honest about assumptions and show sensitivity analysis: what happens if savings are 30 percent lower or the project takes six months longer? Credible business cases survive tough questions.

37. What is organisational change management, and how can a business analyst use the ADKAR model to drive adoption?

Organisational change management is the people side of change: helping individuals move from the current way of working to the new one so the solution is actually adopted and the benefits are realised. A technically perfect system that nobody uses delivers nothing.

It is different from change control, which manages changes to project scope and requirements.

The ADKAR model from Prosci describes five outcomes each person needs, in sequence:

  1. Awareness of why the change is needed.
  2. Desire to support and take part in it.
  3. Knowledge of how to change.
  4. Ability to apply the new skills and behaviours in real work.
  5. Reinforcement to sustain the change and prevent people slipping back.

The model is useful diagnostically: if adoption stalls, you ask which element is missing for which group. Training (knowledge) will not fix a lack of desire.

How a BA contributes:

  • Change impact assessment — for each stakeholder group, what changes in their process, tools, roles, skills and performance measures.
  • Transition requirements — BABOK’s term for temporary needs such as data migration, parallel running, training and support during cutover.
  • Input to communications — explaining the “why” in terms each group cares about.
  • Training needs analysis and support for training material, often from process maps and user stories.
  • Identifying change champions in each team.
  • Adoption metrics — usage, error rates and helpdesk tickets after go-live.

Example: a hospital moving from paper to electronic prescriptions. Doctors were aware and trained, yet adoption was low. The BA found through observation that the new screens took longer during busy outpatient hours, so it was an ability issue. Adding favourite prescription templates fixed it.

Note: Kotter’s eight-step model is another well-known framework. Mentioning it alongside ADKAR shows breadth: Kotter is organisation-level, ADKAR is individual-level.

38. What is a data flow diagram, and how does a context diagram differ from a level 1 DFD?

A data flow diagram (DFD) shows how data moves through a system: where it comes from, how it is processed, where it is stored and where it goes. It shows data movement, not the sequence or timing of steps, which distinguishes it from a flowchart.

Four building blocks:

  • External entity — a person, organisation or system outside the boundary that sends or receives data, such as a customer or payment gateway.
  • Process — transforms incoming data into outgoing data, named with a verb phrase such as “Validate Order”.
  • Data store — data at rest, such as an Orders table or customer master.
  • Data flow — an arrow labelled with the data moving, such as “order details”.

Levels of DFD:

  • Context diagram (level 0) — the entire system as a single process, surrounded by external entities and the data flows between them. It defines scope and boundaries at a glance and has no data stores.
  • Level 1 DFD — breaks that single process into its major sub-processes, such as Place Order, Process Payment, Assign Delivery and Notify Customer, and shows the data stores between them.
  • Level 2 and beyond — decompose individual level 1 processes further where more detail is needed.

Example, a food delivery platform: the context diagram shows Customer, Restaurant, Delivery Partner and Payment Gateway exchanging data with “Food Delivery System”. The level 1 DFD reveals internal processes and stores such as Orders, Menus and Delivery Assignments.

Rules to follow:

  • Data cannot flow directly between two external entities, two data stores, or an entity and a store; a process must sit between them.
  • Every process needs at least one input and one output.
  • Balancing: the inputs and outputs of a parent process must match those of its child diagram.

Note: Two notations exist, Yourdon-DeMarco (circles for processes) and Gane-Sarson (rounded rectangles). Either is fine; consistency matters more than the choice.

39. What is the difference between requirements verification and requirements validation, and what techniques support each?

The two are easy to confuse, but they answer different questions.

  • Verification asks “are the requirements built right?” It checks that requirements are well written and of sufficient quality to design and test against.
  • Validation asks “are these the right requirements?” It checks that they actually meet the stakeholders’ needs and support the business objectives.

Verification checks quality attributes. A good requirement is:

  • Unambiguous — only one interpretation.
  • Complete — no missing conditions, data or exceptions.
  • Consistent — does not contradict other requirements.
  • Testable — you can prove it is met.
  • Feasible, atomic and traceable to a source.

Verification techniques: peer reviews and formal inspections, checklists, glossary checks for consistent terms, and testers reviewing requirements to confirm each can be tested.

Validation techniques:

  • Walkthroughs with business stakeholders.
  • Prototypes and wireframe reviews.
  • Tracing each requirement back to a business objective, which exposes requirements that add no value.
  • Scenario and use case walkthroughs against real business cases.
  • Ultimately, user acceptance testing on the built solution.

Example: “The system shall process refunds quickly” fails verification because “quickly” is not testable; rewritten as “Refunds under ₹5,000 shall be credited within 24 hours of approval”, it passes. But if stakeholders really needed refunds to reach the customer’s original payment method, and the requirement says “to wallet balance”, it is still perfectly written and invalid. Validation with the customer service head would catch that.

Note: A requirement can pass verification and fail validation, or the reverse. Strong BAs do both continuously, not just before sign-off.

40. How do you resolve conflicting requirements from two senior stakeholders who each insist their need comes first?

Conflicting requirements are normal because different departments optimise for different goals. The BA’s job is not to pick a winner but to make the conflict visible, explore options and help the right person decide.

A practical approach:

  1. Understand the underlying interests. Meet each stakeholder separately and ask why they need what they are asking for. Positions often conflict while the real interests do not.
  2. Gather evidence. Use data on volumes, costs, risks or customer impact so the discussion is about facts, not seniority.
  3. Trace each requirement to business objectives and any regulatory obligations. A requirement driven by law or regulation usually constrains the options.
  4. Look for creative options that satisfy both interests: phasing, configuration by segment, or a different design.
  5. Facilitate a joint session where both stakeholders see the options, trade-offs and impacts side by side.
  6. Escalate if needed to the sponsor or decision-maker named in the RACI, with a clear recommendation.
  7. Document the decision and rationale so it is not reopened later.

Example: in a digital account-opening project, the sales head wanted a two-minute sign-up with minimal fields to improve conversion, while the compliance head insisted on complete KYC verification before any account activity. Exploring interests showed sales cared about drop-off at the first screen, and compliance cared about transactions before verification. The agreed design captured minimal details first, completed verification digitally in the same journey, and blocked transactions until KYC was complete. Both goals were met.

Tools that help: prioritisation techniques such as MoSCoW, a decision matrix with weighted criteria agreed in advance, and impact analysis from the traceability matrix.

What to avoid: quietly implementing one stakeholder’s version, averaging requirements into something that satisfies nobody, or letting the loudest voice win by default.

Note: Stay neutral and transparent. Stakeholders trust a BA who presents both sides fairly, even when the decision goes against them.

41. What is a SIPOC diagram, and how does a business analyst use it to scope a process?

SIPOC is a one-page, high-level view of a process that identifies its Suppliers, Inputs, Process, Outputs and Customers. It comes from Six Sigma, where it is used in the Define phase, but BAs use it on any process improvement or system project to agree scope before detailed mapping.

  • Suppliers — people, teams, organisations or systems that provide the inputs.
  • Inputs — the materials, information or resources the process needs.
  • Process — typically four to seven high-level steps, from a clear start to a clear end.
  • Outputs — what the process produces.
  • Customers — who receives the outputs, internal or external.

Example: monthly payroll processing

SuppliersInputsProcessOutputsCustomers
HR, department heads, attendance system, tax departmentEmployee master data, attendance and leave, variable pay approvals, tax declarationsCollect inputs; validate data; calculate gross pay; apply deductions and TDS; approve payroll; transfer salariesSalary credits, payslips, statutory filings, payroll reportsEmployees, finance, auditors, government authorities

How to build it in a workshop: many facilitators start with the Process column to agree start and end points, then define Outputs and Customers, and finally Inputs and Suppliers. Working this way keeps attention on what customers actually receive.

Why it is valuable:

  • Sets clear boundaries, so everyone agrees where the process starts and stops.
  • Identifies stakeholders who might otherwise be missed, such as upstream suppliers of data.
  • Highlights inputs whose poor quality causes downstream problems.
  • Provides a structure for later detailed AS-IS mapping and voice-of-customer work.

Note: Keep SIPOC high level. If the process column grows beyond seven or eight steps, you are drifting into detailed process mapping, which belongs in a separate BPMN diagram.

42. What is the difference between an epic, a feature, a user story and a task, and how do you split a large story?

Agile teams organise work in a hierarchy, from large goals down to small, deliverable pieces. Terms vary slightly by tool and framework, but a common structure is:

LevelWhat it isTypical sizeExample
EpicA large body of work delivering a significant business outcomeSeveral sprints or a quarterDigital loan application
FeatureA distinct capability that delivers value to users (a formal level in SAFe)A few sprintsDocument upload and verification
User storyA small, user-focused piece of value that fits in one sprintDaysAs an applicant, I want to upload my PAN card photo so that I don’t have to visit a branch
TaskA technical step needed to complete a storyHoursBuild image compression service; write API tests

Some organisations add themes or initiatives above epics to group work by strategic goal.

Why splitting matters: large stories hide uncertainty, cannot be finished within a sprint and delay feedback. Each split should still deliver user value, following INVEST, rather than being cut into technical layers such as “build the database” and “build the UI”.

Useful splitting patterns:

  • Workflow steps — search, select, pay, confirm as separate stories.
  • Business rule variations — standard discount first, festive offer rules later.
  • Data variations — support PAN upload first, other documents in later stories.
  • Happy path first, then error and exception paths.
  • Operations — create, view, edit and delete as separate stories.
  • Interface — web first, mobile app next.
  • Spike — a time-boxed investigation when uncertainty is too high to estimate.

Mike Cohn’s SPIDR mnemonic (Spikes, Paths, Interfaces, Data, Rules) is a handy way to remember these.

Note: Tasks belong to the development team and usually are not written by the BA. The BA’s focus is on epics, features and stories with clear acceptance criteria.

43. What is user story mapping, and how does it help a team plan an MVP and later releases?

User story mapping, popularised by Jeff Patton, arranges user stories along the user’s journey instead of in a flat, prioritised list. It gives the team a shared, two-dimensional picture of the whole product.

Structure of a story map:

  • The backbone — high-level user activities laid out left to right in the order a user experiences them. For an online grocery app: Browse, Build Basket, Check Out, Receive Delivery, Get Support.
  • Steps or tasks under each activity, such as search products, filter by brand and view offers under Browse.
  • User stories stacked vertically beneath each step, with the most essential at the top and nice-to-haves lower down.

Planning releases: draw horizontal lines across the map. Everything above the first line forms the MVP or walking skeleton: the thinnest end-to-end slice that lets a real user complete the journey. Later slices become release two, release three and so on.

Example MVP slice for the grocery app: search by name, add to basket, pay by UPI, choose a delivery slot and receive an SMS confirmation. Filters, wish lists, wallet payments and live rider tracking fall into later releases.

Benefits:

  • Everyone sees the big picture, not just the next few backlog items.
  • Gaps become obvious, for example a checkout step with no stories at all.
  • It prevents releasing polished but incomplete features that do not let users finish a journey.
  • It supports conversations with stakeholders about what is truly essential.

Running a mapping session: bring together the product owner, BA, designer, developers and a tester; walk through the journey as a specific persona; write sticky notes or use tools such as Miro or Jira plug-ins; then slice by outcome, asking what the smallest release is that would let us learn something valuable.

Note: A story map complements, rather than replaces, the product backlog. Once slices are agreed, the stories are ordered in the backlog for sprint planning.

44. What is the difference between the Definition of Ready and the Definition of Done in agile teams?

Both are shared checklists that set quality expectations, but they apply at opposite ends of a backlog item’s journey.

Definition of Ready (DoR)Definition of Done (DoD)
When it appliesBefore an item is pulled into a sprintBefore an item counts as complete
Question it answersDo we understand this well enough to start?Is this finished to our quality standard?
Status in ScrumA common team practice, not part of the Scrum GuideFormally defined in the Scrum Guide as a commitment for the Increment
Main contributorsProduct Owner, BA and team during refinementThe whole Scrum team, often with organisational standards

Example Definition of Ready:

  • The story states the user, goal and benefit, and its business value is clear.
  • Acceptance criteria are written and agreed.
  • Dependencies on other teams or vendors are identified.
  • Designs or wireframes are attached where needed.
  • The story is estimated and small enough to finish within a sprint.
  • Test data needs are known.

Example Definition of Done:

  • Code is peer reviewed and merged.
  • Unit and integration tests pass; acceptance criteria are verified.
  • Non-functional requirements such as performance and security checks are met.
  • Documentation and release notes are updated.
  • The increment is deployed to a staging environment and accepted by the Product Owner.

The BA’s contribution: the BA is often the main driver of readiness, making sure stories are clear, testable and properly sliced before sprint planning, and helps confirm that acceptance criteria are satisfied under the Definition of Done.

A caution about DoR: if applied too rigidly, it can become a waterfall-style gate where nothing starts until every detail is known. Treat it as a guideline that improves flow, not a barrier.

Note: A story that meets its acceptance criteria but not the Definition of Done is not done. Acceptance criteria are specific to one story; the DoD applies to every item.

45. What is the BABOK Guide, and what are its six knowledge areas?

The BABOK Guide (A Guide to the Business Analysis Body of Knowledge) is published by the International Institute of Business Analysis (IIBA). Version 3 is the widely used edition and defines business analysis as enabling change by defining needs and recommending solutions that deliver value to stakeholders.

The six knowledge areas:

  1. Business Analysis Planning and Monitoring — planning the approach, stakeholder engagement, governance, information management and measuring BA performance.
  2. Elicitation and Collaboration — preparing for and conducting elicitation, confirming results, communicating information and managing stakeholder collaboration.
  3. Requirements Life Cycle Management — tracing, maintaining, prioritising, assessing changes to and approving requirements.
  4. Strategy Analysis — analysing the current state, defining the future state, assessing risks and defining the change strategy.
  5. Requirements Analysis and Design Definition — specifying and modelling requirements, verifying and validating them, defining the architecture, defining design options and recommending a solution.
  6. Solution Evaluation — measuring solution performance, analysing results, and identifying limitations and actions to increase value.

Other parts of the guide:

  • The Business Analysis Core Concept Model, with six concepts: Change, Need, Solution, Stakeholder, Value and Context.
  • Underlying competencies such as analytical thinking, communication and business knowledge.
  • Around 50 techniques, including interviews, process modelling, SWOT and decision analysis.
  • Perspectives covering Agile, Business Intelligence, Information Technology, Business Architecture and Business Process Management.

Related IIBA certifications for career progression: ECBA (entry level), CCBA (for those with a few years of experience) and CBAP (senior practitioners), plus specialist certificates such as agile analysis.

How to use this in an interview: referencing the knowledge areas shows you see business analysis as a structured discipline. Pair it with a practical example, such as how you managed requirements through their life cycle on a real project.

Note: The knowledge areas are not sequential phases. On a real project you move between them continuously, for example returning to elicitation while defining designs.

46. What is a source-to-target data mapping, and what does a business analyst do in a data migration project?

In a data migration, such as moving from a legacy CRM to a new cloud platform, data must be extracted, transformed and loaded accurately without disrupting the business. The BA ensures the migrated data still means the same thing and supports the new processes.

A source-to-target mapping document defines, field by field, how data moves:

Source fieldTarget fieldTransformation ruleNotes
CUST_GENDER (M/F/blank)GenderM to Male, F to Female, blank to Not specifiedPicklist values agreed with business
DOB (DD-MM-YY text)Date_of_BirthConvert to ISO date; flag invalid datesTwo-digit years resolved by rule
ADDR1 + ADDR2StreetConcatenate with a space, trimMaximum length 255

It also records data types, mandatory rules, default values, lookup tables and how duplicates are handled.

The BA’s activities:

  • Data profiling — using SQL or tools to understand volumes, formats, missing values and duplicates in the source.
  • Defining business rules for transformation, cleansing and deduplication with data owners.
  • Scoping — which records to migrate: all history, or only active customers and the last few years.
  • Reconciliation criteria — record counts, control totals such as outstanding balances, and sample checks of individual records.
  • Supporting mock migrations and reviewing results with business users.
  • Cutover planning — freeze periods, sequence, rollback criteria and business sign-off.

Migration approaches: big bang (everything at once over a planned downtime) or phased (by region, product or customer segment), each with different risks.

Note: Treat personal data carefully during migration: use masked data in test environments, restrict access and follow data protection obligations. Poor data quality discovered late is one of the most common causes of delayed go-lives.

47. How do you read an entity relationship diagram, and what do one-to-many and many-to-many relationships mean?

An entity relationship diagram (ERD) models the data a system holds and how the pieces relate. BAs use ERDs to understand business data, validate rules with stakeholders, write accurate SQL and communicate with developers.

Key elements:

  • Entity — a thing the business keeps data about, such as Customer, Order or Product.
  • Attribute — a property of an entity, such as customer name or order date.
  • Primary key — uniquely identifies each record, such as Customer_ID.
  • Foreign key — an attribute that references the primary key of another entity, creating the relationship.
  • Relationship — how entities are associated, with cardinality (how many) and optionality (whether the relationship is mandatory).

Cardinality types:

  • One-to-one — one employee has one employee ID card.
  • One-to-many — one customer can place many orders, but each order belongs to exactly one customer. The foreign key Customer_ID sits in the Order table.
  • Many-to-many — one student enrols in many courses, and each course has many students. Relational databases cannot store this directly, so it is resolved with an associative (junction) entity, here Enrolment, holding Student_ID, Course_ID and attributes such as enrolment date and grade.

Reading crow’s foot notation: a single line means “one”, the three-pronged crow’s foot means “many”, a circle means “zero” (optional) and a bar means “at least one” (mandatory). So a bar and crow’s foot at the Order end reads as “a customer places one or more orders”.

Levels of data model: conceptual (main entities and relationships for business discussion), logical (all attributes and keys, technology-independent) and physical (actual tables, columns, data types and indexes).

Note: Cardinality is really a business rule. Asking stakeholders “can an order ever have two customers?” often uncovers requirements such as joint accounts or split billing.

48. What are business rules, and how do decision tables help a business analyst document complex rules?

A business rule is a specific, actionable statement that defines or constrains some aspect of the business. It exists independently of any process or system, which is why BAs document rules separately and reference them from processes and stories.

Common types of business rules:

  • Constraints — “A customer must be at least 18 years old to open a savings account.”
  • Computations — “GST is calculated at the applicable rate on the taxable value.”
  • Inferences — “A customer with more than ₹10 lakh in deposits is a Premium customer.”
  • Action enablers — “If a payment fails three times, lock the card and notify the customer.”

Decision tables document rules where several conditions combine to determine an outcome. They make logic complete and unambiguous, and they convert directly into test cases.

Example: personal loan pre-approval

Conditions and actionsRule 1Rule 2Rule 3Rule 4
Credit score 750 or above?YesYesNoNo
Monthly income ₹30,000 or above?YesNoYesNo
Action: outcomeAuto-approveManual reviewManual reviewDecline

Why decision tables work:

  • With n yes/no conditions there are 2 to the power n combinations, here 2 × 2 = 4, so you can check that every combination has been considered.
  • Contradictions and overlaps become visible.
  • Stakeholders can review a table far more easily than paragraphs of nested “if” statements.
  • Each column becomes at least one test case.

Good practice: give each rule an ID and owner, record its source (policy or regulation), keep rules in a central catalogue, and note which rules change often. Frequently changing rules are good candidates for a configurable rules engine rather than hard coding. The DMN (Decision Model and Notation) standard formalises decision tables for such engines.

Note: Interviewers like the testing link: decision tables give testers complete coverage of the rule logic with minimal effort.

49. What are Lean and Six Sigma, and how does a business analyst apply the DMAIC method to improve a process?

Lean and Six Sigma are complementary process improvement approaches, often combined as Lean Six Sigma.

  • Lean, from the Toyota Production System, focuses on removing waste and improving flow so every step adds value for the customer. Its eight wastes are often remembered as DOWNTIME: Defects, Overproduction, Waiting, Non-utilised talent, Transportation, Inventory, Motion and Extra-processing. Value stream mapping is its signature tool.
  • Six Sigma, developed at Motorola, focuses on reducing variation and defects using data and statistics. A six sigma process produces no more than 3.4 defects per million opportunities.

DMAIC is the Six Sigma method for improving an existing process:

  1. Define — the problem statement, goal, scope, customers and their requirements (voice of the customer). A project charter and SIPOC are typical outputs.
  2. Measure — map the current process and collect data to establish a baseline, making sure the measurement system itself is reliable.
  3. Analyse — identify and verify root causes using fishbone diagrams, 5 Whys, Pareto charts and data analysis.
  4. Improve — design and pilot solutions that address the verified causes, then roll them out.
  5. Control — sustain the gains with updated SOPs, control charts, dashboards, training and clear ownership.

Example: a bank’s credit card dispute process takes an average of 21 days. Define sets a target of 10 days. Measure shows cases wait six days for merchant documents. Analyse finds requests are sent by post. Improve introduces an online merchant portal. Control tracks cycle time weekly on a dashboard.

Where the BA adds value: process mapping, data analysis, stakeholder facilitation, requirements for system changes in the Improve phase, and defining KPIs for Control.

Note: For designing a brand-new process, Six Sigma uses DMADV (Define, Measure, Analyse, Design, Verify) instead of DMAIC. Mentioning the belt levels (Yellow, Green, Black) shows familiarity with the certification path.

50. What is the difference between project scope and product scope, and how does a business analyst prevent scope creep?

Product scope is the features and functions that characterise the product or solution, such as “customers can track orders in real time”. It is measured against the requirements.

Project scope is the work needed to deliver that product with those features, including analysis, design, build, testing, training, data migration and deployment. It is measured against the project plan.

A change to product scope almost always changes project scope, but project scope can also change on its own, for example when an extra round of security testing is added.

Scope creep is the uncontrolled growth of scope without matching adjustments to time, budget or resources. A related problem is gold plating, where the team adds extras nobody asked for.

How a BA prevents scope creep:

  • A clear scope statement listing what is in and explicitly out of scope, agreed with the sponsor. Out-of-scope lists are among the most useful lines in any BRD.
  • Link every requirement to a business objective, so requests with no objective are questioned.
  • Baseline and sign-off of requirements at an agreed point.
  • Formal change control for every new request, with impact analysis on cost, time and risk.
  • A traceability matrix to spot work that traces to no approved requirement.
  • Prioritisation such as MoSCoW, so new items displace lower-priority work rather than simply being added.
  • Regular stakeholder communication and demos, so expectations stay aligned and late surprises are rare.

Example: during an HR portal project, managers repeatedly asked for “just one more report”. The BA logged each request, showed the cumulative effort of eleven reports equal to a full sprint, and the sponsor agreed to deliver the three most important at launch and the rest in a later phase.

Note: In agile, scope is expected to evolve, but it is managed through the backlog and fixed-length iterations. The principle is the same: change is fine as long as its trade-offs are visible and decided on.

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as