TRANSCRIPTEnglish

[Top 80] Business Analyst Interview Questions and Answers

2h 58m 9s27,202 words5,047 segmentsEnglish

FULL TRANSCRIPT

0:03

hello there

0:04

if you have a business analyst interview

0:06

coming up shortly

0:08

then this is the video for you over the

0:10

last two years

0:12

we have published several videos on

0:14

business analyst interview preparation

0:16

we have merged the key questions into

0:18

this single video

0:20

we have covered 80 plus questions

0:23

ranging from stakeholder management

0:25

requirements agile methodology sql to

0:28

testing in this video

0:30

this video is ideal for your preparation

0:33

just the day before your interview when

0:34

you are short of time for it

0:36

go over this video and attend the

0:39

interview with confidence

0:41

the video is split using chapters for

0:43

easy navigation to your interested

0:46

section

0:47

if you have not already subscribed to

0:49

our channel please go ahead and

0:51

subscribe to our channel

0:52

and hit the bell icon we have lots to

0:55

cover

0:56

so let's get started

1:01

do you have a business analyst interview

1:03

coming up shortly

1:05

if so this is one of the videos for you

1:08

in this video we are going to cover the

1:11

top eight interview questions

1:12

pertaining to stakeholders identifying

1:16

and

1:16

engaging stakeholders is the vital part

1:19

for the project's success

1:20

and one of the key activities for a

1:22

business analyst

1:24

and hence interviewer would be keen to

1:26

know the list of stakeholders you have

1:28

interacted with

1:30

how you identified them and also the

1:32

challenges you faced while interacting

1:34

with them

1:36

we are going to cover these questions in

1:38

this video so

1:39

stay tuned if you have not already

1:42

subscribed

1:43

please go ahead and click on the

1:45

subscribe button and the bell icon

1:47

so that you are notified when we post a

1:50

new video

1:51

and we post regularly on business

1:53

analysis interview preps skills and

1:55

techniques

1:57

okay we have got a lot to cover so let's

2:00

get started

2:04

as always we will use a simple case

2:07

study which will

2:08

make the concepts easy to grasp rahul is

2:11

a ba

2:12

working with a client running a

2:13

restaurant called wagon gardens

2:16

the client is looking for a mobile app

2:19

which will allow their customers to book

2:21

a table

2:22

let us use the simple case study and see

2:25

who the stakeholders for this project

2:27

are how to identify them and the

2:30

challenges faced while interacting with

2:32

them

2:34

question one who is a stakeholder

2:38

stakeholder can be defined in simple

2:40

terms

2:41

as a party who will be impacted with the

2:44

change

2:45

they can be classified under two

2:47

categories

2:49

who receives the benefit and who will

2:51

deliver the change

2:53

who receives the benefit these are the

2:56

end users

2:57

customers business unit managers

3:00

operation team manager and so on

3:03

and who will deliver the change this is

3:06

the project team

3:07

ranging from project managers developers

3:10

testers trainers and so on

3:14

moving on to question number two who are

3:16

the list of stakeholders you have worked

3:18

with

3:20

this question is asked by the

3:22

interviewer to know the depth of your

3:24

interactions

3:26

we can cover the various stakeholders

3:28

here again

3:29

look at from our classification earlier

3:32

for the first category who receives the

3:34

benefit

3:36

it comprises of business unit manager of

3:39

the unit which gets benefited

3:42

in our example it would be the sales

3:44

department manager

3:46

who would be benefited by this change as

3:48

it would help to streamline

3:50

and ease stable booking for the

3:51

customers which should result in

3:54

increase in the number of visitors

3:56

boosting sales

3:57

and also helping saving cost by reducing

4:00

the number of people

4:02

allocated for taking phone reservations

4:05

the next would be the customers in the

4:08

example again

4:09

the customers who have to call and wait

4:11

for making the table reservations can do

4:14

so

4:14

just with the touch of few buttons in

4:16

their mobile and can get a table booked

4:19

with

4:19

instant confirmation sent to them

4:23

this solution would also benefit the

4:25

staff at the hotel

4:26

who are also using the staff and of the

4:28

application

4:29

for viewing the customer reservations

4:32

all the manual tasks for

4:34

checking the availability and making the

4:36

list of reservations for the given day

4:38

have all been automated and this results

4:41

in

4:42

increased staff efficiency

4:45

subject matter expert they are usually

4:48

part of the business unit operations

4:50

team

4:51

who have been working on the current

4:52

system and process

4:54

for a considerable amount of time and

4:57

are usually

4:57

experts and can provide guidance on the

5:00

current state

5:01

and also help to identify problems and

5:04

provide

5:04

recommendations on the target state

5:07

the last category is regulators

5:10

they are regulating body who ensure

5:13

compliance in our example

5:15

they may not be appropriate but just

5:17

wanted to list

5:18

as they are also a key stakeholder

5:22

so as part of the requirement gathering

5:24

sessions

5:25

the above stakeholders are your key

5:27

people you need to engage

5:29

and gather the requirements as you would

5:31

be working to satisfy their needs and

5:34

objectives

5:36

coming to the next category who delivers

5:38

the change

5:40

this includes the business sponsor who

5:42

is responsible for funding

5:44

and delivering the change and is your

5:46

key stakeholder

5:48

to engage when you are stuck or you need

5:50

guidance

5:51

and also sponsor would help in

5:53

identifying the stakeholders

5:56

next we have the support business units

5:58

like legal and marketing units

6:01

they will also provide further guidance

6:03

on shaping the change

6:05

to ensure we are covered from all the

6:07

angles

6:09

the rest of the people are what is

6:11

generally termed as the project team

6:14

project managers can be one or more

6:17

based on the scale of the project

6:19

they ensure the project gets delivered

6:22

as per the deadline

6:23

and are responsible for the plan

6:26

then we have the developers and testers

6:29

to develop and test the software

6:31

in accordance with the functional

6:33

requirements

6:35

lastly the trainer who is responsible

6:38

for training the staff with a new system

6:41

in our example trainer can be a senior

6:44

person in the staff

6:45

who would be responsible for training

6:47

the staff with navigation and working of

6:49

the new system

6:51

and also creation of standard operating

6:53

procedures

6:55

ba works with them by providing working

6:57

screenshots of the system

6:59

and also help to draft the standard

7:01

operating procedures

7:04

this covers more or less the list of

7:06

stakeholders

7:07

and when you are explaining you can use

7:10

your project examples and go over

7:14

question number three how do you

7:15

identify stakeholders

7:18

this is another commonly asked question

7:21

the interviewer would ask once you join

7:24

the project

7:25

what would be your approach for

7:26

identifying the stakeholders

7:30

listed below are a few techniques first

7:32

one

7:33

contacting business sponsor you can get

7:36

a list of stakeholders

7:38

by contacting the business sponsor you

7:41

can also check with the project manager

7:43

who would be able to help you with the

7:45

stakeholder list

7:47

second one organization charts

7:50

you can use the organization charts of

7:52

the impacted business unit

7:54

to identify the stakeholder list

7:57

third one process models

8:00

in complex environment where the process

8:03

is handled by multiple teams

8:05

if you can look at the process models it

8:08

would have to identify the impacted

8:10

teams

8:11

fourth one document analysis

8:14

if you look at the existing documents of

8:17

your organization

8:18

you can get the stakeholder list from

8:20

there

8:21

fifth one also when you are meeting the

8:24

identified stakeholders

8:26

they will also provide some names during

8:28

the discussion

8:29

and that is another source of getting

8:31

the impacted stakeholders

8:34

in our case study since it is a small

8:36

team of people

8:37

the business sponsor in our example

8:40

would be the owner of the restaurant

8:41

chain

8:42

who would be able to provide the names

8:44

of the managers

8:45

from sales and operations teams and also

8:49

based on the discussion with them we can

8:51

get additional names

8:53

moving on to question 4 what would

8:55

happen if you miss a key stakeholder

8:58

the interviewer might ask since there

9:01

are a lot of stakeholders in a complex

9:03

program

9:04

and missing one of you is possible and

9:06

what do you think will happen if

9:08

we miss again it's a good question

9:11

which emphasizes on the stakeholder

9:13

management

9:15

the answer is the solution which we are

9:17

developing

9:18

may not go live until the requirement of

9:20

the missing stakeholder

9:22

is taken care of causing delays and it

9:25

may also result in development

9:27

and testing rework as it may have an

9:29

impact on the existing functionalities

9:33

let us take an example from our case

9:35

study

9:36

what if we did not engage the operations

9:39

team on the ground

9:40

who is involved in seating of the

9:42

customers

9:44

their requirement could have been to

9:46

have a screen which shows the list of

9:48

reservations for the given day and the

9:50

allocated table numbers

9:52

in case this is not built even though

9:54

everything is ready from a customer

9:56

perspective

9:57

we still cannot go live with the

9:59

solution until this is built

10:02

this would result in developing the

10:04

screen near to the goal life

10:06

causing delays and reworks hence it is

10:09

very

10:10

important to identify all the impacted

10:12

stakeholders at the beginning phase of

10:14

the project

10:16

question number five what is a racy

10:19

matrix

10:20

racy matrix stands for responsible

10:23

accountable

10:24

consulted and informed it provides a

10:28

view of the responsibilities of the

10:30

involved stakeholders

10:33

let us take the requirements task in the

10:35

table as an example to walk through

10:38

first one is r which is responsible

10:41

this indicates the person who will be

10:43

performing the task

10:45

as you're all aware business analyst is

10:48

a person

10:48

who will be gathering and documenting

10:50

the requirements

10:52

hence in the table if you can see under

10:54

the requirements task

10:56

it is marked as r for the business

10:58

analyst

11:01

next is a or accountable

11:04

this is a person who is accountable for

11:06

the task

11:08

in our example business analyst is

11:10

responsible for gathering and

11:11

documenting the requirements and the

11:14

project manager is accountable

11:16

to ensure it is done within the agreed

11:18

timelines

11:20

project manager is ultimately held

11:23

accountable and answerable for the

11:25

successful completion of the task

11:28

next in the line is c which stands for

11:31

consulted

11:33

this stands for the stakeholders who

11:35

will be asked to provide

11:36

information or guidance about the task

11:40

in our example sma group is marked as c

11:43

as they would be the participants of the

11:45

requirement gathering sessions

11:47

and the ones who provide the

11:49

requirements to the business analyst

11:52

next in the list is i which stands for

11:55

informed

11:56

this is the next group of stakeholders

11:59

who need to be informed

12:01

in our example i have marked the

12:03

technical lead and test leads as

12:05

informed as they have to be kept

12:07

informed about the completion of the

12:09

requirement gathering

12:12

question number six what is a

12:14

stakeholder matrix

12:16

stakeholder matrix is a list of

12:18

stakeholders

12:19

as you can see on the slide it has the

12:22

following details of the stakeholder

12:24

like

12:24

name role they contact details

12:28

impact to them due to the change and

12:30

also their influence to shape the change

12:34

let us look at the example matrix

12:36

created for our case study

12:38

we have john who is the restaurant owner

12:41

and sponsor for this project

12:43

who has high impact and high influence

12:47

you have to work closely with him and

12:49

ensure you have his agreement and

12:51

support on all aspects of the change

12:55

next we have jane who is the operations

12:57

manager

12:59

the change has high impact on her as she

13:02

and her team needs to adapt to the new

13:04

ways of looking

13:05

up at the reservations and using the

13:08

tool to seat the customers

13:10

but she does not have high influence

13:13

however she and her team are also key

13:16

end users of this

13:18

staff side of the application and rahul

13:20

rba from the case study

13:22

should engage and understand their needs

13:24

and interests

13:26

they can become the goodwill ambassadors

13:28

for the change

13:30

next up in the line we have sean who is

13:33

one of our

13:34

chefs and one who gave a tour of the

13:36

kitchen and

13:37

walked through of the menu when rahul

13:39

visited the restaurant

13:40

as there is a next change proposal to

13:43

enable online delivery

13:45

but from the current change there is not

13:47

much impact to sean

13:49

and hence from an impact perspective we

13:52

have

13:52

none and also he has low influence

13:56

he just have to be kept informed at the

13:58

most on what is happening on the change

14:02

then we have kelly who is the finance

14:04

manager

14:05

she has no impact directly due to the

14:08

change

14:09

but has high influence as she holds the

14:11

budget

14:13

the ba should meet and ensure she is

14:15

believed and

14:16

rally up her interest in this change

14:20

question number seven what are personas

14:23

personas are fictional characters which

14:26

represent your typical customers

14:30

they are helpful to understand the

14:31

customer's needs

14:33

and build the product accordingly first

14:36

off

14:36

personnels will be created based on the

14:39

brainstorming ideas by the internal team

14:42

and post that research is conducted with

14:44

the actual customers

14:46

to validate the team's assumptions using

14:48

a number of requirement gathering

14:50

techniques

14:52

identifying and validating the needs of

14:55

the personnel

14:56

are very important to ensure we are

14:59

building the product

15:00

which satisfies their need let us take

15:04

two personnels for example

15:06

first one the office manager

15:10

this is a typical manager who has number

15:13

of team members reporting to him

15:16

there would be quarterly or sometimes

15:18

monthly team outings

15:20

and the manager is responsible for

15:22

looking for the fun places

15:24

to have a team lunch or dinner their

15:27

needs

15:28

are quick snapshot of the service

15:30

offerings

15:31

and also a receipt of the bill emailed

15:34

to them

15:35

so that they can do claims for

15:37

reimbursement

15:38

as all the outings are built to the

15:40

company

15:42

second one is the family man who wants

15:44

to book on the weekends for a brunch

15:47

lunch or a dinner he does not care about

15:50

the digital copy of the bill

15:51

but is very keen on the services offered

15:54

for

15:55

the kits and the seating arrangements

15:58

if you see just going at the high level

16:00

we have got two requirements

16:03

first one soft copy of the bill to be

16:06

emailed as a pdf

16:08

second one the service offerings should

16:11

be shown in the booking app or the

16:12

website

16:14

again these two are just assumptions and

16:17

have to be validated

16:18

based on the actual customer research

16:23

moving to the last question in the

16:25

series question number eight

16:27

tell me about a time when you managed a

16:29

difficult stakeholder

16:31

this is a very common question and i

16:34

have just listed two of the common

16:36

scenarios i bet you would have faced one

16:39

of these in your project you have worked

16:40

on

16:41

the first one is the conflicting

16:43

stakeholders

16:45

this is very commonly faced where the

16:47

key stakeholders are not agreeing with a

16:49

decision or an approach

16:51

and without their agreement we cannot

16:53

move forward

16:55

one of the things which works in this

16:57

scenario is

16:59

meeting them separately and identifying

17:01

their concerns

17:03

and work on mitigating the same

17:06

in our case study let us consider a

17:08

scenario

17:09

where the sales department head wants to

17:12

only focus on having the website or the

17:14

application

17:15

for the customer to make the booking but

17:18

the operations head wants to have

17:20

a fully functional staff facing portal

17:22

to help the staff

17:24

for which the sales head feels is a

17:26

wasted effort

17:29

rahul rba can meet both and try to

17:32

facilitate an agreement

17:34

as you see both of them from their point

17:36

of view are right

17:38

here rakhi can meet them separately and

17:41

understand their concerns

17:42

and explain a workable approach which in

17:45

this case can be

17:46

in addition to the customer facing

17:48

website and application

17:50

a minimalistic staff facing portal with

17:53

only some two to three key functions can

17:55

be considered

17:57

this would be a win-win situation for

17:59

both the parties

18:02

second one is unavailability of

18:04

stakeholders

18:05

this is a very common problem you invite

18:08

the key stakeholders for meeting and

18:10

they don't turn up

18:11

they don't return your phone calls or

18:13

your emails

18:15

there are two approaches for working

18:17

through this situation

18:19

the first one can be in the

18:20

communication to the stakeholder

18:22

whether it is an email or a voicemail

18:25

you can explain the importance of the

18:27

project

18:28

and the impact and the benefit the

18:30

change will have on their department

18:33

this usually works by getting their

18:34

attention

18:36

second one can be approaching

18:39

to connect you with their deputy or any

18:42

other team member

18:43

who can help if they are busy at the

18:45

moment

18:47

this is a common issue when dealing with

18:49

senior stakeholders

18:51

and the about two approaches work like

18:53

charm

18:54

use your project experience and see if

18:56

you can link them to

18:57

these two categories while answering

19:02

hello there do you have a business

19:04

analyst interview coming up shortly

19:06

if so this is the video for you as you

19:09

know

19:10

a key responsibility or a skill for a

19:12

business analyst

19:13

is to elicit document and maintain

19:16

requirements and this video is going to

19:19

help you to discover the top

19:21

9 commonly asked questions in business

19:24

analyst interviews

19:25

on requirements so that you are well

19:27

prepared

19:34

to make it easier for grasping the

19:37

concepts and the answers

19:38

we're going to use a case study in this

19:40

case study uh

19:42

a movie theater chain called xyz cinemas

19:44

is looking to build a digital channel

19:46

for allowing the customers to book their

19:49

movie tickets online

19:50

rather than calling up the customer care

19:54

or standing in the long queues and

19:56

getting their tickets

19:57

at the ticket counter so we are going to

20:00

use this

20:01

example case study for answering all the

20:05

questions

20:09

question number one how do you define a

20:11

requirement

20:12

as per babblock version 3 a requirement

20:15

is defined as a usable representation

20:17

of a need to simply put a requirement is

20:20

articulation of a business need for

20:24

solving a problem or capitalizing on a

20:26

business opportunity

20:28

this representation is actually required

20:32

for the engineering team to develop the

20:34

solution

20:35

accordingly to meet the business need

20:38

i've listed few of the examples here so

20:41

these are

20:41

different types of requirements which

20:43

we'll be covering in this

20:45

video i just listed it here to

20:48

give you a view of the requirements so

20:51

number one

20:52

sales department needs a digital channel

20:54

for allowing customer

20:56

customers to book their movie tickets

20:58

online basically it's expanding on the

20:59

case study

21:01

then the system shall display the

21:03

available seats for a movie show

21:05

systems shall allow the customer

21:07

customers to select the available seats

21:10

a system should respond within two

21:12

seconds of a user's input

21:14

a customer can book a maximum of 10

21:16

tickets

21:17

at one time so these are all different

21:20

statements

21:20

as i was stating earlier you know these

21:22

are all different types of requirements

21:24

which we'll be

21:25

covering shortly the nature of the

21:28

representation may be a document or set

21:30

of documents and it

21:31

varies depending on the circumstances

21:33

and the methodology used in developing a

21:35

solution

21:36

we're going to cover this in question

21:38

number nine so

21:39

stay tuned

21:57

question number two what is the

21:59

difference between a

22:01

business and a functional requirement

22:02

this is one of the tricky question

22:04

which is asked in the interview i'll try

22:06

to simplify it

22:08

using the below two tables first off

22:11

business requirement business

22:13

requirements are

22:14

basically representation of a business

22:16

need

22:17

goal objective or outcomes it represents

22:21

the what

22:23

example sales department needs a digital

22:26

channel

22:26

for allowing customers to book their

22:28

movie tickets

22:30

it's very high level and it just

22:33

represents

22:34

what is required by the sales department

22:37

it doesn't give guidance on how it can

22:40

be achieved

22:40

it just represents the what functional

22:43

requirements

22:44

on the other side they describe what

22:48

a system must do to achieve the business

22:51

requirements

22:52

it represents the how example

22:55

the system shall display the available

22:58

seats

22:59

for a movie show the system shall allow

23:02

the customers to select the available

23:04

seat

23:06

ideally it talks more on how

23:09

to meet the business requirement and you

23:12

