Tom Casey General Manager Microsoft SQL Server tomcas@microsoft

1. Tom Casey General Manager Microsoft SQL Server tomcas@microsoft.com

2. Microsoft Business Intelligence Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions • Complete and integrated BI and Performance Management offering • Widespread delivery of business intelligence through Microsoft Office • Enterprise grade and affordable

3. People Ready Insights End User IT Professional Developer Real-time insight Familiar tools Decisions at all levels Secure Reliable Manageable Embedded BI Common Tools Consistent practices Pervasive Insight

4. Integrated and Agile BI Offering DELIVERY COLLABORATION CONTENTMANAGEMENT SharePoint Server SEARCH Reports Dashboards Excel Workbooks Analytic Views Scorecards Plans END USER TOOLS & PERFORMANCE MANAGEMENT APPS Excel PerformancePoint Server BI PLATFORM SQL Server Reporting Services SQL Server Analysis Services SQL Server DBMS SQL Server Integration Services

5. Integrated and Agile BI Offering DELIVERY COLLABORATION CONTENTMANAGEMENT SharePoint Server SEARCH Reports Dashboards Excel Workbooks Analytic Views Scorecards Plans END USER TOOLS & PERFORMANCE MANAGEMENT APPS Excel PerformancePoint Server BI PLATFORM SQL Server Reporting Services SQL Server Analysis Services SQL Server DBMS SQL Server Integration Services

6. Microsoft SQL Server 2005 Solution Architecture : Using Analysis Services with Teradata CLIENT • Extend the reach of Teradata solutions to more users through collaboration on optimized SQL Server Analysis Services adapter and cartridge for Teradata. Reports Dashboards Excel Workbooks Analytic Views Scorecards Plans PERFORMANCE MANAGEMENT & COLLABORATION SharePointServer • ADO.NET or OLE-DB Provider for Teradata • SQL Server Analysis Services cartridge for Teradata helps translate MDX expressions • for MOLAP and ROLAP access to Teradata • SQL Server Analysis Services enables direct and seamless integration for content delivery and navigation using familiar tools • Make use of Reporting Services and Excel via Analysis Services integration BI PLATFORM PerformancePointServer .NET Data Provider SQL Server Analysis Services SQL Server Reporting Services SQL Server DBMS SQL Server Integration Services

7. Analysis and ReportingBroad reach tools for insight Analyze information with powerful and familiar tools • New Office Excel Pivot Tables for analyzing information using business terms • Tight integration between Office Excel and Microsoft SQL Server Analysis Services • Data Mining add-ins for advanced analysis and new visualization capabilities Enabling end-users with ad hoc reporting capabilities • Report Builder for ad hoc reporting of relational or OLAP data • Microsoft SQL Server Reporting Services for personalized views of management data Share reports and analysis over the web • Excel Services for web based viewing of analysis • Scorecards and dashboards for quickly disseminating information • Report Center in SharePoint for centralized report management 7

8. Office Excel 2007New powerful analysis tools for your data Conditional Formatting Spot trends and exceptions in your data to better inform your decisions Data Connection Library Quickly access the most common data sources in your enterprise for data analysis Rich Interactivity Analyze data with new PivotTable tools and enhanced support for SQL Server Analysis Services Excel Services Enhanced Sorting and Filtering Sort by cell color or filter data by quarter to work with only the data you need

9. SQL Server 2005 Reporting ServicesPresentation Quality Enterprise Reporting Report Authoring Visually design reports & layout via the Report Designer Report Management Manage report categorization, data sources, security, subscriptions via the Report Manager Model design Design semantic models that map to real business entities via the Model Designer End user report creation Enable end users to create their own Ad-hoc reports via the Report Builder

10. SQL Sever 2005 Analysis Services Architecture Overview Microsoft SQL Server SQL Server 2005 Analysis Services Developer & Admin Tools Visual Studio 2005 Analysis Services Management Objects XML for Analysis (XML/A) KPI Engine Driver XML/A || ODBO Client applications Data Mining (DMX) Engine DDL Multi-dimensional (MDX) Engine XML/A (MDX) UNIFIED DIMENSIONAL MODEL SQL Server 2005 Management Studio MOLAP ROLAP HOLAP Storage Engine Local cube Cartridge Cartridge Cartridge Cartridge Teradata .NET Provider

11. Performance ManagementIntegrated solution to align and measure the business Improve corporate performance • Scorecards to orient measurement to corporate goals • Single model to align planning and analysis to the business process • Span the organization with planning and measurement capabilities Accelerate management decision making • Office Performance Point Server to integrate scorecarding, analysis and planning • Integrated workflow for simpler consolidation and reporting • Common model for planning used in analysis Enable collaborative analysis • Integration with Office Excel for broad deployment of analysis capabilities • Personalized scorecards and KPIs for individual views • Collaborative environment with context for analysis 11

12. Office PerformancePoint Server 2007An Integrated Performance Management Solution Scorecards Cascading scorecards with interactive charts and data from multiple sources • Analytics • Multi-dimensional slice and dice for advanced analytics including decomposition tree, performance map, and perspective view Planning & Budgeting Plan, budget, forecast at corporate, divisional, and operational levels with visual modeling, • Consolidation & Reporting • Multiple GL data integration including pre-built integration with Dynamics AX, intercompany eliminations , reconciliations, multiple currency translations, and report wizards.

13. Futures: Improved Data Integration Solution Architecture : Integration Services for Teradata CLIENT • Cost effective and efficient integration for TERADATA via high performance load/unload through collaboration on optimized SQL Server Integration Services Adapter for Teradata Reports Dashboards Excel Workbooks Analytic Views Scorecards Plans PERFORMANCE MANAGEMENT & COLLABORATION SharePointServer • Availability & release vehicle TBD • New provider using Teradata’s high performance interfaces for use with SQL Server Integration Services and Teradata • Support for Load and Unload using TPT • SSIS (ETL) tools integration to make connectivity easier, lower cost of integration BI PLATFORM PerformancePointServer SQL Server Analysis Services SQL Server Reporting Services SQL Server DBMS SQL Server Integration Services New SSIS Adapter

14. Futures: Improved Reporting Solution Architecture : Using Reporting Services with Teradata CLIENT • Extend the reach of Teradata solutions to more users through collaboration on optimized SQL Server Reporting Services provider for Teradata. Reports Dashboards Excel Workbooks Analytic Views Scorecards Plans PERFORMANCE MANAGEMENT & COLLABORATION SharePointServer • Availability & release vehicle TBD • SQL Server Reporting Services options to connect to and translate semantics for query access to Teradata • SQL Server Reporting Services enables direct and seamless integration for content delivery and collaboration using familiar tools BI PLATFORM PerformancePointServer .NET Provider for Teradata SQL Server Analysis Services SQL Server Reporting Services SQL Server DBMS SQL Server Integration Services

15. People Ready Partnership • History of innovation & partnership • Shared goals to bring insights to all employees • Take advantage of better integration today! End User IT Professional Developer Real-time insight Familiar tools Decisions at all levels Secure Available Manageable Embedded BI Common Tools Consistent practices

16. © 2007 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.