Pentaho ● What is it ? ● Pentaho Server ● Pentaho Client ● Plugins ● Big Data / Hadoop ● Architecture ● Screen Shots www.semtech-solutions.co.nz [email protected] 

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 www.semtech-solutions.co.nz [email protected] 

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 www.semtech-solutions.co.nz [email protected] 

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 www.semtech-solutions.co.nz [email protected] 

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 www.semtech-solutions.co.nz [email protected] 

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 www.semtech-solutions.co.nz [email protected] 

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 www.semtech-solutions.co.nz [email protected] 

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 www.semtech-solutions.co.nz [email protected] 

Pentaho – Architecture www.semtech-solutions.co.nz [email protected] 

Pentaho – Screen Shots – Drag & Drop ETL www.semtech-solutions.co.nz [email protected] 

Pentaho – Screen Shots – Dashboards www.semtech-solutions.co.nz [email protected] 

Pentaho – Screen Shots – Reports www.semtech-solutions.co.nz [email protected] 

Contact Us ● Feel free to contact us at – www.semtech-solutions.co.nz – [email protected] ● 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