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.
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.
See some examples of running OLAP cubes
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