Data Warehouse Analyst Interview Questions and Answers

1 :: Explain As a BA (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

For any new piece of work a BA (business analyst) needs to know

1. who are the key stakeholders (i.e. those who can kill the project)

2. what are the key stakeholders specific and measurable measures of success (i.e. their objectives) and what VALUE for each objective MUST be achieved in order for the project to be considered a success (e.g. increase sales per order value by 5%)

3. what are the key stakeholders unmeasured measures of success (i.e. their principles that they would like to see happen but aren't going to measure and so the project cannot be assessed by them - e.g. an intuitive solution)

4. what are the key stakeholders high level requirements (i.e. what capabilities do they expect the solution to deliver - e.g. the ability to offer add-on sales during the order taking process)

5. what is in scope of the work in terms of processes, organization units, locations, data, applications, technology

6. what is the scope of the work in terms of time, money, project resources (people and materials)

7. who will the stakeholders nominate for determining further high level requirements and detailed requirements (e.g. subject or domain experts, middle management of operational teams, etc)

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No

2 :: Explain What is the difference between Business Requirement Document and Use case Document. What is the difference.

I need a good BRD and UC template?

BRD Describes the business information of the client.once we are clear abt BRD of the client then only we can create more acurate solutions.this is the initial document that helps to create Business models in Cognos and ReportNet.Actually this information we are getting by KT(Knowledge Transfer) session.

Usecase Document helps to create test case document during unit testing ,actually use case document contains testcase id and i/p values that should use during testing , we are using this id only in Test case document instead of specifying all these i/p values and some other ,that id itself describing all that.so we can say use case is the foundation document for test case document.

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No

3 :: Suppose I am loaded with questions as I am an experienced ETL coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of NON EMPTY so that I dont see records that are blank.?

Reporting services allows the slicing and dicing functionality. to see the non empty records, i think you have to create a calculated measure,to hide all the non empty rows.

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No

4 :: Explain about a tricky situation for which you found a very simple solution?

Your answer should show that they are a problem solver, that they can analyze all the information, and come up with a solution.

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No

5 :: Explain SWOT Analysis?

SWOT Analysis is a strategic planning technique used to assess the internal and external environment in which a company operates and competes. Internal environmental factors are classified into strengths and weaknesses, while external environmental factors are classified into opportunities and threats.

0/5 Rating (0 vote)

Is This Answer Correct?    0 Yes 0 No