Analysis Services
With SQL Server 2005 Analysis Services moves into the realm of real- time analytics. From scalability enhancements to deep integration with Microsoft Office, SQL Server 2005 helps extend business intelligence to every level of your business.
Integration Services (SSIS)
SQL Server Integration Services (SSIS) is a next generation data integration platform that can integrate data from any source. SSIS provides a scalable and extensible platform that empowers development teams to build, manage, and deploy integration solutions to meet unique integration needs.
Data Mining
Microsoft SQL Server 2005 Analysis Services (SSAS) provides tools for data mining with which you can identify rules and patterns in your data, so that you can determine why things happen and predict what will happen in the future – giving you powerful insight that will help your company make better business decisions.
Reporting Services
SQL Server Reporting Services is a comprehensive, server-based reporting solution designed to help you author, manage, and deliver both paper-based and interactive Web-based reports.
Clustering Support
Analysis Services improves availability with support for failover clustering, enhanced multi-instance support, and support for backing up and restoring Analysis Services objects and data.
Key Performance Indicators
Key performance indicators (KPIs) provide businesses with the capability to define graphic, customizable business metrics to help generate and track key corporate benchmarks.
Scalability and Performance
Features such as parallel partition processing, creation of remote relational online analytical processing (ROLAP) or hybrid online analytical processing (HOLAP) partitions, distributed partitioned cubes, persisted calculations, and proactive caching greatly improve the scalability and performance of Analysis Services in SQL Server 2005.
Report Builder
Report Builder is a component of SQL Server 2005 Reporting Services that enables business users to create and deploy reports with a user-friendly enterprise data model.
Proactive Caching
Proactive Caching combines MOLAP class query performance with real-time data analysis and eliminates the need to maintain OLAP stores. The Proactive Cache transparently synchronizes and maintains an updated copy of the data organized specifically for high-speed querying and for isolating end-users from overloading the relational databases. The structure of the cache is automatically derived from the Universal Data Model (UDM) structure and can be finely tuned to balance performance with latency of data.
Integration with the Microsoft Office System
Tight integration of SQL Server 2005 with Excel 2007 and Office SharePoint Server 2007 delivers a simple way for information workers to accessing, analyze and collaborate on BI information directly within the tools that they use every day.