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

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. This includes using ActivePivot's scale out architectures for horizontal and polymorphic distribution.

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.
  • How to set up and configure and deploy distributed cubes

Book this course

ActiveUI - Developers Course

ActiveUI version 4 has been redesigned to provide state of the art html 5 user experience and flexibility. It also provides full extension capabilities in native JavaScript and React components. You will learn how to customize CSS files, extend the existing app and write your own widgets.

Pre-requisites: Good working knowledge of JavaScript and its associated development environments
Duration: 2 days
Learning objectives:
  • How to use the ActiveUI JavaScript library to create your own widgets, to modify and enhance the behavior and appearance of the core widgets.
  • You will also learn how to link the widgets together to implement story telling use cases.
  • Deployment and integration of third party JavaScript libraries is included.
  • The course also covers topics related to the deployment of ActiveUI and how to integrate with your build process.
  • The role and configuration of the Content Server is also covered.

Book this course

ActiveUI - Users Course

This course will allow end users to familiarize themselves to the new ActiveUI. They will earn how to build tabular, graphs and pivots views, how to create dashboards and share bookmarks, customize MDX queries.

Pre-requisites: None
Duration: 1 day
Learning objectives:
  • Learn how to use and configure all the widgets in ActiveUI.
  • Construction of dashboards with global filter controls.
  • Creating and configure charts and graphs.
  • Creating and saving bookmarks.
  • Understand the pivot and tablular widgets, how to create MDX expressions using the wizards, the drill through panel and MDX filters and wizards.

Book this course

ActiveMonitor - Developers Course

You will learn how to implement ActiveMonitor onto an ActivePivot project and introduce the concepts of KPIs, Parameters, Monitors, Workflows and Messaging. You go through practical sessions to configure KPIs and Monitors through user interface ActiveUI. You will also learn how to use the API to customize monitor behaviors and how to use the workflows API.

Pre-requisites: Must have previously attended ActivePivot 5 - Fundamentals, Concepts and Practice AND ActiveUI Developers course
Duration: 2 days
Learning objectives:
  • Understand KPIs and Monitors.
  • Learn the different types of monitors.
  • Understand workflow, how to modify existing workflows and create new ones.
  • How to attach workflow to Monitors.

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.