Data Warehouse BI Interview Preparation Guide

A business object can be used to represent entities of the business that are supported in the design. A business object can accommodate data and the behavior of the business associated with the entity. A business object can be any entity of the development environment or a real person, place or process. Business objects are most commonly used and can be used in businesses with volatile needs.

A dashboard in business intellgence allows huge data and reports to be read in a single graphical interface. They help in making faster decisions by replying on measurable data seen at a glance. They can also be used to get into details of this data to analyze the root cause of any business performance. It represents the business data and business state at a high level. Dashboards can also be used for cost control. Example of need of a dashboard: Banks run thousands of ATM’s. They need to know how much cash is deposited, how much is left etc.

SAS business intelligence has analytical capabilities like statistics, reporting, data mining, predictions, forecasting and optimization. They help in getting data in the format desired. It helps in improving quality of data.

SQL Server Integration Services:- Used for data transformation and creation. Used in data acquisition form a source system.
SQL Server Analysis Services: Allows data discovery using data mining. Using business logic it supports data enhancement.
SQL Server Reporting Services:- Used for Data presentation and distribution access.

Business Intelligence helps to manage data by applying different skills, technologies, security and quality risks. This also helps in achieving a better understanding of data. Business intelligence can be considered as the collective information. It helps in making predictions of business operations using gathered data in a warehouse. Business intelligence application helps to tackle sales, financial, production etc business data. It helps in a better decision making and can be also considered as a decision support system.

Data warehouse
Data mart
OLAP TOOLS
All of the above

a Semi-structured
b unstructured data
Both a and b
Semi data.

A broadcast agent allows automation of emails to be distributed. It allows reports to be sent to different business objects. It also users to choose the report format and send via SMS, fax, pagers etc. broadcast agents allows the flexibility to the users to receive reports periodically or not. They help to manage and schedule the documents.

Slicing - The cube is sliced based on its dimension
Dicing – The cube is rotated without the need of the dimension (independent of dimension.

Slicing and Dicing are used for analyzing data in different views and perspectives.

BO security levels are provided at row and column levels. These security levels are handled by the administrator in either supervisor tool or designer tool. These security levels are to restrict the user or user group at row level or at column level.