Abstract
Data warehouse is the concept of data extracting from resources and made available for ad-hoc queries and report generation to enable business intelligent activities. Data warehouse is one of the most important parts of data mining. The objective of this project is to provide an on-hand information to the beginning data warehouse designer to reinforce the key concept of data warehouse. Additionally this mobile application for data warehouse courseware will be a platform for students to find other related and useful information. A mobile application for data warehouse also includes case study and quiz for better understanding of the data warehouse concept. Case study for finding restaurants is perfectly explained with interactive designs for each approaches of data warehouse. We use Yelp API for restaurant search data. Along with learning materials, this application does not required Internet connection for learning data warehouse. Only the case study requires the Internet connection. In this courseware, we build the data warehouse systematically using four different demonstrations, which covers the topics of fundamentals, design principle of data mart prototype and data mart refinement, building an enterprise data warehouse using an incremental approach and aggregation. Each demonstration contains case study and quiz for generating result for the end users upon their request. The courseware is designed to be a supplementary part of CSC177: Data Warehousing and Data Mining at CSU Sacramento.