Learning Pentaho - From PDI to Full Dashboard

Name: Learning Pentaho - From PDI to Full Dashboard
Rating: 4.5 (1565 reviews)

Learn how to create a BI Dashboard from the beginning using Pentaho

Highest Rated

Created byBIX Tecnologia

Last updated 6/2020

English

English [Auto],Spanish [Auto],

What you'll learn

Learn to use Pentaho (free software) to create a BI Server
How to transform your data in information
Use PDI to interact differents databases
Make a ETL process with PDI to feed a Star Schema
Create a OLAP Cube with Mondrian
Create Dynamic Dashboards in Community Dashboard Editor
Create Roles for Pentaho Server
Develop a basic free BI tool without license limit

Course content

7 sections • 25 lectures • 3h 18m total length

What is Pentaho?3:14
Installing Pentaho4:47
Basic notions9:00
Understand how a BI system is built, from ETL to a data warehouse. See how star schema, facts, dimensions, and Mondrian OLAP cubes drive Pentaho dashboards.

Pivot4j (Alternative to Saiku)0:10
IMPORTANT:
For those who can't download the saiku license. There is an alternative plugin. It is called Pivot4j.

To install Pivot4j instead of Saiku, please folow these instructions:

1- Home > Marketplace
2- Search for Pivot4j
3- Click PIvot4j Analytics
4- Click Install
5- Once installed, back to home > New > Pivot4j
Installing Saiku Plugin4:48
IMPORTANT:
For those who can't download the saiku license. There is an alternative plugin. It is called Pivot4j.

To install Pivot4j instead of Saiku, please folow these instructions:

1- Home > Marketplace
2- Search for Pivot4j
3- Click PIvot4j Analytics
4- Click Install
5- Once installed, back to home > New > Pivot4j
Using CDE5:33
Reading the Data Cube5:10
Creating charts9:46
Creating tables12:08
Filters and parameters part111:51
Learn to create a selector component and a parameter component in pentaho and wire them into a dashboard to filter charts and tables.
Filters and parameters part211:02

Creating access rules5:18
Create region-based roles in the Mondrian schema to control data visibility. Assign schema and cube grants, then use hierarchy and member grants to restrict access by customer region.
Adding users3:51
Explore how to create users and assign roles in the Pentaho user console, linking role names to cube definitions and controlling access to dashboards or folders through share settings.

Requirements

You need to have a basic understanding of data analysis

Description

Hello! Do you want to learn how to develop a business intelligence solution through the Pentaho suite?

In this course we will show the Pentaho tools, using and detailing each one. After the conclusion, you will be able to use Pentaho Data Integration, create an OLAP Cube in Mondrian Schema Workbench and develop smart dashboards in Community Dashboard Editor.

We will provide you a database sample, so you can follow the development. Watch our first class to see what you will be able to do after conclude the course.

If you have doubts do not hesitate to talk to us! We will love to help you.

Go on! I hope you enjoy it.

Who this course is for:

Business Analysts
IT professionals
IT Students
Businessmen

Learning Pentaho - From PDI to Full Dashboard

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 17min

Initial configurations1 lecture • 5min

PDI - Pentaho Data Integration5 lectures • 1hr 11min

Mondrian - OLAP Cube5 lectures • 34min

BI Server8 lectures • 1hr

Restricting access2 lectures • 9min

Concluding1 lecture • 1min

Requirements

Description

Who this course is for: