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.

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

Olap MDX

Olap MDX

Goal

From weeks to minutes, so is the power of multidimensional OLAP solutions we work. No need to rely on knowledge or technology departments, users can make their own advanced adhoc analysis.

Using OLAP cubes is very common in implementations, such as the case of MRW, EOI, Dipsalut...

Everything an analyst needs for consultation, analytical reporting and decision making: charts, graphics capability, drill down, drill to detail, export to different formats, securization by roles...

The multidimensional analysis provides data access at high speed, thanks to its multidimensional design. A to analysis-oriented structure and decision making.

In this course you will learn everything about OLAP and MDX in the world Open Source. You can learn how to create your OLAP structures with which you can exploit your information into a BI system and learn to perform MDX queries directly into these structures.

Target audiences

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

Observations

See some examples of running OLAP cubes

Employment OLAP cubes

Guided OLAP cubes with simulation

OLAP analysis parties with links

Syllabus

Introduction Open Source Business Intelligence Platforms
  • Architecture and features of Pentaho, SpagoBI, BIRT, Mondrian, Kettle, Talend, etc...
  • Development Tools.
Datawarehouse, Olap and Pentaho Analysis. Mondrian OLAP
  • Datawarehouse - Datamart.
  • Star models.
  • Multidimensionality / OLAP
  • OLAP. Mondrian. Mondrian architecture.
  • JPivot and MDX.v
  • Mondrian schemes. Schema Workbench to design schemes Mondrian.
  • Optimization Tips. Pentaho Aggregation Designer.
  • Alternatives to JPivot: STpivot and Saiku
  • Practical examples

Announcement

OLAP & MDX Techniques Training

  • Workshop

Date: Del 19 May. - 20 May. 2023.

Schedule: 9:00H - 14:00H and 15:30H a 18:30H

Place: Av. de Brasil, 17, 16º A-B. Madrid

Price: 375€ / person

Payment: Paypal or Wire transfer (Ask)


OLAP & MDX Techniques Training

  • Online

Date: Del 24 May. - 25 May. 2023.

Schedule: 16:00H - 21:00H (CEST - Madrid)

Place: Plataforma web con profesor

Price: 95€ / person

Payment: Paypal or Wire transfer (Ask)


Contacto

Ajustamos cada curso a sus necesidades.

Nuestra oficina en Madrid