PENERAPAN DATA WAREHOUSE DAN OLAP UNTUK ANALISIS TREN PENJUALAN BERBASIS METODE KIMBALL PADA PT TEGUHWIBAWA SINAR LAUT TULANG BAWANG

Ramadani, Mega and NUGROHO, HANDOYO WIDI (2025) PENERAPAN DATA WAREHOUSE DAN OLAP UNTUK ANALISIS TREN PENJUALAN BERBASIS METODE KIMBALL PADA PT TEGUHWIBAWA SINAR LAUT TULANG BAWANG. Skripsi thesis, Institut Informatika dan Bisnis Darmajaya.

[img] Text
COVER.pdf
Download (118kB)
[img] Text
ABSTRACT.pdf
Download (7kB)
[img] Text
HALAMAN PERNYATAAN.pdf
Download (338kB)
[img] Text
HALAMAN PERSETUJUAN.pdf
Download (648kB)
[img] Text
PENGESAHAN.pdf
Download (847kB)
[img] Text
DAFTAR ISI.pdf
Download (395kB)
[img] Text
BAB I.pdf
Download (130kB)
[img] Text
BAB II.pdf
Download (260kB)
[img] Text
BAB III.pdf
Download (164kB)
[img] Text
BAB IV.pdf
Download (3MB)
[img] Text
BAB V.pdf
Download (11kB)
[img] Text
DAFTAR PUSTAKA.pdf
Download (219kB)

Abstract

ix ABSTRACT IMPLEMENTATION OF DATA WAREHOUSE AND OLAP FOR SALES TREND ANALYSIS USING THE KIMBALL METHOD AT PT TEGUHWIBAWA SINAR LAUT TULANG BAWANG Oleh Mega Ramadani megaramadhani266@gmail.com In the digital era, PT. Teguhwibawa Sinar Laut Tulang Bawang faces challenges in managing Increasingly diverse sales data. One of the recurring issues is inefficiency in product stock management, which often results in the company's inability to fulfill customer demand due to unavailable or depleted inventory. The absence of an integrated system also led to delays in sales trend analysis, ultimately hindering strategic decision-making and reducing the company's competitiveness. To address these issues, an integrated data warehouse system incorporating OLAP technology and the Kimball methodology was implemented. This system enables the company to manage sales data through multidimensional analysis and supports faster, more accurate decision-making. The methodology involved data extraction, transformation, and Toading (ETL) using Pentaho, data storage in a MySQL-based data warehouse, and OLAP analysis and data visualization using Tableau. The results indicated that the system successfully presented multidimensional sales trends, and identified best- selling products, key regions, and payment patterns, all visualized through Tableau dashboards. This supported management in making informed decisions and improving operational efficiency. Keywords: Data Warehouse, OLAP, Kimball, ETL, Tableau, Sales

Item Type: Thesis (Skripsi)
Subjects: Ilmu Komputer
eSkripsi
Divisions: Skripsi/TA & PKPM/KP - Fakultas Ilmu Komputer > Sistem Informasi
Depositing User: Mega Ramadani
Date Deposited: 14 Aug 2025 07:21
Last Modified: 14 Aug 2025 07:21
URI: http://repo.darmajaya.ac.id/id/eprint/20971

Actions (login required)

View Item View Item