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.
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
Observations
See some examples of running OLAP cubes
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
Contacto
Ajustamos cada curso a sus necesidades.
Nuestra oficina en Madrid
- Paseo de la Castellana, 164, 1º
- 28046 Madrid
- info@stratebi.com
- Tlfno: +34 91.788.34.10
- Fax:+34 91.788.57.01
Do you need a training?. We may offer a wide training catalog based on platform and software tools such as Pentaho, Talend, Mondrian, Ctools.