Hi!
Yesterday I had the honour of presenting my mini-
bi/datawarehousing tutorial "Starring Sakila" for MySQL University. I did a modified version of the
presentation I did together with Matt Casters at the MySQL user's conference 2009. The structure of the presentation is still largely the same, although I condensed various bits, and I added practical examples of setting up the
ETL process and creating a Pentaho Analysis View (OLAP pivot table) on top of a Mondrian
Cube.
The slides, session recording, and materials such as SQL script, pentaho data integration jobs and transformations, and Sakila Rentals
Cube for Mondrian are all
available here on MySQL Forge.
Copyright Notice
Presentation slides, and materials such as SQL script, pentaho data integration jobs and transformations, and Sakila Rentals
Cube for Mondrian are all Copyright Roland Bouman. Feel free to download and learn from it. But please do not distribute the materials yourself - instead, point people to the wiki page to get their own copy of the materials. Personal use of the files is allowed. Use these materials for creating training materials of using these materials as training materials is explicitly not allowed without written prior consent. (Just mail me at roland dot bouman at gmail dot com if you would like to use the materials for such purposes, and we can work something out.)
More from Roland Bouman's Blog ...