1 / 13

An introduction to Pentaho

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 ?

semtechs
Download Presentation

An introduction to Pentaho

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Pentaho • What is it ? • Pentaho Server • Pentaho Client • Plugins • Big Data / Hadoop • Architecture • Screen Shots www.semtech-solutions.co.nz info@semtech-solutions.co.nz

  2. 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 info@semtech-solutions.co.nz

  3. 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 info@semtech-solutions.co.nz

  4. 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 info@semtech-solutions.co.nz

  5. 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 info@semtech-solutions.co.nz

  6. 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 info@semtech-solutions.co.nz

  7. 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 info@semtech-solutions.co.nz

  8. 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 info@semtech-solutions.co.nz

  9. Pentaho – Architecture www.semtech-solutions.co.nz info@semtech-solutions.co.nz

  10. Pentaho – Screen Shots – Drag & Drop ETL www.semtech-solutions.co.nz info@semtech-solutions.co.nz

  11. Pentaho – Screen Shots – Dashboards www.semtech-solutions.co.nz info@semtech-solutions.co.nz

  12. Pentaho – Screen Shots – Reports www.semtech-solutions.co.nz info@semtech-solutions.co.nz

  13. Contact Us • Feel free to contact us at • www.semtech-solutions.co.nz • info@semtech-solutions.co.nz • 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

More Related