Business Intelligence Interview Questions and Answers

Business Intelligence Interview Questions and Answers,Business Intelligence Professionals Business Intelligence Interview

Explain the concepts and capabilities of Business Intelligence.

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.

Name some of the standard Business Intelligence tools in the market.

Business intelligence tools are to report, analyze and present data. Few of the tools available in the market are:

Eclipse BIRT Project:- Based on eclipse. Mainly used for web applications and it is open source.
Freereporting.com:- It is a free web based reporting tool.
JasperSoft:- BI tool used for reporting, ETL etc.
Pentaho:- Has data mining, dashboard and workflow capabilities.
Openl:- A web application used for OLAP reporting.

Explain the Dashboard in the business intelligence.

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.

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.

Explain the SQL Server 2005 Business Intelligence components.

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.