An Experts View of the Top BI Tools

Report
RapidDecision
©
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,
MicroStrategy,
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,
MicroStrategy,
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
MicroStrategy
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 11g
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
+
X
++
+
Information Delivery
and Access
++
+
+
++
++
=
Excellent
+
= Good
–
= 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, PeopleSoft 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’
RapidDecision a Pre-Built Data
Warehouse
for E-Business, PeopleSoft,
and JD Edwards
Purchase
Customer
ItemOrder
E-Business
Order
GLWork
Transaction
Invoice
PeopleSoft
Sales
Receipt
Order
Voucher
JD Edwards
Shipment
Supplier
Other Data
Sources
RapidDecision©
» TRANSFORM » RENAME
» TRANSLATE » RENUMBER
» CUSTOMIZATION
Product Overview
RapidDecision
®
Pre-Built
Data Warehouse/
Data Marts
Product Overview
RapidDecision
®
200,000 plus Transformations
Product Overview
RapidDecision
®
Subject Areas
20 Supported
Product Overview
RapidDecision
®
Real Time
Continuous Updates
Product Overview
RapidDecision
®
Pre-Built Queries, Reports
and Analytics
Product Overview
RapidDecision
®
Consolidate Multiple Sources
and Archived Data
Product Overview
RapidDecision
®
ERP Upgrade Protection
Product Overview
RapidDecision
®
Metadata Layer Included
for the Leading BI
Applications
Product Overview
RapidDecision
®
FASTEST
Time to Value
Product Overview
RapidDecision
®
Knowledge Transfer &
Training
Product Overview
RapidDecision
®
MATURE Proven Solution
Product Overview
RapidDecision
®
Guaranteed Implementation
Success
Data Transformations
JDE Data
GBMCU
GBOBJ
GBSUB
GBFY
GBLT
GBAPYC
GBAN01
12345
1450
01
11
AA
12300000
5000000
Business Unit
12345
Object Subsidiary Description
1450
01
AR Sales
Fiscal Year Ledger Type
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
PeopleSoft 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
Account
02
INCMSTMT
2011
1004-1
123000.00
Period 01
Transformations
PeopleSoft
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
Expenses
Account Tree Node (1004067)
Hierarchy
G&A Expenses
Salaries & Benefits
DATA
SOURCES
BUSINESS INTELLIGENCE
TOOLS
RapidDecision
Reporting &
Publishing
Ad Hoc, Query,
and Analysis
Analytic
Applications
MS Office &
Outlook
Integration
RapidDecision
METADATA
®
DATA WAREHOUSE/ DATA MARTS
DATA EXTRACTION
PeopleSoft
Oracle
E-Business
JDE
World
One World
E1
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 RapidDecision
An innovative BI platform designed to be the foundation of your BI
solution
Question
s
and
Answers
To Learn More About
RapidDecision or to Arrange a Demo
Call:
800-775-4261 ext. 5812
Email:
[email protected]
Visit:
www.rapiddecision.net
Call to Action…
Invitation to free monthly webinar:
RapidDecision provides educational
webinars, scheduled monthly.
These webinars are designed to show you
how, as an Oracle e-Business, PeopleSoft
or JD Edwards customer, you can rapidly
implement a data warehouse.
RapidDecision attends all the major
Quest meetings, participating in the
elective sessions and Exhibitor
Showcases.
Take a Test Drive……
Schedule an Onsite Meeting with
RapidDecision
Joe Guerra
Renowned Expert in
Business Intelligence solutions
Innovator and architect
of RapidDecision
®
More than 24 years
experience
Frequent speaker and panelist
on Business Intelligence & Data
Warehousing
RapidDecision
©
An Expert’s View of the
Top BI Tools

similar documents