Learning Pentaho - From PDI to Full Dashboard
4.2 (947 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,591 students enrolled

Learning Pentaho - From PDI to Full Dashboard

Learn how to create a BI Dashboard from the beginning using Pentaho
4.2 (947 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,591 students enrolled
Last updated 3/2018
English
English [Auto-generated], Portuguese [Auto-generated], 1 more
  • Spanish [Auto-generated]
Current price: $129.99 Original price: $199.99 Discount: 35% off
3 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
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
Course content
Expand all 24 lectures 03:17:56
+ Introduction
3 lectures 17:01
Installing Pentaho
04:47
Basic notions
09:00
+ PDI - Pentaho Data Integration
5 lectures 01:11:12
Importing files
12:23
Your first job
18:47
Creating Dimensions
12:08
Creating the Fact Table
15:35
Unifying the processes
12:19
+ Mondrian - OLAP Cube
5 lectures 33:30
OLAP cube
04:42
Dimensions and measures part1
19:28
Dimensions and measures part2
04:14
Starting BI Server
03:01
Connecting Mondrian to BI Server
02:05
+ BI Server
7 lectures 01:00:18

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 Plugin
04:48
Using CDE
05:33
Reading the Data Cube
05:10
Creating tables
12:08
Filters and parameters part1
11:51
Filters and parameters part2
11:02
+ Restricting access
2 lectures 09:09
Creating access rules
05:18
Adding users
03:51