Abstract:

The success of every enterprise depends upon the decisions made by decision makers. Data warehouse is novel concept and plays an important role for decision making by the use of OALAP. There are diverse fields to select and study by the students in this modern era. To build such a data warehouse that is more beneficial for selecting the curriculum by students and the multi-dimensional cube analysis takes place with more refined and elaborated ways. The data mining and OLAP techniques are also applied to prepare the standard platform to analyze the query by multidimensional view. To analyze the curriculum by multiple angles ultimately serves the university teaching decision support system. Before settled down dimensions a survey may be conducted to analyze the trends and demand, in order to make a successful data model. Once the data model is designed the test may takes place for analyzing of the performance for both complex and simple queries. The case study at university level is taken to design the views more advantageous manner the data is gathered from multiple reliable resources and the query isgenerated in more improved way.