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

Number of participants


Price Per Participant (Exc. Tax)

Testimonials (3)

Provisional Courses

Related Categories