InfoSphere Warehousing and Cognos

1. InfoSphere Warehousing and Cognos Phil Downey Program Manager InfoSphere Warehouse August 15, 2008

2. Information On DemandUnlocking the Business Value of Information for Competitive Advantage Workforce Optimization Financial Risk Insight Dynamic Supply Chain Better Business Outcomes Multi-Channel Marketing Customer & Product Profitability Business Optimization Optimization Leverage information to better understand and optimize business performance Establish accurate, trusted information for a single version of the truth, managed over time Flexible Architecture for Leveraging Existing Investments An efficient and solid foundation for managing data and content over its lifecycle Automation

3. Cognos and InfoSphere PERFORMANCE MANAGEMENT • Goal – Performance Management with Information you can Trust • Fact – Performance Management is reliant on trusted information • Fact – Maximizing the value of your trusted information requires Performance Management Flexible Model Design Metrics Driven Data Quality Packaging Information Open Data Access 1. Information Integration for Cognos 8 BI 2. Data Quality for Performance Management Operational Data Store 4. 3. *5. Pre-Configured Off The Shelf Warehousing For Cognos 8 BI Real-time data for Operational Business Intelligence Master Data Management

4. 4 8 7 6 5 1 2 1 5 3 9 7 4 8 3 9 2 6 10 10 Analyze source systems for data structure, content, quality, and relationships Map sources to reference Industry Model and glossary Use Industry Models as basis to define logical data models for warehouse and marts Generate physical models and deploy to InfoSphere Warehouse Reports Define specifications for moving data from sources to warehouse and to marts Generate integration logic to move data into warehouse and into marts OLAP Use Industry Models as basis for defining reporting requirements Develop measure/dimension model and design reports Datamarts Trace lineage from report fields all the way to sources Provide end-to-end data governance Warehouse Data Integration Source Systems

5. IBM Has Invested To Meet These RequirementsOne Single Information Platform An Industry Unique Information Platform • Accelerates client value • Mitigates client risk • Modular, allowing asset re-use IBM Provides the Roadmap for Success!

6. Information Architecture: IBM Industry Data Models-based Solution IBM Banking Data Warehouse (BDW) Banking DataWarehouse Model Financial Services DataModel Business SolutionTemplates Business Applications Sources Enterprise Data Warehouse ROLAPRelational Analytical CRM Core Banking Summary Staging Area System of Record OLAP Profitability Front Office Trading Apps Risk & Compliance Analysis Data Marts Accounting A&L Classified Sources Feedback ExternalEngines Data Analysis & Reporting CIF InfoSphere Platform Data Mining Market Data Predictive Modeling IBM Banking Data Integration Models IBM Information Server (Metadata Server and FastTrack) OtherSources Mgt Reporting

7. InfoSphere WarehouseSupporting Advanced Analytics Portals & Web Apps Reporting Solutions MS Office / Share-point Universal Access MDX SQL/MDX Web Services Analytical Acceleration No Copy Analytics Advanced Design & Management Extreme Performance Workload Management Design Studio Text Analytics Advanced Capability Data Mining Embedded Data Movement Data Compression On-line Analytical Processing (OLAP) Data Retention Remote Data Access MPP Data Server C-Class D-Class E-Class Linux/ Windows AIX/SUN/HP Platform

8. Customer References Mercedes-AMG Turned risk control into a competitive advantage by delivering a truly global consolidated, accurate view of risk in a more timely manner Reliable information and rapid results assist the business in planning, decision-making, and strategy formation— giving Mercedes-AMG a genuine competitive advantage. Boosts bottom-line business performance with new visibility and control 19 of the top 20 consumer packaged goods companies 25 of the top 30 pharmaceutical firms All top 10 automakers 19 of the top 20 U.S. and European banks 325+ retail chains worldwide 1,500+ government and education organizations Harrah’s used Cognos business intelligence to improve its customer relationship management program, and add $50 million to its bottom line results Saved $5 million dollars and identified a new revenue stream estimated at $187 million through more accurate analysis and forecasting Improved supplier performance management through increased understanding of performance metrics and compliance with its army of suppliers

9. No Copy Analytics Bridging the Operational Insight Divide • The No Copy approach to delivering business analytics has many benefits • Enabling real-time Analytics • Increasing Flexibility • Reducing the Development and Management Effort • Flexibility to add and change Analytical Applications cost effectively • This Approach has had Outstanding Business Results • Improved Customer Service • Fraud Detection • Customer Churn Prediction • Event Based Decision Support • Overall Greater Return On Investment • and Lower Cost of Ownership !

10. InfoSphere WarehouseGrowing with your business Needs Enterprise Edition Unlimited Concurrent Users/ Unlimited Data Advanced Analytics Source Data Volume Base Edition Unlimited Concurrent Users/ Unlimited Data Intermediate Edition 50-100 Users Less 1 TB Source Data Starter Edition 20-50 Users Less 350 GB Source Data Developers License Concurrent Workload and Query Complexity

11. Shortening the Time to ValueLowering the cost of implementation and management InfoSphere Balanced Warehouse • The InfoSphere Balanced Warehouse is a pre-built, pre-packaged Warehouse Offering • Reduces Risk • Standard Pre-tested Configuration • Ongoing Supported Package • Predictable performance • Reduces your Time to Value • Create Table Ready • Faster to Deploy • Built for Performance • Easy to Integrate into any environment • Reduces Warehouse Cost of Ownership • Automated Management • Single Product Support • System Built for Performance • Configured for your Business Requirements • Can be ordered in a configuration to meet Business requirements • Modularly expandable • Available in different sizes The difference between receiving a ready to go system versus one that needs to be fully or partially built on arrival can be dramatic in terms of time to value and project risk. That is why the InfoSphere Balanced Warehouse offering is the best choice for your business.

