Transcript Asun – Arman – Rama – Rizal – Roji -Yasin

Asun – Arman – Rama – Rizal – Roji -Yasin





Information delivery enhancements – new features and
capabilities within Interactive Dashboards, Answers, Reporting
and Publishing, Delivers, and Disconnected, as well as enhanced
support for alternative channels suh as enterprise portals
BI Server enhancements – improved new features to lower cost
of ownership and improve the simplicity of administration
Oracle Fusion Middleware and Database integration –
integration with key Oracle infrastructure products to lower cost
and complexity while extending BI capabilities
New data source integration – integration with and optimization
for new data sources, enabling even greater business insight from
virtually any enterprise data source
Security enhancements – enhancements for security, identity
managements, and audit
Web and desktop reporting
A wide variety of targeted, fit-to-task interfaces for report
building, viewing and distribution open the world of SAS
intelligence to all types of users with varying needs and skills,
speeding better decision making while relieving the burden on IT.
 Portal and customizable dashboards
Business users can access aggregated information via an easy-touse, role-based Web portal. It includes point-and-click dashboard
development, enabling users to create and customize their own
dashboards in just minutes from virtually any data source.
 Microsoft Office integration
Business users have seamless access to SAS business intelligence
and analytics from within their Microsoft Office applications,
making it simple for them to access data, perform queries and
analysis, and create reports. They can use familiar Microsoft Office
functionality to distribute results to decision makers.




Query and analysis
Information producers can easily access and query data on their own
without having to learn new skills or make constant demands on IT for
data and reports.
Interactive business visualization
Interactive visualization capabilities enable information producers to
dynamically explore data, investigate patterns and uncover hidden facts.
An extensive suite of customizable graphic presentation options present
information and insights to information consumers that are not easily
detected in tabular formats.
OLAP storage and OLAP data exploration interface
A powerful, multidimensional database is designed to handle large
volumes of business intelligence data, and a specialized interface makes
it easy to build and maintain OLAP data storage cubes. Business users
can use their Web browsers to quickly and interactively look at
summaries of large volumes of data from multiple angles.





Advanced analytics
Dashboards and visualization
Information infrastructure
Query, reporting, and analysis
Search and exploration

Relying on sophisticated analytic engines
that can access both numeric and text data,
these tools interrogate complex historical
data to look for trends, outliers, and patterns
through a visual interface.

Transform how you view your business by
interacting with sophisticated visual
representations of processes and
performance. Perform what-if analysis with
your dashboards to gain new insights – and
make informed decisions.

Let end users interact with business
information and answer ad hoc questions
themselves – without having to understand
complex database languages and underlying
structures

Simplicity of exploration and speed of search
define these user-friendly search and
navigation tools.
Report
Oracle
SAS BI
SAP BI
Tighter
integration with
Fusion
Middleware
Platform, Simplify
administration
and management,
Address top
supportability
areas with
architectural
changes
A wide variety of
targeted, fit-totask interfaces for
report building,
viewing and
distribution open
the world
design and format
interactive
reports, and share
them internally
and externally.
Securely deliver
and explore your
reports via
Ms.Office
Oracle
Dashboard
SAS BI
Good security Portal and
with User
Customisable
Proxy
Authentication
SAP BI
interactive
analytics and
dashboards
with secure
Query and
analysis
Oracle
Also service
ad hoc
queries
SAS BI
easily access
and query
data on their
own without
having to
learn new
skills
SAP BI
interact with
business
information
and answer
ad hoc
questions
A single, modular product architecture that
supports shared services, plug-ins, and add-ons
 Web-based, thin-client, end-user interfaces that
leverage modern interactive Web 2.0 technology
such as Ajax and DHTML
 Full access to modifiable source code and
customizable UIs
 A common platform for on-premise and ondemand use—fully SaaS enabled including builtin multi-tenancy

Open web standards such as J2EE, open XML
object definitions, HTTP, JSP, SOA web services,
and CSS integration
 Unicode and multilingual support with full
internationalization of the product functionality
 Small foot-print and 100% pure Java
architecture
 Powerful security including single sign-on, row
and column level data security, and user/role
repository access security






SpagoBI has got the following main modules:
SpagoBI Server, the BI platform which includes all the
analytical tools, the management of security and
visibility rules, the administration tools
SpagoBI Studio, the new integrated development
environment
SpagoBI Meta, the new environment focused on
metadata
SpagoBI SDK, the new integration layer to use
SpagoBI from external tools
SpagoBI Applications, to collect the vertical analytical
models built using SpagoBI
The Pentaho Open BI Suite consists of a BI
platform, end-user BI capabilities, and the
Pentaho Design Studio :
 The BI platform provides an execution
framework and services that include logging,
auditing, security, scheduling, ETL, web services,
attribute repository and rules engines.
 The end-user BI capabilities include reporting,
analysis, workflow, dashboards, and data
mining.

The Pentaho Design Studio is a set of design and
administration tools that are integrated into the
popular Eclipse environment. These tools allow
business analysts or developers to create reports,
dashboards, analysis models, business rules, and BI
processes.
 The BI platform and end-user BI capabilities form the
Pentaho Server. BI solutions are as designed using the
Pentaho Design Studio and deployed to the Pentaho
Server. The Pentaho Server is the runtime engine,
driven by the workflow engine, which coordinates the
execution and communication between all the BI
Components.

Factors
Platform
Jaspersoft
SpagoBI
Web-based, thin- Web based
client, end-user
interfaces that
leverage modern
interactive Web
2.0 technology
such as Ajax and
DHTML
Pentaho
Web based
Factors
Edition
Jaspersoft
SpagoBI
Pentaho
Have paid one, integrated
with jasper database server.
Another one is Jaspersoft
Community Projects,
Jaspersoft Community
Projects provide basic
business intelligence
functionality for open source
developers who want to add
standalone or integrated BI
capabilities to their
applications and operational
processes.
It's a free open source
project: no enterprise
or professional
edition!
It’s a POSS project
that try to bridge
between pure open
source and proprietary
BI tools.
Factors
Open source
Jaspersoft
SpagoBI
Pentaho
Full access to
modifiable source
code and
customizable UIs
SpagoBI goes
further than other
open source
projects, because
it provides a
unified view or, in
other words, a
higher level of
abstraction, both
for data access
and for user
interaction
A process-centric,
solution-oriented
platform with BI
components that
enable companies
to develop
complete
solutions to BI
problems.


Overall, the commercial BI tools have better
security, and more interactive dashboard and
reporting, faster search and exploration
features. They can synchronise to Microsoft
Office applications.
Actually, the open source BI tools have complete
features too as the commercial ones, but the
less flexible, because they will have difficult
synchronisation with Microsoft Office
applications. They have less security too.




http:// www.oracle.com/Fappserver/Fbusiness-intelligence/docs/oraclebi-ee-new-features-10gr3.
http://www.sas.com/technologies/bi/entbiserver/index.html#section=3
www.jaspersoft.com
Pentaho Open Source Business Intelligence Platform Technical White
Paper (2006)