• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 786-629-6893

Aboutsss Course:

Pentaho Developer course structure is a focused on learning Pentaho BI suite. Topics covered in this course, include Pentaho Data Integration (Kettle) , Reports, Dashboard, Cubes, Action Sequence. Pentaho developer course focuses on training participants on creating dimensional model , Understanding implementation large scale data warehouses , setting up Pentaho BI Suite, writing ETL transformations and Jobs, creating Reports and Dashboards, Creating Cubes and working with MDX and Action Sequence.


Duration : 30 hours


Fee2: 319


Job Trends


Who Should Learn?

Database profesionals

Prerequisite

Basic Concepts of Business intelegence , Data Warehousing and SQL 

Delivery Methodology

We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.

Class Delivery

Live Interactive classes with expert

Training Calender

Date Time Type Attend
No Schedule Available
Contact Us

+91 769-409-5404

Includes
  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion

Curriculum

Pentaho

OBJECTIVEof the Training:
1. Understanding importance of BI and designing dimensional Model.
2. Setting up Pentaho BI suite
3. Creating Transformation and Jobs with best industry practices and workingwith Repository
4. Designing and developing Reports and Dashboards
5. Creating Cubes ,working with MDX and Action Sequence

Introductionto BI and Dimensional Modeling
Basic Architecture of Pentaho
Introduction to Pentaho BI suite and number of components in it. (PDI, MetadataEditor, Schema Work bench, Report Designer, Design Studio)

Dealing with repository

  • Importance of repository and its usage
  • Creating a repository
  • Types of repositories and their specific usage

Dealing with Transformations

  • Creating simple transformations
  • Saving the transformation to the repository
  • Executing the transformation
  • Introduction to basic steps (various input, output, transformation steps)

Understanding Steps In Detail

  • Use of various input steps
  • Use of various output steps
  • Use of various transformation steps
  • Use of Joins
  • Flow controls available in PDI
  • Lookup data at various sources
  • Data Validation

Dealing with Jobs

  • Creating jobs
  • Executing transformation using jobs
  • Passing and retrieving data to/from the transformations.
  • Conditional execution of jobs
  • Pre-execution Validation with job.
  • File management through Jobs

Dealing with Variables

  • Creating and using variables within transformation/job
  • How to create variables and how to use them in transformations
  • Where to use variables
  • Scope of variables

Dealing with Parameters

  • Creating and using parameters
  • System parameters
  • User defined parame

Scheduling of job/transformation
Running & debugging of jobs and transformation Storing Log Informationinto log tables
SCD implementation

  • How to implement Slowly Changing Dimension using Pentaho kettle.

CDC Implementation

  • How to implement Change Data capture logic using kettle

Schema Workbench

  • Introduction To Dimension Modeling Structure
  • Creating Schema file
  • Creating cube and deploying
  • Introduction to MDX

Pentaho Report Designer (PRD)

  • Creating data source connection(JDBC/JNDI/XML/OLAP/PDI)
  • Report Formatting
  • Create a report using different types of database connection
  • Create a report using Pentaho OLAP Cube
  • Charts
  • Use of formula
  • Conditional Formatting
  • Parameter Creation
  • Use of sub-reports
  • Publish the Reports to BI Server
  • Hyper linking Reports

Dashboard CDE (CDF Framework)

  • Create a DATASOURCE at BI Serer
  • Create Simple Pentaho Dashboard using Pentaho Dashboard Designer
  • Create a drill down dashboard using action sequence and reports

Use Case

Use Case 1

Certificate

Certificate
Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?