User interfaces available in Pentaho and their navigation

Last updated on Sep 27 2021
Jayesh Chettiyar

Table of Contents

User interfaces available in Pentaho and their navigation

Pentaho – Navigation

This blog will provide a brief introduction on the user interfaces available in Pentaho and how to navigate through them.

The Welcome Screen

The welcome screen provides two ways to create reports of different types. Those two options are Report Wizard and New Report.
Report Wizard − It provides an easy-to-use four steps process that walk you through creating a new Report.
New Report − If you choose this option, then you can create customized reports based on your requirement.
Pentaho has a set of sample reports to help you figure out how to use a certain Report Designer. The following screenshot shows the welcome page of Pentaho.

pentaho 46
pentaho

The Main Toolbar

The main toolbar is at the top of the window. Take a look at the following screenshot – the maximized box is the main tollbar. It contains button to carry out the following actions − New File, Open File, Save File, Publish the Report, Add Data Source, Run the Report, Select Object, Undo, Redo, Cut Element, Copy Element, Paste Element, Delete Selected Element, and Toggle the Field-Selector Palette.

pentaho 47
pentaho

The Report Workspace

The workspace is the main working area where we can design the reports. Take a look at the following screenshot – the white area at the center is the workspace. It is divided into five bands − Page Header, Report Header, Details, Report Footer, and Page Footer.
Page Header − You can use any type of data here that is suitable to print on top of every report page. It does not allow any dynamic values or page breaks.
Report Header − The second band from top is the Report Header. It contains the report elements. It appears once per report, that is on the first page of the report.
Details − The Details band is the largest portion of your page because most of the report data is presented in this area.
Report Footer − Just like the Report Header, the Report Footer appears just once per report, that is on the last page of the report.
Page Footer − The last band is the Page Footer which appears at the absolute bottom of every page in the report.
You can also create groups for various report elements. Each group has its own Header and Footer bands in the workspace.

pentaho 48
pentaho

The Structure Pane

The structure tab shares a pane with the Data tab in the upper right section of the Report Designer. Take a look at the following screenshot; it shows the exact hierarchy of every element included in a report workspace.

pentaho 49
pentaho

The Data Pane

The Data Pane enables you to add data sources and view individual queries, functions, and parameters in each report. The three buttons at the top of the pane are meant for adding new data sources, functions, and parameters, respectively.
Datasources − All the data sources and queries that you have defined for the current report will be listed here. If you want to add a new data source, then rightclick on the leftmost button (the yello cylinder) click add.
Functions − All the functions (mathematical and conditional) elements that you added to a report will be listed in this category. You can add a function by clicking the (fx) button.
Parameters − You can add a parameter to your report, which will enable the report readers to customize the content of the output.
Take a look at the following screenshot.

pentaho 50
pentaho

The Style Pane

The style pane displays all the visual and positional style options for any given item in the structure pane. Click any structure element, and the composition of the Style Pane will be adjusted to show all the available style properties listed by group. Take a look at the following screenshot.

pentaho 51
pentaho

The Attribute Pane

The Attribute Pane displays all the low-level properties, and input and output options for any given item in the Structure Pane.

pentaho 52
pentaho

The Palette

The palette contains all the elements that you can use to build a report. To add an element, click on a layout band to select it, then drag and drop an element from the palette to the selected band. We have explained the role of each of the report elements in the following table.

Element icon Element name Description
Label A static text string. It cannot change dynamically.
Text-Field A Textual report element and changed dynamically based on the query.
Number-Field Displays dynamic numerical data from a query.
Date-Field Handles date information form a query.
Message An element that combines multiple static and dynamic report elements.
Resource-label Static text string that maps to a resource bundle
Resource-Field Dynamic text string that maps to a resource bundle, allowing you to localize any database field.
Resource – Message Dynamic text string that concatenates data from multiple types, and dynamically maps to a resource bundle.
Image-Field A reference to an image stored in a database.
Image A static image embedded into a report.
Ellipse A vector graphical element in the shape of eclipse.
Rectangle A vector graphical element in the shape of rectangle.
Horizontal-Line A vector graphical line, drawn horizontally.
Vertical-Line A vector graphical line, drawn vertically.
Survey-Scale A simple sliding scale chart element.
Chart A chart or graph that shows your query results graphically.
Simple-Barcodes A barcode chart element.
Bar-Sparkline A Bar Sparkline chart element.
Line-Sparkline A line Sparkline chart element.
Pie-Sparkline A Pie Sparkline chart element.
Band A method of grouping elements.
Sub-Report An element that references another report.
Table-Of-Content A table of content report element.
Index An Index report element.

