Development of Star-Schema Model for Lecturer Performance in Research Activities

Abstract

In this study, the researchers developed a multidimensional data model to investigate the activities of lecturers in universities in carrying out research activities as part of the Three Pillars of Higher Education. Information about lecturers' research activities has been managed using spreadsheet (excel) documents. Thus, access and analysis of the information were limited. Data warehouse development was carried out through several stages, namely requirement analysis, data source analysis, multidimensional modeling, ETL process, and reporting. The information generated in this data warehouse (DW) can be used as one of the business intelligence (BI) models in universities. In this study, the star-schema model was used in designing dimension tables and fact tables to facilitate and speed up the query process. The information generated in this study can be used by management in universities to make decisions and strategic planning. The results of this study can also be used as one of the important information in the preparation of institutional accreditation data and study program accreditation. Keywords-Data warehouse (DW); star-schema; multidimensional data; business intelligence (BI) I. INTRODUCTIONLecturers as one of the intellectual assets in higher education have one of the activities that are part of the Three Pillars of Higher Education, namely carrying out research and community service. Every year there is a lot of funding to carry out research and community service activities. This funding source comes from the ministries of education, culture, research, and technology, as well as from local governments, and internal universities.This research and community service information is used as one of the assessment criteria in the preparation of study program accreditation instruments and university accreditation. Currently, at Politeknik Negeri Sriwijaya, research data and community service are documented at the Research and Community Service Center (Pusat Penelitian dan Pengabdian kepada Masyarakat abbreviated as P3M) Politeknik Negeri Sriwijaya, in the form of spreadsheet (excel) file data, without being further managed into useful information for upper management in the decision-making process.

Data Model Design to Support Data-Driven IT Governance Implementation

“…This section describes the proposed approach used to design and develop the data model and the resulting dashboards to support data-driven governance implementation. The data model of a DWH coupled with a BI system was designed according to the main steps outlined in the literature: (i) requirements analysis; (ii) data source analysis; (iii) data warehouse modelling; ETL process; and (iv) reporting [80,81]. This section describes the proposed approach and the main results obtained in contributing to a datadriven governance implementation.…”

Business Intelligence Untuk Memantau Perkembangan Harga Pangan Provinsi DKI Jakarta

“…Penelitian terdahulu yang berkaitan dengan Business Intelligence yaitu penelitian komparatif tentang kinerja model dimensional (Iqbal et al, 2020); penelitian data warehouse untuk meningkatkan kinerja penelitian dan pelayanan kepada masyarakat (Filiana et al, 2020); penelitian visualisasi data harga dan pasokan beras (Sugiarto et al, 2021); penelitian penerapan sistem intelejensia bisnis dan data mining untuk memantau produksi tanaman obat (Hidayat & Fitriana, 2022); penelitian model sistem Intelegensia Bisnis dan data mining untuk layanan maskapai penerbangan (Fitriana et al, 2019); penelitian star-schema model untuk meningkatkan kinerja dosen dalam aktivitas penelitian (Amin et al, 2021).…”