A case study for data warehousing courseware

Data Warehouse along with Online Analytical Processing (OLAP) are essential elements in making any decisions, which has increasingly become one of the focus of the database industry. Data Warehouse provides an effective way for the analysis of mass data and helps in the decision making process. The objective of this project is to develop a web-based interactive courseware to help data warehouse designers to enhance understanding of the key concepts of OLAP using a case study approach. The courseware will help users to understand the concepts of OLAP with practical examples. This courseware provides an opportunity for students to generate various summary reports from example data with the help of dropdown list on the web pages. In addition, the students can also work on exercises based on the examples provided in the courseware. This project is developed using MYSQL, PHP, HTML, CSS, and Java Scripts technologies.