BI Tools Asun Arman Rama Rizal Roji Yasin Commercial BI Tools Oracle BI Oracle BI 2 Information delivery enhancements new features and capabilities within Interactive Dashboards Answers Reporting and Publishing Delivers and Disconnected as well as enhanced support ID: 803787
Download The PPT/PDF document "Commercial vs Open Source" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Commercial vs Open SourceBI Tools
Asun – Arman – Rama – Rizal – Roji - Yasin
Slide2Commercial BI Tools
Slide3Oracle BI
Slide4Oracle BI (2)
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
Slide5SAS BI
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-to-use, 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.
Slide6SAS BI (2)
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.
Slide7SAP BI
Advanced analytics
Dashboards and visualization
Information infrastructure
Query, reporting, and analysis
Search and exploration
Slide8Advanced analytics
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.
Slide9Dashboards and visualization
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.
Slide10Query, reporting, and analysis
Let end users interact with business information and answer ad hoc questions themselves – without having to understand complex database languages and underlying structures
Slide11Search and exploration
Simplicity of exploration and speed of search define these user-friendly search and navigation tools.
Slide12Comparison between Commercial BI Tool
Oracle
SAS BI
SAP BI
Report
Tighter integration with Fusion Middleware Platform, Simplify administration and management, Address top supportability areas with architectural changes
A wide variety of targeted, fit-to-task 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
Slide13Comparison between Commercial BI Tool cont.
Oracle
SAS BI
SAP BI
D
ashboard
Good security with User Proxy Authentication
Portal and Customisable
interactive analytics and dashboards with secure
Slide14Comparison between Commercial BI Tool cont.
Oracle
SAS BI
SAP BI
Query and analysis
Also service ad hoc queries
easily access and query data on their own without having to learn new skills
interact with business information and answer ad hoc questions
Slide15Open Source BI Tools
Slide16Jaspersoft
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 on-demand use—fully
SaaS
enabled including built-in multi-tenancy
Slide17Jaspersoft (2)
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
Slide18SpagoBI
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
Slide19Pentaho
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.
Slide20Pentaho (2)
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
.
Slide21Comparison between Open Source BI
Factors
Jaspersoft
SpagoBI
Pentaho
Platform
Web-based, thin-client, end-user interfaces that leverage modern interactive Web 2.0 technology such as Ajax and DHTML
Web based
Web based
Slide22Comparison between Open Source BI cont.
Factors
Jaspersoft
SpagoBI
Pentaho
Edition
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.
Slide23Comparison between Open Source BI cont.
Factors
Jaspersoft
SpagoBI
Pentaho
Open source
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.
Slide24Comparison of BI Tools
Slide25Comparison of BI Tools
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.
Slide26References
http:// www.oracle.com/Fappserver/Fbusiness-intelligence/docs/oracle-bi-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)