BUSINESS INTELLIGENCE Questions and Answers

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.