|
Course:
Pentaho Analysis for OLAP Developers
Id: ALY 3050C
Audience: Data Architects and OLAP Developers
Delivery Method: Instructor led, Classroom
Duration: 3 Days
Cost: USD $2,000
Course Benefits:
Online analytical processing (OLAP) is one of the most powerful technologies to use within Business Intelligence applications and systems. OLAP
allows fast, interactive analysis of large volumes of data. The power to explore large amounts of data at the stream of thought allows employees
throughout the enterprise to answer critical business questions and make better decisions. This course explores the architecture, concepts, and
features of Pentaho Analysis (Mondrian) to harness the power of OLAP, including the use of star and snowflake schemas, the use of aggregate tables,
and the integration of Pentaho Analysis and the remainder of the Pentaho BI Suite.
Who Should Attend:
This course is designed for BI developers and analysts tasked with developing cubes for online analytical processing (OLAP).
Learning Objectives:
At the completion of this course, you should be able to:
- Understand the basic concepts of OLAP
- Employ industry standard BI development methodologies
- Explain the life cycle of Pentaho Analysis cubes
- Understand the basic architecture of Pentaho Analysis and its modules
- Understand the integration of Pentaho Analysis with the Pentaho BI Platform
- Develop star and snowflake OLAP schemas for use with Pentaho Analysis
- Employ OLAP security including cell-level access control
- Utilize aggregates and other techniques to improve Pentaho Analysis performance
- Use dimension sharing to build more expressive and maintainable cubes
- Understand the factors that impact performance
Course Prerequisites:
There are no Pentaho Training prerequisites for this course. The course is designed for students with a strong understanding of SQL and relational
database concepts and with experience creating and editing XML files. A basic knowledge of ETL and of web-application administration is also suggested.
Course Requirements:
Students will need a Microsoft® Windows XP or Vista computer with a 1GHz CPU, 1 GB RAM, and a DVD drive, and 750 MB of available hard drive space in
order to fully participate in the classroom delivered courses. We suggest the computer have at least 1.3 GHz CPU, 2 GB of memory, and 1 GB of available
hard drive space. Make sure you have a text editor such as Notepad; you may need it for some of the exercises.
|
English
Deutsch