can see

23:13

it kind of ties back into the business

23:20

requirement

23:23

question number three what is a

23:25

non-functional requirement

23:27

so this is this question can be asked as

23:30

a standalone question

23:31

or it can be also stated as can you tell

23:33

the difference between a functional

23:35

and a non-functional requirement so

23:38

we're going to cover that in this slide

23:40

non-functional requirement is a quality

23:43

requirement or a constraint

23:45

to the solution so it covers the

23:47

following aspects

23:49

so first one is performance so what

23:51

should be the response time

23:54

for a system to respond to a user's

23:56

input so that is captured as part of a

23:59

non-functional requirement related to

24:00

performance second one would be security

24:03

how

24:04

secure the system or the solution should

24:06

be

24:07

third one would be the reliability so

24:09

there are a few applications or systems

24:11

which should be

24:12

up all the time so it can we can state

24:15

that the system

24:16

should be available 99 of the time

24:19

so this would be a reliability uh

24:21

non-functional requirement which can be

24:23

captured

24:24

then the next one would be usability how

24:27

uh how easy it is for the users to use

24:30

the

24:31

system on the solution which we're

24:32

developing the next one would be

24:35

maintainability

24:36

how easy it can to maintain this

24:38

solution and on the last one would be

24:40

related to portability so these are some

24:42

few aspects which we are

24:44

going to document as part of as a non

24:48

nfr which is non-functional requirements

24:51

for the solution which is being

24:52

developed so let's

24:54

look at an example the system should

24:57

respond within

24:58

two seconds of a user's input so which

25:01

is a performance

25:02

nfr so as we discussed

25:06

uh in the previous slide regarding the

25:09

functional requirement

25:10

for the system to display the

25:13

available seats so if you try to put it

25:16

together

25:17

so a customer should be able to click on

25:20

a movie show and within two seconds the

25:23

system should

25:24

show them with a list of available seats

25:27

so that's how we are

25:28

you know tying it together to have a

25:31

great customer experience

25:36

question number four what is a business

25:38

rule

25:39

this is a question where most of the

25:42

people get it wrong

25:43

uh so let me try to simplify this

25:46

as per babblock version three a business

25:49

rule is a specific

25:51

testable directive that serves as a

25:53

criterion

25:54

for guiding behavior shaping judgments

25:56

or making

25:57

decisions that's a little complex

26:00

definition

26:01

but to simply put a business rule

26:04

is a criterion or a constraint which has

26:08

to be

26:09

followed by the solution or the system

26:11

which we are

26:12

building so for example the xyz cinemas

26:15

they had a business rule that a customer

26:17

can book only up to

26:19

a maximum of 10 tickets at a single time

26:22

while calling up the customer care or

26:24

standing

26:25

in the uh line at the ticket counter

26:28

so this ensured that you know there are

26:31

plenty of tickets available for

26:32

everyone so this business rule has to be

26:36

taken into consideration while uh

26:38

developing

26:39

this digital or solution digital channel

26:42

so this gives rise to a functional

26:45

requirement for restricting the number

26:47

of seats which a customer can book at a

26:49

single point of time

26:50

so for example it can be stated as such

26:53

like this the functional requirement

26:54

that

26:55

the system should not allow the

26:57

customers to select more than 10

26:59

available seats

27:00

so this is a restriction which we are

27:02

capturing as part of

27:04

a functional requirement which was

27:07

basically divide

27:09

sorry derived from a business rule

27:14

question number five what are the

27:15

requirement elicitation techniques you

27:18

have used in the past

27:19

i can bet you 100 percent that this

27:22

question

27:22

will be asked in each and every business

27:25

analyst

27:25

interview the reason as i stated earlier

27:29

elicitating requirement is one of the

27:31

key skill and query responsibility

27:33

of a ba and the interviewer would

27:35

definitely love to hear

27:37

how well you have done it in the past

27:39

and also what are the different

27:40

techniques which you have used

27:42

i've listed most of the commonly used

27:44

techniques in this slide and we're going

27:45

to cover

27:46

uh them one by one the first one is

27:49

the workshop this is one of the highly

27:51

recommended

27:52

technique for gathering high quality

27:54

requirements in a short span of time

27:56

i've already made a video on how to run

27:59

a successful workshop

28:00

and gather requirements in less than one

28:03

session

28:04

you can check out in the link below in

28:07

the description link below

28:09

so uh taking example of xyz cinemas if

28:12

you want to

28:13

uh perform a you know capture

28:15

requirement

28:16

so using workshop technique then you

28:18

have to invite all the key people or

28:19

smes from

28:21

the sales department you know customer

28:23

care department

28:24

ticket counter finance so all the key

28:26

people from different

28:28

departments who are involved in this

28:30

particular digital solution

28:32

so you can get everyone into a single

28:34

session

28:35

in a room it can be a few hours or even

28:38

it can be a day

28:39

if they are spread across it can be done

28:42

by a video conferencing or web

28:44

conferencing so you have all the

28:46

participants and you can get

28:48

the requirements uh on their views on

28:50

how the digital solution would be

28:53

and it can be captured and you know for

28:56

further

28:57

solution development second one is the

29:00

intro interview technique so in case if

29:02

you're not able to get

29:03

all these different people from

29:06

different departments

29:08

at a single session then you can

29:11

schedule separate interview sessions

29:13

with

29:14

each of them and try to gather the

29:17

requirements

29:18

which they need from this digital

29:20

solution so it can be done on an

29:22

individual basis and if that

29:23

two or more people available it can be

29:26

done as a group

29:27

interview as well so again this is also

29:29

one of the commonly used

29:30

technique for capturing uh requirement

29:32

or elicitating requirements

29:34

the top one would be observation uh it

29:36

can be passive or active so observation

29:39

if you take an example

29:40

uh you can walk down to the ticket

29:42

counter and and you can see how

29:45

the staff is getting the request from

29:49

the customer

29:49

and issuing the tickets like it can show

29:52

which seats they want

29:54

uh how the customers select so all these

29:56

things can be

29:57

observed and it can be translated

30:00

uh as a requirement for the digital

30:02

channel to kind of mimic this uh

30:05

process so there as i stated that two

30:07

types of pa

30:08

ah observation passive and active

30:10

passive is

30:11

you just stand there and observe and try

30:14

to gather as much information

30:15

or requirements and active as you stand

30:19

there

30:19

observe but now you can ask question to

30:22

the staff who's issuing the tickets or

30:23

who's doing it's

30:24

like why are you doing it this way is

30:27

there a reason

30:28

you know it provides more insight and it

30:31

can be

30:31

kind of translated to the requirements

30:34

for the digital

30:35

channel the fourth one would be the

30:37

document analysis so this can be

30:40

the documents which are available on the

30:42

process it can be the procedures

30:44

it can be the business rules so the

30:47

business rule which we kind of spoke

30:49

about in the previous question

30:51

would be uh you know would be found out

30:54

from this document analysis technique

30:55

and it can be translated to a functional

30:57

requirement

30:58

the next one would be the focus groups

31:01

and the brainstorming

31:02

they're more similar to workshops and

31:05

it's again

31:06

done in a similar way brainstorming is

31:09

more of

31:09

taking one item and trying to get

31:12

the ideas and the views from people and

31:15

kind of ranking it them

31:17

and then translating into requirements

31:19

and also the

31:20

priority of them the next one would be

31:23

the process analysis

31:24

so the process analysis is

31:28

looking at the looking at the end-to-end

31:30

process

31:31

if it's already one if it's already

31:33

there if not creating one and then

31:35

meeting up with the stakeholder and

31:37

showing them okay this is the process

31:38

flow

31:39

what all the uh things you need from a

31:41

digital solution which you are building

31:44

okay so this is also a good way of

31:46

capturing the requirements

31:48

looking at the end-to-end process so you

31:50

don't miss out

31:51

on anything the next one would be

31:54

prototyping again

31:55

if let's say if you want to look at the

31:57

detailing of the digital solution you

31:59

can do a mock-up

32:00

of the screen navigation flow and then

32:04

you can walk up to the stakeholders and

32:06

ask

32:07

okay in the screen what all the elements

32:08

do you need

32:10

is this better or do you need a

32:12

different color to kind of

32:13

sync up with your brand so all those

32:15

detailing uh

32:16

can be achieved using the prototype

32:20

technique the last one would be surveyor

32:22

questioner

32:23

this is again used only if you want to

32:26

collect

32:28

the response from a huge number of

32:31

stakeholders for example

32:34

if you want to get a view of which of a

32:37

feature would be beneficial

32:39

for the customer so you can just draft

32:41

few of the

32:42

questions and send it across to the

32:44

entire

32:46

sales department or customer care

32:47

department and then they can

32:49

select the options and then you can get

32:52

it back and that can be used

32:54

for framing the requirements and also

32:57

prioritization

32:58

so these are some few uh techniques

33:01

which i've covered

33:02

definitely this is a question which

33:03

would be uh coming up

33:05

so this can be used by

33:08

you know you can answer these questions

33:09

by using some experience from your

33:12

previous projects

33:18

question number six what is the

33:19

difference between verification

33:21

and validation of a requirement another

33:23

tricky question

33:25

so verification refers to ensuring that

33:27

the requirement meets the quality

33:29

standards

33:30

that is whether the requirement is clear

33:32

is it consistent with other requirements

33:34

there's no contradiction

33:36

whether the requirement is complete

33:38

whether it is

33:39

testable whether it is unambiguous

33:42

and also whether it's understandable to

33:44

all the stakeholders involved the

33:46

development team the

33:47

testing team so it ensures that the

33:50

the quality of the requirement is

33:54

is good enough for the uh the

33:56

engineering team to proceed with it

33:59

validation on the other hand refers to

34:01

whether the requirement

34:02

is kind of aligned to the business need

34:05

goal

34:06

or outcome and whether it really

34:09

supports

34:10

the needed value so let's say in our

34:12

example if we take a requirement which

34:15

talks about allowing the customers to

34:17

book refreshments

34:19

uh over a digital channel it's a good

34:22

requirement

34:23

and you know it it kind of

34:28

satisfies the verification criteria but

34:31

uh whether is it aligned to the

34:34

the business need or the goal of a

34:37

digital channel to low customers to book

34:39

tickets

34:40

no it's a good feature but it's not

34:42

really aligned to that particular high

34:44

level business

34:45

requirement hence you know when

34:48

the validation process takes place this

34:50

kind of requirement is

34:52

termed as low priority and can be

34:54

revisited once the

34:57

the key requirements are delivered

35:04

question number seven what is rtm or

35:07

requirement traceability matrix

35:09

so this is one of an important tool or

35:12

technique

35:13

which is used to trace requirements

35:17

so this provides backward and forward

35:19

traceability

35:20

as shown in this diagram and it helps

35:23

faster impact analysis and reliable

35:25

assessment

35:26

to ensure that all your business

35:28

requirements are covered

35:30

so if you look at this example uh rtm or

35:33

requirement disability matrix

35:35

so the business requirement uh will be

35:38

mapped to

35:38

the stakeholder requirements uh sql

35:41

requirement one and two

35:42

so in our example if you if you talk

35:45

about the digital channel for allowing

35:46

customers to book

35:48

tickets the stakeholder requirement

35:51

number one can be related to the

35:53

customer facing

35:54

screens and how they can how it allows

35:58

and the other stakeholders who can be

36:00

involved would be

36:01

the backend team or the back office

36:04

operations team

36:05

and what are the requirements from their

36:08

side to process the

36:09

customers online booking so that's how

36:13

the different stakeholders will have a

36:15

different set of requirements so the

36:16

first level of mapping would be

36:18

with respect to the business requirement

36:20

and the stakeholder requirements

36:22

and then the stakeholder requirements

36:24

would be mapped to the functional

36:26

requirements

36:27

and also the non-functional requirements

36:29

which we spoke about

36:31

and then the functional requirements or

36:33

non-functional requirements in turn

36:34

would be mapped to this design component

36:37

okay in order to deliver this

36:40

functional requirement what are the

36:43

design components required

36:45

so if you take an example of the screen

36:49

to show the customers the list of

36:52

available seats

36:54

so the design would involve uh different

36:56

screens

36:57

and also the the the logic for

37:00

uh showing up the available seats so

37:04

so that all comes under the design and

37:06

then

37:07

the design component maps to the the

37:10

code

37:11

so in which a particular language

37:15

the the co the code is there it may be

37:17

java.net

37:19

or it can be any other new technologies

37:22

like python

37:23

so all of this programming comes under

37:27

the code and it is mapped to the

37:30

design component and once the code is

37:33

kind of completed and then it's maps to

37:35

the test case

37:37

so the test case would ensure that

37:40

the code which is developed works

37:42

accordingly to the

37:44

requirement so this kind of gives an

37:47

end-to-end

37:49

mapping to ensure that a business

37:51

requirement is

37:53

kind of developed and

37:56

tested so it's a very useful tool and

37:59

this is one of the key things which

38:01

also use on a day-to-day basis and it

38:04

can be

38:04

asked in an interview

38:11

hello there requirements prioritization

38:15

this has been a challenge for every

38:17

business analyst

38:18

and it is going to be a challenge in the

38:21

future as well

38:22

because the business stakeholders they

38:25

want

38:25

all the requirements delivered as soon

38:27

as possible immediately possibly

38:29

in the single release we know that's not

38:32

going to happen

38:34

if you're having trouble convincing the

38:36

business on the requirements

38:37

prioritization

38:39

or you would need a technique or a

38:41

guidance on

38:42

on the prioritization of the

38:43

requirements this is the video for you

38:46

in this video we're going to cover the

38:47

four key requirement prioritization

38:49

techniques

38:50

which will help you to communicate with

38:53

the business

38:54

and get the highest business value items

38:57

delivered

38:58

first so we are going to cover these

39:01

four key thing four key prioritization

39:03

techniques

39:04

so a lot of cover we can get started but

39:06

before i do

39:07

i just wanted to tell you that this is

39:09

one of the video

39:10

in the business analyst techniques video

39:12

series so i've listed the other videos

39:14

in the description box

39:16

so please feel free to go and check it

39:18

out and also

39:19

if you haven't already subscribed to our

39:21

youtube channel or you're seeing

39:22

the video for our video for the first

39:24

time i will request you to go and hit

39:26

the subscribe button and also

39:28

the bell icon so that you'll be notified

39:30

when we do a new video

39:31

we do a weekly video on business

39:33

analysis techniques

39:34

tools concepts and also the

39:38

interview questions so let's get started

39:41

on the requirement prioritization

39:42

techniques

39:46

as always we'll be using a case study

39:49

and

39:50

using the case study we'll be driving

39:51

the concepts of requirement

39:53

prioritization

39:54

again this is a case study which we have

39:57

used in several of our videos because

39:58

it's very simple and easy for everyone

40:00

to understand

40:01

but if you want me to use a different

40:03

case study open to suggestions

40:06

please feel free to comment your case

40:08

study idea in the comments

40:10

section and we will pick it up for the

40:11

next videos so

40:13

in this case study a movie chain named

40:15

xyz cinemas they're looking for a mobile

40:17

app

40:18

which will allow their customers to book

40:20

movie tickets online simple as that

40:22

they don't want the customers to stand

40:23

in the queue they just want

40:25

the customers to use their mobile app

40:27

book it and what

40:28

enjoy the the movie so the features of

40:31

the app which

40:32

which the client is looking for are

40:35

registration customer registration

40:37

login feature the ticket booking

40:40

booking ticket feature and seed

40:43

selection

40:44

so ability for the customers to select

40:46

the seats

40:47

in the theater online payment

40:50

and again number six is more of uh

40:53

ordering uh refreshments like popcorn

40:56

coke

40:56

if in the app itself so that they don't

40:58

have to stand in the

41:00

line for buying these and the seventh

41:03

feature they're looking for is

41:04

once the refreshments popcorn or coke

41:07

are ordered

41:08

it can be delivered to the seeds where

41:11

the customers are booked using this

41:13

particular

41:14

online app so it's a very good feature

41:17

set uh

41:18

making the customer's life easy so this

41:20

is the features

41:21

so let's say how how we will be using

41:24

the requirement prioritization

41:26

to deliver these features uh released by

41:29

release

41:30

i i know it's good to have everything at

41:32

one shot but again

41:33

we know it's not feasible so let's see

41:35

how we can use a different requirement

41:37

prioritization technique

41:38

to prioritize and deliver these in a

41:41

release wise

41:46

okay let's get started with the first

41:49

requirement

41:49

requirements prioritization technique

41:51

called moscow

41:53

it's one of the most commonly used

41:56

technique

41:57

worldwide the requirements are basically

42:00

classified into must

42:02

should could and would must are your

42:05

mandatory requirements

42:07

without which there is no point in even

42:09

having a release

42:10

so they are the highest priority items

42:12

which has to get in

42:14

the next comes the should they should

42:17

are basically they're also high priority

42:20

items

42:20

but even if they're not delivered in a

42:23

release

42:24

there are workarounds through which uh

42:27

you know

42:28

the same functionality can be uh can be

42:30

satisfied

42:32

and then we have the good and wood so

42:34

basically good and wood are

42:35

nice to haves it's it's good to get them

42:38

into release but if

42:40

you know if you're not able to make it

42:41

that's okay we can defer it to the next

42:43

release

42:44

so let's see how we can apply this

42:46

moscow to our example

42:48

case study so if we if we

42:52

prioritize the requirement requirements

42:54

so the registration the login

42:57

and the book tickets are the must you

43:00

know it's

43:00

the key key things like the purpose of

43:02

the app is

43:03

for the customers to book the tickets

43:06

online

43:06

and the registration and login

43:10

are a pretty precursor basically

43:13

in order to book the tickets right whom

43:15

are we booking against if they

43:17

generally build do you even create an

43:19

account and then

43:21

uh the seed selection and make payment

43:23

agree they're again high priority

43:26

requirements but without

43:29

the ability for the customer to select

43:30

the seats or make online payment

43:33

they can still book the seats uh online

43:37

right the seats will be randomly

43:39

assigned based on the

43:41

best possible uh you know fit for the

43:44

number of seats

43:45

and also the payment they can walk in

43:48

and pay the cash

43:50

i understand it's not a you know best

43:53

customer experience

43:54

but you can still go hard if you just

43:57

have the book ticket

43:58

feature and the registration login

44:00

working fine

44:02

seed selection and make payments can be

44:04

handled

44:05

as a workaround you know with the with

44:07

the cash as we just uh talked about

44:09

and then we have the buying of the

44:11

popcorn coke

44:12

and having them delivered to their seat

44:15

yeah it's really you know it's really

44:17

nice to have

44:18

but it won't stop the release because

44:21

the purpose of the app

44:22

is not to uh for the customer to order

44:25

refreshments

44:26

but it's basically booking the tickets

44:29

online

44:30

so that is the purpose that's the reason

44:32

this these two things will become

44:34

good so now if we have this list

44:37

sorted mastered and could it's better

44:39

when you have a discussion with the it

44:41

okay you know what these are are must

44:43

these are should could

44:45

and you know if if we have that clarity

44:48

it's it's both good for the from an idea

44:50

perspective to get the built-in also

44:52

it's good from a business perspective

44:54

because we are

44:56

uh highlighting to the business that the

44:58

higher value items are being

45:00

delivered first so it's a win-win in

45:03

either way

45:08

okay moving on to the next technique on

45:11

our list

45:13

the next technique is called ranking so

45:16

these are again another

45:17

commonly used technique basically this

45:20

comes into place

45:21

when let's say we have like 10 must

45:25

and then the problem again now comes is

45:28

it would have bandwidth only for let's

45:30

say

45:33

seven of them so again we are in a fix

45:36

