Data Warehousing

Enterprise-scale solutions

Rely on Microsoft SQL Server 2008 to scale demanding analytical applications with millions of records and thousands of users.

Realize the power of a scalable infrastructure

• Take advantage of the improved Aggregation Designer to optimize Online Analytical Processing (OLAP) performance and eliminate unnecessary aggregations with block computation
• Enable high-performance “what if” scenarios by using the new Multidimensional OLAP MOLAP enabled write-back capabilities
• Scale out Analysis Services by sharing one read-only Analysis Services database between several Analysis Services servers
• Add global scalability to your solutions and give all users access to localized analytical data in their native language with powerful translation capabilities and automatic currency conversions

Increase developer productivity

• Benefit from using a single tool in the form of Business Intelligence Development Studio throughout the entire development lifecycle
• Detect potential design issues as they arise with automatic notifications provided by best practice design alerts
• Accelerate and enhance the development process with intuitive cube, dimension, and attribute designers

Improve analytical performance

• Enable the combination of real-time updates with MOLAP class performance with Proactive Caching
• Take advantage of a highly compressed and optimized data cache that is maintained automatically as data in the underlying source databases changes
• Use Proactive Caching to provide superb query performance and isolate data source systems from the load of analytical queries

Take advantage of a scalable backup solution

• Optimize backup performance easily by taking advantage of a scalable backup solution that offers performance comparable to that of a file copy operation

Comprehensive analytics

Use the richness of a single Unified Dimensional Model (UDM) to accommodate multiple analytical needs from multidimensional analysis and reporting to predictive analysis, all in one solution.

Consolidate enterprise analysis data

• Use the Unified Dimensional Model to provide one consolidated business view for relational and multidimensional data that includes business entities, business logic, calculations, and metrics
• Facilitate business information modeling, and employ easy to use Business Intelligence wizards to effectively build in time and financial intelligence

Manage key metrics centrally

• Manage enterprise-wide key performance indicators (KPI’s) centrally by using the Analysis Services KPI Framework — a rich centralized repository for defining, storing, and managing KPIs
• Make centrally stored KPIs available to users through a variety of applications, including Microsoft Office PerformancePoint Server 2007, Microsoft Office Excel 2007, Microsoft Office SharePoint Server 2007, and SQL Server Reporting Services

Perform predictive analysis

• Offer advanced analytical capabilities that enable users to learn from large volumes of historic data, perform predictive analysis, and proactively identify patterns and business trends
• Extend the predictive analysis capabilities of SQL Server with enhanced data mining engine and improved algorithms, and strengthens the powerful data mining framework represented by the extensible .NET programming model and embeddable data mining viewers even further

Deliver intelligent insights

Enjoy the extensibility of an open, embeddable architecture and empower users through optimized interoperability in the 2007 Microsoft Office System, enabling the delivery of pervasive insight to everyone.

Improve interoperability with the Microsoft Office system

• Enable business users to access multidimensional data directly from within the familiar environment of Office Excel 2007; empowering them to effortless explore the data they need when they need it
• Enjoy the power of the predictive and sophisticated analytical capabilities of data mining directly from Office Excel 2007 by using the SQL Server Data Mining Add-Ins

Deliver pervasive business insight

• Use the tight integration of Analysis Services with Office PerformancePoint Server 2007 to help provide rich performance management capabilities that bring together monitoring, analysis, and planning
• Enable centralized access and collaboration to analytical data through deep integration with Office SharePoint Server 2007 or access data through the application of your choice; benefitting from more than100 partners building on top of Microsoft SQL Server Analysis Services

Extend analysis with Web Services

• Develop new applications that integrate analytical capabilities with operations in real time
• Expose your data using XML for Analysis (XML/A), which is the native, standards-based protocol for communicating with the Analysis Services server
• Using XML/A as the native protocol, you can Configure Analysis Services clients to have a zero footprint, and each server is automatically a Web service
• Support tools that work with Analysis Services 2000 on OLE DB for OLAP, ADOMD, and ADOMD.Net
• Light-footprint Win32 layer is available for backward compatibility with tools that work with Analysis Services 2000 on OLE DB for OLAP, ADOMD, and ADOMD.Net