Application of OLAP to the analysis of the curriculum chosen by students

With development of the scale of higher education, more and more data about curriculum chosen by students has been produced. This paper analyzes the application of data warehouse, on-line analytical processing and data mining on the analysis of curriculum chosen by students, accomplishes the design of data warehouse about universities curriculum chosen by students, extracts and transforms curriculum chosen by students data and then loads them into the data warehouse. This paper builds curriculum chosen by students multidimensional cube analysis data model by taking use of OLAP technology, and realizes the query, analysis and show of curriculum chosen by students multidimensional data, so it can analyze the curriculum’s establishment situation from many angles, and serve the university teaching decision support system.