as we have stated in the previous

45:37

technique

45:38

all the must should make it to the

45:40

release but now

45:42

we are going to prioritize further so

45:45

that is where this technique comes into

45:48

play which is called ranking

45:49

here you rank those requirements from a

45:52

scale of one two

45:54

two three four five six and so on and

45:56

the smallest rated requirements has to

45:58

go in

45:59

first so if we apply this technique to

46:01

our case study

46:03

it would look something like this so the

46:05

registration is first then the login

46:08

we have the book tickets functionalities

46:10

number three

46:11

then the seed selection make payment by

46:13

refreshment refreshment server to the

46:15

seat

46:16

so this is another another way or

46:18

another technique of basically ordering

46:20

uh ordering the the requirement

46:24

uh requirements or the product backlog

46:27

because sometimes what will happen is if

46:28

you go to the business and we still

46:30

explain them you know must should then

46:31

could

46:32

they will again tell you know what all

46:35

these tens are must

46:36

so it will be again a bottleneck will be

46:38

a difficult situation

46:40

so in that scenario you can use this

46:42

technique okay we understand these are

46:43

must

46:44

let's try to rank them when we rank them

46:47

they'll be much more clarity on the

46:49

highest value or higher value items

46:51

so that again this clarity will help to

46:54

get those higher value items

46:56

delivered again a very useful technique

46:59

and used again commonly worldwide

47:07

okay let's start to look at the

47:09

requirement prioritization number

47:10

technique number three the canon

47:12

analysis so again this is a different

47:14

view of looking at the requirements and

47:16

we're going to look at it

47:18

exclusively from the customer's

47:20

perspective who's going to use the

47:21

product

47:22

so here there are three factors one is

47:25

the basic factors

47:27

performance factors and excitement

47:29

factors

47:30

basic factors are something like if you

47:32

don't have the feature in the app then

47:34

the customers are straight off

47:36

disappointed they won't even use

47:37

the particular app or an application

47:40

and then we have the performance factors

47:42

so which are basically

47:45

the drawing factor for the customers to

47:47

use the

47:48

application or the app and then they are

47:51

the the next one is excitement feed

47:53

factors so these are basically your

47:56

differentiator from the competitors

47:58

and your usp or unique selling

48:00

proposition so customers will be like

48:02

very excited to use the app

48:04

or the application because of these

48:06

particular

48:08

features so let's try to apply the canon

48:11

analysis

48:12

to our case study so it looks something

48:15

like this

48:16

the registration login book tickets

48:19

pretty

48:20

basic without them there is no point

48:22

even even using the app because if

48:23

you're not able to book the tickets why

48:24

are we even using the app

48:26

and then seed selection and making

48:28

online payment

48:29

yep it would be a you know customers

48:32

would be really happy to use this

48:33

because

48:34

they have the ability to select the

48:35

seats and they don't have to stand

48:38

in us in a line again to pay for the

48:40

cash

48:41

so they'll be happy to make an online

48:43

payment just then

48:45

get onto the theater just walk in and

48:48

then

48:50

the refreshments and the refreshments

48:52

sir to the seat

48:53

that would be an excitement uh factor

48:56

basically

48:57

the the reason for uh uh you know the

49:01

the the reason for this is basically

49:04

well again there is a queue for buying

49:07

refreshments

49:08

so if you're able to do that using the

49:10

app then it's like

49:12

you just walk in after doing the booking

49:16

the you you've selected the seats you

49:19

made the online payments

49:20

and then when you arrive uh at the time

49:22

of your choosing

49:23

you're getting your popcorn coke you

49:26

don't have to stand anywhere

49:27

no line nothing everything is taken care

49:30

so that is basically

49:32

you know it the customers will be

49:34

excited to use this particular

49:36

feature and because of this there will

49:39

be more people

49:40

being driven into this particular cinema

49:43

so it

49:44

will increase the revenue so so these

49:46

are some things it's a basically a

49:47

different

49:48

lens of doing the prioritization so it's

49:50

called the canon analysis and it is used

49:52

it's looking mostly from the customer's

49:56

perspective

50:00

and the last technique we have on the

50:02

list is called

50:03

user story map so basically i've

50:07

i've covered thoroughly taking in

50:10

another case study in one more video

50:12

i'm going to link it in the description

50:14

box so please go and check it out

50:17

where you will be uh shown how to build

50:19

a story map from scratch

50:21

and then to do the prioritization so

50:24

it's basically a visual representation

50:26

of your entire product backlog from

50:29

the the activity sequence of a user so

50:33

in our example would be the customer

50:35

when they

50:37

order the book the tickets online

50:40

and the time they you know they walk

50:43

into the movie theater watch the movie

50:45

and then get out so this is a basically

50:48

a customer journey we call it

50:50

and there will be tasks below it

50:53

so those would be your you know the the

50:56

user stories so basically if you put

50:58

this in a map

50:58

like some somewhat we show this this is

51:00

a basically an example of

51:02

a online home delivery ordering service

51:06

so you will be able to visualize it

51:08

better and the business will be able to

51:10

visualize

51:11

it better because they will be able to

51:13

see the end-to-end picture rather than a

51:15

sequential list

51:16

and then we can go again and you know

51:18

check with the business okay this is how

51:20

it is

51:21

can can you please you know which would

51:23

be the highest benefit

51:24

we can put put put the put the

51:28

requirements

51:28

in so the release one as we see here

51:31

it's called the mvp or the minimum

51:33

viable product

51:34

so that is like without which you cannot

51:36

even you know go in and then similarly

51:39

the other requirements are prioritized

51:41

to release to release three

51:42

it's a similar to what we have seen uh

51:45

in you know in the previous techniques

51:46

but again this is more

51:47

visual and gives an end-to-end view for

51:50

the business

51:51

which the other techniques won't give so

51:53

again it's a very useful technique for

51:55

them to understand and provide the uh

51:58

you know the priorities

51:59

so you're basically assisting them to

52:01

see the end-to-end feature and which

52:03

will be really appreciated

52:05

so these are the four techniques and uh

52:08

what we are going to do is i provided a

52:10

link in the description

52:12

for kind of downloading a quick cheat

52:14

sheet so you can download it keep it for

52:17

your reference

52:18

and start using it in your day-to-day

52:21

job when you're dealing with the

52:22

requirements and prioritization

52:26

hello there in this video we are going

52:29

to cover questions

52:30

pertaining to requirement gathering or

52:33

elicitation

52:34

which is one of the key skills for a

52:36

business analyst

52:38

in the previous video we discussed

52:40

identification

52:41

and types of stakeholders which is the

52:44

first key step for business analyst

52:46

post onboarding to a project once the ba

52:50

has the list of stakeholders

52:51

the next step would be to engage them

52:54

using different requirement gathering

52:55

sessions

52:56

to gather the requirements we will cover

53:00

the techniques used for gathering

53:01

business requirements

53:03

in this video and will focus on

53:05

techniques for functional requirements

53:07

in the next

53:08

video so let's get started with the

53:12

video

53:14

as always we will use a simple case

53:17

study

53:17

which will make the concepts easy to

53:19

grasp

53:20

ravel is a ba working with a client

53:23

running a restaurant called

53:25

wagon gardens the client is looking for

53:28

a mobile app which will allow their

53:30

customers to book a table

53:32

moving on to question 1 what are the

53:35

requirement elicitation techniques

53:37

you have used in the past this is one of

53:40

the most commonly asked question

53:43

and listed below are the commonly used

53:45

requirement elicitation techniques

53:49

some of them are document analysis

53:52

workshops interviews

53:55

observation focus groups

53:58

brainstorming process analysis

54:02

prototyping survey or questionnaire

54:06

we will discuss these techniques in

54:08

detail in the upcoming

54:10

questions based on your answer

54:13

the interviewer will ask deep dive

54:15

questions on the techniques

54:17

which you would have mentioned that you

54:18

have used so make sure

54:20

you tell the technique which you have

54:22

used

54:24

question 2 what is the first elicitation

54:26

method you would use

54:29

the answer in my view would be document

54:31

analysis

54:33

this involves reading the existing

54:35

documents available

54:36

related to the project which you are

54:38

working on

54:39

this will help to provide context and

54:41

background while engaging with the

54:43

stakeholders

54:44

through other elicitation techniques

54:48

this will help you to identify the

54:50

current state and the problems faced in

54:52

the current business unit

54:53

process and others going back to our

54:57

case study

54:58

rahul our ba on the project can request

55:00

for

55:01

and look into the below documents before

55:03

engaging with the stakeholders

55:06

organization chart this would give the

55:09

background of the people

55:10

and business unit structure as vegan

55:13

garden restaurant has several branches

55:16

the organization chart would provide

55:18

information

55:19

on number of branches and names of the

55:21

key people in each branch

55:24

user manual and standard operating

55:27

procedures

55:29

this would give rahul a view of how the

55:31

current table booking process works and

55:34

which system is used by the staff

55:37

so rahul will be familiar with the

55:38

current systems and have a better

55:41

understanding

55:42

while speaking with the stakeholders

55:45

rahul can also look at design documents

55:48

technical documents

55:49

process flows problem reports

55:52

business rule documents or any

55:55

previously captured requirement

55:56

documents

55:57

which would help as stated earlier in

56:00

understanding the current state

56:02

and context of the new project

56:05

let us look at question number three in

56:07

your opinion

56:08

what you think is the best elicitation

56:10

method

56:12

there is no right or wrong answer you

56:14

can answer based on your experience

56:17

in my view the best elicitation method

56:20

is the workshop technique

56:21

as you can gather high quality business

56:24

requirements

56:25

in a short span of time with a variety

56:27

of stakeholders

56:30

the workshop technique involves getting

56:32

all the key impacted stakeholders

56:34

from different departments together for

56:37

an extended period of time

56:39

like a day or two to go over the project

56:42

details

56:43

and understanding from each of them what

56:46

they are looking for

56:47

as an outcome since we have the key

56:50

stakeholders present

56:51

any conflict can be resolved impacts can

56:54

be identified

56:56

and can easily gain agreement from all

56:58

the stakeholders at the same place

57:01

we will discuss this technique in depth

57:03

in the next question

57:05

question number four can you tell me

57:07

about a time when you conducted a

57:09

workshop

57:10

if you have answered that you have used

57:12

the workshop technique

57:14

then interviewer might ask this question

57:16

to get an insight into your experience

57:20

for every requirement elicitation

57:22

technique as mentioned in baboch version

57:24

3

57:24

it has three phases prepare

57:28

conduct and post the session

57:31

let us consider the workshop in context

57:33

with our case study

57:35

rahul rba is going to use the workshop

57:38

technique

57:38

for gathering the business requirements

57:40

for the online table reservation system

57:44

first off rahul needs to prepare for the

57:46

workshop which includes

57:48

setting a clear purpose which is to

57:50

gather business requirements for the

57:52

table reservation system

57:54

identifying the key stakeholders and

57:57

ensuring

57:58

they are available to attend the

57:59

workshop the key stakeholders would

58:02

include the sponsor who is the owner of

58:04

the restaurant

58:05

the business managers from different

58:07

branches and

58:08

senior operations staff who are involved

58:11

in the table booking process currently

58:15

once he has the list of the key

58:16

stakeholders he would schedule

58:19

a place and time convenient for all the

58:21

key stakeholders

58:23

usually workshop is a full day or two

58:26

days event

58:27

the venue should have all the facilities

58:29

like whiteboard projector

58:31

adequate seating etc and refreshments

58:34

like coffee snacks should also be

58:36

arranged rahu chooses his company's

58:39

conference room which has a seating

58:41

arrangement for 15 plus people

58:43

and invites the key stakeholders there

58:46

for a full day workshop

58:48

he has also arranged for lunch and other

58:51

refreshments

58:53

next off rahul would make and share the

58:56

agenda with the attendees

58:58

agenda will have sessions or activities

59:00

for that day

59:01

so that the stakeholders come prepared

59:04

sample full day agenda would be like

59:06

this

59:08

9 to 9 30 introductions can happen 9 30

59:11

to 11 15

59:12

walk through of the current process 11

59:15

15 to 12

59:17

break 11 30 to 1

59:20

discussion on the target process design

59:23

1-2 lunch break 2-4

59:27

gathering the business requirements for

59:29

the target

59:31

4 state 4 30 they can have a short break

59:33

and again 4 30 to 5

59:35

they can have a playback session

59:39

the first stage is key if the

59:40

preparation is good then conducting the

59:42

workshop is pretty easy

59:45

moving to the second stage conducting

59:47

the workshop

59:49

the stakeholders meet at the venue on

59:51

the day of the workshop

59:52

and rahul uses the agenda shared earlier

59:55

to drive the workshop

59:57

and will try to adhere to the agenda as

59:59

close as possible

60:02

as the workshop progresses rahul

60:04

documents the discussions

60:06

requirements and actions if help is

60:09

available

60:10

one can also use them for documentation

60:13

during the workshop

60:14

they are referred to as crime

60:17

the last stage is post the workshop

60:20

which would

60:21

include activities like closing out any

60:24

open actions

60:25

raised during the workshop rahul can

60:28

then share the captured business

60:30

requirements for sign off to the

60:31

stakeholders

60:33

if required rahul can arrange a review

60:36

session with the stakeholders

60:38

to walk through the requirements

60:39

captured for obtaining a sign off

60:43

moving on to the next question question

60:44

number five

60:46

what are the challenges faced while

60:48

using the workshop technique

60:49

and how would you mitigate it this is

60:52

another follow-up question

60:54

asked on workshop the major challenge

60:57

would be non-availability of the key

60:59

stakeholders

61:01

getting all the required people together

61:03

for a day or two

61:04

is by far a difficult task

61:07

some mitigation would be the below

61:09

approaches

61:11

number one explaining the importance of

61:14

the workshop

61:14

and how it will help to shape the system

61:17

which they are trying to build

61:19

number two rescheduling to a suitable

61:22

time

61:22

so that everyone can attend number three

61:26

in case a key person is not available

61:28

then asking them to send their deputy

61:31

or a representative from their team

61:34

if still we are unable to get everyone

61:37

together then covering

61:38

off with the key stakeholders individual

61:41

interview is an

61:41

option which will cover in the next

61:43

slide next question

61:45

question number six can you tell me

61:48

about a time

61:49

when you conducted an interview if you

61:52

have answered that you have used the

61:53

interview technique

61:54

then interviewer might ask this question

61:57

to get to know more about your

61:58

experience

62:00

like we spoke for the workshop the

62:02

interview elicitation technique has

62:04

three phases prepare conduct post

62:08

decision

62:10

let us continue with our case study and

62:12

say one of the key stakeholder jim

62:14

who is the manager of customer support

62:17

could not attend the workshop

62:19

rahul would then use the interview

62:20

technique for sharing the outcome of the

62:22

workshop

62:23

and gather any missing business

62:25

requirements from the customer support

62:28

perspective

62:30

first off rahul needs to prepare for the

62:33

interview which includes

62:34

setting a clear purpose which is to

62:37

gather business requirements from a

62:38

customer support perspective

62:41

schedule a place in time convenient for

62:43

jim to attend

62:45

next off rahul would make a list of

62:47

questions

62:48

like what the customer support staff

62:50

would like to see in the new system for

62:52

answering the customer queries

62:55

what are the functionalities required in

62:57

case there is change required by the

62:59

customer

63:00

and so on and shared these questions in

63:03

the meeting invite to jim

63:05

so that he can speak to the team up

63:07

front and

63:08

have the answers ready as stated earlier

63:12

first stage preparation is always the

63:14

key if the prep is good

63:16

then conducting the interview is pretty

63:18

easy

63:19

moving to the second stage it was agreed

63:22

to have a discussion

63:23

on the conference call and both rahul

63:26

and jim

63:26

joined the call for the interview rahul

63:29

briefly touched upon the outcome of the

63:31

workshop

63:32

and then used the questions shared

63:34

earlier to drive the interview process

63:37

rahul used active listening techniques

63:40

and made notes

63:41

on the discussions requirements and open

63:43

actions

63:46

once all the questions were covered

63:48

rahul thanked jim for his time

63:50

and informed that he will share the

63:51

minutes of meeting and also the

63:54

requirements captured

63:55

for his review and sign off post the

63:58

workshop

63:59

rahul shared the minutes with open

64:01

actions

64:02

and also shared the requirements

64:04

captured for review

64:06

and sign off moving on to the next

64:08

question

64:09

question number seven can you tell me

64:11

about a time when you conducted an

64:13

observation session

64:15

if you have answered that you have used

64:16

observation technique

64:18

then interviewer might ask this question

64:20

to get to know more about your

64:22

experience

64:24

like we spoke for the previous two

64:26

techniques

64:27

the observation elicitation technique

64:29

also has three phases

64:31

prepare conduct and post the session

64:35

let us go back to our case study one of

64:37

the open actions in the workshop was for

64:40

rahul to capture a time and motion study

64:43

that is how much time does the current

64:45

reservation process take

64:47

and also document the current steps

64:49

taken by the staff to complete

64:51

the booking rahul is going to use the

64:54

observation technique for completing

64:56

these two actions

64:58

first off rahul needs to prepare for the

65:01

observation session

65:02

and he follows the following steps

65:06

setting a clear purpose which is to

65:08

document the detailed process

65:10

used by the staff now and do a time and

65:12

motion study

65:14

identifying the participants with the

65:16

help of one of the branch managers

65:19

and scheduling a convenient time for the

65:21

session

65:22

share the agenda with the participants

65:24

up front so that they are prepared for

65:26

the session

65:28

as always first stage is the key if the

65:31

prep is good the rest follows easily

65:35

moving to the second stage rahul meets

65:37

the participants at their workplace

65:39

at the scheduled time and briefs them

65:42

on the required outcome and the reason

65:45

for the same

65:46

rahul uses passive observation technique

65:49

he captures the start time when

65:51

a call is made by the customer and end

65:54

time when the booking is made

65:56

in the current system it is around 3

65:59

minutes

66:00

he then asks the branch manager for a

66:03

staff to make a note of the time

66:05

from today so that the average time can

66:08

be benchmarked

66:09

and used for presenting back to the

66:11

sponsor who wants to know

66:13

this he also observes couple of staff

66:17

and makes note on the steps taken by the

66:19

staff for making the booking from the

66:21

time when the customer

66:23

calls and the booking is done on the

66:25

system

66:26

once the staff completes the booking he

66:29

asks couple of clarifying questions on

66:32

the doubts he had on the process

66:35

he then thanks the participants for

66:37

their time and heads back to the office

66:40

the last stage is to ensure what he

66:43

captured is right

66:45

he converts the steps into process

66:47

diagram and

66:48

sends it to the staff for review

66:52

and also follows up on the open action

66:54

for the average time for booking process

66:57

from the manager

66:58

question number eight another follow-up

67:01

question on

67:02

observation what is the difference

67:04

between active

67:05

and passive observations there are two

67:08

types of observations

67:10

first one active observation when the

67:13

staff is performing the steps

67:14

in the process if you have any questions

67:17

you stop the staff

67:19

and ask clarifying questions when they

67:21

are performing that step

67:23

to gain insights point number two

67:26

passive observation you make a note of

67:29

all the questions

67:30

and wait for the staff to complete all

67:32

the steps in the process

67:34

and then ask your questions

67:37

active observation is used when you are

67:40

more interested

67:41

in specific part of the process whereas

67:43

passive is generally used to capture the

67:46

metrics of the time taken to complete

67:48

the process

67:49

and for benchmarking question number

67:52

nine what is focus group and how to

67:54

conduct one this is similar to the

67:56

workshop

67:57

you get the key people together at the

67:59

same place to get their thoughts and

68:01

