Id: ALY3050 Type: Instructor led lecture / lab Delivery Method: Classroom Duration: 3 Days Cost: $2,000 (2000 euro in EMEA)
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.
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
Who Should Attend:
This course is designed for BI developers and analysts tasked with developing OLAP solutions; however, it is valuable to anyone with a strong understanding
of SQL, ETL, and relational database concepts.
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.
