Rapid Decision An Experts View of the Top

Rapid. Decision © An Expert’s View of the Top BI Tools Presented by: Name goes here Title goes here

Which BI tool is right for you? Vendors : IBM Cognos, Micro. Strategy, Oracle OBIEE, SAP Business Objects

Which BI tool is right for you? All BI tools are NOT created equal

Which BI tool is right for you? About 80 -85% of the features and functions are similar

Which BI tool is right for you? It’s the 15 -20% that differentiate them

Which BI tool is right for you? Who decides which tool – IT or Business Users?

Which BI tool is right for you? Identify the key components that separate them

Which BI tool is right for you? Vendors : IBM Cognos, Micro. Strategy, Oracle OBIEE, SAP Business Objects

What do they have in Common? All the BI tools have a Metadata layer (business rules)

What do they have in Common? Production Reporting

What do they have in Common? Ad-hoc query tool

What do they have in Common? Web Interface

What do they have in Common? Dashboards and Analytics

What do they have in Common? All in the upper right hand corner of the Magic Quadrant (Gartner)

Disclaimer All of the following evaluations represent our opinion and in no way should be used alone in evaluating and purchasing a Business Intelligence tool. All of the tools are leaders in the market, and we recommend that prior to purchasing an Enterprise BI tool a thorough and in-depth analysis be conducted.

Latest release Cognos 10

The latest release Cognos 10 offers Unified BI Workspace called Business Insight

Better performance with shared caching and in-memory processing

Cognos 10 now offers access to personal data sources

Continue to expand its solution portfolio of packaged analytical applications

Cognos 10 delivers builtin collaboration and social networking to promote the exchange of information Integrates with Netezza

THE DIFFERENTIATORS: Metadata can access multiple data sources

THE DIFFERENTIATORS: Known for its ability to do OLAP analysis

THE DIFFERENTIATORS: All content is created with a single interface

THE DIFFERENTIATORS: Latest release has a visual discovery option, Insight

THE DIFFERENTIATORS: Collaboration capabilities allow users to interact on reports.

Only Independent BI Vendor – built from the ground up

One of the most integrated architectures of the BI tools

The latest version 9 is the biggest release in seven years

Offers a FREE Micro. Strategy reporting suite

Focus on pure BI

Tremendous user following – like a cult

THE DIFFERENTIATORS: Users can personalize dashboards/build hierarchies

THE DIFFERENTIATORS: Drillable reports are available on Smart Phones (Mobile BI)

THE DIFFERENTIATORS: Powerful Architecture and Administration tools for metadata

THE DIFFERENTIATORS: No ETL tool for Data Integration requirements

THE DIFFERENTIATORS: No Performance Management tools to track enterprise level data

Has dabbled with many BI tools for years

Acquired Siebel Analytics (now OBI) and Hyperion

Leader in “Business Analytics” defined by analyst firm IDC

Oracle Business Intelligence Enterprise Edition (OBIEE) – all web – zero footprint

Part of “Exa-Everything” BI is a small part of Oracle’s product line

THE DIFFERENTIATORS: Access to multiple data sources via a common metadata layer

THE DIFFERENTIATORS: Pervasive Analytic Applications

THE DIFFERENTIATORS: Robust Security Model

THE DIFFERENTIATORS: Addition of Scorecard and Strategy Management in 11 g

THE DIFFERENTIATORS: BI Publisher production reporting tool using Word and Adobe

New release version 4. 0

Information Design Tool is replacing the Universe Designer

Now supporting multiple data sources at the metadata layer

Xcelsius is renamed to Dashboards with a new cache service to improve performance

Integrated with HANA Enhanced graphing/charting capabilities

THE DIFFERENTIATORS: The leader in ease of use and flexibility

THE DIFFERENTIATORS: Only vendor with integrated ETL and BI metadata

THE DIFFERENTIATORS: Publishing (report bursting) works for both Crystal and Web Intelligence in latest release

THE DIFFERENTIATORS: Latest release allows users to interact with web documents while disconnected

THE DIFFERENTIATORS: Explorer tool provides “Google Like” search information

THE DIFFERENTIATORS: Latest release includes BI Widgets

Evaluation Architecture & Administration Office Integration Production Reporting Dashboards Ad- Hoc Query & Analysis = Excellent = Good = Needs Improvement

How do they compare? Evaluation Criteria Architecture & Administration + ++ – + Office Integration + + + – Production Reporting + + – ++ Dashboards + + + – Ad- Hoc Query & Analysis + ++ Performance Management ++ + ++ X ++ ++ Analytic Applications Information Delivery and Access ++ = Excellent + = Good – X + = Needs Improvement X = Not Available

How do you succeed with the BI tools? The BI tools in and of themselves will NOT guarantee success Ensure Executive Sponsorship

How do you succeed with the BI tools? The BI tools in and of themselves will NOT guarantee success Determine User Adoption Approach

How do you succeed with the BI tools? The BI tools in and of themselves will NOT guarantee success Establish a BI Center of Excellence

