Pentaho Report Design Techniques (RPT1175W)

Course Benefits:

Reporting needs vary from simple tabular data to financial statements to highly interactive reports. This course teaches the fundamental and advanced report design techniques to meet almost any reporting need. The course begins with a session that will help users create and publish their first report in less than two hours. The next three sessions build upon that foundation and teach report parameterization, design techniques with subreports, report functions and calculations, and conditional formatting.

Who Should Attend:

This course is designed for report authors and designers with a strong understanding of SQL and relational database concepts.

Learning Objectives:

At the completion of this course, you should be able to:

• Understand the basic architecture and tools of Pentaho Reporting and the Pentaho BI Platform
• Author complex and dynamic reports using the Pentaho Report Designer
• Use the Pentaho Design Studio to parameterize reports
• Construct reports against relational data sources
• Include charts and subreports in reports
• Use hyperlinks within reports to build a network of reports
• Integrate Pentaho Reports into custom web applications
• Employ calculations and grouping techniques within a report
• Dynamically build the SQL for a report

Course Prerequisites:

There are no Pentaho Training prerequisites for this course. The course is designed for students with a strong understanding of SQL and relational database. A basic knowledge of web-applications is also suggested. The final session requires a strong understanding of HTML and HTML authoring techniques.

Course Requirements:

Our online courses are offered via WebEx. Visit WebEx for the minimal system requirements. Additional information and tools to test your system are available at the WebEx support site.

To complete the exercises, students will need a Microsoft® Windows XP or Vista, Linux or Mac OS X computer with a 1GHz CPU, 1 GB RAM, and a DVD drive, and 750 MB of available hard drive space. We suggest the computer have at least 1.3 GHz CPU, 2 GB of memory, and 1 GB of available hard drive space. A text editor such as Notepad may be needed for some of the tasks.

Course Topic Sessions:

The online format of this course allows students to register for the entire course or for individual topic session.Contact us to register for for the entire course and receive a 20% discount.

Getting Started (Learn More...)
Explores the foundational skills involved in designing and publishing reports with Pentaho Report Designer and the Pentaho BI Platform.

Designing Reports (Learn More...)
Teaches the skills to design high fidelity reports with charts, hyperlinking, subreports, and bands using the Pentaho Report Designer.

Parameterizing Reports (Learn More...)
Introduces the Pentaho Design Studio and techniques for parameterizing reports, dynamically constructing the data queries, and manipulating the report data.

Authoring Dynamic Reports (Learn More...)
Uses functions, calculations, and style expressions to design dynamic reports that include traffic lighting and conditional formatting.