Curso
This OLAP training course focuses in the Online Analytical Processing technology as a tool to implement open source BI in companies by using the Mondrian and related projects. 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. 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 OLAP course are an IT professional that does not have any knowledge in BI and wants to start with technology. Since this OLAP training 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.
Esse curso inclui:
Suporte em tempo real
Certificado
Carga horária:
13 horas
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.
In this video we are going to see how to manipulate the data from an example cube that was created from the installation.
This video explain in more details some components of Mondrian and JPivot
The Mondrian/JPivot solution relies on a database to store the data that the OLAP cube shows.
In this video we are going to see how the objects that are manipulated by Mondrian and JPivot are created.
This video first explain how the dimensions are used to browse and filter data in the cube.
A time dimension is a special type of dimension used by all the cubes in the sample FoorMart Datawarehouse provided by Mondrian.
A measure is the most important numerical value used for quantitative analysis in a cube.
In this video we are going to see how Snowflake dimensions, calculated members, properties and virtual cubes are implemented in the Mondrian schema file.
This video show how to create a data cube in Mondrian from the expense fact table stored in the database.
Oracle PL SQL Course
T-SQL Step by Step Course
Introduction to MongoDB