Course Outline

Report Designer (two days)

Basic level (first day)

    Getting to know the Report Designer user interface Getting to know the user console (Pentaho BI Suite) Creating reports using simple connections (JDBC) Using the query wizard Formatting data (styles, attributes) Publishing reports Using the Report Wizard as an alternative to creating reports Conditional formatting Usage parameters (prompts) Creating charts

Advanced level (second day)

    Defining connections with XML, Tables, PDI Creating reports with subqueries (subreports) and JavaScript queries Advanced data formatting (HTML, JS, EXCEL, Events) Using parameters and functions Using transformations (PDI) as a data source

Business Intelligence Server (One day)

User Console

    Getting to know the user interface Creating reports based on connections from databases and to a CSV file Defining queries Scheduling reports Sharing

Administrator Console

    Users and groups Defining connections Scheduling

Data Integration for report designer purposes (one day)

Basics of creating transformations in Pentaho Data Integration (PDI)

    Discussion of the types of input data. Data processing using simple mechanisms. Data filtering. Data joins. Grouping

Data Integrator integration with Report Designer

    Creating a transformation connection Using data from the transformation

Requirements

Znajomość środowiska Pentaho.

 28 Hours

Number of participants



Price per participant

Testimonials (3)

Related Courses

Related Categories