ENHANCING COLLABORATION DATA MANAGEMENT THROUGH DATA WAREHOUSE DESIGN: MEETING BAN-PT ACCREDITATION AND KERMA REPORTING REQUIREMENTS IN HIGHER EDUCATION

In higher education institutions, effective management of collaboration data is crucial for academic reporting and strategic planning. This study addresses the challenges of managing diverse data types and the necessity for streamlined data management to meet BAN-PT accreditation and Kerma reporting requirements. It aims to design and implement a data warehouse utilizing the star schema for improved accessibility and decision-making. Highlighting the development process, special emphasis is placed on the Extract, Transform, Load (ETL) process with Pentaho to assure data integrity and quality. The methodology involves a systematic approach to constructing the data warehouse, aimed at resolving identified challenges through efficient data organization and quality management. Results demonstrate significant enhancements in data accessibility, reporting efficiency, and quality, leading to reduced administrative efforts and improved decision-making. The research also considers the wider implications of such data management systems in academic administration, suggesting the potential of data warehouses in higher education as benchmarks for similar institutional challenges. Future research directions are recommended for optimizing data warehouse designs and adapting to evolving academic standards, underlining the critical role of advanced data management in meeting stringent accreditation and reporting needs, thus providing a model for technology-driven solutions in educational data management.