SAS Enterprise Business Intelligence CMS SAS Day October

Discussion Topics § SAS Definition of Business Intelligence / Business Analytics § Market Validation / Analysts Rankings § SAS Enterprise Business Intelligence Components § SAS Enterprise Business Intelligence Architecture § Demonstration § Questions & Answers Copyright © 2006, SAS Institute Inc. All rights reserved.

Two Definitions Of BI in the Market 1. Definition One (lets call this Traditional

Approaches to traditional BI Centralized Reporting Function IT or specialized group building reports on demand Copyright © 2006, SAS Institute Inc. All rights reserved. Self Service Reporting Capability End users empowered to create their own reports

Two Definitions Of BI in the Market 1. Definition One (lets call this Traditional BI) • BI is seen just as Query and Reporting 2. Definition Two (lets call this Modern BI, or Business Analytics) • BI is seen to include a wide range of technologies such as Data Integration, Storage, Analytics and Query and Reporting (traditional BI) Copyright © 2006, SAS Institute Inc. All rights reserved.

SAS’ “Modern BI” Offering – (Business Analytics) Data Acquisition, Integration & Quality + Advanced Analytics + Intelligent Storage Copyright © 2006, SAS Institute Inc. All rights reserved. Informatio n Delivery (BI)

SAS Enterprise Intelligence Platform Copyright © 2006, SAS Institute Inc. All rights reserved.

Copyright © 2006, SAS Institute Inc. All rights reserved.

The Power to Know® SAS Enterprise Intelligence Value Copyright © 2006, SAS Institute Inc.

Datamonitor BI Decision Matrix: “SAS is the clear market leader” Source: Datamonitor, “Decision Matrix: Selecting a Business Intelligence Vendor (Competitor Focus)” by Vuk Trifkovic and Tim Gower, April 2007, Reference Code: DMTC 2105 Copyright © 2006, SAS Institute Inc. All rights reserved.

Magic Quadrant for Business Intelligence Platforms, 1 Q 07 Source: Magic Quadrant for Business Intelligence Platforms, 1 Q 07, January 2007, Kurt Schlegel, Bill Hostmann, Andreas Bitterer The Magic Quadrant is copyrighted January 2007 by Gartner, Inc. and is reused with permission. The Magic Quadrant is a graphical representation of a marketplace at and for a specific time period. It depicts Gartner's analysis of how certain vendors measure against criteria for that marketplace, as defined by Gartner does not endorse any vendor, product or service depicted in the Magic Quadrant, and does not advise technology users to select only those vendors placed in the "Leaders" quadrant. The Magic Quadrant is intended solely as a research tool, and is not meant to be a specific guide to action. Gartner disclaims all warranties, express or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose. The Magic Quadrant graphic was published by Gartner, Inc. , as part of a larger research note and should be evaluated in the context of the entire report. The Gartner report is available at http: //www. sas. com/news/analysts/by_firm_gartner. html Copyright © 2006, SAS Institute Inc. All rights reserved.

Headlines: BI Market Consolidation & Uncertainty Business Objects to buy Crystal Marketwatch, 7/18/2003 Hyperion to Buy Brio for $142 Million as Sector Heats Up SEC Info, 8/19/03 Copyright © 2006, SAS Institute Inc. All rights reserved.

Headlines: BI Market Consolidation & Uncertainty Business Objects to buy Crystal Marketwatch, 7/18/2003 Hyperion to Buy Brio for $142 Million as Sector Heats Up SEC Info, 8/19/03 IBM Strengthens Data-Integration Stance With Ascential Buy Information. Week, March 14, 2005 Microsoft Buys Pro. Clarity to Bolster BI Strategy CIO. com, April 3, 2006 Copyright © 2006, SAS Institute Inc. All rights reserved.

Headlines: BI Market Consolidation & Uncertainty Business Objects to buy Crystal Marketwatch, 7/18/2003 Hyperion to Buy Brio for $142 Million as Sector Heats Up SEC Info, 8/19/03 IBM Strengthens Data-Integration Stance With Ascential Buy Information. Week, March 14, 2005 Microsoft Buys Pro. Clarity to Bolster BI Strategy CIO. com, April 3, 2006 Oracle buys Hyperion for $3. 3 billion CNET News. com, February 28 2007 SAP takes on BI with Business Objects purchase IT Week, October 9, 2007 Copyright © 2006, SAS Institute Inc. All rights reserved.

Headlines: What about SAS ? “SAS plans to expand, add workers as rivals merge”

SAS Enterprise BI Server: Components End User Tools • Information Delivery Portal • Dashboards • Web Report Viewer • Web Report Studio • OLAP Viewer • Analytical Stored Process • Microsoft Office Add-In • Enterprise Guide Administrative Tools • Management Console • Metadata Server • Information Map Studio • OLAP Cube Studio Copyright © 2006, SAS Institute Inc. All rights reserved.

SAS Enterprise Intelligence Architecture Source Data Integration Data Storage Analytical Engine Application Server SAS Applications SAS OLAP Server n Stored Process Server BI User Interfaces & Portal Web Query & Reporting n RDBMS Legacy Data Marts SQL Corporate DW PC Files RDBMS S A C C E S S M O D U L E S n Scorecard / Dashboard MS Office Clients OLAP • IBM’s Web. Sphere • BEA’s Web. Logic • Apache Tomcat • JBoss ( SAS V 9. 2) Analytical Store (SAS SPDS) SAS BI Server SAS® DI Studio df. Power Studio (Data Quality) External Data Copyright © 2006, SAS Institute Inc. All rights reserved. Web Server Application Management (Data Integration) SAS Metadata Server SAS Management Console PDA & Remote Users • Server Manager • User Manager • Metadata Manager • Stored Process • Data Library • Security Application Developer SAS App. Dev Studio

SAS Enterprise Business Intelligence… Source Data Integration Data Storage Analytical Engine Application Server SAS Applications SAS OLAP Server n Stored Process Server BI User Interfaces & Portal Web Query & Reporting n RDBMS Legacy Data Marts SQL Corporate DW PC Files RDBMS S A C C E S S M O D U L E S n Scorecard / Dashboard MS Office Clients OLAP • IBM’s Web. Sphere • BEA’s Web. Logic • Apache Tomcat • JBoss ( SAS V 9. 2) Analytical Store (SAS SPDS) SAS BI Server SAS® DI Studio df. Power Studio (Data Quality) External Data Copyright © 2006, SAS Institute Inc. All rights reserved. Web Server Application Management (Data Integration) SAS Metadata Server SAS Management Console PDA & Remote Users • Server Manager • User Manager • Metadata Manager • Stored Process • Data Library • Security Application Developer SAS App. Dev Studio