opinions going back to our previous

68:04

video where we discussed about personas

68:06

which are fictional characters who

68:08

represent the typical customers

68:11

they are helpful to understand the

68:12

customer's need and build the product

68:14

accordingly

68:16

based on brainstorming with the internal

68:18

team the requirements would have been

68:20

locked on what these personnels would

68:22

need

68:24

identifying and validating the needs of

68:26

the personnels are very important to

68:29

ensure

68:29

we are building a product which

68:31

satisfies their need

68:33

focus group is one such technique to use

68:36

for that

68:37

let us take two personas as example

68:40

first one the office manager this is a

68:43

typical manager who has number of team

68:46

members reporting to him

68:48

there would be quarterly or sometimes

68:50

monthly team outings

68:51

and the manager is responsible for

68:53

looking for fun places

68:55

to have a team lunch or dinner their

68:58

needs are quick snapshot of the service

69:00

offerings

69:01

and also the receipt of the bill emailed

69:03

to them

69:04

so that they can do claims for

69:06

reimbursements as all the outings are

69:08

built to the company

69:10

second one family man one who wants to

69:12

book on weekends

69:14

for brunch lunch or dinner he does not

69:17

care about the digital copy of the bill

69:19

but is very keen on services offered for

69:21

the kids

69:22

and the seating arrangements

69:25

if you see just going at a high level we

69:28

have got two requirements

69:30

first one soft copy of the e bill to be

69:32

emailed as a pdf

69:35

second one service offerings should be

69:37

shown in the booking app or the website

69:41

again these are just assumptions and has

69:43

to be validated

69:45

focus group is one of the way to

69:47

validate the assumptions made

69:50

rahul can get the details of their

69:52

previous regular customers from both the

69:53

categories

69:54

office manager and family men and

69:56

arranged for a focus group session with

69:58

them

69:59

to go over the feature of the new online

70:01

booking system

70:04

he also provides perks for participating

70:06

in the session

70:07

by giving them free lunch or dinner

70:09

coupons at the restaurant

70:12

again similar to the workshop technique

70:14

agenda can be shared upfront to these

70:16

people

70:17

so that they are prepared during the

70:20

session

70:21

rahul uses the agenda and goes over the

70:23

list of business requirements captured

70:26

to get their thoughts on each one of

70:28

them

70:29

rahul makes a note of the participant's

70:31

feedback

70:32

once all the items in the agenda are

70:34

complete then rahul thanks the

70:36

participants

70:38

post the focus group session rahul

70:40

compiles the report

70:42

based on the insight received and shares

70:44

with the key stakeholders

70:46

this would help to understand which

70:48

business requirements are key to the

70:50

target audience and which can be

70:52

discarded or

70:53

be prioritized let us look at question

70:56

number 10

70:56

how can you gather requirements from a

70:59

large number of people

71:01

or they can ask you to tell about a time

71:03

when you used

71:04

survey or questionnaire technique

71:07

answer is survey or questionnaire

71:09

technique

71:10

we cannot use any of the techniques we

71:13

spoke about earlier

71:14

due to the sheer volume continuing with

71:18

our case study

71:19

rahul wants to get a view on the

71:21

thoughts of the vegan gardens existing

71:23

customers

71:24

on the new online booking system before

71:27

starting the bill to ensure their

71:28

requirements are satisfied

71:31

going back to our three stages in

71:34

prepare stage

71:35

rahul would compile a list of question

71:38

and answer options to send out to the

71:40

participants

71:41

it is important to have options for each

71:44

question

71:44

and not have a free text field as it

71:47

will be difficult to interpret the

71:49

answers

71:50

sample questions can be like do you

71:52

prefer a mobile app or a web app for

71:54

making the booking

71:56

do you want to receive reminders on your

71:59

reservation

72:01

using the questions rahul will create an

72:04

online survey

72:05

and get the survey link in conduct stage

72:08

rahul sends an email to thousand plus

72:11

existing customers of the restaurant

72:13

to help to take the survey he can also

72:17

provide

72:17

perks to the customers like discounts

72:20

for participating in the survey and it

72:22

is very important to give a deadline for

72:24

the customers to complete the survey

72:26

otherwise we cannot close the activity

72:29

post the deadline date rahul can review

72:32

the results of the survey

72:33

and compile insights and log them as

72:35

business requirements

72:39

hello there do you have a business

72:40

analyst interview coming up shortly

72:43

if so this is the video for you in this

72:46

video we're going to look at the top

72:48

9 interview questions asked related to

72:51

the requirement documents

72:52

as you're already aware eliciting and

72:55

documenting the requirements

72:57

are one of the key aspects of a ba role

73:00

so the

73:00

interviewer would be definitely

73:02

interested in understanding

73:04

the requirement documents which you have

73:06

created in your past

73:07

projects we have a lot to cover so let's

73:11

get started

73:14

i can assure you that they're going to

73:15

be couple of questions

73:17

from this video which will be asked in

73:19

your next business analyst interview

73:21

we're going to look at the brd frds

73:24

their contents and structure we're going

73:26

to also discuss

73:27

on rtm epic user stories their format

73:31

and also the acceptance criteria so it's

73:32

going to be a

73:33

informative video so make sure you watch

73:36

it till the end

73:37

and also if you have not already

73:38

subscribed to our channel

73:40

please go ahead and subscribe to our

73:42

channel right now so that

73:43

you will be notified and you won't miss

73:46

out on any

73:46

of our future videos

73:51

to make it easier for grasping the

73:53

concepts and the answers

73:55

we're going to use a case study with

73:56

this case study

73:58

a movie theater chain called xyz cinemas

74:01

is looking to build a digital channel

74:03

for allowing the customers to book their

74:05

movie tickets online

74:07

rather than calling up the customer care

74:10

or standing in the long queues and

74:12

getting their tickets

74:13

at the ticket counter so we are going to

74:16

use this

74:16

uh example case study for

74:20

answering all the questions

74:24

okay let's get started question number

74:27

one what are the different documents you

74:29

are prepared for capturing requirements

74:31

this question i would say is a sure

74:33

short one

74:34

and it is asked in almost all the

74:37

business analyst

74:38

interviews i've listed the majorly used

74:42

documents it varies from company to

74:44

company

74:45

but these are the common ones so the

74:47

first one is the brd

74:48

which is the business requirement

74:50

document the purpose of this document

74:52

is to capture the business requirements

74:55

and the core business context

74:57

of a particular change initiative the

74:59

second one is the

75:01

functional requirement document which is

75:02

the frd the purpose is to capture the

75:05

functional and non-functional

75:06

requirements

75:08

and it kind of maps back into the

75:10

business requirements

75:12

then we have the use case document again

75:15

the purpose would be to document

75:17

the use cases uh which details the

75:20

interaction between

75:21

an actor and the system or the solution

75:24

which we are trying to build

75:26

and then we have the activity diagrams

75:28

so this

75:29

uh documents the flow of events uh the

75:32

in

75:33

the interactions uh between the

75:36

user and the system and also the

75:38

detailed step-by-step

75:40

flow which basically which will help the

75:42

it team

75:43

to build the solution which we're

75:45

looking for and then we have the

75:47

wireframes

75:48

so the wireframes are basically used uh

75:51

to provide

75:52

a view of how the screen should

75:55

should be looking for the customer so it

75:58

will be the look and feel the colors

76:00

and also the various user interface

76:04

items so all these things would be

76:06

mocked up

76:07

into the wireframes and then we have

76:10

the epics and user stories so all the

76:13

documents which we just spoke about

76:15

are used in the traditional waterfall

76:18

model

76:18

but in case if a project is using agile

76:21

the requirements are captured

76:23

in epics which is again the high level

76:25

requirements and then

76:26

the user stories which are epics are

76:28

broken down into user stories

76:30

so and all the use cases activity

76:33

diagram wireframes are all

76:35

you know converted into supporting

76:37

models and they are

76:38

basically attached to the user stories

76:41

for the epics to provide more context

76:43

and a better understanding of what is

76:46

required to the it team so that they can

76:48

build it accordingly

76:49

and the last one common one which is

76:51

used is the rtm

76:53

which is the requirement traceability

76:54

matrix it is basically used to

76:56

trace the requirements backward and

76:59

forward right from the business

77:01

requirements to the test case and vice

77:04

versa

77:05

we're going to talk about all of these

77:06

in details in the further slides

77:10

moving on question number two what are

77:12

the contents of

77:13

brd or the business requirement document

77:16

again this is a

77:17

a question asked to

77:20

gauge your depth of experience of

77:23

preparing

77:24

such kind of documents so you you can

77:27

use example

77:28

to provide the contents of the brd

77:32

and i've listed few of the uh

77:36

components here but again it varies from

77:37

company to company project to project

77:39

but these are the few

77:40

uh common uh building blocks so the

77:43

first one would be the executive summary

77:45

so if you looking at our example

77:47

this would summary would state that the

77:49

business

77:50

xyz cinemas is looking for a digital

77:52

channel

77:53

for the customers to book their movie

77:55

tickets and the business context will

77:57

provide why they are looking for this

77:59

change initiative

78:00

well here in this context it's just to

78:04

make it more convenient for the customer

78:07

to book online rather than standing up

78:10

in the long queues or calling up

78:12

uh other customer care and you know

78:14

waiting for it to be confirmed

78:16

so that is the customer convenience and

78:18

also if you look it from

78:20

at the staff perspective uh this can

78:22

help to free up

78:23

for some of these steps were doing these

78:25

rules and they can be allocated to

78:27

uh you know other priorities other

78:29

opportunities

78:30

and then there will be a current state

78:32

and target state current state will be a

78:34

basic business process flow like what's

78:36

happening now when the customer comes in

78:38

uh goes to the ticket counter and

78:41

similarly what happens when they call up

78:43

the uh customer care

78:45

and the target state will be how the

78:47

customer with the

78:48

the target state process flow will show

78:51

the

78:52

how the customer will be using this

78:53

digital solution

78:55

to book the tickets and how they will be

78:57

permitted into the cinema halls

78:59

you know the end-to-end business process

79:01

flow how the target state would be

79:03

so this will give more contacts to all

79:05

the

79:06

stakeholders involved and also to the

79:08

engineering team

79:09

i.t and the testing team uh the

79:12

development testing team to understand

79:14

what is being done and why is why it is

79:17

being

79:17

done and then the scope the scope

79:20

section would

79:21

actually have uh what are the things

79:24

which are in scope for now so let's say

79:26

if you're looking for the solution

79:27

whether we wanted to be limited only to

79:29

you know the web web app or a web login

79:32

or

79:33

do we want to also develop a mobile app

79:35

where the customer can book their ticket

79:36

so this would be

79:37

the scope and it should be pretty clear

79:40

what is in scope and what is out of

79:41

scope

79:42

and then comes the business and you know

79:44

the stakeholder requirements so these

79:45

are the requirements

79:46

which are are you know needed to achieve

79:49

the target state so this

79:51

talks about this can talk about the

79:53

requirements related to

79:55

the customers uh able to book their

79:57

tickets online

79:58

and also uh the cancellations uh what

80:02

are the things the customer can do with

80:03

the

80:04

online channel and also similarly on the

80:07

staff side it can be like how

80:10

the staff can identify these book

80:12

tickets how they can let the customer

80:14

into the hall so all of these

80:16

requirements would be

80:17

under these sections and then the next

80:20

one would be the assumption so what are

80:21

the

80:22

assumptions for this initiative so one

80:25

of the assumption i can think of is

80:26

once this channel is available the

80:28

customers will start using it

80:30

you know that's a basic assumption and

80:32

then the dependencies what are some

80:33

things which have to be in place

80:35

for this thing to work and then the

80:38

business rules

80:39

if there's any rules for example like

80:41

the they might have a rule that

80:43

only a maximum of 10 tickets can be

80:46

booked at

80:46

one time so this is a business rule this

80:48

can be translated and documented

80:51

uh for a functional requirement and you

80:53

know

80:54

ensure that the digital solution also uh

80:57

withhold like holds

80:58

this business rule true and then the

81:00

last section would be a glossary which

81:01

will just summarize

81:03

all the abbreviation acronyms used in

81:05

the whole document so just to give a

81:07

view of the person who is reading the

81:08

document understand it

81:10

better so these are some common sections

81:13

in a brd

81:16

moving on question number three what are

81:18

the contents of a functional requirement

81:20

document or frd so this is similar to

81:23

our previous question

81:24

again uh they want to understand your

81:27

depth of knowledge in preparing such

81:29

documents

81:30

so quickly gonna list out all the common

81:33

sections which is

81:34

uh you know used in drafting uh frd

81:37

so first one would be the purpose again

81:39

what is the purpose of this particular

81:41

document

81:42

uh how it's how it you can borrow

81:45

some context from the brd to put it here

81:49

similarly the scope section again can be

81:51

borrowed from the brd what

81:52

is in scope what is out of scope so it's

81:54

very clear and then

81:56

comes these functional and

81:57

non-functional requirements

81:59

so these are the system related

82:01

requirements and

82:03

here you'll be document documenting what

82:05

the system should do

82:07

in our example if we take this would

82:10

talk about

82:11

how the customer should be able to see

82:14

the list of shows

82:15

the list of seats which are available

82:17

for on each show

82:18

and where they can select the seats and

82:21

also make an online payment

82:23

so these are basically a translation of

82:27

the business requirements

82:28

uh into this is the functional

82:31

requirements which

82:32

which basically again what you want the

82:34

system to do

82:35

and these are all linked back to the

82:38

business requirements

82:39

similarly a business rule which we spoke

82:41

about the maximum of 10 seats can be

82:44

booked that also can be translated to a

82:46

functional requirement ensuring only 10

82:48

seats can be booked online and then we

82:50

come to the non-functional requirements

82:52

so these are the

82:52

requirements related to the performance

82:54

the security stability of this online

82:57

solution

82:58

so one such example is responsiveness uh

83:01

we want the solution

83:02

the system to respond within two seconds

83:05

of the user's input so for example user

83:07

selects a date

83:08

within two seconds we should be the

83:11

customer should be able to see the next

83:12

screen so that's one example of it then

83:14

the assumptions

83:15

we just spoke about and then the major

83:18

chunk of this

83:18

document would be the supporting models

83:21

which will provide

83:22

more context to the engineering team

83:25

and helping them to understand how we

83:27

want the solution to work so that they

83:29

can build it accordingly and you know

83:31

tested it

83:32

as well so this is about the use case

83:34

diagrams activity diagrams mockups which

83:36

we just spoke about

83:37

earlier so all of these would comprise

83:41

a you know will be part of a vr sorry

83:43

frd

83:44

and then the last one is a glossary

83:46

again just to provide more context on

83:48

the

83:49

acronyms and of the abbreviations used

83:54

question number four what is the format

83:56

and contents of an epic

83:58

so far we discussed about the waterfall

84:00

methodology and the documents used

84:02

when you come to agile it's very

84:04

document light

84:05

and all the requirements are captured in

84:07

the form of epic

84:08

or user stories epics are tileable and

84:10

then they

84:11

are broken down into detail user stories

84:13

so i've listed

84:14

uh this down the key components of an

84:17

epic

84:18

in this slide ideally in essence what an

84:21

epic

84:21

has is who what and why who requires it

84:25

what is required why is it required so

84:27

this is kind of a format

84:29

which is you know used to capture the

84:32

requirements

84:32

so a template which are provided which

84:34

is a commonly industry-wide

84:36

format which is used across as a who

84:39

requires it

84:40

i want what is required so that why is

84:43

it required

84:44

so that's a format if you look at an

84:46

example

84:47

as a customer i want to pay for my movie

84:50

tickets online

84:51

so that i don't have to stand in queue

84:54

to pay cash at the movie theater

84:56

so this is a again a customer convenient

84:58

convenience

84:59

requirement where we're talking about

85:01

the ability for the customer to pay

85:03

online for the movie tickets which they

85:05

have booked

85:06

so it captures the requirement in this

85:09

particular format and it also has some

85:11

additional information like priority

85:13

what is the priority of the requirement

85:14

is it a must should or record

85:16

or if you're using ranking it can be ra

85:19

you know prioritizes one two three four

85:21

etcetera etcetera so it all uh helps in

85:24

the prioritization of the backlog so

85:25

that the highest value item is delivered

85:27

first

85:28

and then this has the business contacts

85:30

so it provides more context on

85:32

why this particular requirement is uh

85:35

you know listed in first place so all

85:37

the things which we spoke about in brd

85:39

so those things

85:40

can be added here as a business context

85:43

and then it has

85:44

links to the detailed user stories so

85:48

if you look at an epic it gives a

85:51

high level requirement of what is

85:53

required

85:54

in the next slide we will speak about

85:56

the detailed user stories

86:00

question number five what is the format

86:02

and contents of an user story

86:04

so we are building upon from the

86:06

previous question which

86:07

you know which is epic and these are the

86:09

detailed user stories

86:10

so the format of a user story is very

86:13

similar to the

86:14

epic who what and why so what

86:18

i try to provide as an example is the

86:21

epics the epic spoke about how the

86:24

customer should be able to pay online

86:27

and in these two user stories we are

86:28

breaking down it further

86:30

so if you look at the first one as a

86:31

customer i want to pay online using

86:34

my debit or credit card for my movie

86:37

tickets again

86:38

he wants to avoid standing in queue the

86:40

second user story talks about

86:43

customers ability to pay online using

86:45

the online banking portal so for example

86:47

they don't use a

86:48

credit card they want to use their

86:49

online banking net banking portal

86:52

so this breaks down the epic

86:55

into more details of the channel which

86:58

the customer wants to use

86:59

we can still have more user stories like

87:02

the mobile

87:03

valids paypal etc etc

87:06

so this kind of gives you a view how an

87:08

epic is kind of linked to the user story

87:10

and what is the

87:11

format and the user story also has like

87:14

additional information like the priority

87:16

similarly must should could or high

87:19

medium low again one two three four

87:21

ranking

87:22

and then it will also have the epic

87:24

which is linked to

87:25

and then the acceptance criteria which

87:27

will uh we speak about

87:28

uh in the next slide and also the

87:31

supporting models

87:32

so the use cases activity diagrams the

87:34

mockups which we spoke earlier

87:36

all of them would be created and

87:38

attached to

87:39

the user story as a supporting model to

87:41

provide more

87:42

context and more information to the

87:46

engineering team to build the solution

87:50

question number six what is an

87:52

acceptance criteria

87:54

and its former as discussed in the

87:56

previous question

87:57

acceptance criteria is a for is a part

87:59

of our user story

88:01

and it's a very important part it

88:03

basically

88:04

uh states the condition or outcome which

88:07

has to be satisfied in order for a re

88:09

uh for a solution to be acceptable to

88:12

the business stakeholders

88:14

so it's very key in terms of coming up

88:17

with the

88:18

qa test scripts and also the uat test

88:21

scripts

88:22

so so it's a very vital component of a

88:25

user story when we look at the

88:28

template or the format so usually

88:32

the acceptance criterias are also given

88:35

as a one line statement

88:36

in an example demonstrate that the

88:39

customer is able to

88:41

pay using their debit or credit card

88:44

but that is there is high level

88:45

statement on in order to make it

88:47

more robust and ensure that everybody

88:51

gets

88:51

a clear understanding this is the format

88:54

which you see on the screen it's

88:56

based off bdd behavior driven

88:59

development

89:00

so the format is given a context

89:03

when an event happens then what is the

89:06

outcome

89:07

which is expected if we translate that

89:09

to an example

89:10

based on the user story which we just

89:12

discussed given customer has selected

89:15

the show

89:16

and selected their seats when they are

89:18

on the payment

89:19

page of the digital solution then

