Program Training‎ > ‎

Open Source Dashboard Solution with jQuery, PHP, and Pentaho

posted Aug 8, 2012, 9:17 PM by Editor KampusBI   [ updated Feb 14, 2013, 7:52 AM ]

Objectives

At the completion of this course, attendee should be able to : 
  • 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 Duration

5 days / 30 hours

Course Fee

USD 2,500

Prerequisites

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

Hardware / Software Requirements

  • 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

Course Outline

Day 1

1. Dashboard – Visualization of Business
  • 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.

2. Training Preparation - Installation and Configuration
  • 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.

3. Key Technologies Introduction
  • 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.

4.    jQuery
  • 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.

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

Day 2

6. Pentaho BI Server
  • 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.

7. Pentaho Action Sequence
  • 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.

Day 3

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

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

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

11. PHP and Pentaho Integration
  • Consuming Pentaho web services.
  • Execute Pentaho Action Sequence.

Day 4

12. PHP Based Charts
  • Introducing GD and Image Functions.
  • Constructing Basic Chart.

13. jQuery / Javascript Based Visualization
  • 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.

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

Day 5

15. Basic Dashboard Development
  • 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

16. Interactive Dashboard Development
  • Historical Analysis
  • Scenario / What If Analysis Dashboard

Comments