12. InfoSphere Balanced WarehouseShortening the Time to Value E-Class: Enterprise Superior Performance Superior reliability & Availability Source Data Volume D-Class: Growth Solution Superior Price Performance Highly Scalable Highly Available (option) C-Class: Compact Solution High Performance Pervasive Solution Concurrent Workload and Query Complexity

13. Why Is InfoSphere Warehouse Ideal for your Reporting Environment ? Lowers the cost of Designing, Building and Delivering Analytical Applications • InfoSphere Warehouse No Copy Analytics • OLAP • Text Analytics • Data Mining • Easy to Design, Develop, Package and Deploy • Team driven Integrated Design, Development and Deployment capabilities • Integrated Data Movement and Transformation • Open to many application interfaces (Web services, .Net, J2EE etc..) • Self contained and built to perform and scale • Autonomic Management • Data Compression • Balanced Warehouse • Pre-test and Built scalable Platform (HW/SW) • Supports right-time analytics for delivering business information • Real-time Data integration • Extreme Workload Management

14. Alphablox Excel InfoSphere Cubing ServicesNo Copy Access to Data via OLAP and SQL Cognos 8.4/etc.. MDX MDX MDX Cubing Services SQL InfoSphere Warehouse

15. InfoSphere Text AnalyticsIncreasing the Insight into your Applications Information 3 Many Applications today capture vital Product, Customer, Contract Claims information in their applications but are unable to harness it to drive insight. InfoSphere Warehouse Text Analytics can make this happen enabling you to derive new attributes and Dimensionality from your information for further OLAP and Data Mining Analysis Benefits • Enables your Application to target specific information hidden within text • Provides you with a competitive edge by driving further business insight • Drives a greater ROI for your Application Business Value examples • Better Product categorization • Early warning on Customer attrition • Fraud Detection • Product Defect Analysis • Better customer profiling

16. InfoSphere Warehouse Data MiningUnlocking Associations and Behaviors trapped in your application InfoSphere Data Mining embed real time data mining into your warehouse, accessible from any application supporting SQL or ODBO. • Benefits • InfoSphere Warehouse can help you unlock information on customer and product associations and behaviors captured by your application • Business Value • Combined with Text Analytics it provides you with the power to build deep insight that could be critical to to your customers business • Examples • Market Basket Analysis • Customer Behavior • Click Stream Analysis • Disease and treatment analysis • Customer / Claim profiles

17. InfoSphere Design Studio and Admin ConsoleBuilding, Packaging and Supporting your Analytics solution A Complete End to End Solution For Warehouse Application Life Cycle Management

18. Embedded Warehouse Application DevelopmentEnhanced SQL Warehousing Tool (SQW) InfoSphere provides ELT Data Movement and Transformation capabilities based on the DB2 9.5 engine. Transformations and Data Movement jobs are developed in a fully integrated graphical interface within the InfoSphere Design studio. Benefits Easy to Use & Package • Graphically build complex transformations within DB2 • Advanced Workflow Control and Scheduling • Build your Warehouse Source to Target as one Application Integration • Automate Text Analytics & Data Mining workloads • Ability to Natively source data from Non DB2 RDBMS • Scale up and integrate with Information Server /DataStage Compliance • Ability to add version management • Job Monitoring

19. IBM Data Server: Powering InfoSphere WarehousePowering the Warehouse

20. The InfoSphere Balanced Warehouse™Real time, ready to go data warehousing solutions The IBM Balanced Warehouse is the completedata warehousing solution comprised of pre-tested, scalable and fully-integrated system components of InfoSphere Warehouse, Server and Storage. • IBM Balanced Warehouses include everything required to serve as a foundation for your business intelligence solutions. Some of the included highlights are: • Robust InfoSphere Warehouse software • The latest in IBM Server technology • High performance IBM storage • Comprehensive total solution support Balanced Warehouse

21. Business Requirements Warehouse Operations Business Futures Warehouse Function Warehouse Platform InfoSphere Balanced WarehouseA fast track to warehousing IBM modules Preconfigured, pretested allocation of software, storage and hardware to support a specified combination of function and scale Simple Flexible Optimized

22. InfoSphere Balanced WarehouseBetter than an appliance • Simplicity • Predefined configurations for reduced complexity • One number to contact for complete solution support Balanced Warehouse • Flexibility for growth • Add modules to address increasing demands • Multiple on-ramps for different needs • Reliable, nonproprietary hardware for reusability • Optimized performance • Preconfigured and certified for guaranteed performance • Based on best practices for reduced risk

23. InfoSphere Warehousing: the Platform For your Business • InfoSphere Warehousing provides a complete Package for addressing your Warehousing requirements • Whether you require and small reporting solution of a Enterprise Warehouse • Solutions that can growth with your business needs • InfoSphere Warehouse delivers outstanding Return on Investment • Fast Time to Value with the Balanced warehouse • Low Cost of Management • Ease of Deployment • InfoSphere Warehouse No Copy Analytics • Sophisticated Business Analytics • Speed of thought access to Information • Right-time Business Information