89:22

they should be able to pay online using

89:25

their debit or credit card

89:27

so it clearly spells out what are the

89:30

uh what is the context what is the event

89:33

and then what should

89:34

happen so it's very clear to everyone

89:37

the developers and also the testing team

89:39

what the outcome we are looking for in

89:41

what condition

89:43

and it ensures that we build a solution

89:45

according to the

89:46

uh business requirements

89:51

question number seven what is rtm or

89:54

requirement traceability matrix so this

89:56

is one of an

89:57

important tool or technique which is

90:01

used to trace requirements

90:04

so this provides backward and forward

90:06

traceability

90:07

as shown in this diagram and it helps

90:10

faster impact analysis and reliable

90:12

assessment

90:13

to ensure that all your business

90:15

requirements are covered

90:17

so if you look at this example rtm or

90:20

requirement traceability matrix

90:22

so the business requirement will be

90:25

mapped to

90:26

the stakeholder requirements uh sql

90:28

requirement one and two

90:29

so in our example if you if you talk

90:32

about the digital channel for allowing

90:34

customers to book

90:35

uh tickets the stakeholder requirement

90:38

number one can be related to the

90:40

customer facing

90:41

screens and how they can how it allows

90:45

and the other stakeholders who can be

90:47

involved would be

90:48

the backend team or the back office

90:51

operations team

90:52

and what are the requirements from their

90:55

side to process the

90:57

customers online booking so that's how

91:00

the different stakeholders will have a

91:02

different set of requirements so the

91:03

first level of mapping would be

91:05

with respect to the business requirement

91:07

and the stakeholder requirements

91:09

and then the stakeholder requirements

91:11

would be mapped to the functional

91:13

requirements

91:14

and also the non-functional requirements

91:16

which we spoke about

91:18

and then the functional requirements or

91:20

non-functional requirements in turn

91:21

would be mapped to this design component

91:24

okay

91:25

in order to deliver this functional

91:28

requirement

91:29

what are the design components required

91:32

so

91:33

if you take an example of the screen

91:36

to show the customers the list of

91:40

available seats

91:41

so the design would involve different

91:43

screens

91:44

and also the the the logic for

91:48

showing up the available seats so so

91:51

that

91:52

all comes under the design and then the

91:54

design

91:55

component maps to the the code so

91:59

in which a particular language

92:02

the the co the code is there it may be

92:05

java.net

92:06

or it can be uh any other new

92:09

technologies like python

92:10

so all of this programming comes under

92:14

the code and it is mapped to the

92:17

design component and once the code is

92:20

kind of completed and then it's

92:22

maps to the test case so the test case

92:25

would ensure that

92:26

um the code which is developed

92:29

works accordingly to the requirement so

92:32

this

92:33

kind of gives an end-to-end mapping

92:37

to ensure that a business requirement is

92:40

kind of

92:41

test developed and tested

92:44

so it's a very useful tool and this is

92:47

one of the key things which

92:48

also use on a day-to-day basis and it

92:51

can be

92:52

asked in an interview

92:56

moving on question number eight what are

92:59

the different visual models

93:00

you created for documenting requirements

93:04

so this is another key questions which

93:06

keeps

93:07

getting repeated in the business analyst

93:09

interview

93:10

so i've listed the major ones used but

93:13

there are

93:13

much more uh visual models uh

93:17

which have been used so i'll be creating

93:19

another video only

93:20

dedicated to this but in this video i'm

93:22

just going to quickly cover of the

93:25

commonly used ones the first one is the

93:27

use case diagram

93:28

which uh kind of documents the

93:31

interactions between the

93:33

user and the system which we are

93:35

building what are the different things

93:37

a user can do functions with the user

93:40

can

93:40

perform using the system then there is

93:43

the activity diagram

93:44

which again captures uh the interaction

93:47

between the user and the system in a

93:49

very detailed way

93:51

let's say example if the if the customer

93:54

selects on uh the particular show

93:57

what happens what is the screen which is

93:59

shown to the customer

94:00

uh let's say it is in the seed selection

94:04

let's say customer proceeds without

94:06

selecting a seat

94:07

then there should be an error message

94:09

which should be thrown so all of these

94:11

things are kind of captured as part of

94:12

the activity diagrams

94:14

and then it comes the wireframes so this

94:17

is basically the look and feel of the

94:19

screens

94:20

so how the screen should look what are

94:22

the colors

94:23

what are the components which are which

94:26

should be

94:27

available to the customer in the screen

94:29

so all of this visual part

94:31

are handled using the wireframes then we

94:33

have the prototypes which is similar to

94:36

the wireframes but this kind of gives

94:39

a journey in a visual way if the

94:42

customer clicks on

94:43

one button on one screen then what is

94:45

the next screen which is popping up

94:48

they click on this what is the next

94:49

screen which is popping up it's kind of

94:51

you know it's a storyboard which is very

94:53

easy for the developers to visualize

94:55

while they're building the solution and

94:57

also for the testers

94:58

to test the solution and then we have

95:01

the business process flows

95:03

it's the end-to-end flow basically what

95:06

happens

95:07

uh when the event is started

95:10

who are the actors you know they are

95:12

depicted by swim lanes

95:14

what are the actions which are taken by

95:16

the customers

95:17

by the staff on the on the

95:20

business side so all of these things are

95:23

visually represented

95:24

as part of the business process flows

95:26

the last one

95:27

key key one is the data flow diagrams uh

95:30

basically these are

95:32

uh more of a technical in nature which

95:34

shows how

95:35

the data flows from which is the source

95:39

and how it's get getting captured in the

95:42

backend database so these are some key

95:45

things and commonly used

95:46

visual models if you feel there are any

95:50

any similar ones which are very key and

95:52

used widely

95:53

please comment in the comment box and

95:56

i'll pick it up while i'm creating

95:58

the other video

96:02

moving on to the last question question

96:04

number nine what are the tools you have

96:05

used for documenting requirements

96:08

so this is one of those tricky questions

96:11

where the

96:11

base might not be prepared while facing

96:14

the interview so i've just

96:15

listed it out here so

96:19

predominantly most of the requirements

96:21

are captured using

96:23

the ms office tools if you are following

96:26

the waterfall model

96:28

word the frds and brds are captured in

96:30

the word document

96:31

and the the powerpoints

96:34

can be used for presenting these key

96:37

parts to the stakeholders for either

96:41

sign off or you know just to present

96:44

and get their views on and then excel is

96:46

used for the

96:47

requirement traceability so

96:50

it's it's mo it's more or less all the

96:53

business analysts work

96:54

heavily on ms office and then

96:57

there's a sharepoint where all these

97:00

documents are commonly

97:01

uh maintained so it's like requirements

97:04

management is done using

97:06

the sharepoint which all these documents

97:08

which we spoke about

97:10

if you're using waterfall but if you're

97:11

using agile methodology

97:13

i think most of the things are on jira

97:16

uh the epics are created on jira the

97:18

user stories are created on jira

97:20

acceptance criteria is documented as

97:21

part of the user stories

97:23

and all the supporting models like we

97:25

spoke about the mock-ups

97:26

the use cases activity diagrams all will

97:29

be

97:29

just part of the jira and

97:32

confluence is also used uh extensively

97:35

uh where i want to make

97:36

uh provide more notes or more context so

97:39

jiran confluence are the key tools

97:41

in the agile methodology and there is

97:44

this require

97:44

requisite pro this is also one of the

97:46

requirements management tool

97:48

um which will which is which which is

97:50

used

97:51

and then we have the vizio and

97:55

eris so these are the business process

97:57

modeling tools so

97:58

you can create business process models

98:00

using that and visio is extensively

98:02

you know it can be used for your

98:04

activity diagram use case diagrams

98:06

any type of diagrams and you know the

98:09

mock-ups

98:10

can be created uh using visio powerpoint

98:13

and also

98:14

ms paint and then

98:17

if you want to go a little high-tech on

98:20

the

98:21

tools for capturing the business process

98:23

models and all the different

98:24

uh diagrams the visual models i think

98:27

lucidchart is one tool which is

98:30

uh which have all the pre-built

98:32

templates and can be used readily

98:34

uh uh readily and it can be uh

98:37

you know it can save a lot of time and

98:40

then we have

98:41

ballismic this is also it's a mock-up

98:44

tool

98:45

and it's basically used for creating

98:48

all these web-based mockups and mobile

98:51

phone app

98:51

mock-ups so these are the things which

98:54

uh

98:55

you know commonly used again please

98:57

comment in the comment box

98:59

if there are any other tools which you

99:02

think i've missed out here

99:08

hello there welcome to this video in

99:11

this video you're going to discover the

99:12

top 10 commonly asked questions

99:15

in interviews on scrum agile methodology

99:18

if you have an interview coming up

99:20

shortly then this is a video

99:21

for you

99:26

question one what are the events

99:28

ceremonies in agile methodology

99:30

so there are four key uh events

99:34

and we're going to cover those in detail

99:36

in the upcoming slides

99:38

but i'm just going to provide an

99:40

overview of these

99:41

four events in this particular question

99:44

so we have a sprint planning which

99:46

happens

99:48

during the beginning of the sprint and

99:50

then we have the daily scrum

99:52

which happens daily during the duration

99:56

of the sprint

99:57

and then we have sprint review and

99:59

sprint retrospective

100:00

towards the end of the sprint so we're

100:02

going to cover all of these

100:04

events in detail so stay tuned

100:10

number two so this is again another

100:13

commonly asked question is the

100:14

composition of the scrum

100:16

team so ideally the scrum team comprises

100:19

of

100:20

three main roles which are listed in the

100:22

slide one is the product owner

100:24

two is the scrum master and third one is

100:27

the development team the development

100:29

team

100:30

includes the developers uh the testers

100:33

or any other i.t stuff so

100:36

all these three roles comprises of a

100:40

scrum team

100:43

question number three so this question

100:47

relates to the artifacts in scrum as you

100:49

know scrum methodology

100:51

is basically very light in documentation

100:54

but these are the three

100:55

major are kind of used in the process

100:59

so first one is the product backlog so

101:02

this contains

101:03

all the things which relates to the

101:06

doubler for the product the epics the

101:08

user story the defects

101:09

any other ideas so all of this goes into

101:12

the

101:13

product backlog and then we have the

101:15

sprint backlog

101:16

so as i was speaking in the question one

101:19

about sprint

101:20

planning so the items which

101:23

deliver most value to the customer based

101:25

on urgency or based on

101:27

other factors so all these items are

101:30

transferred from

101:31

product backlog to the sprint backlog

101:34

which becomes the scope of that

101:36

particular sprint and which is

101:38

used throughout the sprint the third

101:40

artifact is basically the product

101:43

increment which is delivered in that

101:44

sprint it can

101:46

it contains the software package the

101:49

release notes

101:50

and the user user manuals on how to use

101:52

the functionality

101:54

which was delivered in that particular

101:56

sprint so

101:57

that summarizes the three

102:00

major artifacts used in the scrum

102:02

methodology

102:04

question number four is what is velocity

102:08

so ideally it is ability of the scrum

102:11

stream

102:12

to deliver valuable product increment

102:15

so it's basically calculated based on

102:18

the

102:19

story points of the backlog items which

102:22

were

102:22

delivered in that sprint or we can term

102:25

it as

102:26

done in that particular sprint so let's

102:29

say for an example

102:31

41 story points worth of

102:35

product backlog items were delivered in

102:38

or completed in sprint

102:40

one so then the velocity of that scroll

102:43

scrum team can be termed as 41.

102:46

let's continue the example let's say in

102:48

sprint to the team

102:50

uh completes uh 42

102:54

then they're going to average out 41 and

102:58

42 and then use that

103:00

as a variable in the sprint planning

103:02

meeting basically this kind of gives an

103:04

idea of what the team can deliver

103:07

in a particular sprint and it's used for

103:10

planning

103:11

so that's the main use of velocity

103:14

question number five what is the use of

103:18

a sprint burn down chart or what is a

103:20

sprint

103:21

burn down chart so again this is one of

103:23

the artifacts

103:24

used uh in the process to kind of

103:29

track how the progress is

103:32

with respect to the sprint goal and then

103:35

kind of adapt

103:36

to achieve the goal which was planned in

103:39

the beginning of the sprint

103:40

so if you look at the example chart

103:42

which is given here

103:44

uh it's a two week sprint let's say it's

103:46

14 days

103:48

worth of for days it's tracking and then

103:51

the yellow line kind of for

103:52

tracks the story point which needs to be

103:55

completed on a daily basis to achieve

103:58

the

103:59

sprint goal and then the red kind of

104:02

signifies what is the actual so it's

104:04

basically giving a plan

104:06

versus actual view and then during the

104:09

daily scrum meeting this chart can be

104:12

referred and the team can adapt

104:14

or adjust accordingly to

104:17

complete this part particular sprint

104:20

goal so again it's a very useful

104:22

metric for tracking

104:25

progress question number six

104:28

so i was telling we'll discuss more

104:32

in detail of the events so this is the

104:35

first

104:36

of the four events in scrum process

104:40

so which is a sprint planning meeting so

104:43

a lot of interviews will ask

104:44

what actually happens in those meetings

104:47

so

104:48

so what the basically the purpose of

104:49

this meeting is just to craft

104:51

a sprint goal and also plan to achieve

104:55

it

104:56

so the participants would include the

104:58

scrum team

104:59

uh the development team scrum master and

105:01

product owner and then they will use the

105:04

product backlog and then pick okay

105:07

these are the product backlog items

105:09

let's see what

105:10

should we target for this release so for

105:12

example if it's a

105:14

the team is building a ticket booking

105:17

app for a movie

105:18

theater chain so maybe they would have

105:21

delivered the basic functionality of

105:22

login

105:23

registration and booking the tickets

105:26

but they wouldn't have the functionality

105:28

of seat selection

105:30

by the customer so that can be one of

105:32

the major functionality which they can

105:33

target in the sprint

105:35

and that can go that can be the goal of

105:38

like that can be the sprint goal

105:40

and then that goal can be broken down

105:44

into the user stories and epics which

105:45

will populate this

105:47

print backlog and also the velocity is

105:50

used as an input

105:52

to kind of determine what the team can

105:54

kind of complete in that sprint so

105:56

it's as we discussed in the previous

105:58

slide if the team can complete 41

106:01

story points worth of uh items

106:05

then in the next print also they can use

106:08

that as a guiding parameter and then

106:10

they can keep okay let's we can only do

106:11

for 41

106:13

uh let's see what we can fit in those

106:16

things yeah

106:17

and then using all this uh

106:20

input so the output will be the sprinkle

106:23

as i was just telling in the example

106:25

the seat selection feature can be a

106:27

sprint goal and then the sprint backlog

106:30

all the epics and the users user stories

106:32

related to that particular functionality

106:35

can be

106:36

included in the backlog and then a

106:38

sprint burn down chart which we just

106:41

looked in the previous slide

106:42

can be charted with the plan

106:46

planned story point completion

106:47

throughout the sprint process

106:50

yep

106:53

and the question number seven is the

106:55

next

106:56

item or which is the even which is the

106:59

daily scrum meeting

107:00

explained basically they would ask to

107:03

explain what happens in the daily

107:05

scrum meeting so this is a daily scrum

107:07

or it's also termed as a stand-up

107:09

meeting

107:10

so the purpose is just to review the

107:13

team's progress

107:14

on the sprint goal and not just the plan

107:17

to get there

107:18

the development that the participants

107:20

mainly would be the development team

107:22

and the scrum master product owner is

107:24

kind of

107:25

optional so it's good to include the

107:27

product owner but

107:28

again he or she is optional

107:31

so the inputs would be the sprint

107:33

backlog okay these were the items the

107:35

user stories and the

107:37

tasks which are outstanding for this

107:39

particular

107:40

sprint and also the sprint burn down

107:43

chart how how is the team progressing so

107:46

the progress would be inspected and if

107:48

there's any impediments or was telling

107:50

about the blockages

107:51

uh it can be a technical issue or a

107:54

environmental thing or

107:55

well various factors which will be

107:57

blocking progress so those can be

107:59

identified

108:00

and then um

108:05

usually a follow-up call or a follow-up

108:08

meeting would be set up

108:09

to work on resolving those impediments

108:12

usually it's all driven by

108:14

a scrum master

108:18

oh my question number seven question

108:20

number eight is basically

108:22

uh describe what happens in sprint

108:25

review meeting

108:26

so this review meeting happens at the

108:28

end of the sprint

108:30

and ideally the purpose is to just

108:32

showcase the work which was completed

108:34

in the sprint to the stakeholders this

108:37

meeting will have

108:38

extended stakeholder list along with the

108:41

scrum team which will include the

108:42

sponsors the customers

108:44

or the end users and also the sales team

108:47

they would like to see

108:48

how the product is shaping up and they

108:50

also can provide their feedback

108:53

so the input again would be the goal so

108:56

example we spoke about

108:57

like seed selection feature and then

109:01

how the feature which was developed so

109:03

the usually it will be done by the

109:04

product owner they'll

109:06

just showcase or demo this particular

109:09

functionality to this extended audience

109:11

and then get their feedback like are

109:14

they happy with it or if there's any

109:16

improvements or any enhancements which

109:19

can be done

109:19

it would be noted down and it'll be

109:21

added to the product backlog

109:24

so that was mainly happens in this

109:26

review meeting

109:27

again the product owner also provides a

109:29

status report and also a forecast

109:31

of what would be coming in the next

109:35

prince

109:36

if yeah and also when there is a release

109:38

planned

109:39

so all those things kind of gets

109:41

discussed in this particular

109:43

meeting and we'll move on to question

109:45

number nine

109:46

so this is the last major event

109:49

in the scrum methodology which is print

109:52

retrospective meeting

109:53

so here basically

109:56

it's the participants or the scrum team

109:58

themselves the development team the

110:00

scrum master product owner

110:01

the main agenda is to identify how we

110:04

can make the product development

110:06

process better simple yeah so they look

110:09

at all the

110:11

uh impediment list that's the main thing

110:13

so that they can be prepared in the next

110:15

print and also the review comments which

110:17

were provided by the stakeholders in the

110:19

review meeting so

110:20

those things can be kept in mind uh

110:23

while working on the next sprint

110:25

and also the burned on especially the

110:27

progress uh

110:28

and how how what where like what what

110:31

things can be done better

110:33

in order to hit the plan so it's more of

110:35

a looking back reflecting back and also

110:38

looking forward so those

110:41

outputs would be the action items for

110:42

improvements which can be implemented

110:45

in the upcoming sprints so that there's

110:48

a better process

110:51

question for this particular video is

110:53

again it's what is

110:55

definition of done this is one of a

110:57

tricky question which is

110:58

asked and basically it's an exit

111:01

criteria which is agreed with the

111:03

product owner and the development team

111:05

for

111:06

marking a backlog item

111:09

has been completed and it's ready to be

111:12

shipped so example login feature

111:16

or one of the features which we

111:17

discussed the

111:20

seed selection feature yeah it can be

111:24

only termed as done if it is

111:27

coded tested reviewed and accepted by

111:30

the product

111:31

owner so this is one of the terminology

111:33

for an item to be

111:35

termed as completed so let's say if the

111:38

one of the item is only coded

111:39

and tested you cannot term it as done

111:42

all these factors which have been

111:44

pre-agreed should be

111:46

completed in order for an item to be

111:49

complete termed as done

111:53

hello there do you have a business

111:55

analyst interview coming up shortly

111:57

if so this is the video for you in this

112:00

video we're going to discuss

112:02

the top 15 commonly asked interview

112:04

questions

112:05

on acronyms or ba terminologies

112:08

used in business analysis ranging from

112:11

