posted Aug 8, 2012, 9:17 PM by Editor KampusBI
[
updated Feb 14, 2013, 7:52 AM
]
ObjectivesAt 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 Duration5 days / 30 hours 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 OutlineDay 11. 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 26. 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 38. 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 412. 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 515. 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
|
|