Course OLAP with open source tools

forgot my password

Search:

Menu

Home

How it works?

Buy this course

	Discuss! Add a comment
	Add this course to my favorites
	Add a personal note
	RSS Feeds

Course's author:

MAURO PICHILIANI (ENGLISH)

Mauro Pichiliani has the Master of Science degree on collaborative systems by the Aeronatics Institute of Technology (ITA) in Brazil. He is a specialist on database technologies with more than 8 years of experience on the industry, using products suc...

Go to author's Space

Course stats:


Favorited:	0 times

no vote received

Features

	Textual content
	Video tutorial
	Exercise
	Source code
	Downloads
	Recommended post

Content

Notes

Discuss

Online course
Course OLAP with open source tools

The main BI goal is to support the decision making process in any company by analyzing data in order to understand the available choices and alternatives before the decision makers can make up their minds. This course focuses in the OLAP (Online Analytical Processing) technology as a tool to implement open source BI in companies by using the Mondrian and related projects. The videos in the course covers download, installation, configuration, BI concepts, customization and other technical aspects required to develop and deploy an open source BI solution. All the examples and scenarios discussed are presented in real world situations. The main audiences of this course are an IT professional that does not have any knowledge in BI and wants to start with technology. Since the course focus on beginners and explain every basic concept there is no business or technical BI requirements needed to be known before the start of the course.

Introduction

V�deo
1) Download, Installation and Configuration
Description: 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. |
[Mark this item as viewed]

Jpivot and Mondrian

V�deo
2) Overview
Description: In this video we are going to see how to manipulate the data from an example cube that was created from the installation. |
[Mark this item as viewed]

V�deo
3) Components
Description: This video explain in more details some components of Mondrian and JPivot |
[Mark this item as viewed]

V�deo
4) OLAP models
Description: The Mondrian/JPivot solution relies on a database to store the data that the OLAP cube shows. |
[Mark this item as viewed]

V�deo
5) Mondrian XML Catalog
Description: In this video we are going to see how the objects that are manipulated by Mondrian and JPivot are created. |
[Mark this item as viewed]

Dimensions

V�deo
6) Understanding Dimensions
Description: This video first explain how the dimensions are used to browse and filter data in the cube. |
[Mark this item as viewed]

V�deo
7) Time dimensions
Description: A time dimension is a special type of dimension used by all the cubes in the sample FoorMart Datawarehouse provided by Mondrian. |
[Mark this item as viewed]

V�deo
8) Measures
Description: A measure is the most important numerical value used for quantitative analysis in a cube. |
[Mark this item as viewed]

V�deo
9) SnowFlake Dimensions
Description: In this video we are going to see how Snowflake dimensions, calculated members, properties and virtual cubes are implemented in the Mondrian schema file. |
[Mark this item as viewed]

Cubes

V�deo
10) First cube
Description: This video show how to create a data cube in Mondrian from the expense fact table stored in the database. |
[Mark this item as viewed]

V�deo
11) MDX essentials
Description: This video show how to create a simple MDX query and how to modify it in order to obtain the data from a cube. |
[Mark this item as viewed]

V�deo
12) Aggregations
Description: One of the main issues with OLAP technology, particularly when browsing a data cube, is the performance. |
[Mark this item as viewed]

Interface

V�deo
13) Modifying the JPivot interface
Description: This video finishes the OLAP with open source tools course. |
[Mark this item as viewed]