crud sipoc rfq rfi

112:15

cots and much more we're going to take

112:18

the term expand it and provide

112:22

its usage with an example so that this

112:24

will help you

112:25

to answer the questions in the interview

112:28

process

112:29

we have a lot to cover so let's get

112:31

started

112:34

question number one what is invest

112:37

invest stands for

112:38

independent negotiable valuable

112:41

estimable small

112:43

testable the inverse guidelines are used

112:45

in agile methodology while writing the

112:47

user stories

112:48

the above criteria ensures a

112:50

well-written news stories

112:52

let's look at it again independent it

112:54

talks about

112:55

the user story being independent of

112:58

other user stories

112:59

dependency between user stories create

113:01

complexity and wherever possible

113:03

we should maintain uh user story

113:06

independent

113:06

of the others negotiable this talks

113:09

about

113:10

having a conversation with the team and

113:12

trying to

113:13

work out the details of the story

113:16

accordingly

113:17

valuable the this talks about

113:21

the user story should be creating value

113:23

to the end user

113:25

be the customer or be the staff or

113:28

working with application

113:29

if it doesn't deliver any value then

113:32

there is no

113:33

purpose for user story to be on the

113:35

backlog in the first place so

113:37

to ensure that the user story creates

113:40

some value

113:41

to the end user estimable

113:44

so this talks about how the user story

113:46

should be written so that the

113:47

development team

113:49

can help i can you know look at the

113:52

story and come up with

113:53

estimates it can be a ballpark but yeah

113:56

it should be able to

113:58

estimable by the development team so

114:01

that it helps in the prioritization

114:03

process and the release planning

114:05

small wherever possible the story should

114:08

be broken down

114:09

into uh the smallest part of it

114:12

and it should not be combined with other

114:15

features so wherever possible

114:17

it should be limited to a single

114:19

requirement

114:20

from an end user or from an internal

114:23

staff

114:23

so it becomes easy for

114:27

development testing and maintenance the

114:30

last part is testable

114:32

so by looking at the user stories the

114:34

testing team should be able to come up

114:36

with their

114:37

test scripts and help in their testing

114:40

process

114:40

ideally the acceptance criteria helps in

114:42

this place

114:44

acceptance criteria as part of the user

114:45

stories can be created

114:48

sorry translated into test cases and can

114:50

be used by the testing team

114:54

question number two what is crud crutch

114:58

transfer create read update and delete

115:02

so these are the four basic functions to

115:04

be considered in software development

115:05

while we're dealing with

115:06

data and this the same uh

115:09

thread can be used for drafting you know

115:12

high level requirements

115:13

if you're looking for an example uh and

115:16

you're i'll be tasked to do a

115:18

requirements for an online food

115:19

ordering app even before you are meeting

115:23

the business you can just come up with

115:25

these requirements using crud

115:27

c stands for create so customer should

115:30

be able to place an order

115:32

r stands for read customers should be

115:35

able to view their order

115:36

and u stands for update customer should

115:38

be able to update their order and d

115:41

stands for delete customers should be

115:42

able to cancel their order

115:44

so it's a very good technique to

115:47

uh ensure that the data is handled

115:50

end to end right from creation up to

115:53

deletion

115:57

question number three what is what so

115:59

what stands for strength

116:01

weakness opportunities

116:04

threats it's a strategic planning

116:06

technique used to craft out strategies

116:09

let's try to look at this with an

116:10

example

116:12

one of your clients is a business owner

116:15

and

116:16

sorry restaurant owner and he has a come

116:19

to your

116:20

consulting firm seeking help on how to

116:24

uh you know how to create a strategy

116:28

to combat a new restaurant which has

116:30

come down the corner

116:32

so you can use swot and help out craft

116:35

that strategy so let's

116:36

let's look at it first we identify what

116:39

is the

116:40

strengths of the client so

116:43

the bus the restaurant uh has been for a

116:46

while

116:47

and it's very appreciated for its uh

116:50

taste and also it is highly economical

116:54

and there's huge flocks of crowd are you

116:57

usually coming during the lunch time

116:59

uh during the office hours to grab a

117:02

bite so that's the strength if you look

117:05

at the weakness

117:07

the restaurant closes at uh 8 p.m

117:12

uh due to la you know not not many

117:14

office

117:15

going people kind of hang out at that

117:18

particular restaurant

117:19

whereas a new restaurant which is coming

117:21

up is open till 11 a.m

117:23

so if anyone after 8pm wants to kind of

117:27

uh you know hang out they can go to the

117:29

new restaurant so that's a weakness

117:30

so one of the strategical point to

117:32

combat it is

117:34

maybe open the closing time of the

117:37

restaurant next and the closing time of

117:38

the restaurant

117:39

maybe to 10 or 11 and you know see how

117:41

it works out

117:42

and then the opportunities so this

117:46

new restaurant bringing up it opens up

117:49

for opportunity one of the opportunities

117:51

which you can think of is

117:52

the client's restaurant is in indian

117:54

cuisines while the new restaurant is

117:56

chinese

117:57

so maybe can just have a conversation

117:59

with the

118:01

restaurant owner and try to see if you

118:04

can

118:06

cross cross serve maybe they can promote

118:08

your restaurant

118:09

i can tell you if you're an indie

118:11

restaurant you can go down the rounder

118:12

and you can do the same

118:13

vice versa what's happening is

118:15

collectively you're trying to

118:17

in collaboration you're trying to grow

118:19

each other's business

118:20

the threat is the new restaurant um

118:24

happens to be better and it's able to

118:26

serve faster

118:28

than i think you

118:31

this particular business will be taken

118:33

out of

118:38

going on question number four what is

118:40

uml this is a very

118:42

commonly asked question in the interview

118:45

sessions

118:46

uml stands for unified modeling language

118:49

it's basically a standardized modeling

118:51

language for visualizing and documenting

118:53

the artifacts

118:54

of the software programs most commonly

118:57

used uh

119:00

uml diagrams are the activity diagrams

119:04

use case diagram sequence diagrams so

119:07

basically

119:07

these diagrams provide a view to the

119:10

development team

119:12

how the interaction between the user and

119:15

this system should be

119:16

which will help them to visualize and

119:18

come up with the solution

119:19

accordingly

119:24

question number five what is the

119:25

difference between rfi

119:27

rfq and rfp this is one of the commonly

119:30

asked confusing question

119:32

in the interview process i'm just going

119:34

to try to simplify it in this particular

119:36

slide

119:36

rfi stands for request for information

119:40

all we're doing here is reaching out to

119:42

the different vendors and trying

119:44

to understand what are the services or

119:47

the capabilities

119:48

which the vendor can deliver only that

119:51

nothing much

119:52

just reaching out and trying to

119:54

understand the services

119:56

which they provide rfq stands for

119:58

request for code

120:00

this is usually uh used when you know

120:03

what you want you're reaching out to the

120:04

different vendors

120:06

to understand what the cost involved in

120:07

delivering the solution for that

120:10

for that particular requirement so this

120:12

involves reaching out to the different

120:14

vendors

120:14

just telling them what you need and

120:16

trying to get the code from

120:18

them for comparison the last one is rfp

120:21

this is the one which is commonly used

120:24

this involves

120:25

a kind of a business stay a business

120:27

need or a problem statement

120:29

you reach out to vendors and you give

120:30

them that and you ask them to come back

120:33

with their proposal

120:34

and the cost so the proposal would

120:36

basically involve the approach

120:38

the tools which they'll be used are

120:39

using to solve

120:41

the business problem statement or

120:43

achieve the business need

120:44

and also the cost involved so rfp is one

120:47

of the most commonly

120:48

used but there there are

120:52

uh companies which do use rf i and rfq

120:55

as well

121:04

question number six what is cods cots

121:07

stands for commercial off the shelf code

121:10

system

121:11

are developed and maintained by external

121:12

organization

121:14

and they are just implemented as part of

121:16

the business to meet their business need

121:18

or

121:18

solve a problem statement rather than

121:21

developing their

121:22

own in-house software system for example

121:25

a business needs a customer relationship

121:28

management platform

121:29

instead of developing an in-house

121:31

solution they can go and

121:33

get sap crm zoho crm or salesforce

121:36

similarly if they want to send out

121:38

emails to their customers

121:40

they can use a vapor get response

121:44

etc so the idea here is instead of using

121:47

the time

121:48

developing in-house system

121:52

the business can use a readily available

121:54

software

121:55

and they can get started to address

121:59

their business need or

122:00

resolve a problem statement

122:05

moving on to the next question what is

122:08

wbs

122:09

wbs stands for work breakdown structure

122:13

this is a process of decomposition of

122:16

the task and effort required to complete

122:18

a project or

122:19

an objective so from a ba prospective

122:22

let's say

122:22

you're tasked with the requirement

122:24

gathering for a particular

122:26

initiative so at a high level

122:31

the initiative will result in a

122:33

requirement

122:34

document maybe in form of use stories or

122:37

brd

122:38

or fl you know the functional

122:40

requirements so

122:41

in order to break down and make it more

122:44

easy for managing

122:45

and reporting maybe you can split

122:48

that requirement gathering sessions from

122:51

a customer

122:52

facing view and then you can have

122:54

requirement gathering session

122:56

with department e department b

122:59

and department c so you're basically

123:01

breaking down the

123:03

requirement gathering process across and

123:06

having some

123:07

timelines to it and also then

123:10

crea having a process of documenting the

123:13

requirements and getting the required

123:15

sign off

123:16

so all of these act activities can be

123:18

broken down

123:19

and then into small components

123:22

it can be planned and managed

123:24

accordingly so they

123:26

provide some more visibility and easy

123:29

for the individual performing those

123:31

activities to accomplish

123:37

question number eight what is cpoc sipoc

123:40

stands for suppliers input

123:42

process inputs process outputs and

123:44

customers

123:45

cpoc diagram is used for defining the

123:48

scope of a process

123:49

improvement initiative and also helps to

123:52

understand

123:54

the current state and then to work out

123:57

on the process improvements so cpoc

124:00

ideally basically talks about who the

124:03

suppliers are

124:04

what are the type of inputs they provide

124:06

to a process

124:08

raw materials data etc

124:11

and then what is the process which

124:13

converts the inputs

124:15

to the required outputs what are the

124:18

required outputs

124:19

and who are the ultimate users of those

124:23

outputs so it's in a in a simple

124:26

line uh in a table or a diagram can

124:29

understand what's happening

124:31

currently and can work on the process

124:34

improvements accordingly

124:39

question number nine what is jad chad

124:42

stands for joint application development

124:44

chat sessions are similar to workshops

124:47

or where you have

124:48

a variety of stakeholders ranging from

124:50

the customer the end user

124:52

smes business stakeholders business

124:55

analysts developers

124:57

all collaborating together for capturing

125:00

high quality

125:00

functional requirements basically you

125:03

want to uh

125:04

the end result of this particular

125:06

session would be

125:08

what the what is that the system should

125:11

do

125:12

in order to accomplish the business

125:14

requirements

125:15

so that's the whole agenda for this

125:17

particular sessions

125:18

and this provides a a good understanding

125:22

to the development team

125:23

uh what is required and also some

125:26

business context on

125:27

why it is required so that it will help

125:29

them to

125:30

develop the solution accordingly

125:35

question number 10 what is bpmn bpmn

125:38

stands for business process model

125:40

annotation bpmn is a methodology

125:43

or an industry standard language used

125:46

for visually represent

125:47

representing the business process in the

125:49

form of diagrams

125:51

so the business user or a technical

125:53

developer if they just look at

125:55

this business process model they will be

125:57

able to understand

125:58

or what is the flow of events who does

126:01

what so usually the business process

126:03

models are in the form of swim lanes

126:06

uh one actor and all the activities for

126:08

that actor are confined to a swim lane

126:10

so if you're taking an example you have

126:13

actor one and actor two let's say

126:14

customer uh

126:16

and a ticket provider for a movie

126:19

tickets so customer

126:21

walks in hands over uh informs the

126:24

the ticket counter which show and how

126:27

many tickets

126:28

he or she wants to buy and then the

126:30

ticket provider will

126:32

just show them the screen and as ask the

126:35

customer to pick the seats once

126:37

the seats are being picked picked by the

126:38

customer uh

126:40

the ticket provider confirms the ticket

126:44

and then uh charges informs the customer

126:47

how much

126:48

the ticket is and once the customer pays

126:50

the money the ticket is printed out and

126:52

handed over to the customer

126:54

so this back and forth interaction can

126:56

be easily represented in a business

126:58

process model and let's say if

127:00

a business is trying to take this

127:02

journey to a digital channel where the

127:04

customer can book

127:05

their tickets using phone or you know

127:07

online

127:08

then this particular process model can

127:10

be used to model

127:12

the interac the interaction by the

127:14

developers

127:15

and it's pretty easy it's all there in a

127:19

process model it's easily understandable

127:21

and can be used accordingly for the

127:24

development

127:28

question number 11 what is dfd dfd

127:31

stands for data flow diagram

127:33

so dhp is a visual representation of

127:35

flow of data

127:36

through a software system again this

127:39

really helps

127:40

the development team uh during the

127:42

development process

127:43

so let's say if you're working on a

127:45

reporting requirement uh

127:47

you can provide a view of how the data

127:50

is captured

127:51

and where it is stored so let's say

127:52

example the customer data is captured

127:54

through

127:55

the you are the front-end screens and it

127:56

is stored in one particular

127:58

database similarly the transactional

128:00

data are recorded in another

128:02

database and then how which are the

128:05

fields you can try to

128:08

capture from which database so you can

128:11

you can provide this

128:12

view in a data flow diagram

128:16

and this will really help the

128:17

development team to come up with a

128:19

required solution

128:20

for the report

128:25

question number 12 who is an sme

128:29

sme stands for subject matter expert

128:32

smes are invaluable resources for

128:34

understanding how the current processes

128:37

work so uh they are actually either

128:40

uh you know experts in their own niche

128:43

or

128:43

on field for example if you're looking

128:46

at a particular

128:47

part of the business the first point of

128:50

contact

128:51

uh would be an sme because they know

128:53

inside out they've been

128:54

in the system for a few years they may

128:57

be

128:58

uh senior team members of the team or

129:01

business architects or sometimes even

129:02

the business analysts who have been

129:04

working on that particular

129:05

uh process for a while would be an sme

129:08

the smes

129:09

are really key during the requirement

129:12

gathering

129:13

phase uh when you're eliciting

129:15

requirements they are the point

129:17

of contact to provide how the current

129:20

process is

129:21

and what are the things they would

129:23

require to make it

129:30

better

129:32

question number 13 what is rtm rtm

129:35

stands for requirement reasonability

129:37

matrix

129:37

it's basically a matrix used to trace

129:40

requirements

129:41

it provides the backward and forward

129:43

traceability

129:44

and it helps in a faster impact analysis

129:48

and

129:48

unreliable assessment to ensure all the

129:50

business requirements are

129:52

designed developed and tested so let's

129:55

look at an example

129:56

in the below diagram we have a business

129:59

requirement

130:00

it's a map to the stakeholder

130:02

requirements one and two

130:03

and the stakeholder requirements is

130:05

further mapped to the functional

130:07

requirement and non-functional

130:09

requirement

130:10

and then the functional requirement in

130:11

turn is mapped to the design component

130:14

which traces to the code whichever

130:17

language it can be

130:18

written in java.net python and then the

130:21

particular code then it maps up to a

130:25

test case

130:26

so if you just look at this particular

130:28

diagram and metrics

130:29

you can ensure that a business

130:31

requirement here

130:32

on stakeholder requirements here is is

130:35

is designed

130:36

developed and tested so this provides

130:39

an end-to-end view and ensures that

130:42

everything is covered

130:47

question number 14 what is roi roi

130:50

stands for

130:51

written on investment this is a very

130:53

important

130:54

metric and it measures the return of

130:57

investment relative

130:58

to the investment cost and this is a

131:02

again as i state it's a very important

131:03

metric for approval of a project or an

131:06

initiative

131:07

let's take an example if there are a

131:09

certain number of

131:11

business use user perform users

131:13

performing a certain

131:14

activity and let's say on an yearly

131:17

basis

131:18

that amount is around hundred thousand

131:21

dollars spent year-on-year for that

131:24

particular

131:25

activity and there is a proposal

131:28

for automating that part and the

131:31

cost for implem implementing the

131:34

solution would be let's say 50 000

131:36

and then year on year maintenance cost

131:39

of ten thousand dollars

131:41

so if you look at a five-year uh time

131:43

frame

131:44

without implementing this solution the

131:47

cost would be around five hundred

131:48

thousand dollars

131:50

a hundred thousand dollars a year on

131:51

year but if we implement the solution

131:54

the total of cost for five years would

131:56

be hundred

131:57

thousand dollars uh fifty thousand

131:59

dollars for

132:00

first year and then ten ten ten ten for

132:03

the subsequent years

132:04

sorry it's 90 000 so when you're looking

132:07

at five year time frame

132:09

with implementation of the solution it's

132:11

90 000

132:12

without implementation of the solution

132:14

it's 500 000

132:15

so there's a clear benefit

132:18

of 410 000 uh saved due to implementing

132:22

this particular

132:23

proposed solution so when you present

132:25

these figures to the business it's easy

132:27

for them to

132:29

take a decision for providing the

132:31

funding and go ahead for a project or

132:33

initiative

132:38

moving on to the last question question

132:40

number 15

132:41

what is uat i believe most of you guys

132:44

already know

132:45

know the answer but i just wanted to

132:46

cover it off

132:48

the uat stands for user acceptance

132:50

testing

132:51

uat is performed by the business end

132:54

users

132:55

of that particular application and they

132:57

check whether

132:58

the developed software works in line

133:01

with the with their business

133:02

requirements

133:03

and the business analyst role in this

133:06

part would be to

133:07

assist the end users to perform uat

133:11

uh by helping them with the test cases

133:13

desk scripts

133:15

defect arising a defect defect

133:18

management or defect resolution

133:20

and also to clarify whether a certain

133:22

request which is

133:23

raised during uat whether it's part of

133:26

the initial requirement

133:28

or is it a scope creep

133:34

hello there do you have a business

133:36

analyst interview coming up shortly

133:38

if so this is one of the videos for you

133:41

in this video we're going to cover the

133:43

top 11 into week questions

133:45

asked on sql queries

133:48

you may be wondering why would they ask

133:50

sql query

133:52

in a business analyst interview if you

133:54

are appearing for a

133:56

role of a system analyst it business

133:58

analyst

133:59

or in a techno functional role then

134:02

definitely there will be questions

134:03

on sql so this video will help you

134:06

prepare for the interview and also

134:09

having a techno

134:10

functional expertise is always

134:12

considered a plus

134:14

during the hiring process so we have a

134:17

lot to

134:17

cover let's get started

134:22

before we proceed further i would

134:24

request you to please go ahead and

134:25

subscribe

134:26

to our youtube channel if you have not

134:27

already done so and also please go ahead

134:30

and click on the bell icon so that

134:31

you will be notified when we will be

134:33

uploading a new video in the business

134:36

analyst

134:37

interview series we are planning to

134:38

upload 10 more videos

134:40

so please go ahead and click on the bell

134:42

icon so that you're notified whenever we

134:44

upload it

134:49

okay let's get started as we usually do

134:52

we look we take a case study and then

134:55

answer the questions using the case

134:56

study

134:57

so in this case study we are going to

135:00

have

135:00

a company e-commerce company which is

135:03

selling

135:04

electronics like mobile phone laptop on

135:07

tab

135:07

tablet and this is a particular

135:11

table in the database called orders

135:14

which kind of

135:14

records who's the customer what are they

135:17

ordered

