Abstract
OLAP is a short form for On Line Analytic Processing. It enables multidimensional view of data and answers multi-dimensional queries by using database tables. OLAP allows users to analyze and view the data in different dimensions and help make strategic and tactical decisions based on the information stored in the data warehouses. The main objective of this project is to provide the students with a web based interactive tutorial on OLAP and its operations with live examples and exercises. The courseware on OLAP will be available to all the interested users around the world. The courseware will help students to practically learn the concepts of OLAP by running open sample queries on example data. Also, the students get an opportunity to work on exercises based on the examples demonstrated to them. The courseware uses data that has been extracted from various sources, and loaded into Sql tables so that open queries can be run on the data to demonstrate examples explaining concept of OLAP operations. The website is created by using languages such as html, php and MySQL. Anyone with internet access are free to use this tool, however certain portions of the website has limited access and might ask for the users credentials. The OLAP courseware is integrated with two other courseware created earlier so that students can have an easy access to all the concepts regarding data mining and data warehousing from a single website. The OLAP courseware is used and evaluated positively in the class of CSC 177 data mining and data warehousing at CSU Sacramento fall 2014.