Day #1 – Jedox 210 Specialist

This course is directed at everybody just starting with Jedox and aiming for an overview of basic functionality how to read and write data.

Course Objectives

After this course students will be able to effectively analyze data and create plannings with Jedox. You learn these fundamental concepts:

• Introduction to multidimensional models
• Create reports and enter data

Requirements

• Knowledge of data storage in tabular form (lists)
• Knowledge of how to edit Excel formulas (formula wizard, formula bar, F2-mode, structure of formulas)
• Knowledge of how to deal with references (freeze references with F4)
• Knowledge of standard Excel functions: SUM(), IF(), CONCATENATE() and the name manager

Day #2 – Jedox 211 Report Specialist

This course is directed at users who want to deepen their knowledge of report design to provide complex reports for analysis and planning.

Course Objectives

After this course students will be able to build complex and dynamic reports with Jedox and optimize their planning using advanced features.

Requirements

• Participation in course 210
• Alternatively knowledge of basic Jedox functionality like “Paste View” and data splashing as well as basic knowledge of multidimensional OLAP databases
• Knowledge of how to edit Excel formulas (formula wizard, formula bar, F2-mode, structure of formulas)
• Knowledge of how to deal with references (freeze references with F4)
• Knowledge of standard Excel functions: SUM(), IF(), CONCATENATE() and the name manager