Explain the SQL Server 2005 Business Intelligence components

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
Explain the concepts and capabilities of Business Object - Data warehousing
A business object can be used to represent entities of the business that are supported in the design. A business object .....
What is broad cast agent? - Data warehousing
A broadcast agent allows automation of emails to be distributed. It allows reports to be sent to different business objects.....
Functional differences between BO and COGNOs - Data warehousing
COGNOS is software that makes business intelligence and plans the performance......
Post your comment