[Top 80] Business Analyst Interview Questions and Answers
FULL TRANSCRIPT
hello there
if you have a business analyst interview
coming up shortly
then this is the video for you over the
last two years
we have published several videos on
business analyst interview preparation
we have merged the key questions into
this single video
we have covered 80 plus questions
ranging from stakeholder management
requirements agile methodology sql to
testing in this video
this video is ideal for your preparation
just the day before your interview when
you are short of time for it
go over this video and attend the
interview with confidence
the video is split using chapters for
easy navigation to your interested
section
if you have not already subscribed to
our channel please go ahead and
subscribe to our channel
and hit the bell icon we have lots to
cover
so let's get started
do you have a business analyst interview
coming up shortly
if so this is one of the videos for you
in this video we are going to cover the
top eight interview questions
pertaining to stakeholders identifying
and
engaging stakeholders is the vital part
for the project's success
and one of the key activities for a
business analyst
and hence interviewer would be keen to
know the list of stakeholders you have
interacted with
how you identified them and also the
challenges you faced while interacting
with them
we are going to cover these questions in
this video so
stay tuned if you have not already
subscribed
please go ahead and click on the
subscribe button and the bell icon
so that you are notified when we post a
new video
and we post regularly on business
analysis interview preps skills and
techniques
okay we have got a lot to cover so let's
get started
as always we will use a simple case
study which will
make the concepts easy to grasp rahul is
a ba
working with a client running a
restaurant called wagon gardens
the client is looking for a mobile app
which will allow their customers to book
a table
let us use the simple case study and see
who the stakeholders for this project
are how to identify them and the
challenges faced while interacting with
them
question one who is a stakeholder
stakeholder can be defined in simple
terms
as a party who will be impacted with the
change
they can be classified under two
categories
who receives the benefit and who will
deliver the change
who receives the benefit these are the
end users
customers business unit managers
operation team manager and so on
and who will deliver the change this is
the project team
ranging from project managers developers
testers trainers and so on
moving on to question number two who are
the list of stakeholders you have worked
with
this question is asked by the
interviewer to know the depth of your
interactions
we can cover the various stakeholders
here again
look at from our classification earlier
for the first category who receives the
benefit
it comprises of business unit manager of
the unit which gets benefited
in our example it would be the sales
department manager
who would be benefited by this change as
it would help to streamline
and ease stable booking for the
customers which should result in
increase in the number of visitors
boosting sales
and also helping saving cost by reducing
the number of people
allocated for taking phone reservations
the next would be the customers in the
example again
the customers who have to call and wait
for making the table reservations can do
so
just with the touch of few buttons in
their mobile and can get a table booked
with
instant confirmation sent to them
this solution would also benefit the
staff at the hotel
who are also using the staff and of the
application
for viewing the customer reservations
all the manual tasks for
checking the availability and making the
list of reservations for the given day
have all been automated and this results
in
increased staff efficiency
subject matter expert they are usually
part of the business unit operations
team
who have been working on the current
system and process
for a considerable amount of time and
are usually
experts and can provide guidance on the
current state
and also help to identify problems and
provide
recommendations on the target state
the last category is regulators
they are regulating body who ensure
compliance in our example
they may not be appropriate but just
wanted to list
as they are also a key stakeholder
so as part of the requirement gathering
sessions
the above stakeholders are your key
people you need to engage
and gather the requirements as you would
be working to satisfy their needs and
objectives
coming to the next category who delivers
the change
this includes the business sponsor who
is responsible for funding
and delivering the change and is your
key stakeholder
to engage when you are stuck or you need
guidance
and also sponsor would help in
identifying the stakeholders
next we have the support business units
like legal and marketing units
they will also provide further guidance
on shaping the change
to ensure we are covered from all the
angles
the rest of the people are what is
generally termed as the project team
project managers can be one or more
based on the scale of the project
they ensure the project gets delivered
as per the deadline
and are responsible for the plan
then we have the developers and testers
to develop and test the software
in accordance with the functional
requirements
lastly the trainer who is responsible
for training the staff with a new system
in our example trainer can be a senior
person in the staff
who would be responsible for training
the staff with navigation and working of
the new system
and also creation of standard operating
procedures
ba works with them by providing working
screenshots of the system
and also help to draft the standard
operating procedures
this covers more or less the list of
stakeholders
and when you are explaining you can use
your project examples and go over
question number three how do you
identify stakeholders
this is another commonly asked question
the interviewer would ask once you join
the project
what would be your approach for
identifying the stakeholders
listed below are a few techniques first
one
contacting business sponsor you can get
a list of stakeholders
by contacting the business sponsor you
can also check with the project manager
who would be able to help you with the
stakeholder list
second one organization charts
you can use the organization charts of
the impacted business unit
to identify the stakeholder list
third one process models
in complex environment where the process
is handled by multiple teams
if you can look at the process models it
would have to identify the impacted
teams
fourth one document analysis
if you look at the existing documents of
your organization
you can get the stakeholder list from
there
fifth one also when you are meeting the
identified stakeholders
they will also provide some names during
the discussion
and that is another source of getting
the impacted stakeholders
in our case study since it is a small
team of people
the business sponsor in our example
would be the owner of the restaurant
chain
who would be able to provide the names
of the managers
from sales and operations teams and also
based on the discussion with them we can
get additional names
moving on to question 4 what would
happen if you miss a key stakeholder
the interviewer might ask since there
are a lot of stakeholders in a complex
program
and missing one of you is possible and
what do you think will happen if
we miss again it's a good question
which emphasizes on the stakeholder
management
the answer is the solution which we are
developing
may not go live until the requirement of
the missing stakeholder
is taken care of causing delays and it
may also result in development
and testing rework as it may have an
impact on the existing functionalities
let us take an example from our case
study
what if we did not engage the operations
team on the ground
who is involved in seating of the
customers
their requirement could have been to
have a screen which shows the list of
reservations for the given day and the
allocated table numbers
in case this is not built even though
everything is ready from a customer
perspective
we still cannot go live with the
solution until this is built
this would result in developing the
screen near to the goal life
causing delays and reworks hence it is
very
important to identify all the impacted
stakeholders at the beginning phase of
the project
question number five what is a racy
matrix
racy matrix stands for responsible
accountable
consulted and informed it provides a
view of the responsibilities of the
involved stakeholders
let us take the requirements task in the
table as an example to walk through
first one is r which is responsible
this indicates the person who will be
performing the task
as you're all aware business analyst is
a person
who will be gathering and documenting
the requirements
hence in the table if you can see under
the requirements task
it is marked as r for the business
analyst
next is a or accountable
this is a person who is accountable for
the task
in our example business analyst is
responsible for gathering and
documenting the requirements and the
project manager is accountable
to ensure it is done within the agreed
timelines
project manager is ultimately held
accountable and answerable for the
successful completion of the task
next in the line is c which stands for
consulted
this stands for the stakeholders who
will be asked to provide
information or guidance about the task
in our example sma group is marked as c
as they would be the participants of the
requirement gathering sessions
and the ones who provide the
requirements to the business analyst
next in the list is i which stands for
informed
this is the next group of stakeholders
who need to be informed
in our example i have marked the
technical lead and test leads as
informed as they have to be kept
informed about the completion of the
requirement gathering
question number six what is a
stakeholder matrix
stakeholder matrix is a list of
stakeholders
as you can see on the slide it has the
following details of the stakeholder
like
name role they contact details
impact to them due to the change and
also their influence to shape the change
let us look at the example matrix
created for our case study
we have john who is the restaurant owner
and sponsor for this project
who has high impact and high influence
you have to work closely with him and
ensure you have his agreement and
support on all aspects of the change
next we have jane who is the operations
manager
the change has high impact on her as she
and her team needs to adapt to the new
ways of looking
up at the reservations and using the
tool to seat the customers
but she does not have high influence
however she and her team are also key
end users of this
staff side of the application and rahul
rba from the case study
should engage and understand their needs
and interests
they can become the goodwill ambassadors
for the change
next up in the line we have sean who is
one of our
chefs and one who gave a tour of the
kitchen and
walked through of the menu when rahul
visited the restaurant
as there is a next change proposal to
enable online delivery
but from the current change there is not
much impact to sean
and hence from an impact perspective we
have
none and also he has low influence
he just have to be kept informed at the
most on what is happening on the change
then we have kelly who is the finance
manager
she has no impact directly due to the
change
but has high influence as she holds the
budget
the ba should meet and ensure she is
believed and
rally up her interest in this change
question number seven what are personas
personas are fictional characters which
represent your typical customers
they are helpful to understand the
customer's needs
and build the product accordingly first
off
personnels will be created based on the
brainstorming ideas by the internal team
and post that research is conducted with
the actual customers
to validate the team's assumptions using
a number of requirement gathering
techniques
identifying and validating the needs of
the personnel
are very important to ensure we are
building the product
which satisfies their need let us take
two personnels for example
first one the office manager
this is a typical manager who has number
of team members reporting to him
there would be quarterly or sometimes
monthly team outings
and the manager is responsible for
looking for the fun places
to have a team lunch or dinner their
needs
are quick snapshot of the service
offerings
and also a receipt of the bill emailed
to them
so that they can do claims for
reimbursement
as all the outings are built to the
company
second one is the family man who wants
to book on the weekends for a brunch
lunch or a dinner he does not care about
the digital copy of the bill
but is very keen on the services offered
for
the kits and the seating arrangements
if you see just going at the high level
we have got two requirements
first one soft copy of the bill to be
emailed as a pdf
second one the service offerings should
be shown in the booking app or the
website
again these two are just assumptions and
have to be validated
based on the actual customer research
moving to the last question in the
series question number eight
tell me about a time when you managed a
difficult stakeholder
this is a very common question and i
have just listed two of the common
scenarios i bet you would have faced one
of these in your project you have worked
on
the first one is the conflicting
stakeholders
this is very commonly faced where the
key stakeholders are not agreeing with a
decision or an approach
and without their agreement we cannot
move forward
one of the things which works in this
scenario is
meeting them separately and identifying
their concerns
and work on mitigating the same
in our case study let us consider a
scenario
where the sales department head wants to
only focus on having the website or the
application
for the customer to make the booking but
the operations head wants to have
a fully functional staff facing portal
to help the staff
for which the sales head feels is a
wasted effort
rahul rba can meet both and try to
facilitate an agreement
as you see both of them from their point
of view are right
here rakhi can meet them separately and
understand their concerns
and explain a workable approach which in
this case can be
in addition to the customer facing
website and application
a minimalistic staff facing portal with
only some two to three key functions can
be considered
this would be a win-win situation for
both the parties
second one is unavailability of
stakeholders
this is a very common problem you invite
the key stakeholders for meeting and
they don't turn up
they don't return your phone calls or
your emails
there are two approaches for working
through this situation
the first one can be in the
communication to the stakeholder
whether it is an email or a voicemail
you can explain the importance of the
project
and the impact and the benefit the
change will have on their department
this usually works by getting their
attention
second one can be approaching
to connect you with their deputy or any
other team member
who can help if they are busy at the
moment
this is a common issue when dealing with
senior stakeholders
and the about two approaches work like
charm
use your project experience and see if
you can link them to
these two categories while answering
hello there do you have a business
analyst interview coming up shortly
if so this is the video for you as you
know
a key responsibility or a skill for a
business analyst
is to elicit document and maintain
requirements and this video is going to
help you to discover the top
9 commonly asked questions in business
analyst interviews
on requirements so that you are well
prepared
to make it easier for grasping the
concepts and the answers
we're going to use a case study in this
case study uh
a movie theater chain called xyz cinemas
is looking to build a digital channel
for allowing the customers to book their
movie tickets online
rather than calling up the customer care
or standing in the long queues and
getting their tickets
at the ticket counter so we are going to
use this
example case study for answering all the
questions
question number one how do you define a
requirement
as per babblock version 3 a requirement
is defined as a usable representation
of a need to simply put a requirement is
articulation of a business need for
solving a problem or capitalizing on a
business opportunity
this representation is actually required
for the engineering team to develop the
solution
accordingly to meet the business need
i've listed few of the examples here so
these are
different types of requirements which
we'll be covering in this
video i just listed it here to
give you a view of the requirements so
number one
sales department needs a digital channel
for allowing customer
customers to book their movie tickets
online basically it's expanding on the
case study
then the system shall display the
available seats for a movie show
systems shall allow the customer
customers to select the available seats
a system should respond within two
seconds of a user's input
a customer can book a maximum of 10
tickets
at one time so these are all different
statements
as i was stating earlier you know these
are all different types of requirements
which we'll be
covering shortly the nature of the
representation may be a document or set
of documents and it
varies depending on the circumstances
and the methodology used in developing a
solution
we're going to cover this in question
number nine so
stay tuned
question number two what is the
difference between a
business and a functional requirement
this is one of the tricky question
which is asked in the interview i'll try
to simplify it
using the below two tables first off
business requirement business
requirements are
basically representation of a business
need
goal objective or outcomes it represents
the what
example sales department needs a digital
channel
for allowing customers to book their
movie tickets
it's very high level and it just
represents
what is required by the sales department
it doesn't give guidance on how it can
be achieved
it just represents the what functional
requirements
on the other side they describe what
a system must do to achieve the business
requirements
it represents the how example
the system shall display the available
seats
for a movie show the system shall allow
the customers to select the available
seat
ideally it talks more on how
to meet the business requirement and you
can see
it kind of ties back into the business
requirement
question number three what is a
non-functional requirement
so this is this question can be asked as
a standalone question
or it can be also stated as can you tell
the difference between a functional
and a non-functional requirement so
we're going to cover that in this slide
non-functional requirement is a quality
requirement or a constraint
to the solution so it covers the
following aspects
so first one is performance so what
should be the response time
for a system to respond to a user's
input so that is captured as part of a
non-functional requirement related to
performance second one would be security
how
secure the system or the solution should
be
third one would be the reliability so
there are a few applications or systems
which should be
up all the time so it can we can state
that the system
should be available 99 of the time
so this would be a reliability uh
non-functional requirement which can be
captured
then the next one would be usability how
uh how easy it is for the users to use
the
system on the solution which we're
developing the next one would be
maintainability
how easy it can to maintain this
solution and on the last one would be
related to portability so these are some
few aspects which we are
going to document as part of as a non
nfr which is non-functional requirements
for the solution which is being
developed so let's
look at an example the system should
respond within
two seconds of a user's input so which
is a performance
nfr so as we discussed
uh in the previous slide regarding the
functional requirement
for the system to display the
available seats so if you try to put it
together
so a customer should be able to click on
a movie show and within two seconds the
system should
show them with a list of available seats
so that's how we are
you know tying it together to have a
great customer experience
question number four what is a business
rule
this is a question where most of the
people get it wrong
uh so let me try to simplify this
as per babblock version three a business
rule is a specific
testable directive that serves as a
criterion
for guiding behavior shaping judgments
or making
decisions that's a little complex
definition
but to simply put a business rule
is a criterion or a constraint which has
to be
followed by the solution or the system
which we are
building so for example the xyz cinemas
they had a business rule that a customer
can book only up to
a maximum of 10 tickets at a single time
while calling up the customer care or
standing
in the uh line at the ticket counter
so this ensured that you know there are
plenty of tickets available for
everyone so this business rule has to be
taken into consideration while uh
developing
this digital or solution digital channel
so this gives rise to a functional
requirement for restricting the number
of seats which a customer can book at a
single point of time
so for example it can be stated as such
like this the functional requirement
that
the system should not allow the
customers to select more than 10
available seats
so this is a restriction which we are
capturing as part of
a functional requirement which was
basically divide
sorry derived from a business rule
question number five what are the
requirement elicitation techniques you
have used in the past
i can bet you 100 percent that this
question
will be asked in each and every business
analyst
interview the reason as i stated earlier
elicitating requirement is one of the
key skill and query responsibility
of a ba and the interviewer would
definitely love to hear
how well you have done it in the past
and also what are the different
techniques which you have used
i've listed most of the commonly used
techniques in this slide and we're going
to cover
uh them one by one the first one is
the workshop this is one of the highly
recommended
technique for gathering high quality
requirements in a short span of time
i've already made a video on how to run
a successful workshop
and gather requirements in less than one
session
you can check out in the link below in
the description link below
so uh taking example of xyz cinemas if
you want to
uh perform a you know capture
requirement
so using workshop technique then you
have to invite all the key people or
smes from
the sales department you know customer
care department
ticket counter finance so all the key
people from different
departments who are involved in this
particular digital solution
so you can get everyone into a single
session
in a room it can be a few hours or even
it can be a day
if they are spread across it can be done
by a video conferencing or web
conferencing so you have all the
participants and you can get
the requirements uh on their views on
how the digital solution would be
and it can be captured and you know for
further
solution development second one is the
intro interview technique so in case if
you're not able to get
all these different people from
different departments
at a single session then you can
schedule separate interview sessions
with
each of them and try to gather the
requirements
which they need from this digital
solution so it can be done on an
individual basis and if that
two or more people available it can be
done as a group
interview as well so again this is also
one of the commonly used
technique for capturing uh requirement
or elicitating requirements
the top one would be observation uh it
can be passive or active so observation
if you take an example
uh you can walk down to the ticket
counter and and you can see how
the staff is getting the request from
the customer
and issuing the tickets like it can show
which seats they want
uh how the customers select so all these
things can be
observed and it can be translated
uh as a requirement for the digital
channel to kind of mimic this uh
process so there as i stated that two
types of pa
ah observation passive and active
passive is
you just stand there and observe and try
to gather as much information
or requirements and active as you stand
there
observe but now you can ask question to
the staff who's issuing the tickets or
who's doing it's
like why are you doing it this way is
there a reason
you know it provides more insight and it
can be
kind of translated to the requirements
for the digital
channel the fourth one would be the
document analysis so this can be
the documents which are available on the
process it can be the procedures
it can be the business rules so the
business rule which we kind of spoke
about in the previous question
would be uh you know would be found out
from this document analysis technique
and it can be translated to a functional
requirement
the next one would be the focus groups
and the brainstorming
they're more similar to workshops and
it's again
done in a similar way brainstorming is
more of
taking one item and trying to get
the ideas and the views from people and
kind of ranking it them
and then translating into requirements
and also the
priority of them the next one would be
the process analysis
so the process analysis is
looking at the looking at the end-to-end
process
if it's already one if it's already
there if not creating one and then
meeting up with the stakeholder and
showing them okay this is the process
flow
what all the uh things you need from a
digital solution which you are building
okay so this is also a good way of
capturing the requirements
looking at the end-to-end process so you
don't miss out
on anything the next one would be
prototyping again
if let's say if you want to look at the
detailing of the digital solution you
can do a mock-up
of the screen navigation flow and then
you can walk up to the stakeholders and
ask
okay in the screen what all the elements
do you need
is this better or do you need a
different color to kind of
sync up with your brand so all those
detailing uh
can be achieved using the prototype
technique the last one would be surveyor
questioner
this is again used only if you want to
collect
the response from a huge number of
stakeholders for example
if you want to get a view of which of a
feature would be beneficial
for the customer so you can just draft
few of the
questions and send it across to the
entire
sales department or customer care
department and then they can
select the options and then you can get
it back and that can be used
for framing the requirements and also
prioritization
so these are some few uh techniques
which i've covered
definitely this is a question which
would be uh coming up
so this can be used by
you know you can answer these questions
by using some experience from your
previous projects
question number six what is the
difference between verification
and validation of a requirement another
tricky question
so verification refers to ensuring that
the requirement meets the quality
standards
that is whether the requirement is clear
is it consistent with other requirements
there's no contradiction
whether the requirement is complete
whether it is
testable whether it is unambiguous
and also whether it's understandable to
all the stakeholders involved the
development team the
testing team so it ensures that the
the quality of the requirement is
is good enough for the uh the
engineering team to proceed with it
validation on the other hand refers to
whether the requirement
is kind of aligned to the business need
goal
or outcome and whether it really
supports
the needed value so let's say in our
example if we take a requirement which
talks about allowing the customers to
book refreshments
uh over a digital channel it's a good
requirement
and you know it it kind of
satisfies the verification criteria but
uh whether is it aligned to the
the business need or the goal of a
digital channel to low customers to book
tickets
no it's a good feature but it's not
really aligned to that particular high
level business
requirement hence you know when
the validation process takes place this
kind of requirement is
termed as low priority and can be
revisited once the
the key requirements are delivered
question number seven what is rtm or
requirement traceability matrix
so this is one of an important tool or
technique
which is used to trace requirements
so this provides backward and forward
traceability
as shown in this diagram and it helps
faster impact analysis and reliable
assessment
to ensure that all your business
requirements are covered
so if you look at this example uh rtm or
requirement disability matrix
so the business requirement uh will be
mapped to
the stakeholder requirements uh sql
requirement one and two
so in our example if you if you talk
about the digital channel for allowing
customers to book
tickets the stakeholder requirement
number one can be related to the
customer facing
screens and how they can how it allows
and the other stakeholders who can be
involved would be
the backend team or the back office
operations team
and what are the requirements from their
side to process the
customers online booking so that's how
the different stakeholders will have a
different set of requirements so the
first level of mapping would be
with respect to the business requirement
and the stakeholder requirements
and then the stakeholder requirements
would be mapped to the functional
requirements
and also the non-functional requirements
which we spoke about
and then the functional requirements or
non-functional requirements in turn
would be mapped to this design component
okay in order to deliver this
functional requirement what are the
design components required
so if you take an example of the screen
to show the customers the list of
available seats
so the design would involve uh different
screens
and also the the the logic for
uh showing up the available seats so
so that all comes under the design and
then
the design component maps to the the
code
so in which a particular language
the the co the code is there it may be
java.net
or it can be any other new technologies
like python
so all of this programming comes under
the code and it is mapped to the
design component and once the code is
kind of completed and then it's maps to
the test case
so the test case would ensure that
the code which is developed works
accordingly to the
requirement so this kind of gives an
end-to-end
mapping to ensure that a business
requirement is
kind of developed and
tested so it's a very useful tool and
this is one of the key things which
also use on a day-to-day basis and it
can be
asked in an interview
hello there requirements prioritization
this has been a challenge for every
business analyst
and it is going to be a challenge in the
future as well
because the business stakeholders they
want
all the requirements delivered as soon
as possible immediately possibly
in the single release we know that's not
going to happen
if you're having trouble convincing the
business on the requirements
prioritization
or you would need a technique or a
guidance on
on the prioritization of the
requirements this is the video for you
in this video we're going to cover the
four key requirement prioritization
techniques
which will help you to communicate with
the business
and get the highest business value items
delivered
first so we are going to cover these
four key thing four key prioritization
techniques
so a lot of cover we can get started but
before i do
i just wanted to tell you that this is
one of the video
in the business analyst techniques video
series so i've listed the other videos
in the description box
so please feel free to go and check it
out and also
if you haven't already subscribed to our
youtube channel or you're seeing
the video for our video for the first
time i will request you to go and hit
the subscribe button and also
the bell icon so that you'll be notified
when we do a new video
we do a weekly video on business
analysis techniques
tools concepts and also the
interview questions so let's get started
on the requirement prioritization
techniques
as always we'll be using a case study
and
using the case study we'll be driving
the concepts of requirement
prioritization
again this is a case study which we have
used in several of our videos because
it's very simple and easy for everyone
to understand
but if you want me to use a different
case study open to suggestions
please feel free to comment your case
study idea in the comments
section and we will pick it up for the
next videos so
in this case study a movie chain named
xyz cinemas they're looking for a mobile
app
which will allow their customers to book
movie tickets online simple as that
they don't want the customers to stand
in the queue they just want
the customers to use their mobile app
book it and what
enjoy the the movie so the features of
the app which
which the client is looking for are
registration customer registration
login feature the ticket booking
booking ticket feature and seed
selection
so ability for the customers to select
the seats
in the theater online payment
and again number six is more of uh
ordering uh refreshments like popcorn
coke
if in the app itself so that they don't
have to stand in the
line for buying these and the seventh
feature they're looking for is
once the refreshments popcorn or coke
are ordered
it can be delivered to the seeds where
the customers are booked using this
particular
online app so it's a very good feature
set uh
making the customer's life easy so this
is the features
so let's say how how we will be using
the requirement prioritization
to deliver these features uh released by
release
i i know it's good to have everything at
one shot but again
we know it's not feasible so let's see
how we can use a different requirement
prioritization technique
to prioritize and deliver these in a
release wise
okay let's get started with the first
requirement
requirements prioritization technique
called moscow
it's one of the most commonly used
technique
worldwide the requirements are basically
classified into must
should could and would must are your
mandatory requirements
without which there is no point in even
having a release
so they are the highest priority items
which has to get in
the next comes the should they should
are basically they're also high priority
items
but even if they're not delivered in a
release
there are workarounds through which uh
you know
the same functionality can be uh can be
satisfied
and then we have the good and wood so
basically good and wood are
nice to haves it's it's good to get them
into release but if
you know if you're not able to make it
that's okay we can defer it to the next
release
so let's see how we can apply this
moscow to our example
case study so if we if we
prioritize the requirement requirements
so the registration the login
and the book tickets are the must you
know it's
the key key things like the purpose of
the app is
for the customers to book the tickets
online
and the registration and login
are a pretty precursor basically
in order to book the tickets right whom
are we booking against if they
generally build do you even create an
account and then
uh the seed selection and make payment
agree they're again high priority
requirements but without
the ability for the customer to select
the seats or make online payment
they can still book the seats uh online
right the seats will be randomly
assigned based on the
best possible uh you know fit for the
number of seats
and also the payment they can walk in
and pay the cash
i understand it's not a you know best
customer experience
but you can still go hard if you just
have the book ticket
feature and the registration login
working fine
seed selection and make payments can be
handled
as a workaround you know with the with
the cash as we just uh talked about
and then we have the buying of the
popcorn coke
and having them delivered to their seat
yeah it's really you know it's really
nice to have
but it won't stop the release because
the purpose of the app
is not to uh for the customer to order
refreshments
but it's basically booking the tickets
online
so that is the purpose that's the reason
this these two things will become
good so now if we have this list
sorted mastered and could it's better
when you have a discussion with the it
okay you know what these are are must
these are should could
and you know if if we have that clarity
it's it's both good for the from an idea
perspective to get the built-in also
it's good from a business perspective
because we are
uh highlighting to the business that the
higher value items are being
delivered first so it's a win-win in
either way
okay moving on to the next technique on
our list
the next technique is called ranking so
these are again another
commonly used technique basically this
comes into place
when let's say we have like 10 must
and then the problem again now comes is
it would have bandwidth only for let's
say
seven of them so again we are in a fix
as we have stated in the previous
technique
all the must should make it to the
release but now
we are going to prioritize further so
that is where this technique comes into
play which is called ranking
here you rank those requirements from a
scale of one two
two three four five six and so on and
the smallest rated requirements has to
go in
first so if we apply this technique to
our case study
it would look something like this so the
registration is first then the login
we have the book tickets functionalities
number three
then the seed selection make payment by
refreshment refreshment server to the
seat
so this is another another way or
another technique of basically ordering
uh ordering the the requirement
uh requirements or the product backlog
because sometimes what will happen is if
you go to the business and we still
explain them you know must should then
could
they will again tell you know what all
these tens are must
so it will be again a bottleneck will be
a difficult situation
so in that scenario you can use this
technique okay we understand these are
must
let's try to rank them when we rank them
they'll be much more clarity on the
highest value or higher value items
so that again this clarity will help to
get those higher value items
delivered again a very useful technique
and used again commonly worldwide
okay let's start to look at the
requirement prioritization number
technique number three the canon
analysis so again this is a different
view of looking at the requirements and
we're going to look at it
exclusively from the customer's
perspective who's going to use the
product
so here there are three factors one is
the basic factors
performance factors and excitement
factors
basic factors are something like if you
don't have the feature in the app then
the customers are straight off
disappointed they won't even use
the particular app or an application
and then we have the performance factors
so which are basically
the drawing factor for the customers to
use the
application or the app and then they are
the the next one is excitement feed
factors so these are basically your
differentiator from the competitors
and your usp or unique selling
proposition so customers will be like
very excited to use the app
or the application because of these
particular
features so let's try to apply the canon
analysis
to our case study so it looks something
like this
the registration login book tickets
pretty
basic without them there is no point
even even using the app because if
you're not able to book the tickets why
are we even using the app
and then seed selection and making
online payment
yep it would be a you know customers
would be really happy to use this
because
they have the ability to select the
seats and they don't have to stand
in us in a line again to pay for the
cash
so they'll be happy to make an online
payment just then
get onto the theater just walk in and
then
the refreshments and the refreshments
sir to the seat
that would be an excitement uh factor
basically
the the reason for uh uh you know the
the the reason for this is basically
well again there is a queue for buying
refreshments
so if you're able to do that using the
app then it's like
you just walk in after doing the booking
the you you've selected the seats you
made the online payments
and then when you arrive uh at the time
of your choosing
you're getting your popcorn coke you
don't have to stand anywhere
no line nothing everything is taken care
so that is basically
you know it the customers will be
excited to use this particular
feature and because of this there will
be more people
being driven into this particular cinema
so it
will increase the revenue so so these
are some things it's a basically a
different
lens of doing the prioritization so it's
called the canon analysis and it is used
it's looking mostly from the customer's
perspective
and the last technique we have on the
list is called
user story map so basically i've
i've covered thoroughly taking in
another case study in one more video
i'm going to link it in the description
box so please go and check it out
where you will be uh shown how to build
a story map from scratch
and then to do the prioritization so
it's basically a visual representation
of your entire product backlog from
the the activity sequence of a user so
in our example would be the customer
when they
order the book the tickets online
and the time they you know they walk
into the movie theater watch the movie
and then get out so this is a basically
a customer journey we call it
and there will be tasks below it
so those would be your you know the the
user stories so basically if you put
this in a map
like some somewhat we show this this is
a basically an example of
a online home delivery ordering service
so you will be able to visualize it
better and the business will be able to
visualize
it better because they will be able to
see the end-to-end picture rather than a
sequential list
and then we can go again and you know
check with the business okay this is how
it is
can can you please you know which would
be the highest benefit
we can put put put the put the
requirements
in so the release one as we see here
it's called the mvp or the minimum
viable product
so that is like without which you cannot
even you know go in and then similarly
the other requirements are prioritized
to release to release three
it's a similar to what we have seen uh
in you know in the previous techniques
but again this is more
visual and gives an end-to-end view for
the business
which the other techniques won't give so
again it's a very useful technique for
them to understand and provide the uh
you know the priorities
so you're basically assisting them to
see the end-to-end feature and which
will be really appreciated
so these are the four techniques and uh
what we are going to do is i provided a
link in the description
for kind of downloading a quick cheat
sheet so you can download it keep it for
your reference
and start using it in your day-to-day
job when you're dealing with the
requirements and prioritization
hello there in this video we are going
to cover questions
pertaining to requirement gathering or
elicitation
which is one of the key skills for a
business analyst
in the previous video we discussed
identification
and types of stakeholders which is the
first key step for business analyst
post onboarding to a project once the ba
has the list of stakeholders
the next step would be to engage them
using different requirement gathering
sessions
to gather the requirements we will cover
the techniques used for gathering
business requirements
in this video and will focus on
techniques for functional requirements
in the next
video so let's get started with the
video
as always we will use a simple case
study
which will make the concepts easy to
grasp
ravel is a ba working with a client
running a restaurant called
wagon gardens the client is looking for
a mobile app which will allow their
customers to book a table
moving on to question 1 what are the
requirement elicitation techniques
you have used in the past this is one of
the most commonly asked question
and listed below are the commonly used
requirement elicitation techniques
some of them are document analysis
workshops interviews
observation focus groups
brainstorming process analysis
prototyping survey or questionnaire
we will discuss these techniques in
detail in the upcoming
questions based on your answer
the interviewer will ask deep dive
questions on the techniques
which you would have mentioned that you
have used so make sure
you tell the technique which you have
used
question 2 what is the first elicitation
method you would use
the answer in my view would be document
analysis
this involves reading the existing
documents available
related to the project which you are
working on
this will help to provide context and
background while engaging with the
stakeholders
through other elicitation techniques
this will help you to identify the
current state and the problems faced in
the current business unit
process and others going back to our
case study
rahul our ba on the project can request
for
and look into the below documents before
engaging with the stakeholders
organization chart this would give the
background of the people
and business unit structure as vegan
garden restaurant has several branches
the organization chart would provide
information
on number of branches and names of the
key people in each branch
user manual and standard operating
procedures
this would give rahul a view of how the
current table booking process works and
which system is used by the staff
so rahul will be familiar with the
current systems and have a better
understanding
while speaking with the stakeholders
rahul can also look at design documents
technical documents
process flows problem reports
business rule documents or any
previously captured requirement
documents
which would help as stated earlier in
understanding the current state
and context of the new project
let us look at question number three in
your opinion
what you think is the best elicitation
method
there is no right or wrong answer you
can answer based on your experience
in my view the best elicitation method
is the workshop technique
as you can gather high quality business
requirements
in a short span of time with a variety
of stakeholders
the workshop technique involves getting
all the key impacted stakeholders
from different departments together for
an extended period of time
like a day or two to go over the project
details
and understanding from each of them what
they are looking for
as an outcome since we have the key
stakeholders present
any conflict can be resolved impacts can
be identified
and can easily gain agreement from all
the stakeholders at the same place
we will discuss this technique in depth
in the next question
question number four can you tell me
about a time when you conducted a
workshop
if you have answered that you have used
the workshop technique
then interviewer might ask this question
to get an insight into your experience
for every requirement elicitation
technique as mentioned in baboch version
3
it has three phases prepare
conduct and post the session
let us consider the workshop in context
with our case study
rahul rba is going to use the workshop
technique
for gathering the business requirements
for the online table reservation system
first off rahul needs to prepare for the
workshop which includes
setting a clear purpose which is to
gather business requirements for the
table reservation system
identifying the key stakeholders and
ensuring
they are available to attend the
workshop the key stakeholders would
include the sponsor who is the owner of
the restaurant
the business managers from different
branches and
senior operations staff who are involved
in the table booking process currently
once he has the list of the key
stakeholders he would schedule
a place and time convenient for all the
key stakeholders
usually workshop is a full day or two
days event
the venue should have all the facilities
like whiteboard projector
adequate seating etc and refreshments
like coffee snacks should also be
arranged rahu chooses his company's
conference room which has a seating
arrangement for 15 plus people
and invites the key stakeholders there
for a full day workshop
he has also arranged for lunch and other
refreshments
next off rahul would make and share the
agenda with the attendees
agenda will have sessions or activities
for that day
so that the stakeholders come prepared
sample full day agenda would be like
this
9 to 9 30 introductions can happen 9 30
to 11 15
walk through of the current process 11
15 to 12
break 11 30 to 1
discussion on the target process design
1-2 lunch break 2-4
gathering the business requirements for
the target
4 state 4 30 they can have a short break
and again 4 30 to 5
they can have a playback session
the first stage is key if the
preparation is good then conducting the
workshop is pretty easy
moving to the second stage conducting
the workshop
the stakeholders meet at the venue on
the day of the workshop
and rahul uses the agenda shared earlier
to drive the workshop
and will try to adhere to the agenda as
close as possible
as the workshop progresses rahul
documents the discussions
requirements and actions if help is
available
one can also use them for documentation
during the workshop
they are referred to as crime
the last stage is post the workshop
which would
include activities like closing out any
open actions
raised during the workshop rahul can
then share the captured business
requirements for sign off to the
stakeholders
if required rahul can arrange a review
session with the stakeholders
to walk through the requirements
captured for obtaining a sign off
moving on to the next question question
number five
what are the challenges faced while
using the workshop technique
and how would you mitigate it this is
another follow-up question
asked on workshop the major challenge
would be non-availability of the key
stakeholders
getting all the required people together
for a day or two
is by far a difficult task
some mitigation would be the below
approaches
number one explaining the importance of
the workshop
and how it will help to shape the system
which they are trying to build
number two rescheduling to a suitable
time
so that everyone can attend number three
in case a key person is not available
then asking them to send their deputy
or a representative from their team
if still we are unable to get everyone
together then covering
off with the key stakeholders individual
interview is an
option which will cover in the next
slide next question
question number six can you tell me
about a time
when you conducted an interview if you
have answered that you have used the
interview technique
then interviewer might ask this question
to get to know more about your
experience
like we spoke for the workshop the
interview elicitation technique has
three phases prepare conduct post
decision
let us continue with our case study and
say one of the key stakeholder jim
who is the manager of customer support
could not attend the workshop
rahul would then use the interview
technique for sharing the outcome of the
workshop
and gather any missing business
requirements from the customer support
perspective
first off rahul needs to prepare for the
interview which includes
setting a clear purpose which is to
gather business requirements from a
customer support perspective
schedule a place in time convenient for
jim to attend
next off rahul would make a list of
questions
like what the customer support staff
would like to see in the new system for
answering the customer queries
what are the functionalities required in
case there is change required by the
customer
and so on and shared these questions in
the meeting invite to jim
so that he can speak to the team up
front and
have the answers ready as stated earlier
first stage preparation is always the
key if the prep is good
then conducting the interview is pretty
easy
moving to the second stage it was agreed
to have a discussion
on the conference call and both rahul
and jim
joined the call for the interview rahul
briefly touched upon the outcome of the
workshop
and then used the questions shared
earlier to drive the interview process
rahul used active listening techniques
and made notes
on the discussions requirements and open
actions
once all the questions were covered
rahul thanked jim for his time
and informed that he will share the
minutes of meeting and also the
requirements captured
for his review and sign off post the
workshop
rahul shared the minutes with open
actions
and also shared the requirements
captured for review
and sign off moving on to the next
question
question number seven can you tell me
about a time when you conducted an
observation session
if you have answered that you have used
observation technique
then interviewer might ask this question
to get to know more about your
experience
like we spoke for the previous two
techniques
the observation elicitation technique
also has three phases
prepare conduct and post the session
let us go back to our case study one of
the open actions in the workshop was for
rahul to capture a time and motion study
that is how much time does the current
reservation process take
and also document the current steps
taken by the staff to complete
the booking rahul is going to use the
observation technique for completing
these two actions
first off rahul needs to prepare for the
observation session
and he follows the following steps
setting a clear purpose which is to
document the detailed process
used by the staff now and do a time and
motion study
identifying the participants with the
help of one of the branch managers
and scheduling a convenient time for the
session
share the agenda with the participants
up front so that they are prepared for
the session
as always first stage is the key if the
prep is good the rest follows easily
moving to the second stage rahul meets
the participants at their workplace
at the scheduled time and briefs them
on the required outcome and the reason
for the same
rahul uses passive observation technique
he captures the start time when
a call is made by the customer and end
time when the booking is made
in the current system it is around 3
minutes
he then asks the branch manager for a
staff to make a note of the time
from today so that the average time can
be benchmarked
and used for presenting back to the
sponsor who wants to know
this he also observes couple of staff
and makes note on the steps taken by the
staff for making the booking from the
time when the customer
calls and the booking is done on the
system
once the staff completes the booking he
asks couple of clarifying questions on
the doubts he had on the process
he then thanks the participants for
their time and heads back to the office
the last stage is to ensure what he
captured is right
he converts the steps into process
diagram and
sends it to the staff for review
and also follows up on the open action
for the average time for booking process
from the manager
question number eight another follow-up
question on
observation what is the difference
between active
and passive observations there are two
types of observations
first one active observation when the
staff is performing the steps
in the process if you have any questions
you stop the staff
and ask clarifying questions when they
are performing that step
to gain insights point number two
passive observation you make a note of
all the questions
and wait for the staff to complete all
the steps in the process
and then ask your questions
active observation is used when you are
more interested
in specific part of the process whereas
passive is generally used to capture the
metrics of the time taken to complete
the process
and for benchmarking question number
nine what is focus group and how to
conduct one this is similar to the
workshop
you get the key people together at the
same place to get their thoughts and
opinions going back to our previous
video where we discussed about personas
which are fictional characters who
represent the typical customers
they are helpful to understand the
customer's need and build the product
accordingly
based on brainstorming with the internal
team the requirements would have been
locked on what these personnels would
need
identifying and validating the needs of
the personnels are very important to
ensure
we are building a product which
satisfies their need
focus group is one such technique to use
for that
let us take two personas as example
first one the office manager this is a
typical manager who has number of team
members reporting to him
there would be quarterly or sometimes
monthly team outings
and the manager is responsible for
looking for fun places
to have a team lunch or dinner their
needs are quick snapshot of the service
offerings
and also the receipt of the bill emailed
to them
so that they can do claims for
reimbursements as all the outings are
built to the company
second one family man one who wants to
book on weekends
for brunch lunch or dinner he does not
care about the digital copy of the bill
but is very keen on services offered for
the kids
and the seating arrangements
if you see just going at a high level we
have got two requirements
first one soft copy of the e bill to be
emailed as a pdf
second one service offerings should be
shown in the booking app or the website
again these are just assumptions and has
to be validated
focus group is one of the way to
validate the assumptions made
rahul can get the details of their
previous regular customers from both the
categories
office manager and family men and
arranged for a focus group session with
them
to go over the feature of the new online
booking system
he also provides perks for participating
in the session
by giving them free lunch or dinner
coupons at the restaurant
again similar to the workshop technique
agenda can be shared upfront to these
people
so that they are prepared during the
session
rahul uses the agenda and goes over the
list of business requirements captured
to get their thoughts on each one of
them
rahul makes a note of the participant's
feedback
once all the items in the agenda are
complete then rahul thanks the
participants
post the focus group session rahul
compiles the report
based on the insight received and shares
with the key stakeholders
this would help to understand which
business requirements are key to the
target audience and which can be
discarded or
be prioritized let us look at question
number 10
how can you gather requirements from a
large number of people
or they can ask you to tell about a time
when you used
survey or questionnaire technique
answer is survey or questionnaire
technique
we cannot use any of the techniques we
spoke about earlier
due to the sheer volume continuing with
our case study
rahul wants to get a view on the
thoughts of the vegan gardens existing
customers
on the new online booking system before
starting the bill to ensure their
requirements are satisfied
going back to our three stages in
prepare stage
rahul would compile a list of question
and answer options to send out to the
participants
it is important to have options for each
question
and not have a free text field as it
will be difficult to interpret the
answers
sample questions can be like do you
prefer a mobile app or a web app for
making the booking
do you want to receive reminders on your
reservation
using the questions rahul will create an
online survey
and get the survey link in conduct stage
rahul sends an email to thousand plus
existing customers of the restaurant
to help to take the survey he can also
provide
perks to the customers like discounts
for participating in the survey and it
is very important to give a deadline for
the customers to complete the survey
otherwise we cannot close the activity
post the deadline date rahul can review
the results of the survey
and compile insights and log them as
business requirements
hello there do you have a business
analyst interview coming up shortly
if so this is the video for you in this
video we're going to look at the top
9 interview questions asked related to
the requirement documents
as you're already aware eliciting and
documenting the requirements
are one of the key aspects of a ba role
so the
interviewer would be definitely
interested in understanding
the requirement documents which you have
created in your past
projects we have a lot to cover so let's
get started
i can assure you that they're going to
be couple of questions
from this video which will be asked in
your next business analyst interview
we're going to look at the brd frds
their contents and structure we're going
to also discuss
on rtm epic user stories their format
and also the acceptance criteria so it's
going to be a
informative video so make sure you watch
it till the end
and also if you have not already
subscribed to our channel
please go ahead and subscribe to our
channel right now so that
you will be notified and you won't miss
out on any
of our future videos
to make it easier for grasping the
concepts and the answers
we're going to use a case study with
this case study
a movie theater chain called xyz cinemas
is looking to build a digital channel
for allowing the customers to book their
movie tickets online
rather than calling up the customer care
or standing in the long queues and
getting their tickets
at the ticket counter so we are going to
use this
uh example case study for
answering all the questions
okay let's get started question number
one what are the different documents you
are prepared for capturing requirements
this question i would say is a sure
short one
and it is asked in almost all the
business analyst
interviews i've listed the majorly used
documents it varies from company to
company
but these are the common ones so the
first one is the brd
which is the business requirement
document the purpose of this document
is to capture the business requirements
and the core business context
of a particular change initiative the
second one is the
functional requirement document which is
the frd the purpose is to capture the
functional and non-functional
requirements
and it kind of maps back into the
business requirements
then we have the use case document again
the purpose would be to document
the use cases uh which details the
interaction between
an actor and the system or the solution
which we are trying to build
and then we have the activity diagrams
so this
uh documents the flow of events uh the
in
the interactions uh between the
user and the system and also the
detailed step-by-step
flow which basically which will help the
it team
to build the solution which we're
looking for and then we have the
wireframes
so the wireframes are basically used uh
to provide
a view of how the screen should
should be looking for the customer so it
will be the look and feel the colors
and also the various user interface
items so all these things would be
mocked up
into the wireframes and then we have
the epics and user stories so all the
documents which we just spoke about
are used in the traditional waterfall
model
but in case if a project is using agile
the requirements are captured
in epics which is again the high level
requirements and then
the user stories which are epics are
broken down into user stories
so and all the use cases activity
diagram wireframes are all
you know converted into supporting
models and they are
basically attached to the user stories
for the epics to provide more context
and a better understanding of what is
required to the it team so that they can
build it accordingly
and the last one common one which is
used is the rtm
which is the requirement traceability
matrix it is basically used to
trace the requirements backward and
forward right from the business
requirements to the test case and vice
versa
we're going to talk about all of these
in details in the further slides
moving on question number two what are
the contents of
brd or the business requirement document
again this is a
a question asked to
gauge your depth of experience of
preparing
such kind of documents so you you can
use example
to provide the contents of the brd
and i've listed few of the uh
components here but again it varies from
company to company project to project
but these are the few
uh common uh building blocks so the
first one would be the executive summary
so if you looking at our example
this would summary would state that the
business
xyz cinemas is looking for a digital
channel
for the customers to book their movie
tickets and the business context will
provide why they are looking for this
change initiative
well here in this context it's just to
make it more convenient for the customer
to book online rather than standing up
in the long queues or calling up
uh other customer care and you know
waiting for it to be confirmed
so that is the customer convenience and
also if you look it from
at the staff perspective uh this can
help to free up
for some of these steps were doing these
rules and they can be allocated to
uh you know other priorities other
opportunities
and then there will be a current state
and target state current state will be a
basic business process flow like what's
happening now when the customer comes in
uh goes to the ticket counter and
similarly what happens when they call up
the uh customer care
and the target state will be how the
customer with the
the target state process flow will show
the
how the customer will be using this
digital solution
to book the tickets and how they will be
permitted into the cinema halls
you know the end-to-end business process
flow how the target state would be
so this will give more contacts to all
the
stakeholders involved and also to the
engineering team
i.t and the testing team uh the
development testing team to understand
what is being done and why is why it is
being
done and then the scope the scope
section would
actually have uh what are the things
which are in scope for now so let's say
if you're looking for the solution
whether we wanted to be limited only to
you know the web web app or a web login
or
do we want to also develop a mobile app
where the customer can book their ticket
so this would be
the scope and it should be pretty clear
what is in scope and what is out of
scope
and then comes the business and you know
the stakeholder requirements so these
are the requirements
which are are you know needed to achieve
the target state so this
talks about this can talk about the
requirements related to
the customers uh able to book their
tickets online
and also uh the cancellations uh what
are the things the customer can do with
the
online channel and also similarly on the
staff side it can be like how
the staff can identify these book
tickets how they can let the customer
into the hall so all of these
requirements would be
under these sections and then the next
one would be the assumption so what are
the
assumptions for this initiative so one
of the assumption i can think of is
once this channel is available the
customers will start using it
you know that's a basic assumption and
then the dependencies what are some
things which have to be in place
for this thing to work and then the
business rules
if there's any rules for example like
the they might have a rule that
only a maximum of 10 tickets can be
booked at
one time so this is a business rule this
can be translated and documented
uh for a functional requirement and you
know
ensure that the digital solution also uh
withhold like holds
this business rule true and then the
last section would be a glossary which
will just summarize
all the abbreviation acronyms used in
the whole document so just to give a
view of the person who is reading the
document understand it
better so these are some common sections
in a brd
moving on question number three what are
the contents of a functional requirement
document or frd so this is similar to
our previous question
again uh they want to understand your
depth of knowledge in preparing such
documents
so quickly gonna list out all the common
sections which is
uh you know used in drafting uh frd
so first one would be the purpose again
what is the purpose of this particular
document
uh how it's how it you can borrow
some context from the brd to put it here
similarly the scope section again can be
borrowed from the brd what
is in scope what is out of scope so it's
very clear and then
comes these functional and
non-functional requirements
so these are the system related
requirements and
here you'll be document documenting what
the system should do
in our example if we take this would
talk about
how the customer should be able to see
the list of shows
the list of seats which are available
for on each show
and where they can select the seats and
also make an online payment
so these are basically a translation of
the business requirements
uh into this is the functional
requirements which
which basically again what you want the
system to do
and these are all linked back to the
business requirements
similarly a business rule which we spoke
about the maximum of 10 seats can be
booked that also can be translated to a
functional requirement ensuring only 10
seats can be booked online and then we
come to the non-functional requirements
so these are the
requirements related to the performance
the security stability of this online
solution
so one such example is responsiveness uh
we want the solution
the system to respond within two seconds
of the user's input so for example user
selects a date
within two seconds we should be the
customer should be able to see the next
screen so that's one example of it then
the assumptions
we just spoke about and then the major
chunk of this
document would be the supporting models
which will provide
more context to the engineering team
and helping them to understand how we
want the solution to work so that they
can build it accordingly and you know
tested it
as well so this is about the use case
diagrams activity diagrams mockups which
we just spoke about
earlier so all of these would comprise
a you know will be part of a vr sorry
frd
and then the last one is a glossary
again just to provide more context on
the
acronyms and of the abbreviations used
question number four what is the format
and contents of an epic
so far we discussed about the waterfall
methodology and the documents used
when you come to agile it's very
document light
and all the requirements are captured in
the form of epic
or user stories epics are tileable and
then they
are broken down into detail user stories
so i've listed
uh this down the key components of an
epic
in this slide ideally in essence what an
epic
has is who what and why who requires it
what is required why is it required so
this is kind of a format
which is you know used to capture the
requirements
so a template which are provided which
is a commonly industry-wide
format which is used across as a who
requires it
i want what is required so that why is
it required
so that's a format if you look at an
example
as a customer i want to pay for my movie
tickets online
so that i don't have to stand in queue
to pay cash at the movie theater
so this is a again a customer convenient
convenience
requirement where we're talking about
the ability for the customer to pay
online for the movie tickets which they
have booked
so it captures the requirement in this
particular format and it also has some
additional information like priority
what is the priority of the requirement
is it a must should or record
or if you're using ranking it can be ra
you know prioritizes one two three four
etcetera etcetera so it all uh helps in
the prioritization of the backlog so
that the highest value item is delivered
first
and then this has the business contacts
so it provides more context on
why this particular requirement is uh
you know listed in first place so all
the things which we spoke about in brd
so those things
can be added here as a business context
and then it has
links to the detailed user stories so
if you look at an epic it gives a
high level requirement of what is
required
in the next slide we will speak about
the detailed user stories
question number five what is the format
and contents of an user story
so we are building upon from the
previous question which
you know which is epic and these are the
detailed user stories
so the format of a user story is very
similar to the
epic who what and why so what
i try to provide as an example is the
epics the epic spoke about how the
customer should be able to pay online
and in these two user stories we are
breaking down it further
so if you look at the first one as a
customer i want to pay online using
my debit or credit card for my movie
tickets again
he wants to avoid standing in queue the
second user story talks about
customers ability to pay online using
the online banking portal so for example
they don't use a
credit card they want to use their
online banking net banking portal
so this breaks down the epic
into more details of the channel which
the customer wants to use
we can still have more user stories like
the mobile
valids paypal etc etc
so this kind of gives you a view how an
epic is kind of linked to the user story
and what is the
format and the user story also has like
additional information like the priority
similarly must should could or high
medium low again one two three four
ranking
and then it will also have the epic
which is linked to
and then the acceptance criteria which
will uh we speak about
uh in the next slide and also the
supporting models
so the use cases activity diagrams the
mockups which we spoke earlier
all of them would be created and
attached to
the user story as a supporting model to
provide more
context and more information to the
engineering team to build the solution
question number six what is an
acceptance criteria
and its former as discussed in the
previous question
acceptance criteria is a for is a part
of our user story
and it's a very important part it
basically
uh states the condition or outcome which
has to be satisfied in order for a re
uh for a solution to be acceptable to
the business stakeholders
so it's very key in terms of coming up
with the
qa test scripts and also the uat test
scripts
so so it's a very vital component of a
user story when we look at the
template or the format so usually
the acceptance criterias are also given
as a one line statement
in an example demonstrate that the
customer is able to
pay using their debit or credit card
but that is there is high level
statement on in order to make it
more robust and ensure that everybody
gets
a clear understanding this is the format
which you see on the screen it's
based off bdd behavior driven
development
so the format is given a context
when an event happens then what is the
outcome
which is expected if we translate that
to an example
based on the user story which we just
discussed given customer has selected
the show
and selected their seats when they are
on the payment
page of the digital solution then
they should be able to pay online using
their debit or credit card
so it clearly spells out what are the
uh what is the context what is the event
and then what should
happen so it's very clear to everyone
the developers and also the testing team
what the outcome we are looking for in
what condition
and it ensures that we build a solution
according to the
uh business requirements
question number seven what is rtm or
requirement traceability matrix so this
is one of an
important tool or technique which is
used to trace requirements
so this provides backward and forward
traceability
as shown in this diagram and it helps
faster impact analysis and reliable
assessment
to ensure that all your business
requirements are covered
so if you look at this example rtm or
requirement traceability matrix
so the business requirement will be
mapped to
the stakeholder requirements uh sql
requirement one and two
so in our example if you if you talk
about the digital channel for allowing
customers to book
uh tickets the stakeholder requirement
number one can be related to the
customer facing
screens and how they can how it allows
and the other stakeholders who can be
involved would be
the backend team or the back office
operations team
and what are the requirements from their
side to process the
customers online booking so that's how
the different stakeholders will have a
different set of requirements so the
first level of mapping would be
with respect to the business requirement
and the stakeholder requirements
and then the stakeholder requirements
would be mapped to the functional
requirements
and also the non-functional requirements
which we spoke about
and then the functional requirements or
non-functional requirements in turn
would be mapped to this design component
okay
in order to deliver this functional
requirement
what are the design components required
so
if you take an example of the screen
to show the customers the list of
available seats
so the design would involve different
screens
and also the the the logic for
showing up the available seats so so
that
all comes under the design and then the
design
component maps to the the code so
in which a particular language
the the co the code is there it may be
java.net
or it can be uh any other new
technologies like python
so all of this programming comes under
the code and it is mapped to the
design component and once the code is
kind of completed and then it's
maps to the test case so the test case
would ensure that
um the code which is developed
works accordingly to the requirement so
this
kind of gives an end-to-end mapping
to ensure that a business requirement is
kind of
test developed and tested
so it's a very useful tool and this is
one of the key things which
also use on a day-to-day basis and it
can be
asked in an interview
moving on question number eight what are
the different visual models
you created for documenting requirements
so this is another key questions which
keeps
getting repeated in the business analyst
interview
so i've listed the major ones used but
there are
much more uh visual models uh
which have been used so i'll be creating
another video only
dedicated to this but in this video i'm
just going to quickly cover of the
commonly used ones the first one is the
use case diagram
which uh kind of documents the
interactions between the
user and the system which we are
building what are the different things
a user can do functions with the user
can
perform using the system then there is
the activity diagram
which again captures uh the interaction
between the user and the system in a
very detailed way
let's say example if the if the customer
selects on uh the particular show
what happens what is the screen which is
shown to the customer
uh let's say it is in the seed selection
let's say customer proceeds without
selecting a seat
then there should be an error message
which should be thrown so all of these
things are kind of captured as part of
the activity diagrams
and then it comes the wireframes so this
is basically the look and feel of the
screens
so how the screen should look what are
the colors
what are the components which are which
should be
available to the customer in the screen
so all of this visual part
are handled using the wireframes then we
have the prototypes which is similar to
the wireframes but this kind of gives
a journey in a visual way if the
customer clicks on
one button on one screen then what is
the next screen which is popping up
they click on this what is the next
screen which is popping up it's kind of
you know it's a storyboard which is very
easy for the developers to visualize
while they're building the solution and
also for the testers
to test the solution and then we have
the business process flows
it's the end-to-end flow basically what
happens
uh when the event is started
who are the actors you know they are
depicted by swim lanes
what are the actions which are taken by
the customers
by the staff on the on the
business side so all of these things are
visually represented
as part of the business process flows
the last one
key key one is the data flow diagrams uh
basically these are
uh more of a technical in nature which
shows how
the data flows from which is the source
and how it's get getting captured in the
backend database so these are some key
things and commonly used
visual models if you feel there are any
any similar ones which are very key and
used widely
please comment in the comment box and
i'll pick it up while i'm creating
the other video
moving on to the last question question
number nine what are the tools you have
used for documenting requirements
so this is one of those tricky questions
where the
base might not be prepared while facing
the interview so i've just
listed it out here so
predominantly most of the requirements
are captured using
the ms office tools if you are following
the waterfall model
word the frds and brds are captured in
the word document
and the the powerpoints
can be used for presenting these key
parts to the stakeholders for either
sign off or you know just to present
and get their views on and then excel is
used for the
requirement traceability so
it's it's mo it's more or less all the
business analysts work
heavily on ms office and then
there's a sharepoint where all these
documents are commonly
uh maintained so it's like requirements
management is done using
the sharepoint which all these documents
which we spoke about
if you're using waterfall but if you're
using agile methodology
i think most of the things are on jira
uh the epics are created on jira the
user stories are created on jira
acceptance criteria is documented as
part of the user stories
and all the supporting models like we
spoke about the mock-ups
the use cases activity diagrams all will
be
just part of the jira and
confluence is also used uh extensively
uh where i want to make
uh provide more notes or more context so
jiran confluence are the key tools
in the agile methodology and there is
this require
requisite pro this is also one of the
requirements management tool
um which will which is which which is
used
and then we have the vizio and
eris so these are the business process
modeling tools so
you can create business process models
using that and visio is extensively
you know it can be used for your
activity diagram use case diagrams
any type of diagrams and you know the
mock-ups
can be created uh using visio powerpoint
and also
ms paint and then
if you want to go a little high-tech on
the
tools for capturing the business process
models and all the different
uh diagrams the visual models i think
lucidchart is one tool which is
uh which have all the pre-built
templates and can be used readily
uh uh readily and it can be uh
you know it can save a lot of time and
then we have
ballismic this is also it's a mock-up
tool
and it's basically used for creating
all these web-based mockups and mobile
phone app
mock-ups so these are the things which
uh
you know commonly used again please
comment in the comment box
if there are any other tools which you
think i've missed out here
hello there welcome to this video in
this video you're going to discover the
top 10 commonly asked questions
in interviews on scrum agile methodology
if you have an interview coming up
shortly then this is a video
for you
question one what are the events
ceremonies in agile methodology
so there are four key uh events
and we're going to cover those in detail
in the upcoming slides
but i'm just going to provide an
overview of these
four events in this particular question
so we have a sprint planning which
happens
during the beginning of the sprint and
then we have the daily scrum
which happens daily during the duration
of the sprint
and then we have sprint review and
sprint retrospective
towards the end of the sprint so we're
going to cover all of these
events in detail so stay tuned
number two so this is again another
commonly asked question is the
composition of the scrum
team so ideally the scrum team comprises
of
three main roles which are listed in the
slide one is the product owner
two is the scrum master and third one is
the development team the development
team
includes the developers uh the testers
or any other i.t stuff so
all these three roles comprises of a
scrum team
question number three so this question
relates to the artifacts in scrum as you
know scrum methodology
is basically very light in documentation
but these are the three
major are kind of used in the process
so first one is the product backlog so
this contains
all the things which relates to the
doubler for the product the epics the
user story the defects
any other ideas so all of this goes into
the
product backlog and then we have the
sprint backlog
so as i was speaking in the question one
about sprint
planning so the items which
deliver most value to the customer based
on urgency or based on
other factors so all these items are
transferred from
product backlog to the sprint backlog
which becomes the scope of that
particular sprint and which is
used throughout the sprint the third
artifact is basically the product
increment which is delivered in that
sprint it can
it contains the software package the
release notes
and the user user manuals on how to use
the functionality
which was delivered in that particular
sprint so
that summarizes the three
major artifacts used in the scrum
methodology
question number four is what is velocity
so ideally it is ability of the scrum
stream
to deliver valuable product increment
so it's basically calculated based on
the
story points of the backlog items which
were
delivered in that sprint or we can term
it as
done in that particular sprint so let's
say for an example
41 story points worth of
product backlog items were delivered in
or completed in sprint
one so then the velocity of that scroll
scrum team can be termed as 41.
let's continue the example let's say in
sprint to the team
uh completes uh 42
then they're going to average out 41 and
42 and then use that
as a variable in the sprint planning
meeting basically this kind of gives an
idea of what the team can deliver
in a particular sprint and it's used for
planning
so that's the main use of velocity
question number five what is the use of
a sprint burn down chart or what is a
sprint
burn down chart so again this is one of
the artifacts
used uh in the process to kind of
track how the progress is
with respect to the sprint goal and then
kind of adapt
to achieve the goal which was planned in
the beginning of the sprint
so if you look at the example chart
which is given here
uh it's a two week sprint let's say it's
14 days
worth of for days it's tracking and then
the yellow line kind of for
tracks the story point which needs to be
completed on a daily basis to achieve
the
sprint goal and then the red kind of
signifies what is the actual so it's
basically giving a plan
versus actual view and then during the
daily scrum meeting this chart can be
referred and the team can adapt
or adjust accordingly to
complete this part particular sprint
goal so again it's a very useful
metric for tracking
progress question number six
so i was telling we'll discuss more
in detail of the events so this is the
first
of the four events in scrum process
so which is a sprint planning meeting so
a lot of interviews will ask
what actually happens in those meetings
so
so what the basically the purpose of
this meeting is just to craft
a sprint goal and also plan to achieve
it
so the participants would include the
scrum team
uh the development team scrum master and
product owner and then they will use the
product backlog and then pick okay
these are the product backlog items
let's see what
should we target for this release so for
example if it's a
the team is building a ticket booking
app for a movie
theater chain so maybe they would have
delivered the basic functionality of
login
registration and booking the tickets
but they wouldn't have the functionality
of seat selection
by the customer so that can be one of
the major functionality which they can
target in the sprint
and that can go that can be the goal of
like that can be the sprint goal
and then that goal can be broken down
into the user stories and epics which
will populate this
print backlog and also the velocity is
used as an input
to kind of determine what the team can
kind of complete in that sprint so
it's as we discussed in the previous
slide if the team can complete 41
story points worth of uh items
then in the next print also they can use
that as a guiding parameter and then
they can keep okay let's we can only do
for 41
uh let's see what we can fit in those
things yeah
and then using all this uh
input so the output will be the sprinkle
as i was just telling in the example
the seat selection feature can be a
sprint goal and then the sprint backlog
all the epics and the users user stories
related to that particular functionality
can be
included in the backlog and then a
sprint burn down chart which we just
looked in the previous slide
can be charted with the plan
planned story point completion
throughout the sprint process
yep
and the question number seven is the
next
item or which is the even which is the
daily scrum meeting
explained basically they would ask to
explain what happens in the daily
scrum meeting so this is a daily scrum
or it's also termed as a stand-up
meeting
so the purpose is just to review the
team's progress
on the sprint goal and not just the plan
to get there
the development that the participants
mainly would be the development team
and the scrum master product owner is
kind of
optional so it's good to include the
product owner but
again he or she is optional
so the inputs would be the sprint
backlog okay these were the items the
user stories and the
tasks which are outstanding for this
particular
sprint and also the sprint burn down
chart how how is the team progressing so
the progress would be inspected and if
there's any impediments or was telling
about the blockages
uh it can be a technical issue or a
environmental thing or
well various factors which will be
blocking progress so those can be
identified
and then um
usually a follow-up call or a follow-up
meeting would be set up
to work on resolving those impediments
usually it's all driven by
a scrum master
oh my question number seven question
number eight is basically
uh describe what happens in sprint
review meeting
so this review meeting happens at the
end of the sprint
and ideally the purpose is to just
showcase the work which was completed
in the sprint to the stakeholders this
meeting will have
extended stakeholder list along with the
scrum team which will include the
sponsors the customers
or the end users and also the sales team
they would like to see
how the product is shaping up and they
also can provide their feedback
so the input again would be the goal so
example we spoke about
like seed selection feature and then
how the feature which was developed so
the usually it will be done by the
product owner they'll
just showcase or demo this particular
functionality to this extended audience
and then get their feedback like are
they happy with it or if there's any
improvements or any enhancements which
can be done
it would be noted down and it'll be
added to the product backlog
so that was mainly happens in this
review meeting
again the product owner also provides a
status report and also a forecast
of what would be coming in the next
prince
if yeah and also when there is a release
planned
so all those things kind of gets
discussed in this particular
meeting and we'll move on to question
number nine
so this is the last major event
in the scrum methodology which is print
retrospective meeting
so here basically
it's the participants or the scrum team
themselves the development team the
scrum master product owner
the main agenda is to identify how we
can make the product development
process better simple yeah so they look
at all the
uh impediment list that's the main thing
so that they can be prepared in the next
print and also the review comments which
were provided by the stakeholders in the
review meeting so
those things can be kept in mind uh
while working on the next sprint
and also the burned on especially the
progress uh
and how how what where like what what
things can be done better
in order to hit the plan so it's more of
a looking back reflecting back and also
looking forward so those
outputs would be the action items for
improvements which can be implemented
in the upcoming sprints so that there's
a better process
question for this particular video is
again it's what is
definition of done this is one of a
tricky question which is
asked and basically it's an exit
criteria which is agreed with the
product owner and the development team
for
marking a backlog item
has been completed and it's ready to be
shipped so example login feature
or one of the features which we
discussed the
seed selection feature yeah it can be
only termed as done if it is
coded tested reviewed and accepted by
the product
owner so this is one of the terminology
for an item to be
termed as completed so let's say if the
one of the item is only coded
and tested you cannot term it as done
all these factors which have been
pre-agreed should be
completed in order for an item to be
complete termed as done
hello there do you have a business
analyst interview coming up shortly
if so this is the video for you in this
video we're going to discuss
the top 15 commonly asked interview
questions
on acronyms or ba terminologies
used in business analysis ranging from
crud sipoc rfq rfi
cots and much more we're going to take
the term expand it and provide
its usage with an example so that this
will help you
to answer the questions in the interview
process
we have a lot to cover so let's get
started
question number one what is invest
invest stands for
independent negotiable valuable
estimable small
testable the inverse guidelines are used
in agile methodology while writing the
user stories
the above criteria ensures a
well-written news stories
let's look at it again independent it
talks about
the user story being independent of
other user stories
dependency between user stories create
complexity and wherever possible
we should maintain uh user story
independent
of the others negotiable this talks
about
having a conversation with the team and
trying to
work out the details of the story
accordingly
valuable the this talks about
the user story should be creating value
to the end user
be the customer or be the staff or
working with application
if it doesn't deliver any value then
there is no
purpose for user story to be on the
backlog in the first place so
to ensure that the user story creates
some value
to the end user estimable
so this talks about how the user story
should be written so that the
development team
can help i can you know look at the
story and come up with
estimates it can be a ballpark but yeah
it should be able to
estimable by the development team so
that it helps in the prioritization
process and the release planning
small wherever possible the story should
be broken down
into uh the smallest part of it
and it should not be combined with other
features so wherever possible
it should be limited to a single
requirement
from an end user or from an internal
staff
so it becomes easy for
development testing and maintenance the
last part is testable
so by looking at the user stories the
testing team should be able to come up
with their
test scripts and help in their testing
process
ideally the acceptance criteria helps in
this place
acceptance criteria as part of the user
stories can be created
sorry translated into test cases and can
be used by the testing team
question number two what is crud crutch
transfer create read update and delete
so these are the four basic functions to
be considered in software development
while we're dealing with
data and this the same uh
thread can be used for drafting you know
high level requirements
if you're looking for an example uh and
you're i'll be tasked to do a
requirements for an online food
ordering app even before you are meeting
the business you can just come up with
these requirements using crud
c stands for create so customer should
be able to place an order
r stands for read customers should be
able to view their order
and u stands for update customer should
be able to update their order and d
stands for delete customers should be
able to cancel their order
so it's a very good technique to
uh ensure that the data is handled
end to end right from creation up to
deletion
question number three what is what so
what stands for strength
weakness opportunities
threats it's a strategic planning
technique used to craft out strategies
let's try to look at this with an
example
one of your clients is a business owner
and
sorry restaurant owner and he has a come
to your
consulting firm seeking help on how to
uh you know how to create a strategy
to combat a new restaurant which has
come down the corner
so you can use swot and help out craft
that strategy so let's
let's look at it first we identify what
is the
strengths of the client so
the bus the restaurant uh has been for a
while
and it's very appreciated for its uh
taste and also it is highly economical
and there's huge flocks of crowd are you
usually coming during the lunch time
uh during the office hours to grab a
bite so that's the strength if you look
at the weakness
the restaurant closes at uh 8 p.m
uh due to la you know not not many
office
going people kind of hang out at that
particular restaurant
whereas a new restaurant which is coming
up is open till 11 a.m
so if anyone after 8pm wants to kind of
uh you know hang out they can go to the
new restaurant so that's a weakness
so one of the strategical point to
combat it is
maybe open the closing time of the
restaurant next and the closing time of
the restaurant
maybe to 10 or 11 and you know see how
it works out
and then the opportunities so this
new restaurant bringing up it opens up
for opportunity one of the opportunities
which you can think of is
the client's restaurant is in indian
cuisines while the new restaurant is
chinese
so maybe can just have a conversation
with the
restaurant owner and try to see if you
can
cross cross serve maybe they can promote
your restaurant
i can tell you if you're an indie
restaurant you can go down the rounder
and you can do the same
vice versa what's happening is
collectively you're trying to
in collaboration you're trying to grow
each other's business
the threat is the new restaurant um
happens to be better and it's able to
serve faster
than i think you
this particular business will be taken
out of
going on question number four what is
uml this is a very
commonly asked question in the interview
sessions
uml stands for unified modeling language
it's basically a standardized modeling
language for visualizing and documenting
the artifacts
of the software programs most commonly
used uh
uml diagrams are the activity diagrams
use case diagram sequence diagrams so
basically
these diagrams provide a view to the
development team
how the interaction between the user and
this system should be
which will help them to visualize and
come up with the solution
accordingly
question number five what is the
difference between rfi
rfq and rfp this is one of the commonly
asked confusing question
in the interview process i'm just going
to try to simplify it in this particular
slide
rfi stands for request for information
all we're doing here is reaching out to
the different vendors and trying
to understand what are the services or
the capabilities
which the vendor can deliver only that
nothing much
just reaching out and trying to
understand the services
which they provide rfq stands for
request for code
this is usually uh used when you know
what you want you're reaching out to the
different vendors
to understand what the cost involved in
delivering the solution for that
for that particular requirement so this
involves reaching out to the different
vendors
just telling them what you need and
trying to get the code from
them for comparison the last one is rfp
this is the one which is commonly used
this involves
a kind of a business stay a business
need or a problem statement
you reach out to vendors and you give
them that and you ask them to come back
with their proposal
and the cost so the proposal would
basically involve the approach
the tools which they'll be used are
using to solve
the business problem statement or
achieve the business need
and also the cost involved so rfp is one
of the most commonly
used but there there are
uh companies which do use rf i and rfq
as well
question number six what is cods cots
stands for commercial off the shelf code
system
are developed and maintained by external
organization
and they are just implemented as part of
the business to meet their business need
or
solve a problem statement rather than
developing their
own in-house software system for example
a business needs a customer relationship
management platform
instead of developing an in-house
solution they can go and
get sap crm zoho crm or salesforce
similarly if they want to send out
emails to their customers
they can use a vapor get response
etc so the idea here is instead of using
the time
developing in-house system
the business can use a readily available
software
and they can get started to address
their business need or
resolve a problem statement
moving on to the next question what is
wbs
wbs stands for work breakdown structure
this is a process of decomposition of
the task and effort required to complete
a project or
an objective so from a ba prospective
let's say
you're tasked with the requirement
gathering for a particular
initiative so at a high level
the initiative will result in a
requirement
document maybe in form of use stories or
brd
or fl you know the functional
requirements so
in order to break down and make it more
easy for managing
and reporting maybe you can split
that requirement gathering sessions from
a customer
facing view and then you can have
requirement gathering session
with department e department b
and department c so you're basically
breaking down the
requirement gathering process across and
having some
timelines to it and also then
crea having a process of documenting the
requirements and getting the required
sign off
so all of these act activities can be
broken down
and then into small components
it can be planned and managed
accordingly so they
provide some more visibility and easy
for the individual performing those
activities to accomplish
question number eight what is cpoc sipoc
stands for suppliers input
process inputs process outputs and
customers
cpoc diagram is used for defining the
scope of a process
improvement initiative and also helps to
understand
the current state and then to work out
on the process improvements so cpoc
ideally basically talks about who the
suppliers are
what are the type of inputs they provide
to a process
raw materials data etc
and then what is the process which
converts the inputs
to the required outputs what are the
required outputs
and who are the ultimate users of those
outputs so it's in a in a simple
line uh in a table or a diagram can
understand what's happening
currently and can work on the process
improvements accordingly
question number nine what is jad chad
stands for joint application development
chat sessions are similar to workshops
or where you have
a variety of stakeholders ranging from
the customer the end user
smes business stakeholders business
analysts developers
all collaborating together for capturing
high quality
functional requirements basically you
want to uh
the end result of this particular
session would be
what the what is that the system should
do
in order to accomplish the business
requirements
so that's the whole agenda for this
particular sessions
and this provides a a good understanding
to the development team
uh what is required and also some
business context on
why it is required so that it will help
them to
develop the solution accordingly
question number 10 what is bpmn bpmn
stands for business process model
annotation bpmn is a methodology
or an industry standard language used
for visually represent
representing the business process in the
form of diagrams
so the business user or a technical
developer if they just look at
this business process model they will be
able to understand
or what is the flow of events who does
what so usually the business process
models are in the form of swim lanes
uh one actor and all the activities for
that actor are confined to a swim lane
so if you're taking an example you have
actor one and actor two let's say
customer uh
and a ticket provider for a movie
tickets so customer
walks in hands over uh informs the
the ticket counter which show and how
many tickets
he or she wants to buy and then the
ticket provider will
just show them the screen and as ask the
customer to pick the seats once
the seats are being picked picked by the
customer uh
the ticket provider confirms the ticket
and then uh charges informs the customer
how much
the ticket is and once the customer pays
the money the ticket is printed out and
handed over to the customer
so this back and forth interaction can
be easily represented in a business
process model and let's say if
a business is trying to take this
journey to a digital channel where the
customer can book
their tickets using phone or you know
online
then this particular process model can
be used to model
the interac the interaction by the
developers
and it's pretty easy it's all there in a
process model it's easily understandable
and can be used accordingly for the
development
question number 11 what is dfd dfd
stands for data flow diagram
so dhp is a visual representation of
flow of data
through a software system again this
really helps
the development team uh during the
development process
so let's say if you're working on a
reporting requirement uh
you can provide a view of how the data
is captured
and where it is stored so let's say
example the customer data is captured
through
the you are the front-end screens and it
is stored in one particular
database similarly the transactional
data are recorded in another
database and then how which are the
fields you can try to
capture from which database so you can
you can provide this
view in a data flow diagram
and this will really help the
development team to come up with a
required solution
for the report
question number 12 who is an sme
sme stands for subject matter expert
smes are invaluable resources for
understanding how the current processes
work so uh they are actually either
uh you know experts in their own niche
or
on field for example if you're looking
at a particular
part of the business the first point of
contact
uh would be an sme because they know
inside out they've been
in the system for a few years they may
be
uh senior team members of the team or
business architects or sometimes even
the business analysts who have been
working on that particular
uh process for a while would be an sme
the smes
are really key during the requirement
gathering
phase uh when you're eliciting
requirements they are the point
of contact to provide how the current
process is
and what are the things they would
require to make it
better
question number 13 what is rtm rtm
stands for requirement reasonability
matrix
it's basically a matrix used to trace
requirements
it provides the backward and forward
traceability
and it helps in a faster impact analysis
and
unreliable assessment to ensure all the
business requirements are
designed developed and tested so let's
look at an example
in the below diagram we have a business
requirement
it's a map to the stakeholder
requirements one and two
and the stakeholder requirements is
further mapped to the functional
requirement and non-functional
requirement
and then the functional requirement in
turn is mapped to the design component
which traces to the code whichever
language it can be
written in java.net python and then the
particular code then it maps up to a
test case
so if you just look at this particular
diagram and metrics
you can ensure that a business
requirement here
on stakeholder requirements here is is
is designed
developed and tested so this provides
an end-to-end view and ensures that
everything is covered
question number 14 what is roi roi
stands for
written on investment this is a very
important
metric and it measures the return of
investment relative
to the investment cost and this is a
again as i state it's a very important
metric for approval of a project or an
initiative
let's take an example if there are a
certain number of
business use user perform users
performing a certain
activity and let's say on an yearly
basis
that amount is around hundred thousand
dollars spent year-on-year for that
particular
activity and there is a proposal
for automating that part and the
cost for implem implementing the
solution would be let's say 50 000
and then year on year maintenance cost
of ten thousand dollars
so if you look at a five-year uh time
frame
without implementing this solution the
cost would be around five hundred
thousand dollars
a hundred thousand dollars a year on
year but if we implement the solution
the total of cost for five years would
be hundred
thousand dollars uh fifty thousand
dollars for
first year and then ten ten ten ten for
the subsequent years
sorry it's 90 000 so when you're looking
at five year time frame
with implementation of the solution it's
90 000
without implementation of the solution
it's 500 000
so there's a clear benefit
of 410 000 uh saved due to implementing
this particular
proposed solution so when you present
these figures to the business it's easy
for them to
take a decision for providing the
funding and go ahead for a project or
initiative
moving on to the last question question
number 15
what is uat i believe most of you guys
already know
know the answer but i just wanted to
cover it off
the uat stands for user acceptance
testing
uat is performed by the business end
users
of that particular application and they
check whether
the developed software works in line
with the with their business
requirements
and the business analyst role in this
part would be to
assist the end users to perform uat
uh by helping them with the test cases
desk scripts
defect arising a defect defect
management or defect resolution
and also to clarify whether a certain
request which is
raised during uat whether it's part of
the initial requirement
or is it a scope creep
hello there do you have a business
analyst interview coming up shortly
if so this is one of the videos for you
in this video we're going to cover the
top 11 into week questions
asked on sql queries
you may be wondering why would they ask
sql query
in a business analyst interview if you
are appearing for a
role of a system analyst it business
analyst
or in a techno functional role then
definitely there will be questions
on sql so this video will help you
prepare for the interview and also
having a techno
functional expertise is always
considered a plus
during the hiring process so we have a
lot to
cover let's get started
before we proceed further i would
request you to please go ahead and
subscribe
to our youtube channel if you have not
already done so and also please go ahead
and click on the bell icon so that
you will be notified when we will be
uploading a new video in the business
analyst
interview series we are planning to
upload 10 more videos
so please go ahead and click on the bell
icon so that you're notified whenever we
upload it
okay let's get started as we usually do
we look we take a case study and then
answer the questions using the case
study
so in this case study we are going to
have
a company e-commerce company which is
selling
electronics like mobile phone laptop on
tab
tablet and this is a particular
table in the database called orders
which kind of
records who's the customer what are they
ordered
what is the value of the order in which
city they awarded and also the
mode of payment is it cash paypal
or credit cards so we're going to use
this table and then we're going to
derive the the queries and also look at
the results
question number one how do you retrieve
all records from a table
so this is one of the most commonly
asked and the
basic question anyone will ask you an
interview so the sql query for that
is select star from table name so
in our example the table name is order
so that's why it's select star
from orders and the result would be all
the
rows and the fields which we saw in the
table
would be displayed
question number two how do you retrieve
only
custom name and order value fields so
the select star
displayed all the fields from the table
now the interviewer will be checking
your knowledge
on how would you retrieve certain fields
which are of interest to you
so here the customer name and the order
value so the sql query for that
is select name
which style which is for the customer
name and value which is
for the order value from orders the
table
the result would be as such so now if
you see the result will have only
two fields or two columns corresponding
to the customer name
and the order value it won't show all
the
fields which are you know from the table
so this will help to
uh focus while you're doing the analysis
when you're
looking for only certain values uh
certain fields
and their values
question number three how do you
retrieve only customers with
order value more than five hundred
dollars so this is again
some conditionality is being uh
placed into the question so the sql
query for this
is we're going to select the name and
the order value from the table
but we're going to add a conditionality
which is
where value is greater than 500 so what
this will do is
it will only filter out the rows with
a order value more than 500 dollars
so from our previous example we had
seven rows
but now there's only four rows displayed
because
only four rows for these four uh
customers the other value is greater
than
five hundred dollars again this will
help you
i will performing the analysis and
that's why these are the questions which
the interviewer will
ask so that to kind of uh gauge your
depth
under understanding in the sql queries
question number four how do you retrieve
only customers with order value
more than 500 and from ordered from
seattle which is a city so again
building upon from the previous question
here we are further fine tweaking the
conditionality
and getting a narrower result
so the sql query for this remains the
same as what we saw in the previous
question
only the additional thing is where value
is 500 and city equal to seattle so and
city
equal to clt will be the additional part
in the sql query
which will give us a result as such uh
where
we had four rows from the previous
query but this query will return only
one because this is only
a row which satisfies both this
condition where the value is greater
than 500
and also the customer ordered from
seattle
so that's why we're again fine tuning it
so these are all again
conditional conditional questions which
will be asked to gauge your
understanding on sql queries most of the
time it will be
based on scenario they won't just ask
can you give me an example with this and
that how do you filter
it'll be most on a business scenario so
that they will they
they understand that you understand the
concept of how do you
take a business query and business
requirement
and translate into a sql query
moving on question number five so again
we are
asking how do you retrieve only
customers with order value more than 500
or more is cache again these are all
conditionalities
but here it's our conditionality either
this
or that so we'll look at the query
it is the same as what we saw previously
the only change is
after value is greater than 500 we have
a r clause
and then mode equal to cash so we are
interested in customers
with order value more than 500 or was
paid in cash
so the query will return as such if you
see there are
five rows here and i want to point out
the row number two
smith even though his order value is
less than 500 which is 450
because his cache mode the mode is cache
the sql query will return this
particular result
moving on question number seven
so here uh the question would be how do
you retrieve customers
whose order value is between 100 and
500. so this is a range question
i think we covered values now this is a
range
so the sql query for this is again name
value from orders
but we're going to use a clause called
between
so we're going to use a where value
between 100 and 500 so what this sql
query will basically
retrieve is all the order values
ranging from 100 to 500 and the result
would kind of look like this
so these are the three records which are
having a value
greater than 100 but lesser than 500 so
this is again
really useful when you're doing the
analysis and also translating the
business requirement into functional
specs and also sometimes
the itbas provide inputs
to the technical spec and that's where
all these queries will come in handy
pushing forward question number seven
how do you retrieve only customers
ordered from
seattle and baltimore so the previous
question was more of a range
and this question is uh values
if the value equals to this or that how
it will happen
so one of the uh syntax we can use
is the in in syntax
so we select name city from orders
remain the same but the where
conditionality changes with
city in seattle baltimore
so which will result the records or the
rules
of of customers ordered from seattle
or baltimore
okay moving on question number eight so
this is a very interesting question
how do you find the total number of rec
orders
so the interviewer might just ask how do
you find total number of orders in the
database
so the syntax for that is count star
so if you hit select count star from
orders it will give you
the number of records from the table
so in our case study or example we had
seven records and that's the reason the
result would have
written seven
question number nine how do you insert a
order to the table
so this is so we all the queries we
looked at till now is more of
fetching the data so this query would be
insertion or addition of a order of a
record to the table
so let's let's see the sql query for the
same
so this is a query insert into
orders which is the table name and we're
going to list on all the fields
of the particular table order number
name category
value city and mode and then we are
going to
input the values which we are going to
add to these particular fields using the
values
syntax and then we give order number is
8
name of the customer is jane the
category of purchase is mobile
value of the purchase is 300 city from
the purchase
where the purchase is made is new york
and the mode of
payment is cash so this is a query once
the query is executed
the result would look like this the
table would have an additional row
which is the last row or order number
eight
and all the parameters which we have
supplied as values
will be added to that particular row of
the table
question number ten how do you update
an order value so we looked at fetching
the records
then we looked at how we add a record to
a table
let's say we have added a record to a
table but the value is not
correct it's incorrect due to an error
so
we can use the sql query with update to
update it to the correct value
so the syntax would be something like
this update
orders set city equal to baltimore
so the city we had entered as part of
the insertion
was new york but which was incorrect
actually the customer ordered from
baltimore so now that's why we are
updating it using set city is equal to
baltimore
where order number is eight so this
order number
or where order number is equal to eight
is the clause
basically it'll search for this
particular record we know it's unique
because order number is unique and then
it'll look for
the city and replace whatever value
with baltimore so post the execution of
this query
order number eight would look something
like
like this everything will be the same
except the city would be updated from
new york
to baltimore
question number 11 the last question in
this video
how do you find customers with minimum
and maximum
order value so is this again an
uh query for analysis so if you want to
find what is a minimum order value
the syntax is select min
value which is the field name from
orders
so this would result in 225
because this is the minimum order value
in the orders table similarly if you
want to look at
what is the maximum value we want to
find out what the maximum order value
then the syntax is similar select
instead of min
it will be max value which is a field
from the orders table
and the result would be thousand so if
you've seen earlier
1000 is the highest order value placed
by a customer
till now and that's the reason thousand
would be written
so again these are all um kind of uh
analysis queries uh and it and it can be
comes in handy during the analysis
phase so that's about
it from a questions and answers
perspective so it's only 11 questions
again
as i told earlier these are all very
simple queries
but if you don't get this right you
won't progress further in the interview
uh the interviewer might not be even
interested to ask more so
i know these are basics but it's good
it's uh you know
always good to revise the basics and in
the next two videos i'll be covering
most of the more advanced sql queries
and also some more concepts
of sql like rdbms or the different types
of
keys primary key for foreign all those
things i'll be covering in the next set
of videos
so please make sure your you subscribe
to this uh
youtube channel and click on the bell
icon so that whenever we load it
you'll be notified
question number three what are the
different levels of testing
this is one of the question asked to
gauge your knowledge of different types
of
testing across the software development
life cycle
let's look at it
i've summarized it in this particular
diagram
so the first level of testing is called
the unit testing
and it is done by the developers so once
they've written the code
they check if everything works fine as
per the requirement
the second level of testing is called
sit
or system integration testing so once
the unit testing is successful
it's deployed to the sit region
and sad environment and then the the
testers would be
performing the system integration
testing just to ensure the connectivity
works
and all the test cases and test
scenarios which have written against the
requirement works well
and the thirdly the third level of
testing is
called uat or user acceptance testing so
this is done by the business users
so these are the end users of the
application which is being developed
and these are the users who would have
provided
the requirements in the first place
so they will be doing it or there will
be a representative from the business
team who will be doing it on their
behalf
so they'll be checking whether the
application develops satisfies
their requirements and once everything
is successful
then the the code moves to the
production environment
so the go live or the deployment of
production
usually happens on a weekend and
once the code is deployed to production
there will be a couple of
people from again from the business team
the end users will be checking
whether the code works fine in the live
environment so there's no hiccups
there's no
at least the basic critical test cases
would be executed by them to ensure
everything works fine so this type of
testing is called live testing
there are different names to it but the
concept remains the same
so these are the different levels of
testing
i hope it helps on
understanding the concepts involved
there
in this video you're going to look at a
variety of topics uh from business
analyst role in testing
creation of test plan rtm
test scenarios and test case creation
and also the different testing tools
used
and also we're going to look at all
these questions from a
view of a business analyst so this is a
really a different view
and all the other videos which we have
on testing interview and questions and
this talks
in specific and in relation to a
business analyst
and also if you have not already
subscribed to our channel i would
request you to please go ahead and
subscribe to our prefix ba youtube
channel so that you're notified
when we come up with the next video we
have a lot of cover so let's get started
to make it easier for grasping the
concepts and the answers
we're going to use a case study in this
case study uh
a movie theater chain called xyz cinemas
is looking to build a digital channel
for allowing the customers
to book their movie tickets online
rather than now
calling up the customer care or standing
in the long queues
and getting their tickets at the ticket
counter so we are going to use this
uh example case study for
answering all the questions
question number one what is the role of
a business analyst during
testing phase this is a sure short
question
and ninety percent of the time this
question would be
asked in the interview so there are two
major testing phases
uh one will be the site system
integration testing
the other one will be the uat user
acceptance testing so we're going to
look at
the rules and responsibilities of a
business analyst during these two
key testing phases so let's start with
sit
so the first key responsibility of a
business analyst would be the
walkthrough of the requirements
to the testers so the business analyst
will explain
what the requirement is answer any
questions from the tester so they
understand
what is being required and now what is
being developed
and then the testers will go back and
come back with the
test scenarios and test cases and that
is a second task for a business analyst
to review them and ensure that they have
got
the scenarios and the test cases right
for all the requirements
which leads us to the third point which
is checking requirements traceability
we're going to talk about more on this
in the subsequent slide when we talk
about the requirement
and traceability metrics but here just
to
this step is done to ensure that all the
requirements
are having a subsequent scenario or test
case
and then the other key part or key role
is when the test execution happens once
the defect has been locked
by the uh the testing team
it is assigned to the to the business
analyst first to ensure that
the defect is valid before it you know
gets assigned to the development team
if it is an invalid defect like invalid
scenario or the testers might not have
understood
it correctly then it can be rejected by
the business
and less than and there so that the time
of the development team is not
wasted so it's like a different triage
it's done by the business analyst
the last key thing is articulating
business
impact and assisting in defect
prioritization let's say there are like
10 defects and
there will be a question asked what is
the priority of the defects
because we might not be in a position to
fix everything by the development team
then
it becomes a responsibility of a
business analyst
to get the business impact for all those
defects
and then assign the priority one two
three so that it makes it easier for the
development team to get it done
and if there are further defects it can
be pushed over to the next release which
are not very
critical or high so that's on the site
coming to the uat i think most of the
things what we discussed
holds good for uat as well the
walkthroughs
the reviews or traceability validity of
the defects and articulating business
impact
along with that this is where there
would be additional things
asked by a business analyst that is
here creation of the test scenarios and
test cases
so as you know the uat is done by the
business users and they are not
very uh equipped with testing concepts
or you know
testing or they might not have that time
because they are doing you 18 addition
to their day job
so there will be a request rise for the
business analyst
to create the test scenarios and test
cases so this is where
your knowledge of scenarios and test
cases will come in handy
and the other one would be this
management and reporting
again due to the lack of bandwidth by
the business use users
so the management like the test planning
creation of schedule strategy
environment setup
all of those things would come as a
responsibility of a business analyst
and also the daily reporting and
ensuring the
high priority defects are being resolved
all those management
is being asked by to the to be done by
the business analyst
ideally these were a traditional role of
a test manager
but nowadays the trend has been the
business analysis are being asked to
pitch in
so having knowledge of these will give
you edge
over the other candidates in the
interview process
question number two what is functional
and regression testing
i know there are a lot of different
types of testing sanity testing load
testing performance testing etc etc
but with respect to business analysts
these are the key
or two key types of testing which is
functional and regression
so let's look at them quickly first one
is functional testing
this refers to testing of
functionalities developed
as part of that current release so these
are the new functionalities which are
delivered
and testing of those functionalities is
referred to as functional testing
regression testing so this refers to
testing of the existing functionalities
and to ensure that they still work fine
post addition of these new
functionalities to the application so
this is usually done
at the end of the test cycle let's try
to look
at these with an example
so again the example refers to our case
study and
the new release delivers the online
payment functionality to the customers
so prior to this release customers were
using the application to book movie
tickets
post booking the tickets they would use
to get a confirmation and then they used
to give the confirmation to the ticket
counter and pay
make the payment either using cash debit
card or pay mobile balance at the ticket
counter
suppose this release the customers can
make online payments
through the application itself so they
don't have to
take the confirmation go to the ticket
counter and all of those things so it's
much more simplified and a better
customer experience
right so let's look at what is
functional and regression testing
in this example functional testing so
this refers to the
online payment functionality which is
being
deployed as part of the current release
so it's a new functionality
so testing of that is known as
functional testing
regression testing so testing of the
functionalities which were already
existing which is like registering
login seat selection for the movies
so all of these are existing
functionalities and they still need to
work post the deployment of the online
payment functions
functionality so testing of those
existing functionality
is referred to as regression testing so
these these are the
key uh types of key to uh two types of
testing and which would be
asked by the interviewer
question number four what is a test
scenario
a test scenario refers to a particular
functionality which needs to be tested
as simple as that so test scenarios
uh can be created using use cases
if your project is using waterfall
methodology
or acceptance criteria if your project
is using agile methodology
so if the business asks you can you
create the scenarios
there's no need to panic all you have to
do is translate the use cases
acceptance criteria to test scenarios as
simple as that
let's look at a couple of examples to
give a
wider context so again these
examples are taken from our case study
so test scenario number one
check the search functionality for the
movies so this scenario basically talks
about
where the customer can enter a keyword
and the appropriate movie
appears in the listing test scenario
number two
check the availability of seats for a
particular movie so this is where the
customer logs in
selects the movie the timings and then
goes to a screen where it shows
which seats are available or which seats
are not
for selection so the seats which are
available maybe in white and the seats
which are not available
can be grayed out just scenario number
three
check for the online payment
functionality so this is a functionality
where the customers can
pay using credit card debit card paypal
or any mobile ballots so if you see
all these scenarios test scenarios are
basically
either use cases or acceptance criteria
so
if a need arises for you to create a
test scenario
it's as simple as translating the user's
use use cases or acceptance criteria
question number five what is the test
case or the components of test case
so this question uh is another commonly
asked one
so test case is defined as a series of
actions executed to verify a particular
functionality
so basically this is an extension of the
test scenario
so these are the steps taken uh by the
tester
to verify whether the test scenario is
as per the expectation
so let's look at it using an example
so if we you look at the test scenario
which was check the availability of
seats for a particular movie
let's see how a test case for it looks
like
so there will be a test case name so can
we test the seat availability
display and then this table and the
columns are pretty key here
so it has the step number description
expected result
actual result pass fail defect id so
this answers what are the components of
a test case
if asked the
these are the key information key
columns there can be additional
columns used by the sit testers but
again if
if if it's from a uat perspective and
you're preparing
a test case this is more than sufficient
so let's look at the example so step
number one
and the description so the description
is like enter the xyz cinema url
what is the expected result this xyz
cinema's website should open in a
browser
and step number two search for a movie
expected result is the search movie
should appear with an image
and the name step number three uh click
on the movie
uh name or image once it is clicked the
expected result will be the timing
should be displayed
and then the last step is to click on
the particular time
and here is where the the key
uh test key expected result is which is
the seating arrangement should be
displayed with the available seats in
white
and the reserve seats or the book seats
already grayed out so this is the
expected result
so you're doing all the steps involved
to come to step number four to check
whether the available seats are
shown in white yeah and can be clicked
so this is how a test case looks like or
these are the components of test case
so this can be used to answer the
question as far as in the interview
and if the business asks you to prepare
a test case you can use the same
template
to prepare one for the uh the business
in the next slide we're going to look at
the test execution
and how the remaining columns are filled
so let's look at it in the next slide
previous slide if a question is asked
what happens in the
execution so you can use this
explanation as a reference
let's say a business user is executing
this particular test case as part of the
uat
the actual result pass fail and defect
id the last three columns should be
updated as part of the execution so if
you go
by this so the first step was to enter
the url
for the xyz cinemas the website should
open
which which it did and then the second
step was to search for a movie
the actual result was once it was
searched the movie with the image
was displayed the relevant movie which
the customer was uh
searching for and then once the the
movie was clicked
the timing should have been displayed
which was displayed
in this uh execution cycle so once these
steps are successful
uh which is the actual result is as per
the expected result
then the pass fail column should be
updated with pass pass pass indicate
indicating that these steps were
successful let's
look at the last step where once you
once the particular time is clicked
the seats available seats should be
shown in white
but what was observed was all the seats
were grayed out
even the available seats so which is a
fail
so this particular step was not
successful so when this happens
the tester needs to indicate it by
fail by updating the password column as
fail and then
a defect has to be erased so a
tool which is used for defect management
jira qc whatever is used in the
particular project
defect has to be raised the defect
usually contains
what is the defect what is the problem
expected actual results what are the
steps taken
all of this information is already
available it can be taken here and copy
pasted there
and also accompanying screenshots so
this will help
for further investigation of the defect
we're going to look at the defect
life cycle the next question but just
wanted to
give you a view of what all the key
components of raising a defect
so this is what happens in the execution
so if there's any question asked
so this explanation can be used to
answer
answer it
question number six explain the defect
life cycle
so this is one of the most commonly
asked question in the interviews on
testing
so let's look at it so it all starts
with a defect being raised
by the testing team it can be sit or it
can be uat the business user
the the life cycle remains the same so
the defect is rise
i've indicated the status of the defect
by the highlighted yellow box
the status of the defect will be new
and before going to the next step it's
very crucial and critical
that the the these components are
present
in the defect which is the description
of the defect what exactly is a
there's a problem and what is what was
the expected result
what is actual results and what was the
steps
taken to execute this particular test
case
and then the screenshots the relevant
screenshot so this will really help
the the analysis of the defect to be
very
faster so once the defect is raised it's
usually assigned to the business analyst
so it's your job to first check whether
all of these components are
available if not first and foremost you
have to inform the testers to add all
these components
so it comes to the business analyst the
business analyst first checks whether
it's valid or not
whether it is asked by the requirement
or the testers are
testing something which is autoscope so
if it's
valid then it is it gets assigned to the
development
team and the status of the defi defect
gets changed to assign
and in case if it's not valid the
business analyst rejects the defect
stating it's an invalid and also the
reason for rejection
and the status of the defect goes to
rejected
and then once it is assigned to the
development team the development will
team will check the validity of the
defect first
if it's not valid maybe it's this
detailer or environment
then it gets rejected as invalid with
the reasons specified by the
development team but in case it's valid
it goes
further investigations are done by the
development team so the first check is
to check whether
if there's any duplicate defect already
out there so this is
more common when if you're doing a
pro testing of an application for a
global robot
so there will be multiple countries
involved or multiple stakeholders
testing the same thing
what would happen in that scenario as
there would be
multiple testing teams testing the same
functionality and there are a lot of
cases where there might be duplicate
defects so they'll check whether it's
duplicate or not
if it's duplicate they will tag it to
the original defect or the defect which
was raised first
and the status of the of this particular
defect will be a duplicate
and then let's say it's not a duplicate
they will check whether
they're able to fix it so there are
several reasons where the
development team might not be able to
fix a defect one of them would be the
time constraint let's say that defect is
raised three days uh uh
until the end of the testing cycle or
two days or on the last day so this
doesn't give the development team enough
time to fix it
or if a defect is too complex to fix
maybe it requires architectural changes
so there are variety of reasons where
they won't be able to fix it
in that particular release then those
type of defects would be
deferred to the next release and the
status of that particular defect would
be deferred
and then let's say they're able to fix
it if they're able to fix it
then they would resolve the fix and then
they will deploy the fix
so once this deployed the fix is
deployed the status will change
to fixed indicating the testing team to
retest the defect
so that defect will be retested if the
defect is fixed
or not if it's not fixed it will be
reassigned back to the
development team with with stating the
same thing the
providing the resale read test results
the screenshots etc etc
let's say if it is fixed then the defect
will be closed
and the status of the defect will be
closed and
also there are the other defects the
rejected ones and the duplicate ones
are also will be moved to closed
eventually
and then this brings us to the end of
the
defect lifecycle again a very key
question so
you can use this and also try to use an
example when you explain this to the
interviewer
question number seven what is the
difference between priority and severity
again a very commonly asked question and
it's a
tricky one most of the people get it
wrong and this is a key one for a
business analyst because
business analysts are involved in the
prioritization of a defect
so let's look at it priority
priority basically defines the order in
which the defect should be
fixed and it's based on the business
value so let's say there are
10 defects the priority defines
how the development team should be
fixing them and the priority is based on
the business value again
so one of the key activities and
responsibilities of a business analyst
is during the defect management defect
triage to come up with this priority
so which will help the development team
to fix the key defects
uh for you know the release so that you
know the release goes as per planned and
the lesser priority ones can be
taken up in the next release
severity so cvrt is a degree of impact
the defect has on the operation of the
application
so this is the functionality's uh impact
so if for key functionality it doesn't
work
the severity is very high and it is
severity is based on the impact of
functionality
so there are again two priority and
severity are two different things but
you know it may look the same but they
are slightly they're two different
things
uh let me try to explain this with an
example and this is also
again a commonly asked question can you
tell me an example of high priority and
low severity
so one of the things is the company logo
is wrong so there is no key impact to
any functionality if a company logo is
wrong
so it doesn't the severity is very low
but the priority is high because if the
company logo is not
correct one if the customers who are
visiting the xyz cinemas online booking
website they may think you know what
this is not the website
or this may be a scammy website or there
are a lot of
thoughts and this will prevent the usage
of
usage of this particular online booking
service by the customers
so from a business perspective it is a
very high priority
and it needs to be fixed so this is one
of the key
examples which can be given the other
one is
high severity and low priority so
the footer links on the online booking
platform does not work let's say for an
example
so they don't work and from a
functionality perspective a url not
working is a high severity
but if if the online booking
url if it's not working like if they
click on book tickets if that doesn't
work
then again it becomes high priority but
if the
footer links does not work it becomes
low priority the reason being is
most of the customers don't use it let's
say 90
of the customers don't click on the
footer links so
in case if it's not being fixed on this
particular release due to the resource
or time constraint it can be fixed in
the
next release so it becomes a lower
priority
so this is the difference uh and uh you
can frame
you can use examples from your own own
past projects so that'll add more value
while answering this particular question
moving on to question number eight what
is rtm or requirement traceability
matrix
we covered this in couple of our videos
earlier
but i'm going to cover it today just
from a testing perspective
so as you know it's a matrix used to
test requirements backward and forward
from a testing perspective what is
required
here is to ensure that all the business
requirements are covered
as part of testing which is the
mapping of the requirements to the test
cases so if you look at an example the
business requirement
would be mapped to the stakeholder
requirements and stakeholder requirement
would be mapped to the functional and
non-functional requirement
and then the functional requirements
which would be
mapped to the test scenarios and test
scenarios will be mapped to the
test cases so this is
the key part and when as a business
analyst
as we spoke about in the first question
that is
one of the key responsibilities of a ba
is to review the test cases
and ensure you know that it all covers
all the requirements so you can use the
requirement traceability matrix to do
that
so you can map all the test scenarios
and test cases
and ensure that everything is covered as
part of the test cycle
both from an sit and also can be same
can be used from a uat perspective
this brings us to question number nine
the last question what are the tools
used in testing so this
particular question is asked used to
just test your exposure to testing
related activities and also the
artifacts
you can just pick and choose from the
table here to answer this particular
question
so the test strategy test plan uh
documentation is done by ms wood
we didn't cover this as part of the
video this is
another thing it might require a video
on its own but this plant
strategy is basically a document which
provides the approach which would be
used for testing the testings which are
in scope
the schedule when will the testing will
happen in scope out scope
and also the rules and responsibilities
and reporting
uh but it's a video on its own so that's
the reason i didn't cover it here
but it's all done using ms word and then
the test cases documentation the test
case
which we discussed so the documentation
is done using
qc or alms so these are the tools used
if there's no tools used then it will be
just
ms office which is the excel and then
the google sheets
if the company doesn't use office and
they just wanted to use
the google suit then google sheets is
used and then for execution
qc or alum is used so in the tool itself
once the test cases are done instead of
updating it
on an excel spreadsheet the testers can
update it directly in the tool itself
and reporting is very quick you can just
export the whole results
for you used on the test execution
update done to qc or alum so that's one
key tool
and then the defect logging so we
discussed the defect lifecycle
and the there are a lot of tools in the
market for defect management
and logging defects so the common used
ones are jira
in case of agile if it's waterfall still
the
qc alum is used and we have bugzilla and
clearquest so these are some common
common use tools which have come up in
the recent past
and then for screenshots for defects so
i've stated that the screenshots are
very key
for defect management and for
screenshots
we have some sniping tools like uh
snagit
uh light chart screen ticker if nothing
works you can just
take a screenshot and edit it using ms
paint so this helps
to provide more details in the defect
for the business analyst or also
the development team for quicker
resolution
and in case if there's database testing
involved then
toad or squirrel is used
commonly used so these are some commonly
used
tools you can just pick and choose based
on your experience while
answering this particular question
wow that's a long video i didn't expect
it when i started filming
but thanks so much for sticking around
to this point
did you enjoy this video if so i would
request you
to go ahead and subscribe to our youtube
channel
and also download the business analyst
interview
guide so there's a link in the
description you can click on it and
download it
it will have over 50 plus questions
again commonly asked questions
which will help you to smash your next
business analyst
interview so please go ahead and
download it and use it
as a prep material for your next
business analyst interview
and also i request you again to
subscribe to our channel
we post videos regularly on business
analyst techniques tools
uh tutorials and also interview prep so
until
i speak to you in the next video thank
you so much for listening to this
particular video
see you around and bye bye
UNLOCK MORE
Sign up free to access premium features
INTERACTIVE VIEWER
Watch the video with synced subtitles, adjustable overlay, and full playback control.
AI SUMMARY
Get an instant AI-generated summary of the video content, key points, and takeaways.
TRANSLATE
Translate the transcript to 100+ languages with one click. Download in any format.
MIND MAP
Visualize the transcript as an interactive mind map. Understand structure at a glance.
CHAT WITH TRANSCRIPT
Ask questions about the video content. Get answers powered by AI directly from the transcript.
GET MORE FROM YOUR TRANSCRIPTS
Sign up for free and unlock interactive viewer, AI summaries, translations, mind maps, and more. No credit card required.