135:18

what is the value of the order in which

135:20

city they awarded and also the

135:22

mode of payment is it cash paypal

135:25

or credit cards so we're going to use

135:27

this table and then we're going to

135:30

derive the the queries and also look at

135:33

the results

135:37

question number one how do you retrieve

135:40

all records from a table

135:41

so this is one of the most commonly

135:44

asked and the

135:45

basic question anyone will ask you an

135:47

interview so the sql query for that

135:50

is select star from table name so

135:53

in our example the table name is order

135:55

so that's why it's select star

135:57

from orders and the result would be all

136:00

the

136:01

rows and the fields which we saw in the

136:03

table

136:04

would be displayed

136:10

question number two how do you retrieve

136:13

only

136:14

custom name and order value fields so

136:17

the select star

136:19

displayed all the fields from the table

136:22

now the interviewer will be checking

136:25

your knowledge

136:26

on how would you retrieve certain fields

136:29

which are of interest to you

136:31

so here the customer name and the order

136:33

value so the sql query for that

136:35

is select name

136:39

which style which is for the customer

136:40

name and value which is

136:42

for the order value from orders the

136:45

table

136:46

the result would be as such so now if

136:49

you see the result will have only

136:51

two fields or two columns corresponding

136:53

to the customer name

136:54

and the order value it won't show all

136:58

the

136:58

fields which are you know from the table

137:01

so this will help to

137:02

uh focus while you're doing the analysis

137:05

when you're

137:06

looking for only certain values uh

137:09

certain fields

137:10

and their values

137:14

question number three how do you

137:16

retrieve only customers with

137:18

order value more than five hundred

137:19

dollars so this is again

137:21

some conditionality is being uh

137:25

placed into the question so the sql

137:28

query for this

137:29

is we're going to select the name and

137:31

the order value from the table

137:33

but we're going to add a conditionality

137:36

which is

137:37

where value is greater than 500 so what

137:40

this will do is

137:42

it will only filter out the rows with

137:45

a order value more than 500 dollars

137:48

so from our previous example we had

137:50

seven rows

137:51

but now there's only four rows displayed

137:54

because

137:55

only four rows for these four uh

137:58

customers the other value is greater

138:00

than

138:00

five hundred dollars again this will

138:02

help you

138:03

i will performing the analysis and

138:06

that's why these are the questions which

138:08

the interviewer will

138:10

ask so that to kind of uh gauge your

138:13

depth

138:14

under understanding in the sql queries

138:18

question number four how do you retrieve

138:21

only customers with order value

138:23

more than 500 and from ordered from

138:27

seattle which is a city so again

138:29

building upon from the previous question

138:32

here we are further fine tweaking the

138:35

conditionality

138:36

and getting a narrower result

138:39

so the sql query for this remains the

138:41

same as what we saw in the previous

138:43

question

138:44

only the additional thing is where value

138:47

is 500 and city equal to seattle so and

138:51

city

138:52

equal to clt will be the additional part

138:54

in the sql query

138:55

which will give us a result as such uh

138:58

where

138:59

we had four rows from the previous

139:02

query but this query will return only

139:04

one because this is only

139:07

a row which satisfies both this

139:09

condition where the value is greater

139:11

than 500

139:12

and also the customer ordered from

139:15

seattle

139:16

so that's why we're again fine tuning it

139:18

so these are all again

139:21

conditional conditional questions which

139:23

will be asked to gauge your

139:25

understanding on sql queries most of the

139:28

time it will be

139:29

based on scenario they won't just ask

139:33

can you give me an example with this and

139:35

that how do you filter

139:36

it'll be most on a business scenario so

139:38

that they will they

139:39

they understand that you understand the

139:41

concept of how do you

139:43

take a business query and business

139:45

requirement

139:46

and translate into a sql query

139:51

moving on question number five so again

139:54

we are

139:55

asking how do you retrieve only

139:56

customers with order value more than 500

140:00

or more is cache again these are all

140:02

conditionalities

140:03

but here it's our conditionality either

140:06

this

140:07

or that so we'll look at the query

140:10

it is the same as what we saw previously

140:13

the only change is

140:14

after value is greater than 500 we have

140:17

a r clause

140:18

and then mode equal to cash so we are

140:20

interested in customers

140:22

with order value more than 500 or was

140:25

paid in cash

140:27

so the query will return as such if you

140:30

see there are

140:31

five rows here and i want to point out

140:35

the row number two

140:36

smith even though his order value is

140:38

less than 500 which is 450

140:41

because his cache mode the mode is cache

140:44

the sql query will return this

140:47

particular result

140:53

moving on question number seven

140:56

so here uh the question would be how do

140:59

you retrieve customers

141:00

whose order value is between 100 and

141:03

500. so this is a range question

141:06

i think we covered values now this is a

141:09

range

141:10

so the sql query for this is again name

141:13

value from orders

141:15

but we're going to use a clause called

141:17

between

141:18

so we're going to use a where value

141:21

between 100 and 500 so what this sql

141:24

query will basically

141:26

retrieve is all the order values

141:29

ranging from 100 to 500 and the result

141:32

would kind of look like this

141:33

so these are the three records which are

141:35

having a value

141:36

greater than 100 but lesser than 500 so

141:39

this is again

141:41

really useful when you're doing the

141:42

analysis and also translating the

141:45

business requirement into functional

141:47

specs and also sometimes

141:49

the itbas provide inputs

141:52

to the technical spec and that's where

141:55

all these queries will come in handy

142:00

pushing forward question number seven

142:02

how do you retrieve only customers

142:04

ordered from

142:05

seattle and baltimore so the previous

142:08

question was more of a range

142:10

and this question is uh values

142:14

if the value equals to this or that how

142:16

it will happen

142:17

so one of the uh syntax we can use

142:20

is the in in syntax

142:24

so we select name city from orders

142:25

remain the same but the where

142:27

conditionality changes with

142:29

city in seattle baltimore

142:32

so which will result the records or the

142:36

rules

142:37

of of customers ordered from seattle

142:40

or baltimore

142:44

okay moving on question number eight so

142:47

this is a very interesting question

142:49

how do you find the total number of rec

142:51

orders

142:52

so the interviewer might just ask how do

142:54

you find total number of orders in the

142:56

database

142:56

so the syntax for that is count star

143:00

so if you hit select count star from

143:02

orders it will give you

143:04

the number of records from the table

143:07

so in our case study or example we had

143:10

seven records and that's the reason the

143:12

result would have

143:13

written seven

143:18

question number nine how do you insert a

143:21

order to the table

143:23

so this is so we all the queries we

143:26

looked at till now is more of

143:28

fetching the data so this query would be

143:32

insertion or addition of a order of a

143:35

record to the table

143:36

so let's let's see the sql query for the

143:39

same

143:40

so this is a query insert into

143:43

orders which is the table name and we're

143:45

going to list on all the fields

143:47

of the particular table order number

143:50

name category

143:51

value city and mode and then we are

143:54

going to

143:54

input the values which we are going to

143:58

add to these particular fields using the

144:00

values

144:01

syntax and then we give order number is

144:03

8

144:04

name of the customer is jane the

144:06

category of purchase is mobile

144:08

value of the purchase is 300 city from

144:11

the purchase

144:12

where the purchase is made is new york

144:13

and the mode of

144:15

payment is cash so this is a query once

144:18

the query is executed

144:20

the result would look like this the

144:23

table would have an additional row

144:25

which is the last row or order number

144:28

eight

144:28

and all the parameters which we have

144:31

supplied as values

144:32

will be added to that particular row of

144:34

the table

144:39

question number ten how do you update

144:42

an order value so we looked at fetching

144:44

the records

144:46

then we looked at how we add a record to

144:48

a table

144:49

let's say we have added a record to a

144:51

table but the value is not

144:53

correct it's incorrect due to an error

144:55

so

144:56

we can use the sql query with update to

144:59

update it to the correct value

145:01

so the syntax would be something like

145:03

this update

145:04

orders set city equal to baltimore

145:08

so the city we had entered as part of

145:10

the insertion

145:11

was new york but which was incorrect

145:14

actually the customer ordered from

145:15

baltimore so now that's why we are

145:17

updating it using set city is equal to

145:20

baltimore

145:20

where order number is eight so this

145:23

order number

145:24

or where order number is equal to eight

145:26

is the clause

145:27

basically it'll search for this

145:28

particular record we know it's unique

145:31

because order number is unique and then

145:33

it'll look for

145:34

the city and replace whatever value

145:38

with baltimore so post the execution of

145:41

this query

145:42

order number eight would look something

145:45

like

145:46

like this everything will be the same

145:48

except the city would be updated from

145:50

new york

145:50

to baltimore

145:54

question number 11 the last question in

145:56

this video

145:58

how do you find customers with minimum

146:01

and maximum

146:02

order value so is this again an

146:05

uh query for analysis so if you want to

146:08

find what is a minimum order value

146:10

the syntax is select min

146:13

value which is the field name from

146:16

orders

146:16

so this would result in 225

146:20

because this is the minimum order value

146:23

in the orders table similarly if you

146:26

want to look at

146:27

what is the maximum value we want to

146:29

find out what the maximum order value

146:32

then the syntax is similar select

146:34

instead of min

146:35

it will be max value which is a field

146:37

from the orders table

146:39

and the result would be thousand so if

146:41

you've seen earlier

146:42

1000 is the highest order value placed

146:45

by a customer

146:46

till now and that's the reason thousand

146:49

would be written

146:50

so again these are all um kind of uh

146:53

analysis queries uh and it and it can be

146:57

comes in handy during the analysis

147:01

phase so that's about

147:04

it from a questions and answers

147:07

perspective so it's only 11 questions

147:09

again

147:10

as i told earlier these are all very

147:12

simple queries

147:13

but if you don't get this right you

147:16

won't progress further in the interview

147:18

uh the interviewer might not be even

147:19

interested to ask more so

147:21

i know these are basics but it's good

147:23

it's uh you know

147:24

always good to revise the basics and in

147:27

the next two videos i'll be covering

147:29

most of the more advanced sql queries

147:31

and also some more concepts

147:33

of sql like rdbms or the different types

147:37

of

147:39

keys primary key for foreign all those

147:41

things i'll be covering in the next set

147:43

of videos

147:44

so please make sure your you subscribe

147:46

to this uh

147:48

youtube channel and click on the bell

147:50

icon so that whenever we load it

147:52

you'll be notified

147:56

question number three what are the

147:58

different levels of testing

148:00

this is one of the question asked to

148:02

gauge your knowledge of different types

148:04

of

148:04

testing across the software development

148:06

life cycle

148:08

let's look at it

148:11

i've summarized it in this particular

148:13

diagram

148:15

so the first level of testing is called

148:17

the unit testing

148:18

and it is done by the developers so once

148:20

they've written the code

148:22

they check if everything works fine as

148:25

per the requirement

148:27

the second level of testing is called

148:30

sit

148:30

or system integration testing so once

148:33

the unit testing is successful

148:35

it's deployed to the sit region

148:39

and sad environment and then the the

148:41

testers would be

148:43

performing the system integration

148:45

testing just to ensure the connectivity

148:47

works

148:47

and all the test cases and test

148:49

scenarios which have written against the

148:51

requirement works well

148:54

and the thirdly the third level of

148:56

testing is

148:57

called uat or user acceptance testing so

149:00

this is done by the business users

149:02

so these are the end users of the

149:04

application which is being developed

149:06

and these are the users who would have

149:09

provided

149:10

the requirements in the first place

149:13

so they will be doing it or there will

149:16

be a representative from the business

149:18

team who will be doing it on their

149:20

behalf

149:20

so they'll be checking whether the

149:22

application develops satisfies

149:24

their requirements and once everything

149:27

is successful

149:28

then the the code moves to the

149:32

production environment

149:33

so the go live or the deployment of

149:37

production

149:37

usually happens on a weekend and

149:40

once the code is deployed to production

149:42

there will be a couple of

149:44

people from again from the business team

149:46

the end users will be checking

149:48

whether the code works fine in the live

149:51

environment so there's no hiccups

149:53

there's no

149:54

at least the basic critical test cases

149:57

would be executed by them to ensure

149:59

everything works fine so this type of

150:01

testing is called live testing

150:03

there are different names to it but the

150:04

concept remains the same

150:06

so these are the different levels of

150:08

testing

150:09

i hope it helps on

150:13

understanding the concepts involved

150:16

there

150:19

in this video you're going to look at a

150:20

variety of topics uh from business

150:23

analyst role in testing

150:24

creation of test plan rtm

150:27

test scenarios and test case creation

150:30

and also the different testing tools

150:31

used

150:32

and also we're going to look at all

150:34

these questions from a

150:35

view of a business analyst so this is a

150:38

really a different view

150:40

and all the other videos which we have

150:42

on testing interview and questions and

150:44

this talks

150:44

in specific and in relation to a

150:47

business analyst

150:48

and also if you have not already

150:50

subscribed to our channel i would

150:51

request you to please go ahead and

150:53

subscribe to our prefix ba youtube

150:54

channel so that you're notified

150:56

when we come up with the next video we

150:59

have a lot of cover so let's get started

151:04

to make it easier for grasping the

151:06

concepts and the answers

151:08

we're going to use a case study in this

151:10

case study uh

151:11

a movie theater chain called xyz cinemas

151:14

is looking to build a digital channel

151:16

for allowing the customers

151:17

to book their movie tickets online

151:20

rather than now

151:21

calling up the customer care or standing

151:24

in the long queues

151:25

and getting their tickets at the ticket

151:27

counter so we are going to use this

151:30

uh example case study for

151:33

answering all the questions

151:40

question number one what is the role of

151:41

a business analyst during

151:43

testing phase this is a sure short

151:45

question

151:46

and ninety percent of the time this

151:48

question would be

151:49

asked in the interview so there are two

151:51

major testing phases

151:53

uh one will be the site system

151:56

integration testing

151:56

the other one will be the uat user

151:58

acceptance testing so we're going to

152:00

look at

152:01

the rules and responsibilities of a

152:02

business analyst during these two

152:04

key testing phases so let's start with

152:07

sit

152:08

so the first key responsibility of a

152:12

business analyst would be the

152:13

walkthrough of the requirements

152:15

to the testers so the business analyst

152:18

will explain

152:18

what the requirement is answer any

152:20

questions from the tester so they

152:22

understand

152:23

what is being required and now what is

152:25

being developed

152:26

and then the testers will go back and

152:28

come back with the

152:30

test scenarios and test cases and that

152:32

is a second task for a business analyst

152:34

to review them and ensure that they have

152:37

got

152:38

the scenarios and the test cases right

152:41

for all the requirements

152:42

which leads us to the third point which

152:44

is checking requirements traceability

152:46

we're going to talk about more on this

152:48

in the subsequent slide when we talk

152:50

about the requirement

152:50

and traceability metrics but here just

152:53

to

152:54

this step is done to ensure that all the

152:57

requirements

152:58

are having a subsequent scenario or test

153:00

case

153:01

and then the other key part or key role

153:05

is when the test execution happens once

153:08

the defect has been locked

153:09

by the uh the testing team

153:12

it is assigned to the to the business

153:15

analyst first to ensure that

153:17

the defect is valid before it you know

153:19

gets assigned to the development team

153:21

if it is an invalid defect like invalid

153:24

scenario or the testers might not have

153:26

understood

153:26

it correctly then it can be rejected by

153:29

the business

153:30

and less than and there so that the time

153:32

of the development team is not

153:34

wasted so it's like a different triage

153:37

it's done by the business analyst

153:39

the last key thing is articulating

153:42

business

153:42

impact and assisting in defect

153:44

prioritization let's say there are like

153:46

10 defects and

153:48

there will be a question asked what is

153:50

the priority of the defects

153:52

because we might not be in a position to

153:53

fix everything by the development team

153:55

then

153:56

it becomes a responsibility of a

153:58

business analyst

153:59

to get the business impact for all those

154:02

defects

154:03

and then assign the priority one two

154:05

three so that it makes it easier for the

154:07

development team to get it done

154:09

and if there are further defects it can

154:11

be pushed over to the next release which

154:13

are not very

154:14

critical or high so that's on the site

154:18

coming to the uat i think most of the

154:21

things what we discussed

154:22

holds good for uat as well the

154:25

walkthroughs

154:26

the reviews or traceability validity of

154:28

the defects and articulating business

154:30

impact

154:31

along with that this is where there

154:33

would be additional things

154:35

asked by a business analyst that is

154:38

here creation of the test scenarios and

154:41

test cases

154:42

so as you know the uat is done by the

154:44

business users and they are not

154:46

very uh equipped with testing concepts

154:48

or you know

154:49

testing or they might not have that time

154:51

because they are doing you 18 addition

154:52

to their day job

154:54

so there will be a request rise for the

154:56

business analyst

154:57

to create the test scenarios and test

154:59

cases so this is where

155:00

your knowledge of scenarios and test

155:02

cases will come in handy

155:04

and the other one would be this

155:06

management and reporting

155:08

again due to the lack of bandwidth by

155:09

the business use users

155:11

so the management like the test planning

155:15

creation of schedule strategy

155:17

environment setup

155:18

all of those things would come as a

155:20

responsibility of a business analyst

155:22

and also the daily reporting and

155:25

ensuring the

155:26

high priority defects are being resolved

155:28

all those management

155:30

is being asked by to the to be done by

155:32

the business analyst

155:33

ideally these were a traditional role of

155:35

a test manager

155:36

but nowadays the trend has been the

155:39

business analysis are being asked to

155:40

pitch in

155:41

so having knowledge of these will give

155:44

you edge

155:44

over the other candidates in the

155:46

interview process

155:51

question number two what is functional

155:53

and regression testing

155:55

i know there are a lot of different

155:56

types of testing sanity testing load

155:58

testing performance testing etc etc

156:00

but with respect to business analysts

156:03

these are the key

156:04

or two key types of testing which is

156:06

functional and regression

156:08

so let's look at them quickly first one

156:11

is functional testing

156:12

this refers to testing of

156:13

functionalities developed

156:15

as part of that current release so these

156:18

are the new functionalities which are

156:20

delivered

156:20

and testing of those functionalities is

156:22

referred to as functional testing

156:25

regression testing so this refers to

156:27

testing of the existing functionalities

156:30

and to ensure that they still work fine

156:32

post addition of these new

156:34

functionalities to the application so

156:36

this is usually done

156:37

at the end of the test cycle let's try

156:40

to look

156:41

at these with an example

156:45

so again the example refers to our case

156:47

study and

156:48

the new release delivers the online

156:50

payment functionality to the customers

156:52

so prior to this release customers were

156:54

using the application to book movie

156:56

tickets

156:57

post booking the tickets they would use

156:59

to get a confirmation and then they used

157:01

to give the confirmation to the ticket

157:02

counter and pay

157:04

make the payment either using cash debit

157:06

card or pay mobile balance at the ticket

157:08

counter

157:09

suppose this release the customers can

157:11

make online payments

157:12

through the application itself so they

157:14

don't have to

157:15

take the confirmation go to the ticket

157:17

counter and all of those things so it's

157:19

much more simplified and a better

157:21

customer experience

157:22

right so let's look at what is

157:24

functional and regression testing

157:25

in this example functional testing so

157:28

this refers to the

157:30

online payment functionality which is

157:32

being

157:33

deployed as part of the current release

157:35

so it's a new functionality

157:37

so testing of that is known as

157:38

functional testing

157:41

regression testing so testing of the

157:43

functionalities which were already

157:44

existing which is like registering

157:46

login seat selection for the movies

157:49

so all of these are existing

157:50

functionalities and they still need to

157:53

work post the deployment of the online

157:56

payment functions

