Online course

# Course OLAP with open source tools

Rating
551
• ## Introduction

• 1

Mark as viewed

#### In this video we are going to see how to download, install and configure the main components that will be used during the other videos of the course.

Watch this video
• ## Jpivot and Mondrian

• 2

### Overview Overview

Mark as viewed

#### In this video we are going to see how to manipulate the data from an example cube that was created from the installation.

Watch this video
• 3

### ComponentsComponents

Mark as viewed

#### This video explain in more details some components of Mondrian and JPivot

Watch this video
• 4

### OLAP modelsOLAP models

Mark as viewed

#### The Mondrian/JPivot solution relies on a database to store the data that the OLAP cube shows.

Watch this video
• 5

### Mondrian XML CatalogMondrian XML Catalog

Mark as viewed

#### In this video we are going to see how the objects that are manipulated by Mondrian and JPivot are created.

Watch this video
• ## Dimensions

• 6

### Understanding DimensionsUnderstanding Dimensions

Mark as viewed

#### This video first explain how the dimensions are used to browse and filter data in the cube.

Watch this video
• 7

### Time dimensionsTime dimensions

Mark as viewed

#### A time dimension is a special type of dimension used by all the cubes in the sample FoorMart Datawarehouse provided by Mondrian.

Watch this video
• 8

### Measures Measures

Mark as viewed

#### A measure is the most important numerical value used for quantitative analysis in a cube.

Watch this video
• 9

### SnowFlake DimensionsSnowFlake Dimensions

Mark as viewed

#### In this video we are going to see how Snowflake dimensions, calculated members, properties and virtual cubes are implemented in the Mondrian schema file.

Watch this video
• ## Cubes

• 10

### First cubeFirst cube

Mark as viewed

#### This video show how to create a data cube in Mondrian from the expense fact table stored in the database.

Watch this video
• 11

### MDX essentialsMDX essentials

Mark as viewed

#### This video show how to create a simple MDX query and how to modify it in order to obtain the data from a cube.

Watch this video
• 12

### Aggregations Aggregations

Mark as viewed

#### One of the main issues with OLAP technology, particularly when browsing a data cube, is the performance.

Watch this video
• ## Interface

• 13

### Modifying the JPivot interfaceModifying the JPivot interface

Mark as viewed

#### This video finishes the OLAP with open source tools course.

Watch this video