Analisis Korelasi Pada Data Warehouse Domain Akademik Di Universitas Gadjah Mada; Correlation Analysis On The Data Warehouse Domain Of Academic At Universitas Gadjah Mada

RAHMAN, KHAFID AULIA, Nurwidyantoro, Arif

2015 | Skripsi | FMIPA UGM

UGM require reliable information to support decision making. The university is particularly concerned in academic domain. Currently, UGM's executives are still having problems in obtaining academic information, as the data are not integrated with each other and are still in transactional form. Organizations' transactional data needs to be processed before it can be used as an analysis subject. One way to display information as an analysis subject is by using data warehouse. This research works on designing and developing UGM's data warehouse for academic domain. The developed data warehouse shall be used as a data source for correlation analysis with four parameters, i.e. final GPA, duration of study, age of enrollment, and age of graduation. Correlation analysis were conducted to see how the parameters of the students and see the direction of relationship. The data warehouse and the analysis result will then be visualized to facilitate UGM's executives to make decisions or policies. The result shows that, generally, duration of study has a positive correlation with age of graduation and age of enrollment, i.e. a student with a longer duration of study usually has a younger age of graduation and age of enrollment. Final GPA has a negative correlation with duration of study and age of graduation, i.e. a student with higher final GPA usually has a longer duration of study and older age of graduation. However, for the Faculty of Forestry, the duration of study has a negative correlation with the age of enrollment and age of graduation, as currently, its only graduates were enrolled in 2010; therefore, it does not accurately represent the data population.

Kata Kunci : Analysis; Pentaho; Data Warehouse; Data Mining; Correlation; Spearman Rank Correlation; Academi; Students