157:57

functionality so testing of those

157:59

existing functionality

158:01

is referred to as regression testing so

158:03

these these are the

158:05

key uh types of key to uh two types of

158:07

testing and which would be

158:09

asked by the interviewer

158:14

question number four what is a test

158:15

scenario

158:17

a test scenario refers to a particular

158:19

functionality which needs to be tested

158:22

as simple as that so test scenarios

158:25

uh can be created using use cases

158:29

if your project is using waterfall

158:31

methodology

158:32

or acceptance criteria if your project

158:35

is using agile methodology

158:37

so if the business asks you can you

158:39

create the scenarios

158:41

there's no need to panic all you have to

158:43

do is translate the use cases

158:46

acceptance criteria to test scenarios as

158:49

simple as that

158:50

let's look at a couple of examples to

158:53

give a

158:54

wider context so again these

158:57

examples are taken from our case study

158:59

so test scenario number one

159:01

check the search functionality for the

159:03

movies so this scenario basically talks

159:06

about

159:06

where the customer can enter a keyword

159:09

and the appropriate movie

159:11

appears in the listing test scenario

159:13

number two

159:14

check the availability of seats for a

159:16

particular movie so this is where the

159:18

customer logs in

159:19

selects the movie the timings and then

159:22

goes to a screen where it shows

159:24

which seats are available or which seats

159:27

are not

159:27

for selection so the seats which are

159:29

available maybe in white and the seats

159:31

which are not available

159:33

can be grayed out just scenario number

159:35

three

159:36

check for the online payment

159:37

functionality so this is a functionality

159:39

where the customers can

159:40

pay using credit card debit card paypal

159:44

or any mobile ballots so if you see

159:47

all these scenarios test scenarios are

159:50

basically

159:51

either use cases or acceptance criteria

159:54

so

159:54

if a need arises for you to create a

159:57

test scenario

159:58

it's as simple as translating the user's

160:00

use use cases or acceptance criteria

160:06

question number five what is the test

160:08

case or the components of test case

160:11

so this question uh is another commonly

160:14

asked one

160:15

so test case is defined as a series of

160:17

actions executed to verify a particular

160:19

functionality

160:20

so basically this is an extension of the

160:22

test scenario

160:23

so these are the steps taken uh by the

160:27

tester

160:27

to verify whether the test scenario is

160:30

as per the expectation

160:32

so let's look at it using an example

160:35

so if we you look at the test scenario

160:38

which was check the availability of

160:40

seats for a particular movie

160:42

let's see how a test case for it looks

160:44

like

160:46

so there will be a test case name so can

160:48

we test the seat availability

160:50

display and then this table and the

160:53

columns are pretty key here

160:55

so it has the step number description

160:57

expected result

160:59

actual result pass fail defect id so

161:02

this answers what are the components of

161:05

a test case

161:06

if asked the

161:10

these are the key information key

161:11

columns there can be additional

161:14

columns used by the sit testers but

161:17

again if

161:18

if if it's from a uat perspective and

161:20

you're preparing

161:21

a test case this is more than sufficient

161:25

so let's look at the example so step

161:28

number one

161:28

and the description so the description

161:30

is like enter the xyz cinema url

161:33

what is the expected result this xyz

161:36

cinema's website should open in a

161:37

browser

161:38

and step number two search for a movie

161:41

expected result is the search movie

161:42

should appear with an image

161:44

and the name step number three uh click

161:47

on the movie

161:48

uh name or image once it is clicked the

161:50

expected result will be the timing

161:52

should be displayed

161:53

and then the last step is to click on

161:55

the particular time

161:56

and here is where the the key

162:00

uh test key expected result is which is

162:02

the seating arrangement should be

162:04

displayed with the available seats in

162:05

white

162:06

and the reserve seats or the book seats

162:08

already grayed out so this is the

162:09

expected result

162:10

so you're doing all the steps involved

162:12

to come to step number four to check

162:15

whether the available seats are

162:18

shown in white yeah and can be clicked

162:22

so this is how a test case looks like or

162:24

these are the components of test case

162:26

so this can be used to answer the

162:28

question as far as in the interview

162:29

and if the business asks you to prepare

162:31

a test case you can use the same

162:33

template

162:34

to prepare one for the uh the business

162:37

in the next slide we're going to look at

162:39

the test execution

162:40

and how the remaining columns are filled

162:43

so let's look at it in the next slide

162:48

previous slide if a question is asked

162:50

what happens in the

162:51

execution so you can use this

162:54

explanation as a reference

162:57

let's say a business user is executing

162:58

this particular test case as part of the

163:00

uat

163:01

the actual result pass fail and defect

163:03

id the last three columns should be

163:05

updated as part of the execution so if

163:08

you go

163:09

by this so the first step was to enter

163:12

the url

163:13

for the xyz cinemas the website should

163:16

open

163:16

which which it did and then the second

163:18

step was to search for a movie

163:20

the actual result was once it was

163:22

searched the movie with the image

163:24

was displayed the relevant movie which

163:26

the customer was uh

163:29

searching for and then once the the

163:31

movie was clicked

163:32

the timing should have been displayed

163:34

which was displayed

163:36

in this uh execution cycle so once these

163:39

steps are successful

163:41

uh which is the actual result is as per

163:43

the expected result

163:45

then the pass fail column should be

163:47

updated with pass pass pass indicate

163:49

indicating that these steps were

163:51

successful let's

163:52

look at the last step where once you

163:55

once the particular time is clicked

163:57

the seats available seats should be

163:59

shown in white

164:00

but what was observed was all the seats

164:03

were grayed out

164:04

even the available seats so which is a

164:07

fail

164:08

so this particular step was not

164:10

successful so when this happens

164:12

the tester needs to indicate it by

164:16

fail by updating the password column as

164:18

fail and then

164:20

a defect has to be erased so a

164:23

tool which is used for defect management

164:25

jira qc whatever is used in the

164:27

particular project

164:28

defect has to be raised the defect

164:30

usually contains

164:32

what is the defect what is the problem

164:34

expected actual results what are the

164:36

steps taken

164:37

all of this information is already

164:38

available it can be taken here and copy

164:40

pasted there

164:41

and also accompanying screenshots so

164:44

this will help

164:45

for further investigation of the defect

164:47

we're going to look at the defect

164:48

life cycle the next question but just

164:51

wanted to

164:52

give you a view of what all the key

164:54

components of raising a defect

164:56

so this is what happens in the execution

164:58

so if there's any question asked

165:00

so this explanation can be used to

165:02

answer

165:03

answer it

165:07

question number six explain the defect

165:09

life cycle

165:10

so this is one of the most commonly

165:12

asked question in the interviews on

165:14

testing

165:16

so let's look at it so it all starts

165:18

with a defect being raised

165:19

by the testing team it can be sit or it

165:22

can be uat the business user

165:24

the the life cycle remains the same so

165:27

the defect is rise

165:28

i've indicated the status of the defect

165:30

by the highlighted yellow box

165:32

the status of the defect will be new

165:36

and before going to the next step it's

165:38

very crucial and critical

165:40

that the the these components are

165:43

present

165:43

in the defect which is the description

165:45

of the defect what exactly is a

165:48

there's a problem and what is what was

165:50

the expected result

165:51

what is actual results and what was the

165:53

steps

165:54

taken to execute this particular test

165:57

case

165:58

and then the screenshots the relevant

165:59

screenshot so this will really help

166:03

the the analysis of the defect to be

166:06

very

166:07

faster so once the defect is raised it's

166:10

usually assigned to the business analyst

166:12

so it's your job to first check whether

166:14

all of these components are

166:16

available if not first and foremost you

166:19

have to inform the testers to add all

166:20

these components

166:22

so it comes to the business analyst the

166:24

business analyst first checks whether

166:26

it's valid or not

166:27

whether it is asked by the requirement

166:29

or the testers are

166:30

testing something which is autoscope so

166:33

if it's

166:34

valid then it is it gets assigned to the

166:37

development

166:38

team and the status of the defi defect

166:40

gets changed to assign

166:42

and in case if it's not valid the

166:44

business analyst rejects the defect

166:45

stating it's an invalid and also the

166:47

reason for rejection

166:48

and the status of the defect goes to

166:50

rejected

166:52

and then once it is assigned to the

166:54

development team the development will

166:56

team will check the validity of the

166:58

defect first

166:59

if it's not valid maybe it's this

167:01

detailer or environment

167:03

then it gets rejected as invalid with

167:05

the reasons specified by the

167:08

development team but in case it's valid

167:10

it goes

167:11

further investigations are done by the

167:13

development team so the first check is

167:15

to check whether

167:16

if there's any duplicate defect already

167:18

out there so this is

167:20

more common when if you're doing a

167:23

pro testing of an application for a

167:25

global robot

167:26

so there will be multiple countries

167:28

involved or multiple stakeholders

167:29

testing the same thing

167:31

what would happen in that scenario as

167:33

there would be

167:34

multiple testing teams testing the same

167:36

functionality and there are a lot of

167:37

cases where there might be duplicate

167:39

defects so they'll check whether it's

167:41

duplicate or not

167:42

if it's duplicate they will tag it to

167:44

the original defect or the defect which

167:45

was raised first

167:47

and the status of the of this particular

167:49

defect will be a duplicate

167:51

and then let's say it's not a duplicate

167:53

they will check whether

167:54

they're able to fix it so there are

167:56

several reasons where the

167:58

development team might not be able to

168:00

fix a defect one of them would be the

168:02

time constraint let's say that defect is

168:04

raised three days uh uh

168:08

until the end of the testing cycle or

168:09

two days or on the last day so this

168:11

doesn't give the development team enough

168:13

time to fix it

168:14

or if a defect is too complex to fix

168:18

maybe it requires architectural changes

168:20

so there are variety of reasons where

168:22

they won't be able to fix it

168:23

in that particular release then those

168:26

type of defects would be

168:27

deferred to the next release and the

168:29

status of that particular defect would

168:30

be deferred

168:32

and then let's say they're able to fix

168:33

it if they're able to fix it

168:36

then they would resolve the fix and then

168:39

they will deploy the fix

168:40

so once this deployed the fix is

168:42

deployed the status will change

168:44

to fixed indicating the testing team to

168:46

retest the defect

168:48

so that defect will be retested if the

168:51

defect is fixed

168:52

or not if it's not fixed it will be

168:54

reassigned back to the

168:56

development team with with stating the

168:59

same thing the

169:00

providing the resale read test results

169:03

the screenshots etc etc

169:05

let's say if it is fixed then the defect

169:07

will be closed

169:08

and the status of the defect will be

169:10

closed and

169:12

also there are the other defects the

169:14

rejected ones and the duplicate ones

169:16

are also will be moved to closed

169:18

eventually

169:19

and then this brings us to the end of

169:23

the

169:23

defect lifecycle again a very key

169:26

question so

169:27

you can use this and also try to use an

169:30

example when you explain this to the

169:32

interviewer

169:35

question number seven what is the

169:38

difference between priority and severity

169:40

again a very commonly asked question and

169:43

it's a

169:43

tricky one most of the people get it

169:45

wrong and this is a key one for a

169:47

business analyst because

169:48

business analysts are involved in the

169:50

prioritization of a defect

169:52

so let's look at it priority

169:55

priority basically defines the order in

169:57

which the defect should be

169:59

fixed and it's based on the business

170:00

value so let's say there are

170:02

10 defects the priority defines

170:06

how the development team should be

170:08

fixing them and the priority is based on

170:10

the business value again

170:11

so one of the key activities and

170:14

responsibilities of a business analyst

170:16

is during the defect management defect

170:18

triage to come up with this priority

170:20

so which will help the development team

170:23

to fix the key defects

170:24

uh for you know the release so that you

170:27

know the release goes as per planned and

170:29

the lesser priority ones can be

170:31

taken up in the next release

170:34

severity so cvrt is a degree of impact

170:37

the defect has on the operation of the

170:38

application

170:39

so this is the functionality's uh impact

170:42

so if for key functionality it doesn't

170:44

work

170:44

the severity is very high and it is

170:47

severity is based on the impact of

170:49

functionality

170:50

so there are again two priority and

170:52

severity are two different things but

170:54

you know it may look the same but they

170:56

are slightly they're two different

170:57

things

170:58

uh let me try to explain this with an

171:00

example and this is also

171:02

again a commonly asked question can you

171:04

tell me an example of high priority and

171:06

low severity

171:08

so one of the things is the company logo

171:11

is wrong so there is no key impact to

171:15

any functionality if a company logo is

171:17

wrong

171:18

so it doesn't the severity is very low

171:21

but the priority is high because if the

171:23

company logo is not

171:26

correct one if the customers who are

171:28

visiting the xyz cinemas online booking

171:31

website they may think you know what

171:33

this is not the website

171:34

or this may be a scammy website or there

171:36

are a lot of

171:37

thoughts and this will prevent the usage

171:40

of

171:40

usage of this particular online booking

171:42

service by the customers

171:44

so from a business perspective it is a

171:47

very high priority

171:48

and it needs to be fixed so this is one

171:50

of the key

171:51

examples which can be given the other

171:53

one is

171:54

high severity and low priority so

171:58

the footer links on the online booking

172:00

platform does not work let's say for an

172:02

example

172:04

so they don't work and from a

172:08

functionality perspective a url not

172:10

working is a high severity

172:12

but if if the online booking

172:15

url if it's not working like if they

172:17

click on book tickets if that doesn't

172:19

work

172:19

then again it becomes high priority but

172:22

if the

172:23

footer links does not work it becomes

172:25

low priority the reason being is

172:27

most of the customers don't use it let's

172:29

say 90

172:30

of the customers don't click on the

172:32

footer links so

172:34

in case if it's not being fixed on this

172:36

particular release due to the resource

172:38

or time constraint it can be fixed in

172:39

the

172:40

next release so it becomes a lower

172:42

priority

172:43

so this is the difference uh and uh you

172:46

can frame

172:46

you can use examples from your own own

172:49

past projects so that'll add more value

172:52

while answering this particular question

172:56

moving on to question number eight what

172:58

is rtm or requirement traceability

173:00

matrix

173:01

we covered this in couple of our videos

173:04

earlier

173:05

but i'm going to cover it today just

173:06

from a testing perspective

173:08

so as you know it's a matrix used to

173:10

test requirements backward and forward

173:13

from a testing perspective what is

173:15

required

173:16

here is to ensure that all the business

173:18

requirements are covered

173:20

as part of testing which is the

173:23

mapping of the requirements to the test

173:25

cases so if you look at an example the

173:27

business requirement

173:29

would be mapped to the stakeholder

173:30

requirements and stakeholder requirement

173:33

would be mapped to the functional and

173:35

non-functional requirement

173:36

and then the functional requirements

173:39

which would be

173:40

mapped to the test scenarios and test

173:42

scenarios will be mapped to the

173:44

test cases so this is

173:47

the key part and when as a business

173:50

analyst

173:51

as we spoke about in the first question

173:53

that is

173:54

one of the key responsibilities of a ba

173:57

is to review the test cases

173:59

and ensure you know that it all covers

174:01

all the requirements so you can use the

174:03

requirement traceability matrix to do

174:05

that

174:06

so you can map all the test scenarios

174:08

and test cases

174:09

and ensure that everything is covered as

174:12

part of the test cycle

174:13

both from an sit and also can be same

174:15

can be used from a uat perspective

174:21

this brings us to question number nine

174:23

the last question what are the tools

174:25

used in testing so this

174:26

particular question is asked used to

174:28

just test your exposure to testing

174:31

related activities and also the

174:32

artifacts

174:34

you can just pick and choose from the

174:36

table here to answer this particular

174:37

question

174:38

so the test strategy test plan uh

174:41

documentation is done by ms wood

174:43

we didn't cover this as part of the

174:44

video this is

174:46

another thing it might require a video

174:48

on its own but this plant

174:50

strategy is basically a document which

174:52

provides the approach which would be

174:54

used for testing the testings which are

174:56

in scope

174:57

the schedule when will the testing will

174:59

happen in scope out scope

175:01

and also the rules and responsibilities

175:02

and reporting

175:04

uh but it's a video on its own so that's

175:07

the reason i didn't cover it here

175:08

but it's all done using ms word and then

175:12

the test cases documentation the test

175:14

case

175:15

which we discussed so the documentation

175:17

is done using

175:18

qc or alms so these are the tools used

175:21

if there's no tools used then it will be

175:23

just

175:23

ms office which is the excel and then

175:26

the google sheets

175:27

if the company doesn't use office and

175:29

they just wanted to use

175:32

the google suit then google sheets is

175:34

used and then for execution

175:37

qc or alum is used so in the tool itself

175:41

once the test cases are done instead of

175:43

updating it

175:44

on an excel spreadsheet the testers can

175:47

update it directly in the tool itself

175:49

and reporting is very quick you can just

175:52

export the whole results

175:53

for you used on the test execution

175:56

update done to qc or alum so that's one

175:59

key tool

176:00

and then the defect logging so we

176:02

discussed the defect lifecycle

176:04

and the there are a lot of tools in the

176:06

market for defect management

176:08

and logging defects so the common used

176:10

ones are jira

176:11

in case of agile if it's waterfall still

176:14

the

176:15

qc alum is used and we have bugzilla and

176:18

clearquest so these are some common

176:20

common use tools which have come up in

176:22

the recent past

176:24

and then for screenshots for defects so

176:26

i've stated that the screenshots are

176:28

very key

176:29

for defect management and for

176:31

screenshots

176:32

we have some sniping tools like uh

176:34

snagit

176:36

uh light chart screen ticker if nothing

176:39

works you can just

176:40

take a screenshot and edit it using ms

176:42

paint so this helps

176:45

to provide more details in the defect

176:48

for the business analyst or also

176:50

the development team for quicker

176:52

resolution

176:53

and in case if there's database testing

176:55

involved then

176:56

toad or squirrel is used

177:00

commonly used so these are some commonly

177:03

used

177:04

tools you can just pick and choose based

177:06

on your experience while

177:08

answering this particular question

177:11

wow that's a long video i didn't expect

177:14

it when i started filming

177:16

but thanks so much for sticking around

177:19

to this point

177:20

did you enjoy this video if so i would

177:23

request you

177:24

to go ahead and subscribe to our youtube

177:26

channel

177:27

and also download the business analyst

177:30

interview

177:31

guide so there's a link in the

177:32

description you can click on it and

177:34

download it

177:35

it will have over 50 plus questions

177:37

again commonly asked questions

177:39

which will help you to smash your next

177:41

business analyst

177:42

interview so please go ahead and

177:44

download it and use it

177:46

as a prep material for your next

177:48

business analyst interview

177:49

and also i request you again to

177:51

subscribe to our channel

177:53

we post videos regularly on business

177:54

analyst techniques tools

177:56

uh tutorials and also interview prep so

177:59

until

177:59

i speak to you in the next video thank

178:01

you so much for listening to this

178:03

particular video

178:04

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.

SIGN UP FREE TO UNLOCK

AI SUMMARY

Get an instant AI-generated summary of the video content, key points, and takeaways.

SIGN UP FREE TO UNLOCK

TRANSLATE

Translate the transcript to 100+ languages with one click. Download in any format.

SIGN UP FREE TO UNLOCK

MIND MAP

Visualize the transcript as an interactive mind map. Understand structure at a glance.

SIGN UP FREE TO UNLOCK

CHAT WITH TRANSCRIPT

Ask questions about the video content. Get answers powered by AI directly from the transcript.

SIGN UP FREE TO UNLOCK

GET MORE FROM YOUR TRANSCRIPTS

Sign up for free and unlock interactive viewer, AI summaries, translations, mind maps, and more. No credit card required.