• Understand concept of Information Visualizations with Dashboard.
• Build an Interactive Dashboards using various Charts / Widgets.
• Able to construct Key Performance Indicator (KPI) tabular or visualization indicators.
• Understand  key concept technologies of Pentaho, PHP, jQuery, Web Services, and REST.
• Able to expose REST using Pentaho Action Sequence or other Pentaho solutions.
• Understand Data Processing with PHP.

Course Fee

• Basic HTML (HyperText Markup Language) and CSS (Cascading Style Sheet).
• Relational Database and SQL (SQL Server, Oracle, MySQL, PostgreSQL, etc).
• Basic JavaScript.

• PC  or  Laptop  with  minimum  of  2GHz  CPU,  1  GB  of  RAM,  DVD  Drive  and 15 GB  of available hard disk space. 
• Softwares : 
• Microsoft Windows XP / Windows 7 Professional Edition
• Java Runtime Environment (JRE) 
• Apache HTTP Server (with PHP Engine)
• Apache Tomcat 
• MySQL 5.0 Database Server 
• Pentaho BI Server

• What is Dashboard ?.
• Key Performance Indicators (KPI).
• Graphical presentations of various types of Data and Information.
• Challenges and Solutions to Mobile Visualizations (Smartphone & Tablet PC).
• Demos.

• Java Runtime Environment / Java Development Kit. 
• Pentaho BI Server. 
• Pentaho Design Studio.
• XAMPP package (Apache HTTP Server, PHP Engine and MySQL). 
• jQuery.
• SQLYog – a GUI based mysql client. 
• Data and Script samples.

• Pentaho Open Source BI
• Pentaho Application Stacks.
• Pentaho BI Server and Web Services.
• PHP
• PHP as multi purpose Interpreter Language.
• PHP as Server Side Programming Language (for HTTP).
• Rich Features (Libraries) of PHP.
• MySQL Database Server
• JavaScript and jQuery
• JavaScript as client side programming language.
• jQuery – a cross browser JavaScript library.
• MVC (Model, View and Controller) Programming Pattern.

• Selectors : Basic CSS selector, parent-child, container, position, etc.
• Manipulating Element Properties and Content.
• Event Handling.
• Using Plugins.
• Advance Interactive using AJAX.
• Data Form Validator.

• Advanced Interactions using jQuery UI Widget : Datepicker and Slider Widget.
• UI Effects.
• Integration Flash and Javascript Chart with jQuery.
• Interactive Charts.

• What is Pentaho Solutions (Reports, ETL Scripts, Cube Schema, Metadata Definitions, Action Sequences, etc) ?
• Pentaho Administration and User Console  (PAC / PUC).
• Creating and Mainting User and Database Connections using PAC.
• Browsing and Using Pentaho Solutions using PAC.
• Apache Tomcat Configuration.

• What is Pentaho Action Sequence and its relation to other Pentaho Solutions ?
• Pentaho Design Studio.
• Action Sequence components : OLAP, Relational, Javascript, etc.
• Javascript inside Pentaho Action Sequence.
• Constructing REST.

• Pentaho BI Server XML Configuration Files.
• Default web services .
• Extending Pentaho web services.
• Security and Access Control List (ACL) settings.

• Creating connection to MySQL.
• Sending SQL Query and Receiving Results.
• Constructing Tabular Data View.
• Using Parameterized Input to Filter Results.

• Date and Time Functions.
• Numeric Functions.
• XML and JSON Data Format.
• Regular Expression.

• Consuming Pentaho web services.
• Execute Pentaho Action Sequence.

• Introducing GD and Image Functions.
• Constructing Basic Chart.

• Basic Chart Types : Pie, Bar, and Line Charts.
• Advanced Chart Types : Spark Lines and Bullet Charts.
• Data Consumer : Static generated  and AJAX.
• Interactivity.
• Animating Chart.

• Basic Chart Types : Pie, Bar, and Line Charts.
• Data Consumer : Static generated  and AJAX.
• Interactivity.
• Animating Chart.

• Data and KPI Preparation
• Adopting Model, View and Controller (MVC) 
• Chart / Visualization Template 
• PHP Dashboard Templates
• Data Source Preparation and KPI using Pentaho Action Sequence

• Historical Analysis
• Scenario / What If Analysis Dashboard