Pentaho Open Source BI

1
Pentaho Open Source BI

• Goldwin

2
Pentaho Overview

• Pentaho is the commercial open source software
  for Business
• Intelligence (BI)
• Pentaho been developed since 2004.
• Pentaho provides comprehensive reporting, OLAP
  analysis, dashboards, data integration, data
  mining and a BI platform.

3
Pentahos Benefit

• Open Source
• Have community that support the users
• Running well under multi platform (Windows,
  Linux, Macintosh,
• Solaris, Unix, etc)
• Have complete package from reporting, ETL for
  warehousing data
• management, OLAP server data mining also
  dashboard.

4
Pentahos Applications

• Suite Pentaho
• - BI Platform (JBoss Portal)
• - Pentaho Dashboard
• - JFreeReport
• - Mondrian
• - Kettle
• - Weka
• All build under Java platform

5
Pentaho BI Platform

• Pentaho BI Platform supports Pentaho end to end
  business intelligence capabilities and provide
  central access to your business information, with
  back end security, integration, scheduling,
  auditing and more.
• Pentaho BI Platform was designed as a unfilled
  platform that can scale to meet the needs of any
  size organization.

6
Pentaho BI Platform (2)
7
Pentaho Dashboard

• Pentaho Dashboards give business users the
  critical information they need to understand and
  improve organizational performance.
• Provide immediate insight into individual,
  departmental, or enterprise performance by
  delivering key metrics in an attractive and
  intuitive visual interface.

8
Pentaho Dashboard (2)
9
Pentaho Dashboard (3)
10
Pentaho Reporting

• Pentaho Reporting allows organizations to easily
  access, format and deliver information to
  employees, customers and partners.
• As a result, Pentaho Reporting is considered a
  core business
• intelligence need and often the first BI
  application deployed

11
Pentaho Reporting (2)
12
Mondrian (2)
13
Mondrian is used for

• High performance, interactive analysis of large
  or small volumes of information
• "Dimensional" exploration of data, for example
  analyzing sales by product line, by region, by
  time period
• Parsing of Multi-Dimensional eXpression (MDX)
  language into Structured Query Language (SQL) to
  retrieve answers to dimensional queries
• High-speed queries through the use of aggregate
  tables in the RDBMS
• Advanced calculations using the calculation
  expressions of the MDX language

14
Kettle

• Kettle has capabilities to access, cleanse, and
  integrate data from wherever your organization
  has it.
• Kettle delivers powerful Extract, Transform and
  Load (ETL) capabilities with an intuitive design
  environment, and a proven, scalable,
  standards-based architecture.

15
Kettle (2)
16
Kettle Suite

• Kitchen Job Execution
• Spoon GUI Designer
• Carte Cluster Web Server
• Pan Transformation Execution

17
Weka

• Uncover hidden relationships in your data and
  discover indicators of future performance with
  Weka.
• Take your business intelligence to the next level
  through predictive analytics and exploit
  correlations in your data to better to improve
  organizational performance.
• REF http//en.wikipedia.org/wiki/Data_mining

18
Weka (3)
19
Weka (4)