|
Explain the SQL Server 2005 Business Intelligence components.SQL Server 2005 is a complete platform that enables BI features, tools for analytical applications. It has tools for building analytical applications and its functionality made the easier way of building and managing complex BI systems.
The components are
- Integration Services : extracts, transforms and loads
- Relational Database: Deals with relational warehousing
- SQL Server: Multidimensional database
- Reporting Service: For generating managed and ad hoc reports
- Office Products: For Ad Hoc query and analysis
- BI development studio: Database development tools
- Management Sudio: Database management
|
