Before developing a course, we listen to the real needs and objectives of each client, to adjust training and get high profitability We adjust each course to your needs.

We are also specialists in formations 'in company' tailored to the needs of each organization, where harvesting for several participants from the same company is much higher. If this is your case, contact us.

Check our courses

Full Workshop Pentaho

Full Workshop Pentaho

Goal

We look for a very practical approach in order to install during the entire platform to perform all exercises with vuestos own data; We deliver documents, presentations and ability to access code of the developments that have realizado.Adaptamos training needs and Business Intelligence strategy of each organization.

It is intended that during the same may be able to install all the components in their latest versions, from a more advanced structure than the typical demo of Pentaho and the ability to access schemes databases that ye may define or already have, and present the solution through a Portal Business Intelligence.

See examples of our solutions to cotinuación and Section Demos Online.

Our VideoTutorial Introduction to Pentaho has been seen by thousands of users (Youtube channel):

Target audiences

Information technology professionals, IT managers, consultants in Business Intelligence, business analysts, systems analysts, Java architects, system developers, administrators, database, developers and professionals in relation to the area of technology, marketing, business and financial.

Previous requirements

Knowledge databases and to be distributed among the different students scripts load sample data.


Observations

Confirmations

Confirmations will be sent to the e-mail sent by the student.

Cancellations

The deadlines for the cancellation of registration requested, are 10 working days before the start of the course.

In case of cancellation later by the student, Stratebi reserves the right to charge a percentage of the value of the course.

Stratebi reserves the right to cancel or postpone the training, provided they notify the contractor and / or return the full amount in case of cancellation.

Responsibilities Stratebi

  • Present the content as laid out in the training program.
  • Distribution prepared for the installation of all the necessary components in the course.
  • Provide access to the equipment required (PDFs, exercises, software, etcs) for the contracted course.
  • Provide local training delivery.
  • Issuance of certification of attendance by Stratebi.

Student Responsibilities

Participate in training in the given period, bringing a notebook with the minimum requirements for participation in training, these being the following:

  • Minimum of 2GB of RAM.
  • Minimum of 4GB of disk space (HD)
  • Operating System (Windows XP, Vista, 7, Linux,...)
  • Possessing a privileged user installation programs on the operating system.

Syllabus

Introduction Open Source Business Intelligence Platforms
  • Architecture and features of Pentaho, SpagoBI, BIRT, Mondrian, Kettle, Talend, etc...
  • Development Tools.
ETL (Kettle)
  • Good practices for ETL process definition.
  • Functional Overview (work, Transformations, flow control)
  • Parameterisation
    • Environment Variables
    • Parameterization of connections to databases. shared connections.
    • Parameterization of loads and load types
  • Jobs
    • Overview
    • Steps types (Mail, File Managament, etc... )
    • Description of Steps
    • Steps examples of more useful and common
  • Transformations
    • Overview
    • Steps types (Input, Output, Tranform, etc...
    • Description of Steps
    • Steps examples of more useful and common
  • Practical examples
Datawarehouse, Olap and Pentaho Analysis. Mondrian OLAP
  • Datawarehouse - Datamart.
  • Star models.
  • Multidimensionality / OLAP
  • OLAP. Mondrian. Mondrian architecture.
  • JPivot and MDX.
  • Mondrian schemes. Schema Workbench to design schemes Mondrian.
  • Optimization Tips. Pentaho Aggregation Designer.
  • Alternatives to JPivot: STpivot and Saiku
  • Practical examples
Reporting
  • AdHoc Reporting
    • Operation WAQR
    • Pentaho Metadata Editor
    • Creating metadata model
    • Templates WAQR
  • Pentaho Reporting. Report Designer.
  • Practical examples
Dashboards
  • Introduction.
    • Previous concepts.
    • Good practices.
    • Practical design. Storyboard.
  • Types of dashboards.
  • CDF
    • Introduction.
    • Examples.
  • CDF ( Dashboard Editor )
    • Introduction.
    • Examples.
  • Dashboards Adhoc.
    • Introduction.
    • Examples. OLAP access.
  • STDashboard
What is Data Mining. Introduction and examples
Data Mining tool: Weka
  • Data Format
  • Data Exploration
  • Classification algorithms
  • Display
  • KnowledgeFlow
Data Mining algorithms with weka:
  • Clustering algorithms
  • Decision Trees
  • Linear regression
Simple examples on different algorithms and analysis of the results obtained

Contacto

Ajustamos cada curso a sus necesidades.

Nuestra oficina en Madrid

Do you need a training?. We may offer a wide training catalog based on platform and software tools such as Pentaho, Talend, Mondrian, Ctools.