An introduction to Pentaho

54 %
46 %
Information about An introduction to Pentaho

Published on March 1, 2014

Author: mikejf12



A short introduction to Pentaho, how can it be used for business intelligence. How
can it help us in our processing of big data on Hadoop ?

Pentaho  What is it ?  Pentaho Server  Pentaho Client  Plugins  Big Data / Hadoop  Architecture  Screen Shots

Pentaho – What is it ?  It is a business intelligence system  It offers Analytics Visual data integration OLAP Reports Dashboards Data mining ETL  Written in Java

Pentaho – What is it ?  Offered as Free community edition Purchased enterprise edition  Available for Windows Linux Mac OSX  Community supported  Open source plugins available  Uses the Apache Java Application Server

Pentaho – Server Pentaho server components  BI / BA Platform - the core platform, hosts contents and offers services  Analysis (Mondrian) – an OLAP server, query via MDX, XML In memory data aggregation  Dashboard Designer (PDD) – supports monitoring / decision making  Analysis (PAZ) – drag and drop OLAP viewer, create MDX queries  Reporting (PIR) – plugin for adhoc reports  Data Access – create data sources / define data models  Mobile – extends Pentaho to the mobile world Dashboards and reports on a small screen

Pentaho – Client Pentaho client components  Data Integration (PDI) – Kettle ETL engine, single node / cloud  Big Data – ETL for Hadoop / NoSQL databases  Report Designer – codeless report creation  Data Mining – uses Weka for pattern searching and trend prediction  Meta Data (PME) – create business models of data sources  Aggregate Designer (PAD) – pre calculation for aggregation  Schema Workbench (PSW) – OLAP cube analysis  Design Studio (PDS) – automation / business logic task support

Pentaho – Plugins Pentaho plugins  Ctools – free / open source tools by webdetails  Charting (CCC) – create dashboard charts  Build Framework (CBF) – release management for Pentaho apps  Data Access (CDA) – common layer for data access  Data Browser (CDB) – visual OLAP data browser  Distributed Cache (CDC) – high performance, scalable shared cache  Data Generator (CDG) – for dashboard creation Creates tables, data and Mondrian schema

Pentaho – Plugins Pentaho plugins  Data Validator (CDV) – data integrity via validation tests  Graphics Gen (CGG) – server side rendering of charts as images  Dashboard Editor (CDE) – sophisticated community dashboard editor  Dashboard Framework (CDF) extendable, AJAX based dashboard framework  Startup Tabs (CST) – define start up tabs by user  Saiku – analysis suite / open source  Saiku Reporting – drag & drop report design tool

Pentaho – Big Data What are Hadoop's characteristics ? Mainly command line driven Minimal built in processing / filtering / validation options No drag & drop ETL like job creation What can Pentaho bring to Hadoop ? Visual drag & drop job creation Visual reports Ad / Hoc querying Dashboards And more … It would be a good extension to Hadoop's core functionality

Pentaho – Architecture

Pentaho – Screen Shots – Drag & Drop ETL

Pentaho – Screen Shots – Dashboards

Pentaho – Screen Shots – Reports

Contact Us  Feel free to contact us at  We offer IT project consultancy  We are happy to hear about your problems  You can just pay for those hours that you need  To solve your problems

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

An introduction to Pentaho - YouTube

A short introduction to Pentaho, how can it be used for business intelligence. How can it help us in our processing of big data on Hadoop ?
Read more

Real-Time Analytics with Pentaho | Pentaho

Want to break out of your data warehouse to do real-time reporting? Pentaho data integration can help solve the challenges of data latency and data ...
Read more

An Introduction to Pentaho Instaview - YouTube

Watch this short whiteboard session to see how Instaview takes users from data to analytics in three simple steps - dramatically reducing the ...
Read more

Introduction - Pentaho Corporation

Provides an introduction to the process. ... Show More. There were no results for this query
Read more

Introduction to Pentaho Reporting - Pentaho Reporting ...

Components. Pentaho Reporting consists of the Reporting engine, Report Designer, the Pentaho BI Server, and the following client tools and add-ons:
Read more

Open Source meets Business Intelligence An Introduction to ...

Open Source meets Business Intelligence An Introduction to Pentaho Seminar ÒBusiness IntelligenceÓ 06.02.07 Kons tanz Monika Podolecheva
Read more

An introduction to Pentaho - Video Dailymotion

A short introduction to Pentaho, how can it be used for business intelligence. How can it help us in our processing of big data on Hadoop ?
Read more