On-Line Analytic Processing (OLAP) modeling for graduation data presentation

摘要

The greatness of an educational institution can not be separated from the success of its graduates in bringing the name of their educational institution background when the graduation are working. However, a problem frequently arise when leaders or decision makers can not obtain a quick and accurate information about their graduates condition to be used as a reference to take policy because of the large amount of data and the data are not yet integrated into a single database. With the existence of the tools that can quickly and accurately process and display graduation related information, can be obviously helpful for leaders / decision makers, and therefore an information system to handle the data is needed to be provided. The data warehouse is used to store accurate data and has been through the ETL (Extract, Transform, Load) stage. OLAP (On-Line Analytical Processing) is one tool that can be used to process graduation data that has been through the filtering process before it is stored into the data warehouse and can present the report according to the user's request. With this problem, it is necessary to create a model for presenting graduation data by creating a data warehouse and presenting the data in multi-dimensional (OLAP) form. By applying the nine steps to design a data warehouse, a proper design of data warehouse can be obtained as needed.