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
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.
Introduction
1
What is Pentaho?
2
Installing Pentaho
3
Basic notions
Initial configurations
1
Setting up the database
PDI - Pentaho Data Integration
1
Importing files
2
Your first job
3
Creating Dimensions
4
Creating the Fact Table
5
Unifying the processes
Mondrian - OLAP Cube
1
OLAP cube
2
Dimensions and measures part1
3
Dimensions and measures part2
4
Starting BI Server
5
Connecting Mondrian to BI Server
BI Server
1
Installing Saiku Plugin
2
Using CDE
3
Reading the Data Cube
4
Creating charts
5
Creating tables
6
Filters and parameters part1
7
Filters and parameters part2
Restricting access
1
Creating access rules
2
Adding users
Concluding
1
Thank you!
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!