My old Pentaho CDE dashboard workout view in 3 devices

TEST View -1

TEST View -2 

Learn Pentaho BI suite(CE) - Pentaho Schema Workbench - Analysis - OLAP - Cubes - Multi Dimensional Databases course structure

Learn Multi Dimensional Database using Pentaho mondrian OLAP Cubes.

 

* Click Images and navigate to get better view of the content.

Sample Slides : 

NOTE : Adding course content in construction with more topics and advanced concepts.

Learn Pentaho BI suite - Pentaho Data Integration (a.k.a Kettle ETL) course structure

Click the images to get best view of the content.

Download Detailed Course content here

MySQL : field doesn't have a default value in MySql when inserting values into a table

On the command prompt issue below command then try inserting the values.

mysql> set @@sql_mode = '  ';
Query OK, 0 rows affected (0.00 sec)

Example :
mysql> INSERT INTO nb (id) VALUES(3);
Query OK, 1 row affected, 1 warning (0.00 sec)

References:
https://netbeans.org/bugzilla/show_bug.cgi?id=190731

Tip : Install mysql driver in Pentaho Data Integration (Kettle)

1) Download mysql-connector-java-gpl-5.1.35.msi from

http://dev.mysql.com/downloads/connector/j/

2) Execute the .msi file. (As soon as you click on run button it executes and disappears). 

3) It'll create MySQL folder inside "Program Files(x86)". (Not the "Program Files")

    Go to below location "C:\Program Files (x86)\MySQL\Connector.J 5.1" and find 

     the "mysql-connector-java-5.1.35-bin.jar" file.

4) Copy this driver to lib folder of kettle .

i.e.,. copy driver in : pdi-ce-5.4.0.0-128\data-integration\lib

5) Start PDI and try giving connection to a mysql database .

Example : 

Resources : 

1) http://stackoverflow.com/questions/18894416/install-mysql-jdbc-driver-msi