|
Q1: Feature #1 of 10 of SQL Server 2005 for Business Intelligence?
1) 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 will help extend business intelligence to every level of your business.
Q2: Feature #2 of 10 of SQL Server 2005 for Business Intelligence?
2) Data Transformation Services (DTS) DTS is a set of graphical tools and programmable objects that you can use to extract, transform, and load (ETL) data from disparate sources and move it to a single or multiple destinations. SQL Server 2005 will introduce a complete redesign of DTS that provides a comprehensive ETL platform.
Q3: Feature #3 of 10 of SQL Server 2005 for Business Intelligence?
3) Data Mining
Four new data mining algorithms will be introduced, as well as improved tools and wizards that will make data mining easier for businesses of any size.
Q4: Feature #4 of 10 of SQL Server 2005 for Business Intelligence?
4) Reporting Services
With SQL Server 2005, Reporting Services will provide self service, end-user ad hoc report creation, enhanced query development for online analytical processing (OLAP) environments and enhancements in scale allowing for rich and easy-to-maintain enterprise reporting environments.
Q5: Feature #5 of 10 of SQL Server 2005 for Business Intelligence?
5) 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.
Q6: Feature #6 of 10 of SQL Server 2005 for Business Intelligence?
6) 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.
Q7: Feature #7 of 10 of SQL Server 2005 for Business Intelligence?
7) 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 will greatly improve the scalability and performance of Analysis Services in SQL Server 2005.
Q8: Feature #8 of 10 of SQL Server 2005 for Business Intelligence?
8) One-Click Cube
When creating a cube in a data warehouse project, the Cube Wizard will include an option to enable one-click-cube detection and suggestions. This option will examine the relationships in a data source view and make suggestions for fact tables, dimension tables, and measures.
Q9: Feature #9 of 10 of SQL Server 2005 for Business Intelligence?
9) 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.
Q10: Feature #10 of 10 of SQL Server 2005 for Business Intelligence?
10) Integration with the Microsoft Office System
Reports that are served up by the Report Server in Reporting Services can run in the context of Microsoft SharePoint Portal Server and Microsoft Office System applications such as Microsoft Word and Microsoft Excel. You can use SharePoint features to subscribe to reports, create new versions of reports, and distribute reports. You can also open reports in Word or Excel to view HTML versions of the reports.
|