Pentaho BI Suite: presentation, modules, licenses
Organization of a BI project with Pentaho
Data design and modeling
Available support, documentation

Practical workshop: Installation and presentation of the Pentaho environment

Data integration issue (operational and decision-making)
ETL (Extract Transform Load ) tools available
PDI: architecture,
Spoon functionalities : graphic design, configuration
Extraction and integration of database data (files, lookups, calculations, …)
Implementation place of filters and flow routing
Logging, monitoring and error management
Use of JavaScript and Java classes in transformations, iterative processing Performing
tasks,
PDI deployment and
Agile-BI web services : presentation, interest, plugin

Practical workshops: installation of PDI and getting started with Spoon – transformations (basic / advanced) on multiple sources – flow redirection – use of arguments, creation of jobs

Presentation, architecture OLAP
multidimensional analysis : concepts, queries
Star schemas
Use of the MDX language, optimization of
Mondrian queries , Workbench schema: implementation
Creation and publication of cubes

Practical workshop: Getting started with Pentaho Analysis – creating and publishing analyzes

Reporting with Pentaho: presentation of the tool, available reports
Data integration, setting up of filters
Integration of graphics
Definition of templates
Sub-reports, drill-linking, bursting

Hands-on workshop: Creating multiple reports with Pentaho Report Designer

Presentation, metadata layer
Implementation of business models and views
Securing access to
WAQR (Web Ad-hoc Query Reporter) data: presentation, deployment of reports

Practical workshop: setting up metadata in Pentaho Report Designer