Course Outline

Report Designer (two days)

Basic level (first day)

  1. Familiarize yourself with the Report Designer user interface
  2. Getting to know the user console (Pentaho BI Suite)
  3. Creating reports using simple connections (JDBC)
  4. Using the query creator
  5. Data formatting (styles, attributes)
  6. Publishing reports
  7. Using Report Wizard as an alternative to creating reports
  8. Conditional formatting
  9. Using parameters (prompts)
  10. Creating charts

Advanced level (second day)

  1. Defining connections with XML, Tables, PDI
  2. Creating reports with subqueries (subreports) and JavaScript queries
  3. Advanced data formatting (HTML, JS, EXCEL, Events)
  4. Use of parameters and functions
  5. Using transformation (PDI) as a data source

Business Intelligence Server (One Day)

User Console

  1. Familiarize yourself with the user interface
  2. Creating reports based on connections from databases and to a CSV file
  3. Defining queries
  4. Report scheduling
  5. Sharing

Administrator Console

  1. Users and groups
  2. Defining connections
  3. Scheduling

Data Integration for report designer purposes (one day)

Basics of creating transformations in Pentaho Data Integration (PDI)

  1. Overview of the types of input data
  2. Data processing using simple mechanisms
  3. Data filtering
  4. Data joins
  5. Grouping

Data Integrator integration with Report Designer

  1. Creating a connection for transformation
  2. Using transformation data

Requirements

Znajomość środowiska Pentaho.

 28 Hours

Delivery Options

Private Group Training

Our identity is rooted in delivering exactly what our clients need.

  • Pre-course call with your trainer
  • Customisation of the learning experience to achieve your goals -
    • Bespoke outlines
    • Practical hands-on exercises containing data / scenarios recognisable to the learners
  • Training scheduled on a date of your choice
  • Delivered online, onsite/classroom or hybrid by experts sharing real world experience

Private Group Prices RRP from €9120 online delivery, based on a group of 2 delegates, €2880 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.

Contact us for an exact quote and to hear our latest promotions


Public Training

Please see our public courses

Testimonials (5)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories