Business Analytics Report Designer

Pentaho Course -ID

BA2000

Duration:

2 days

Date:

Course description

In the Business Analytics Report Designer course, you will learn how to design, create and publish custom reports using the Report From connections between data sources to adding design elements, you will get to know all the necessary steps for designing attractive and engaging reports for your company. This course will help you prepare for the PentahoSolution Consultant exam.

Note: The Business Analytics courses do not cover data integration and data administration training. For more information about data integration training, see the DI1000 Pentaho Data Integration course.

Target Audience

Business User	Business Analyst	Data Analyst	Software Architect	Pentaho Admin	Pentaho Support

Learning Goals

After completing this course, you will be able to:

describe the main features of the report designer
connect data sources and use design tools for reporting
create reports using various data and design elements
format report elements and apply different formats
add hyperlinks and parameters to the reports
create and manage diagrams and subordinate reports in the Report Designer
create reports using the report wizard

Course Schedule

Day 1

Module 1	Getting started with Pentaho Business Analytics
Lesson	Introduction to Pentaho Business Analytics
Lesson	Navigating through the Pentaho user console
Lesson	Overview of the training contents

Module 2	Creating reports using the Report Designer, Part 1
Lesson	Navigation in the Report Designer
Lesson	Connecting a data source and writing a request
Exercise	Connect a data source and write a request
Lesson	Adding data elements and creating report groups
Exercise	Add data items and create a report group
Lesson	Creating sums/summands
Exercise	Create group and report sums/summands
Lesson	Creating headers and footers in reports
Lesson	Formatting reports
Lesson	Using conditional formatting
Lesson	Publishing reports
Exercise	Create a header and footer, then format and publish your report

Module 3	Creating reports using the Report Designer, Part 2
Lesson	Adding report parameters
Lesson	Creating hyperlinks
Exercise	Adding parameters and hyperlinks
Lesson	Creating diagrams and sub-reports
Exercise	Create a report with several sub-reports

Day 2

Module 4	Extended reporting topics
Lesson	Working with charts in the Report Designer
Exercise	Creating a drillable chart
Lesson	Using sub-reports in the Report Designer
Exercise	Creating a report with multiple sub-reports
Lesson	Using data integration as a data source in the Report Designer
Lesson	Creating report templates
Exercise	Create and setting up of a report template