Mastering Pentaho Business Intelligence tool

Name: Mastering Pentaho Business Intelligence tool
Rating: 3.8 (31 reviews)

Learn Pentaho BI for Report Designing, Data Integration and many more.

Created byEdionik Solutions

Last updated 2/2019

English

What you'll learn

Pentaho allows generating reports in HTML, Excel, PDF, Text, CSV, and xml. This course provides a basic understanding of how to generate professional reports using Pentaho Report Designer.

Course content

1 section • 33 lectures • 2h 49m total length

Business Intelligence4:58
Overview of Pentaho9:12
Pentaho Architecture1:22
Pentaho Report Designer Overview1:26
PRD-23:17
Installing JDK1:46
Installing PRD tool0:51
Explore installing the prd tool and gain practical insights, while engaging with design concepts and session reflections from a Pentaho business intelligence course.
Pentaho Report Designer Welcome Screen8:25
Explore the Pentaho report designer welcome screen, learning to navigate the workspace, manage reports, add sources, and configure elements like text, images, charts, and groups to build reports.
Adding Datasource and Query in PRD8:02
Reporting Elements1:51
Adding page footer field2:14
Groups in Pentaho2:57
Learn to use groups in Pentaho to segregate and visually separate items, group similar data for readability, and perform aggregations such as sums or averages.
Formatting report elements5:31
Chart Report in Pentaho9:49
Connect to a database, select fields, and build bar chart reports in Pentaho to visualize data with drag-and-drop design and customizable visuals.
Creating Flight Database8:36
Data Source Connection JDBC Interface2:36
Mastering Pentaho BI demonstrates configuring a JDBC data source connection, including database name, port, username, and password, creating and managing connections, and adding or deleting queries.
Data Source Connection JNDI3:57
Learn to set up a data source connection using JNDI, configure properties, name the connection, test the database link, and save the configuration.
Data Source Connection-Advanced I13:09
Data Source Connection Advanced -II10:42
Data Source Connection Advanced -III3:19
Explore data source connection advanced techniques in Pentaho Business Intelligence to preview a list of countries, sort them in ascending order, and select a country, then confirm the selection.
Getting started with Pentaho Data Integration4:20
Introduction to Pentaho Data Integration2:45
Transformations in Pentaho1:34
Designing a Transformation8:37
Design a Pentaho transformation by arranging steps in the design window, using drag-and-drop to build the flow, add a user defined expression, then save and run with previews.
Using the Mouseover Assistance Toolbar1:18
Editing Features in Practice12:25
Running transformation in interactive fashion8:41
Learn to run Pentaho transformations in an interactive fashion, inspecting data as it is created, testing each step to debug and understand transformation flow.
Error Handling0:59
Explore error handling in Pentaho by addressing automated transformation crashes, how failures are noticed and managed, and setting errors to prevent unexpected crashes.
Implementing the Error Handling Functionality6:55
Basics About Job1:54
Creating a Simple Job3:10
More About Designing Jobs6:00
Enriching your work by sending an email7:17

Requirements

Before you start proceeding with this course, we assume that you have prior exposure to Core Java, Database Concepts, and SQL Queries.

Description

Pentaho Reporting is a suite (collection of tools) for creating relational and analytical reports. It can be used to transform data into meaningful information. Pentaho allows generating reports in HTML, Excel, PDF, Text, CSV, and xml. This course provides a basic understanding of how to generate professional reports using Pentaho Report Designer.

This course is designed for all those who want to create, read, write, and modify Dynamic Reports using Java. In addition, it will also be quite useful for those who would like to become a Data Analyst.

Before you start proceeding with this course, we assume that you have prior exposure to Core Java, Database Concepts, and SQL Queries.

This course on Pentaho is designed for both technical and non-technical BI practitioners to develop their skills and knowledge for the most effective use of the Pentaho Business Intelligence (BI) Suite, required for successful projects.

Why should you take Pentaho BI?

Nasdaq, Caterpillar, Beontra, Telefonica, Randstad and many Fortune 500 companies are using Pentaho BI
Pentaho was acquired by Hitachi Data Systems
The average pay stands at $84,893 per year - Indeed. com

Who this course is for:

This course is designed for all those who want to create, read, write, and modify Dynamic Reports using Pentaho Report Designer Tool. In addition, it will also be quite useful for those who would like to become a Data Analyst.