Before organising a course or seminar, we listen to the real needs and objectives of each client, in order to adapt the training and get the most out of it. We tailor each course to your needs.

We are also specialists in 'in company' trainings adapted to the needs of each organisation, where the benefit for several attendees from the same company is much greater. If this is your case, contact us.

 

Calls for course

Ponemos a disposición también plataforma Cloud con todas las herramientas instaladas y configuradas, listas para la formación, incluyendo ejercicios, bases de datos, etc... para no perder tiempo en la preparación y configuración inicial. ¡Sólo preocuparos de aprender!

Ofrecemos también la posibilidad de realizar formaciones en base a ‘Casos de Uso’

Se complementa la formación tradicional de un temario/horas/profesor con la realización de casos prácticos en las semanas posteriores al curso en base a datos reales de la propia organización, de forma que se puedan ir poniendo en producción proyectos iniciales con nuestro soporte, apoyo al desarrollo y revisión con los alumnos y equipos, etc…

En los 10 últimos años, ¡hemos formado a más de 250 organizaciones y 3.000 alumnos!

Ah, y regalamos nuestras famosas camisetas de Data Ninjas a todos los asistentes. No te quedes si las tuyas

1  2  3  4  5

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.

Ver documento

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

Day 1

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

Day 2

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

Day 3

Reporting
  • AdHoc Reporting
    • Operation WAQR
    • Pentaho Metadata Editor
    • Creating metadata model
    • Templates WAQR
  • Pentaho Reporting. Report Designer.
  • Practical examples

Day 4

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

Day 5

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