PENGEMBANGAN APLIKASI REAL-TIME BUSINESS INTELLIGENCE BERBASIS WEB UNTUK SUBJEK KEGIATAN AKADEMIK PADA UNIVERSITAS

摘要

Academic activities at Universitas Atma Jaya Yogyakarta (UAJY) runs continuously and add more data to the existing operational system. This data still can not be used by the university for strategic decision making. Currently, decisions are made based on habits and general logic that not based on a comprehensive data and facts. Meanwhile, preparing reports required for accreditation purposes and preparing reports on academic units.udReal-time business intelligence (BI) application using data warehouse to be solution for data analysis. The process of creating a data warehouse includes design of data warehouse; retrieval of academic data from multiple data sources; extraction, transformation, loading (ETL) process; cube creation; and report generation. ETL processes are conducted using Pull Change Data Capture approach so that data changes during a certain period can be transferred in realtime. The tools used are Microsoft Visual Studio 2008, SQL Server 2008 and Report Portal 4.0.udWith the implementation of this application, is expected to meet the university management needs to know information about the academic activities, assist in reporting, and help make decisions more effectively and efficiently compared to just using intuition.ududud