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]
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]
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]
– 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]
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]
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]
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]
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
semtechs
mikit
tubone24
ryomaru0825
hakubishin3
sakaik
grimoh
naospon
ogiwarat
yokawasa
mattstauffer
teba_eleven
tinyjin
samlambert
jrom
bluesmoon
jakevdp
bkeepers
destraynor
maggiecrowley
mraible
productmarketing
wjessup
mojombo
lara
![Pentaho – Architecture www.semtech-solutions.co.nz [email protected]](https://files.speakerdeck.com/presentations/72c7811083330131707a26064ba69595/slide_8.jpg){kind=link}
![Pentaho – Screen Shots – Dashboards www.semtech-solutions.co.nz [email protected]](https://files.speakerdeck.com/presentations/72c7811083330131707a26064ba69595/slide_10.jpg){kind=link}
![Pentaho – Screen Shots – Reports www.semtech-solutions.co.nz [email protected]](https://files.speakerdeck.com/presentations/72c7811083330131707a26064ba69595/slide_11.jpg){kind=link}
