IMPLEMENTASI OLAP BERBASIS METODE KIMBALL UNTUK MENINGKATKAN EFISIENSI ANALISIS DATA PADA PERUM DAMRI CABANG LAMPUNG

Cahnia, Murni and Agharina, Melda (2025) IMPLEMENTASI OLAP BERBASIS METODE KIMBALL UNTUK MENINGKATKAN EFISIENSI ANALISIS DATA PADA PERUM DAMRI CABANG LAMPUNG. Skripsi thesis, Insitut Informatika dan Bisnis Darmajaya.

[img] Text
COVER.pdf
Download (312kB)
[img] Text
HALAMAN PERNYATAAN.pdf
Download (346kB)
[img] Text
HALAMAN PERSETUJUAN.pdf
Download (671kB)
[img] Text
HALAMAN PENGESAHAN.pdf
Download (1MB)
[img] Text
ABSTRACT.pdf
Download (213kB)
[img] Text
DAFTAR ISI.pdf
Download (215kB)
[img] Text
BAB I.pdf
Download (406kB)
[img] Text
BAB II.pdf
Download (572kB)
[img] Text
BAB III.pdf
Download (490kB)
[img] Text
BAB IV.pdf
Download (3MB)
[img] Text
BAB V.pdf
Download (203kB)
[img] Text
DAFTAR PUSTAKA.pdf
Download (425kB)
[img] Text
LAMPIRAN.pdf
Download (345kB)

Abstract

ix ABSTRACT IMPLEMENTATION OF KIMBALL BASED OLAP TO ENHANCE DATA ANALYSIS EFFICIENCY AT PERUM DAMRI LAMPUNG BRANCH Oleh MURNI CAHNIA Murnycahnia06@gmail.com The Lampung Branch of Perum DAMRI faced challenges in analyzing routespecific revenue, driver performance, and fleet optimization based on mileage and income. Operational transaction data had previously been stored in a database without being effectively analyzed, which hindered data-driven decision-making. This study aimed to implement Business Intelligence (BI) technology using Online Analytical Processing (OLAP), following the Kimball methodology, to improve the efficiency of operational data analysis at DAMRI. The research methods included data extraction, transformation, and loading (ETL) using Pentaho; data storage in a MySQL-based data warehouse; and OLAP analysis and data visualization using Tableau. The findings demonstrated that OLAP implementation facilitated the identification of operational trends such as travel patterns, passenger volumes, revenue fluctuations, and the performance of both the fleet and drivers. The resulting interactive dashboard enabled managers to make faster and more accurate decisions, thereby improving operational efficiency and increasing company revenue. Key Words: OLAP, Business Intelligence, Data Warehouse, Kimball Methodology

Item Type: Thesis (Skripsi)
Subjects: Ilmu Komputer
eSkripsi
Divisions: Skripsi/TA & PKPM/KP - Fakultas Ilmu Komputer > Sistem Informasi
Depositing User: Murni Cahnia
Date Deposited: 19 Aug 2025 06:51
Last Modified: 19 Aug 2025 06:51
URI: http://repo.darmajaya.ac.id/id/eprint/21013

Actions (login required)

View Item View Item