ActivePivot courses can be delivered on your premises or in one of our ActiveViam offices throughout the world (London, Singapore, Paris, New-York). Most of our courses are hosted in a classroom style. We can also offer tailor-made courses on specific topics.

The courses are designed for technical experts who will be involved in customising ActivePivot. In order to ensure that they get the best from our courses, we asking our trainees to be familiar with Java Core APIs, the Spring framework and Maven 2.

training course

Catalogue of available courses

ActivePivot 4 - Introduction

In this course you will learn how to use the ActivePivot APIs in order to build OLAP/multidimensional cubes. You will understand the basics of ActivePivot configuration and extensions, and learn how to plug in a data source, define the cube meta model, implement comparators, calculator and post processors, add tailor-made services, and set up security. ActiveUI and Microsoft Excel will be used as the front end interfaces to browse the cubes.

Target audience: Java developers.

Pre-requisites: Java core, Spring framework (IOC), Maven.
Duration: 3 days
Learning objectives:

Upon completion of this course, you will be able to:

  • Set up a Development environment (Maven, Eclipse, debugging)
    - Configure the ActivePivotManager, ActivePivotSchema and ActivePivot
    - Use Excel and ActiveUI for cube browsing
    - Best practise for Cube design (schema and cube definitions)
  • Data Loading (the ActivePivot transaction, the Calculator and CSV Source)
  • Enrich a source of data using the calculator
    - Implement a comparators and formatters
    - Configure the MDX engine
    - Set up the drill through functionality and add post processed columns
    - Understand out the ActivePivot real time capabilities
    - Configure security and manage authentication, authorization and entitlements
  • Pre-processed aggregators
  • Post Processors: Dynamic Aggregation, Formula Post Processor

Book this course

ActivePivot 4 - Relational Store

In this course you will learn how to use the ActivePivot Integration Services layer. You will use the APIs related to the Relational Store to feed an ActivePivot cube, enrich the data source and understand the persistence / recovery features. This course will bring out Relation Stores capabilities as a real time ETL framework.

Pre-requisites: ActivePivot 4 - Introduction
Duration: 2 days
Learning objectives:

Upon completion of this course, you will be able to:

  • Configure the stores and joins between the stores
  • Enrich the stores with the Transaction Handler
  • Check the store persistence/recovery features
  • Detect a change in a given store and link it to a post processor
  • Tune the store configuration

Book this course

ActivePivot 5 - Fundamentals, Concepts and Practise

ActivePivot 5 has a completely redesigned datastore which is much more than a new feature that provides better memory utilisation and scalability. Designed to take performance to unprecedented levels, ActivePivot 5 also supports Multi Version Concurrency Control (MVCC), epochs, transactions log and off-heap storage. Taken together, these new features present a step-change in the way you design and implement ActivePivot projects. This brand new course introduces the concepts step-by-step and is appropriate not only for beginners but also for experienced developers. You will learn how to design and partition datastores, optimise for NUMA, exploit the MVCC for cross-epoch queries, how to create and configure message channels, topics and column calculators. The impact of factless and unbalanced hierarchies on cube design will be examined. The locations API is explained and hands-on sessions illustrate many post processor design patterns including non linear aggregations.

Pre-requisites: Java core, Spring framework (IOC), Maven.
Duration: 3 days
Learning objectives:
  • Set up a Development environment (Maven, Eclipse, debugging)
    - Configure the ActivePivot Manager, Data Store and ActivePivot
    - Use Excel and ActiveUI for cube browsing
    - Best practise for Cube design (data store, schema and cube definitions)
  • Data Loading (the ActivePivot transaction, the data store and sources)
  • Enrich a source of data
    - Implement a comparators and formatters
    - Configure the MDX engine
    - Set up the drill through functionality and add post processed columns
    - Understand out the ActivePivot real time capabilities
    - Configure security and manage authentication, authorization and entitlements
  • Pre-processed aggregators
  • Post Processors: Dynamic Aggregation, Formula Post Processor

Book this course

MDX in ActivePivot

In this course you will learn how to use the MDX query language using ActiveUI. After an introduction to the basic syntax and constructs of the MDX language you will learn about the fundamental building blocks of MDX: dimensions, hierarchies, tuples, sets, calculated members. You will learn about the numerical and statistical functions that are built into MDX, how to create filters and how to use ActivePivot's epoch dimension to create measures that show trends on a timeline.

You will also learn how to write efficient MDX for execution in ActivePivot. This is particularly useful for developers who are building in-house user interfaces. It is also suitable for end users and business analysis who need to build reports, ActivePivot developers and designers who need to understand the optimum balance between Java post processors and MDX

This brand new course has been designed and built for ActivePivot by a leading BI training and consulting expert.

Pre-requisites: None
Duration: 1 day
Learning objectives:
  • How to use the MDX editor in ActiveUI
  • Best practise for the design of dimensions and hierarchies
  • Learn MDX language syntax and idioms
  • How to use MDX calculated members as an alternative to Java post processors
  • How to use sets to filter the cube
  • How to use ActivePivot's Epoch dimension to build trend measures from MDX expressions

Book this course

ActivePivot 5 - Performance optimisation

This new training course focusses on the techniques and approaches for optimising the performance of ActivePivot version 5.

Attendees on the course will have access to a multi-numa node server with 250G memory and 32 cores running a project that contains a number of performance problems that are based on real use cases. During the course the students will be guided by senior consultant from our Professional Services group to resolve the problems and obtain the best possible performance.

Pre-requisites: Must have previously attended ActivePivot 5 - Fundamentals, Concepts and Practise
Duration: 2 days
Learning objectives:
  • Partitioning of Datastores and bitmap cubes,
  • Bitmap versus JIT cubes,
  • Datastore chunk sizes, indexes and dictionaries and the impact of NUMA
  • The importance IVectors and Swapping
  • Post processors design and the correct use of dynamic aggregation, compiled queries, prefetchers, IQueryCache and aggregates cache,
  • JVM set up and GC settings
  • How to read a thread dump, how to use Java Mission Control and how to interpret the information presented in ActivePivot MBeans.

Book this course

NB: For courses delivered in the ActiveViam office in London,
there is no need to bring laptops as all equipment and course materials will be provided.