Commercial vs Open Source BI Tools

1. Asun – Arman – Rama – Rizal – Roji - Yasin Commercial vs Open SourceBI Tools

2. Commercial BI Tools

3. Oracle BI

4. 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 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

5. SAS 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.

6. SAS 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.

7. SAP BI • Advanced analytics • Dashboards and visualization • Information infrastructure • Query, reporting, and analysis • Search and exploration

8. Advanced 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.

9. Dashboards 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.

10. Query, 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

11. Search and exploration • Simplicity of exploration and speed of search define these user-friendly search and navigation tools.

12. Comparison between Commercial BI Tool

13. Comparison between Commercial BI Tool cont.

14. Comparison between Commercial BI Tool cont.

15. Open Source BI Tools

16. Jaspersoft • 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

17. Jaspersoft (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

18. SpagoBI SpagoBIhas 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

19. Pentaho • 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.

20. Pentaho (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.

21. Comparison between Open Source BI

22. Comparison between Open Source BI cont.

23. Comparison between Open Source BI cont.

24. Comparison of BI Tools

25. Comparison 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.

26. References • 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)