Abstract-In the distance learning environment students are often working from remote locations. All or most of their interaction will be through the online course management system. Since students cannot attend a physical lab classroom there is a need for accessible labs to serve remote students and improve their understanding of data warehouse (DW) and the textbook materials. For the DW course specifically, a platform that supports student exploration of several features such as SQL, DW, Online Analytical Processing (OLAP), as well as design of the DW is needed. A data warehousing course that meets many recommendations from industry and academia has been successfully offered for several years at our school. The DW course is offered solely in the online format using Oracle products and datasets for labs. The class incorporates a data warehouse design process that includes planning the star schema as well as defining the metadata, physical design, and application views. The paper describes the lab for the data warehousing course, its design and implementation, the exercises students will complete in both design and data analysis, and the data warehousing tool itself.Index Terms-Web-enabled lab, data warehousing, online learning, distance education.
I. INTRODUCTIONIn the distance learning environment students are often working from remote locations. All or most of their interaction will be through the online course. Since students cannot attend a physical lab classroom, accessible labs for remote students are needed to improve their understanding of data warehouse (DW) and the textbook materials. In the distance learning environment, data warehousing courses face specific challenges. In particular students need free software. The software needs to work with a variety of operating systems to provide platform independence. Further, the installation or use of DW should require no or minimal installation. Another barrier is the difficulty students must face to configure the DW software correctly for their systems [1]. For the DW course, a platform that supports student exploration of several features such as SQL, DW, Online Analytical Processing (OLAP), as well as design of the DW is needed.Data warehousing is one of many approaches in the broader field of Business Intelligence (BI). Research reveals rapid growth in the demand for professionals with skills in BI and analytics. Findings also indicate that there is a significant gap between demand and individuals with needed BI skills. Hence, there is a move to encourage more academic offerings to build capacity in all BI areas including data warehousing. Research also reveals that BI is truly an interdisciplinary field. Practitioners highlight that the need for analytical skills extends beyond technicians. Analytic skills are needed throughout the organization. Therefore educators have been encouraged to increase offerings that help develop BI and analytical skills for students across disciplines [2]- [4].Prior literature often examined ways to include data warehousing...