Pentaho Business Intelligence Training in Madrid, Spain

This course provides participants with comprehensive knowledge of Pentaho BI Suite, an open-source business intelligence platform. The program covers installation, configuration, data integration, reporting, dashboards, and analytics. Participants will learn how to transform raw data into meaningful insights using Pentaho BI tools.

Introduction & Setup

• Introduction to Pentaho BI Suite

  • Components: PDI, Report Designer, Analyzer, User Console

  • Pentaho architecture and use cases

• Installation and Configuration

  • Setting up Pentaho BI Server

  • User management and security basics

• Pentaho User Console (PUC)

  • Navigation, repository management, scheduling jobs

Data Integration with PDI (Kettle)

• Introduction to Pentaho Data Integration

• Creating ETL transformations

  • Input, transformation, and output steps

  • Filtering, sorting, joins, lookups

• Job orchestration in PDI

  • Scheduling, error handling, logging

• Data integration with multiple sources (databases, Excel, CSV, APIs)

Reporting & Dashboards

• Pentaho Report Designer

  • Report templates, formatting, charts

  • Using parameters and prompts

  • Publishing reports to BI server

• Pentaho Dashboard Designer

  • Creating dashboards with multiple widgets

  • Drill-down and interactive filters

  • Connecting dashboards to ETL outputs

Advanced Analytics & Administration

• Pentaho Analyzer

  • OLAP analysis and multidimensional queries

  • Cube design and data exploration

  • KPI monitoring

• Advanced Topics

  • Using Pentaho with cloud services

• Administration & Security

  • User roles, permissions, repository management

  • Monitoring and performance tuning

Hands-on Exercises

Summary and Conclusion