Transcript Pentaho Open Source BI - Bci news Blog | Just another

Pentaho Open Source BI
Goldwin
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.
Pentaho’s 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.
Pentaho’s Applications


Suite Pentaho
- BI Platform (JBoss Portal)
- Pentaho Dashboard
- JFreeReport
- Mondrian
- Kettle
- Weka
All build under Java platform
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.
Pentaho BI Platform (2)
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.
Pentaho Dashboard (2)
Pentaho Dashboard (3)
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
Pentaho Reporting (2)
Mondrian (2)
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
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.
Kettle (2)
Kettle Suite




Kitchen : Job Execution
Spoon : GUI Designer
Carte : Cluster Web Server
Pan : Transformation Execution
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
Weka (3)
Weka (4)