Data Warehouse BI Interview Question:

Explain the SQL Server 2005 Business Intelligence components?

Submitted by: Administrator

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.
Submitted by: Administrator