IMPLEMENTASI DIMENSIONAL MODELING DALAM EXECUTIVE INFORMATION SYSTEM SERTIFIKASI INTERNASIONAL DI ITCC

SIHOMBING, JOEY ANDREW FRANSISCO and Jatnika, Hendra and Palupiningsih, Pritasari (2024) IMPLEMENTASI DIMENSIONAL MODELING DALAM EXECUTIVE INFORMATION SYSTEM SERTIFIKASI INTERNASIONAL DI ITCC. Diploma thesis, ITPLN.

[thumbnail of 202031073_Joey Andrew Fransisco Sihombing_Rev_JOEY ANDREW FRANSISC.pdf] Text
202031073_Joey Andrew Fransisco Sihombing_Rev_JOEY ANDREW FRANSISC.pdf
Restricted to Registered users only

Download (6MB)

Abstract

Information Technology Certification Center atau yang dikenal juga dengan ITCC merupakan laboratorium di Institut Teknologi PLN yang memiliki hak untuk melakukan pelatihan dan sertifikasi Internasional. Berdasarkan laman resmi, ITCC telah mensertifikasi 6853 peserta yang terbagi menjadi 5 pelatihan dan sertifikasi. Selama ini, ITCC menyajikan data sertifikasi dalam LPJ dan Microsoft Excel. Kedua metode tersebut rentan terhadap kerusakan dan kehilangan file fisik, human error, memerlukan waktu yang lama untuk pencarian data serta biaya tambahan dalam pembaruan. Penelitian ini bertujuan membangun dashboard Executive Information System (EIS) interaktif dan dinamis menggunakan metode dimensional modeling dalam membangun data warehouse EIS yang menggunakan teknik star schema. Dimensional modeling digunakan karena dirancang untuk mendukung kebutuhan dalam analisis dan pelaporan. Star schema dipilih karena memiliki query yang simpel, desain sederhana dan pemeliharaan yang mudah. phpMyAdmin digunakan sebagai tempat penyimpanan data warehouse, kemudian dihubungkan ke Microsoft Power BI untuk pembuatan dashboard. Hasil evaluasi dilakukan oleh tim ITCC yaitu proctor dan trainer, dekan ITPLN, wakil dekan ITPLN, kaprodi ITPLN dan asisten ITCC serta pemangku kepentingan menunjukan hasil sangat memuaskan dan telah menyajikan data sangat baik dengan skor kepuasan 95%. Namun dashboard tersebut diharapkan dapat dikembangkan kembali dengan menambahkan logo-logo sertifikasi di ITCC dan dapat menambahkan data secara realtime.

The Information Technology Certification Center or also known as ITCC is a laboratory at the PLN Institute of Technology that has the right to conduct international training and certification. Based on the official website, ITCC has certified 6853 participants which are divided into 5 training and certifications. So far, ITCC has presented certification data in LPJ and Microsoft Excel. Both methods are susceptible to physical file corruption and loss, human error, long time for data retrieval and additional costs in updates. This research aims to build an interactive and dynamic Executive Information System (EIS) dashboard using the dimensional modeling method in building an EIS data warehouse using the star schema technique. Dimensional modeling is used because it is designed to support the needs in analysis and reporting. Star schema was chosen because it has simple queries, simple design and easy maintenance. phpMyAdmin is used as a data warehouse store, then connected to Microsoft Power BI for dashboard creation. The results of the evaluation carried out by the ITCC team, namely the proctor and trainer, the dean of ITPLN, the vice dean of ITPLN, the head of the ITPLN study program and ITCC assistants and stakeholders showed very satisfactory results and had presented very good data with a satisfaction score of 95%. However, the dashboard is expected to be redeveloped by adding certification logos in ITCC and can add data in real-time.

Item Type: Thesis (Diploma)
Uncontrolled Keywords: Dimesional Modeling, Data Warehouse, Four Step Method, Dashboard, Executive Information System Dimesional Modeling, Data Warehouse, Four Step Method, Dashboard, Executive Information System
Subjects: Skripsi
Bidang Keilmuan > Teknik Informatika
Divisions: Fakultas Telematika Energi > S1 Teknik Informatika
Depositing User: Sudarman
Date Deposited: 30 Sep 2025 06:31
Last Modified: 30 Sep 2025 06:31
URI: https://repository.itpln.ac.id/id/eprint/1563

Actions (login required)

View Item
View Item