How do you succeed with the BI tools? The BI tools in and of themselves will NOT guarantee success Create a SOLID Data Foundation

How to Connect BI to you Data To Direct Connect or Not to Direct Connect That Is the Question!

Unlocking the Data ?

Oracle E-Business, People. Soft and JD Edwards Data: How to Handle the Complexity Company Name Business Unit Code Account Level of Detail Amount

It’s all about the ‘Left Side’

Rapid. Decision a Pre-Built Data Warehouse for E-Business, People. Soft, and JD Edwards Purchase Customer Item. Order E-Business Order GLWork Transaction Invoice People. Soft Sales Receipt Order Voucher JD Edwards Shipment Supplier Other Data Sources Rapid. Decision© » TRANSFORM » RENAME » TRANSLATE » RENUMBER » CUSTOMIZATION

Product Overview Rapid. Decision Pre-Built Data Warehouse/ Data Marts ®

Product Overview Rapid. Decision ® 200, 000 plus Transformations

Product Overview Rapid. Decision Subject Areas 20 Supported ®

Product Overview Rapid. Decision Real Time Continuous Updates ®

Product Overview Rapid. Decision ® Pre-Built Queries, Reports and Analytics

Product Overview Rapid. Decision ® Consolidate Multiple Sources and Archived Data

Product Overview Rapid. Decision ® ERP Upgrade Protection

Product Overview Rapid. Decision ® Metadata Layer Included for the Leading BI Applications

Product Overview Rapid. Decision FASTEST Time to Value ®

Product Overview Rapid. Decision ® Knowledge Transfer & Training

Product Overview Rapid. Decision ® MATURE Proven Solution

Product Overview Rapid. Decision ® Guaranteed Implementation Success

Data Transformations JDE Data GBMCU GBOBJ GBSUB GBFY GBLT GBAPYC GBAN 01 12345 1450 01 11 AA 12300000 5000000 Business Unit 12345 Object Subsidiary Description Fiscal Year Ledger Type 1450 01 AR Sales 2011 AA Ledger Type Description Balance 01 Actual Amount 173000. 00

Transformations JDE ERP Source Data Transforms Output 109365 Date 12/31/2009 12345 Lookup Parent Sold to Customer Ship to Customer Bill to Customer 12300000 Calculation 6950 Hierarchy 123000. 00 Expenses G&A Expenses Salaries & Benefits

Data Transformations People. Soft Data PLAN_TYPE 67 TREENAME TREENODE ACCOUNT 01 HIRE_DT CUSTOMER Prior Year Close Accounting Period 01 04 -JAN-2011 1004 103000. 00 20000. 00 Plan Type Desc Tree Level Account Fiscal Year Bill-To Customer Inception To Date Health Savings Account 02 INCMSTMT 2011 1004 -1 123000. 00 Period 01

Transformations People. Soft ERP Source Data Transforms Output 12/31/2009 Date rollups FY=2009 FQ=4 FM=12 Cust ID = 1004 Lookup Parent Sold to Customer Ship to Customer Bill to Customer Prior Year Close = 103000. 00 Acct Period 01 Bal = 20000. 00 Calculation Inception to Date = 123000. 00 Account Tree Node (1004067) Hierarchy Expenses G&A Expenses Salaries & Benefits

DATA SOURCES BUSINESS INTELLIGENCE TOOLS Rapid. Decision Reporting & Publishing Ad Hoc, Query, and Analysis Analytic Applications MS Office & Outlook Integration Rapid. Decision METADATA ® DATA WAREHOUSE/ DATA MARTS DATA EXTRACTION People. Soft Oracle E-Business JDE World One World E 1 Other Data Sources Planning & Budgeting

Supported Marts General Ledger Property Management MRP Job Cost Equipment Management HR Transportation Logistics Fixed Assets Accounts Payable Accounts Receivable Home Builders Sales Inventory Purchasing Work Order Service Billing Asset-Life Cycle Management Payroll Expense Management Other Modules Upon Request Warehouse Management

Discover Rapid. Decision An innovative BI platform designed to be the foundation of your BI solution Question s and Answers

To Learn More About Rapid. Decision or to Arrange a Demo Call: 800 -775 -4261 ext. 5812 Email: info@rapiddecision. net Visit: www. rapiddecision. net

Call to Action…

Invitation to free monthly webinar: Rapid. Decision provides educational webinars, scheduled monthly. These webinars are designed to show you how, as an Oracle e-Business, People. Soft or JD Edwards customer, you can rapidly implement a data warehouse. Rapid. Decision attends all the major Quest meetings, participating in the elective sessions and Exhibitor Showcases.

Take a Test Drive……

Schedule an Onsite Meeting with Rapid. Decision Joe Guerra Renowned Expert in Business Intelligence solutions Innovator and architect of Rapid. Decision ® More than 24 years experience Frequent speaker and panelist on Business Intelligence & Data Warehousing

Rapid. Decision © An Expert’s View of the Top BI Tools