Qbit - 356 Jedox Integration Professional course

To make decisions based on facts, you need timely and accurate data. Data quality is critical to the success of any analytics project. Extract, transform and load your data automatically from different sources with Jedox Integrator. This course provides a structured entry into data integration.

The training covers:

•     Database and file connections
•     Extracts (Relational, File, Calender, ConstantTree, CubeSlice)
•     Field transforms (Date, Lookup, text functions)

•     Hierarchy Transforms
•     Table Transforms (normalize, loop)
•     Dimension and Cube Loads
•     Standard Jobs

Data integration and automation of loading processes


2 days

Course objectives:

After this course students will be able to retrieve data from various sources and to transform it for different load processes, to build dimensions, to load transactional data into a cube as well as to automate these processes.

Target group:

This course is directed at those without specialist knowledge in data integration who want to automatically load and maintain a model from a source system using Jedox.


  • Participation in Jedox Intro Course or equivalent knowledge
  • Knowledge of building Jedox models (dimensions, elements, attributes, cubes)
  • Knowledge of how to enter data in a cube
  • Understand the difference between relational and multidimensional data management concepts

Sign up for Qbit Course 356 - Jedox Integration Course

See our other courses

After this course you will be able to analyse data and create dynimcal and complex report and set up a Jedox Database

After this course students will be able to build a dynamic report with DynaRanges and form elements using Jedox Web and to enhance it with business charts and further calculations.

After this course students will be able to seamlessly link multiple Web templates, optimize the user interface and the intuitive usability through dynamic navigation and much more.

"In 2011 we were hitting the roof with our Excel model that had become very complex. We entered a Master Degree Training Session for the purpose of converting our Excel to Jedox within 3 months. Today we have used Jedox as our group budget and reporting platform for 5 years."

Jan Knudsen, Head of Business Controlling ABB A/S

"We chose a partnership with Qbit in August 2016 to use Jedox to  our Group Forecasts to more digitised and modern management platform.
We see great opportunities in the collaboration to eliminate / upgrade the Group's many complex and manual spreadsheets, with the more flexible and user-friendly Jedox. "

Anders Egeblad, Head of Corporate Finance, Tryg

"Rambøll chose Jedox as a group budget and forecasts the solution to all 500 budget users worldwide - due to self-service, flexibility, ease of use and price - and for the first time in history, Rambøll has delivered its consolidated group budget on time."

Christiane Johansen, Director Global Shared Support and Global Business Applications, Rambøll