PENGEMBANGAN DATA WAREHOUSE DAN ON-LINE ANALYTICAL PROCESSING (OLAP) UNTUK PENEMUAN INFORMASI DAN ANALISIS DATA (Studi Kasus : Sistem Informasi Penerimaan Mahasiswa Baru STMIK AMIKOM PURWOKERTO)

Abstract

Background preparation of this thesis report, Silva (2007) mentions that the competition for students between universities was inevitable as it grows, universities should equip themselves to survive in the competition that ultimately colleges that are not sensitive to compete. The demand for a high performance organization that has also faced by STMIK AMIKOM Purwokerto. Existing data on the colleges that are so big and much needed storage space allocation will be helped and be efficient with the data warehouse (Wikramanayake, 2006). Based on the data management / decision makers in education institutions is always a constant attempt to find an information / decision analysis that are useful in the search for new students. For the needs of the analysis method was used OLAP (OnLine Analytical Processing) which presents the data in the form of multidimensional query that is easier to be presented and analyzed. Data collection methods used in the preparation of this report include the method of observation of interviews and field studies, literature, internet search, as well as observing systems that are already running. This research was conducted with the following steps: 1) The analysis system that includes the current SIPMB analysis, identification of the cause of the problem, analysis of system requirements. 2) System design, including design of data warehouses and OLAP applications PMB. This design produces data warehouse architecture, data modeling dimensional, the establishment of a data warehouse, OLAP stakeholders PMB, PMB OLAP viewpoint, scenario, model systems, and user interface design. 3) Implementation, covers the application of OLAP applications PMB and operations performed included, 4) testing system, test the product in accordance with ISO 9126 software includes six quality characteristics of Functionality, Reliability, Usability, efficiency, Maintainability, Portability. In order not to interfere the performance of the operational databases (OLTP) SIPMB process of creating a data warehouse is done on different machines by performing replicate of the database used SIPMB. For the needs of the application is made data analysis OLAP PMB. These applications could present multidimensional data in grid view. Analysis of these data may include analysis of specialization in new student enrollment based on the period of new admissions, enrollment surge, home school, home province and district, Pengembangan Data Warehouse dan On-line Analytical Processing (OLAP) Untuk Penemuan Informasi Dan Analisis Data Jurnal Telematika Vol. 4 No.2 Agustus 2011 14 registration information, day, month, or year. So that the results of data analysis can be the management in determining the appropriate marketing strategies to increase the number of freshmen applicants either currently running or for admission in the coming year.