A self-paced online course designed for both technical and non-technical BI practitioners to develop their skills and knowledge for the most effective use of the Pentaho Business Intelligence (BI) Suite, required for successful projects.


    Course Objectives

      • Module 1 – Basic Conceptual Architecture & Architectural Components
      • Module 2 – Clustering in Pentaho
      • Module 3 – Data Transformation-Changing the Data from one form to another form
      • Module 4 – Flow
      • Module 5 – Implementation of SCD & Jobs
      • Module 6 – Types of Repository in Pentaho
      • Module 7 – Pentaho Repository & Report Designing
      • Module 8 – Adhoc Reporting/Dashboard
      • Module 9 – What is Cube
      • Module 10 – What is MDX?
      • Module 11 – ETL Connectivity with Hadoop Ecosystem
      • Module 12 – Creating Pentaho Analyzer Report
      • Module 13 – Creating dashboards in Pentaho with 5.3.x Version
      • Module 14 – Creating Pentaho Interactive Report

    Module 1 – Basic Conceptual Architecture & Architectural Components

      • Dimensional modeling
      • Dimensional design
      • Star schema-what and by (model)
      • Star schema –what and by (language)
      • Conformed dimensions
      • Additive vs. semi-additive facts
      • Snow flake schema
      • Star vs.  Dimensional schema
      • Slowly changing dimensions

    Module 2 – Clustering in Pentaho

      • Files in pentaho
      • Spoon.bat
      • Pan.bat
      • Kitech.bat
      • Carte.bat
      • Encr.bat
      • Spoon transformation and its steps of transformation
      • How to create a connection in DB
      • How to move a data from CSV file input to table output
      • How to move the data from CSV file input to the Microsoft excel output
      • How to move the data from Microsoft excel input to write to log
      • Data Grid
      • Generate rows

    Module 3 – Data Transformation-Changing the Data from one form to another form

      • How to add constant
      • How to add sequence
      • Add value field changing sequence
      • How the calculator work in pentaho
      • No. range in pentaho
      • Replace in string
      • Select values-select field value
      • Select field value to constant
      • Sort rows
      • Split field to rows
      • String operation-string cut
      • Unique rows
      • Unique rows (hash set)
      • Value mapper

    Module 4 – Flow

      • Revision of SSH command
      • How to handle the null value in pentaho
      • Mail in pentaho
      • Error handling in pentaho
      • Filter rows
      • Priorities stream

    Module 5 – Implementation of SCD & Jobs

      • Revision of SCD type 2
      • Jobs
      • Differences between jobs and transformation
      • How to make ETL dynamic
      • How to make transformation dynamic
      • File management
      • Create folder
      • Conditions
      • Scripting
      • Bulk loading
      • XML
      • Utility
      • Repository
      • File transfer
      • File encryption

    Module 6 – Types of Repository in Pentaho

      • How to make ETL dynamic
      • Difference between parameter and variable
      • How to pass a variable from a job to transformation
      • How to use a parameter within a transformation
      • How to set and get the value from a job to a transformation
      • Environmental variable
      • Functionality of repository in pentaho
      • Data base connection
      • Repository import

    Module 7 – Pentaho Repository & Report Designing

        • Basic operational report/dashboard
        • Row bending effect in pentaho
        • Report designing
        • How to public the report/dashboard
        • How pentaho server BI looks like
        • How to create Bar chart, Pi chart and Line chart in pentaho
        • Limitation of design the product
        • Sub report/dashboard in pentaho

    Module 8 – Adhoc Reporting/Dashboard

          • How to pass parameter in report/dashboard?
          • Drill down report/dashboard
          • How to create report/dashboard using cubes?
          • How to create report/dashboard using excel sheet?
          • How to create report/dashboard using Pentaho Data Integration

    Module 9 – What is Cube

          • What are the benefit of cube?
          • How to create the cube?
          • How to deploy a cube?
          • How to create a report/dashboard using a cube?

    Module 10 – What is MDX?

          • MDX basics
          • MDX in practice
          • Cells
          • Tuple implicit added aggregation member
          • Tuple
          • Tuple implicit dimensions
          • Sets in MDX
          • Selects
          • Referencing dimensions,level members
          • Member referencing
          • Positional
          • Hierarchical navigation
          • Hierarchical navigation MISC
          • Functions
          • Meta data

    Module 11 – ETL Connectivity with Hadoop Ecosystem

          • How ETL tools work in Big data Industry
          • Connecting to HDFS from ETL tool and moving data from Local system to HDFS
          • Moving Data from DBMS to HDFS
          • Working with Hive with ETL Tool
          • Creating Map Reduce job in ETL tool
          • End to End ETL PoC showing Hadoop integration with ETL tool

    Module 12 – Creating Pentaho Analyzer Report

    Module 13 – Creating dashboards in Pentaho with 5.3.x Version

    Module 14 – Creating Pentaho Interactive Report

    We record every live session we hold. Video recordings of each and every session will be posted on our blog too. So, this means you can get access to what the session is about and this way you do not miss any class. But take a note of it that you can have access to these Video recordings for 6 months only from the date you start your training. Access to these videos or to other required course material will be provided using Google Drive Cloud for lifetime.

    Yes, you can cancel your enrolment. We provide a complete refund after deducting the administration fee. To know more, please go through our Refund Policy.

    We have a team of industry-expert instructors or trainers who possess 8-10 yrs. of relevant experience in various Business Technologies. Every instructor / trainer undergo our specialized training program called “Train the Trainer” at Xoomtrainings. Our trainers are trained so that our learners get a great learning experience.

    Yes, classes at Xoomtrainings are conducted through online video streaming where there is two-way communication between users and instructors. The users can speak by using a microphone, chat by sending a message through a chat window and share their screens with an instructor. For better understanding, users can take the sample recorded class on this page to know of the quality of instruction and the way the class is conducted.

    Yes, the instructor will allocate you a real-time project to have a clear understanding of how you are able to conceptualize and implement the real-world application of the course content.

    Yes, we run multiple offers from time-to-time. Please, contact the support team they will give the Coupon Code.

    Yes, we will give you a discount of Rs 1500/- on selected course if you refer someone. We also offer special discount for groups.

    Yes, we will provide you the links of the software to download (trial version) which are open source and for proprietary tools we will provide you trial version, if available.

    For your practical work, we will help you set up a Virtual Machine on your system with IDE’s. This will be local access for you. The detailed step-wise installation guides are present in your LMS which will help you install and set-up the environment for any course. In case, you come across any doubt, the 24/7 support team will promptly assist you through mail (support@xoomtrainings.in) or Phone (+91 -40-4018 3355)

    4 Mbps of internet speed is recommended to attend LIVE classes. However, we have seen people attending the classes with a much slower internet connection too.

    Yes. You will receive a Digital E-Certificate from us once you complete the course. You can include this is in your Resume to get placed better.

    Xoomtrainings is the largest online education company and a large number of recruitment firms contacts us for our student’s profiles from time-to-time. Since there is a big demand for this skill, we help our certified students get connected to prospective employers. We also help our customers prepare their resumes, work on real life projects and provide assistance for interview preparation. Having said that, please understand that we don’t guarantee any placement. However, if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.

    No doubt, your transaction is always safe and secure with Xoomtrainings.

    You will get 24/7 access to the blog to post your questions. Trainers will answer your questions through email within 24 hrs. of time. Also, our support team will help you 24/7 through mail (support@xoomtrainings.in) or Phone (+91-40-4018 3355 ,7093502091,92 ).

    You can give us a CALL at INDIA: +91-40-4018 3355 ,7093502091,92  Or Email at contact@xoomtrainings.in


    Tab Content

    Course Reviews

    No Reviews found for this course.

    • Rs.19,999.00
    • 30 Hours

    Course Features

    Lifetime access to the learning management system including Class recordings, presentations, sample code and projects

    Lifetime access to the support team (available 24/7) in resolving queries during and after the course completion

    Xoomtrainings certified based on your project performance, reviewed by our expert panel

    Xoomtrianings enjoys strong relationship with multiple staffing companies in US, UK and India. If you are looking out for exploring Placement opportunities, you can pass your resumes once you complete the course and we will help you with job assistance. We don’t charge any extra fees for passing the resume to our partners and clients

    Course Enquiry

    © 2015 - 2016 Xoom Trainings powered by Innovin IT Solutions Pvt.LTD..All Rights Reserved.
    There are no courses Added to Cart