Data Warehouse Analyst

  Home  Data Warehouse  Data Warehouse Analyst


“Data Warehouse Analyst guideline for job interview preparation. Explore list of Data Warehouse Analyst frequently asked questions(FAQs) asked in number of Data Warehouse Analyst interviews. Post your comments as your suggestions, questions and answers on any Data Warehouse Analyst Interview Question or answer. Ask Data Warehouse Analyst Question, your question will be answered by our fellow friends.”



21 Data Warehouse Analyst Questions And Answers

2⟩ Explain What is a View as it relates to system modeling?

A view organizes diagrams into logical groups to describe a particular aspect of the system. It is the abstraction of the system organized is such a way as to give a perspective of a related set of concerns.

The purpose of using views as a business analyst is to enable the analyst to comprehend very complex systems, and to organize the problem or solution domain around specific areas of expertise. The audience interested in each view may vary based on their roles and experience. A subject matter expert from the business will ask different questions and have different concerns than a developer or system architect. Views help present the information in an easily digestible manner.

 158 views

3⟩ Explain What is analytical or analytic mean?

If someone is analytical then it means the person is always thinking about things - analyzing, pondering, etc. A person who is analytical will have all of the facts about something before doing it.

Analytical is one of the 4 types of people. The other 3 are Promoters, Supporters and Controllers. Most everyone has a portion of every personality trait, but resembles 1-2 for the majority.

 156 views

4⟩ 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.

 149 views

5⟩ 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.

 174 views

6⟩ 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.

 159 views

10⟩ 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)

 134 views

12⟩ Explain What sort of existing documents should Business Analysts refer to when starting on a new project?

Few analysts are brought on to a project at the very beginning. For those that are, they will often have a hand in creating some of the important documents that other analysts should reference when they first join.

First, get your hands on the project charter. The project charter, while high level, will provide critical information on the project.

 179 views

14⟩ What is a Data Warehouse?

Data Warehouse

Data from different data sources is stored in a relational database for end use analysis

Data from different data sources is stored in a relational database for end use analysis Data is organized in summarized, aggregated, subject oriented, non volatile patterns.

Data is a data warehouse is consolidated, flexible collection of data Supports analysis of data but does not support online analysis of data.

Data from different data source is stored in a relationaldatabase for end use analysis

 165 views

15⟩ Explain Is it the job of a business analyst or systems analyst to draw the class diagram?

It depends, it depends, and it depends!

As for most questions in business analysis, there isn?t only one answer. Whose job is to create a class diagram depends on the purpose of the class diagram.

First of all, the question implies that there is only one class diagram for a given project: ?The Class Diagram?. For the most part, this is not the case. On some projects there may be a multitude of class diagrams while in others there may be none.

 167 views

18⟩ Explain What is the difference between a Primary and Secondary Actor in Use Case Modeling?

Use Case modeling is used to diagrammatically depict a system and those people or processes that interact with it. This system can be a business system (a process) or an application system (computer or web based). To understand the scope of the system under consideration a system boundary is used. Anything depicted within the system boundary is part of the system under consideration, while anything outside of it is not. Use cases are then used to define a group of user-system interactions that together deliver value to the user of the system. These users are called actors.

 175 views

20⟩ Explain What is Cost Benefit Analysis (CBA)?

Cost Benefit Analysis is a technique used to determine if the financial benefit s of a project outweigh the associated cost of undertaking the project in the first place. For a short term project where the benefit may be an immediate one-time cash windfall this may be as simple as subtracting the total of all the project cost from the total of all of the project benefits. If the total is positive, then the project may be worth completing.

 157 views