pentaho open source bi - profs area scienze ed...
Post on 22-May-2018
228 Views
Preview:
TRANSCRIPT
Pentaho Overview
● Pentaho is the commercial open source software for Business Intelligence (BI)
● Pentaho has been developed since 2004.● Pentaho provides comprehensive
reporting, OLAP analysis, dashboards, data integration, data mining and a BI platform.
Pentaho’s Benefit
● Open Source● Has community that supports the users● Running well under multi platform
(Windows, Linux, Macintosh, Solaris, Unix, etc)
● Has complete package for reporting, ETL for warehousing data management, OLAP server, data mining, and dashboard.
Pentaho’s Applications
● Pentaho Suite– BI Platform– Pentaho Dashboard– JfreeReport– Mondrian– Kettle– Weka
● All built 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 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 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
Mondrian (2)
● It 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 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
References● Bouman, Roland. Pentaho solutions : business
intelligence and data warehousing with Pentaho and MySQL. Indianapolis, IN: Wiley, 2009.
● Carina. Pentaho 3.2 data integration beginner's guide : explore, transform, validate, and integrate your data with ease. Birmingham, U.K. Packt Pub, 2010.
● http://wiki.pentaho.com/display/COM/Pentaho+Books
● http://wiki.pentaho.com/
top related