Take a look at the following screenshot; the highlighted box on the left side is the palette of reporting elements.

pentaho 53
pentaho

So, this brings us to the end of blog. This Tecklearn ‘User interfaces available in Pentaho and their navigation’ blog helps you with commonly asked questions if you are looking out for a job in Pentaho BI. If you wish to learn Pentaho BI and build a career in Business Intelligence domain, then check out our interactive, Pentaho BI Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Pentaho BI Certification Training

Pentaho BI Training

About the Course

Pentaho BI Training from Tecklearn teaches you how to develop Business Intelligence (BI) dashboard using Pentaho BI tool from scratch. Pentaho is an open-source comprehensive BI suite and provides integration with Hadoop distribution for handling large dataset and doing reporting on top of it. This course explores the fundamentals of Pentaho Data integration, creating an OLAP Cube, integrating Pentaho BI suite with Hadoop, and much more through the best practices. Our Online Pentaho Training Course also provides real-time projects to enhance your skills and successfully clear the Pentaho Business Analytics Certification exam.

Why Should you take Pentaho BI Training?

• The average annual pay for a Pentaho Developer is $124828 a year. -ZipRecuiter.com.
• Around 2500 websites globally are using Pentaho BI and it has a market share of around 3% globally.
• Pentaho is a suite of Business Intelligence products, which provide data integration, OLAP services, reporting, dashboarding, data mining and ETL capabilities. Pentaho is a one stop solution for all business analytics needs.

What you will Learn in this Course?

Data Modelling
• Why need Data Modelling
• Data Modelling Scope and Benefits
• Data Model Analogy
• Case Study
Introduction to Pentaho BI Suite
• Overview of Pentaho Business Intelligence and Analytics tools
• Pentaho Data Integration (PDI)
• Pentaho Report Designer (PRD)
• Pentaho Metadata Editor (PME)
• Pentaho Schema Workbench (PSW)
• Dashboard Capabilities
Installation
• Installation of Java
• Installation steps for Pentaho ETL Tool
• Spoon Installation
• Spoon Overview
• Connection to Database
Retrieving Data from Flat or Raw Files using Pentaho
• Working with Flat Files or Delimited Files
• Different Use Cases
• Read Data from different Delimited Files using Pentaho
Clustering in Pentaho
• Basics of clustering in Pentaho Data Integration
• Creating a database connection
• Working with CSV Files
Pentaho Report Designer
• Designing Basic Report containing Graphical Chart
• Conditional Formatting and Studying the PRPT File Format
• Building a Basic Report in PDF Report
• Data Source Connection and Query Designer
• Working with Group (Group Header, Group Footer)
• API Based Reporting
Pentaho Data Integration – Transformation
• What is Data Transformation
• Step, Hop, Variable
• Various Input and Output Steps
• Transformation Steps, Big Data Steps and Scripting
Different Types of Transformation
• Transformation Steps in Detail
• Add sequence and use calculator
• Generating Output
• Data Validation
Slowly Changing Dimensions (SCD)
• Slowly Changing Dimensions,
• SCD Type I
• SCD Type II
• Deploying SCD
Pentaho Dashboard
• Pentaho Dashboard
• Passing parameters in Report and Dashboard
• Drill-down of Report
• Deploying Cubes for report creation
• Working with Excel sheets
• Pentaho Data integration for report creation
Understanding Cube
• What is a Cube
• Report and Dashboard creation with Cube
• Creation and benefits of Cube
Pentaho Analyzer
• Pentaho analytics for discovering
• Blending various data types and sizes
• Advanced analytics for visualizing data across multiple dimensions
Pentaho Data Integration (PDI) Development
• PDI steps used to create an ETL job
• PDI / Kettle steps to create an ETL transformation
Pentaho Administration
• Creating and Managing Users and Roles
• Security
• Performance Tuning
• Dashboard Creation with Advance Features

 

0 responses on "User interfaces available in Pentaho and their navigation"

Leave a Message

Your email address will not be published. Required fields are marked *