Data Warehouse BI Question:
Explain the SQL Server 2005 Business Intelligence components?
Answer:
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.
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.
| Previous Question | Next Question |
| Explain SAS Business Intelligence? | Do you know the concepts and capabilities of Business Intelligence? |