TRANSFORMASI DATA PENJUALAN UNTUK PERANCANGAN DATA WAREHOUSE MENGGUNAKAN METODE KIMBALL

RAHMITA, HUTAMI (2024) TRANSFORMASI DATA PENJUALAN UNTUK PERANCANGAN DATA WAREHOUSE MENGGUNAKAN METODE KIMBALL. S1 thesis, Universitas Mercu Buana Jakarta.

[img]
Preview
Text (HAL COVER)
1. Hal Cover.pdf

Download (1MB) | Preview
[img]
Preview
Text (ABSTRAK)
2. Abstrak.pdf

Download (130kB) | Preview
[img] Text (BAB I)
3. BAB I.pdf
Restricted to Registered users only

Download (293kB)
[img] Text (BAB II)
4. BAB II.pdf
Restricted to Registered users only

Download (447kB)
[img] Text (BAB III)
5. BAB III.pdf
Restricted to Registered users only

Download (1MB)
[img] Text (BAB IV)
6. BAB IV.pdf
Restricted to Registered users only

Download (2MB)
[img] Text (BAB V)
7. BAB V.pdf
Restricted to Registered users only

Download (111kB)
[img] Text (DAFTAR PUSTAKA)
8. Daftar Pustaka.pdf
Restricted to Registered users only

Download (136kB)
[img] Text (LAMPIRAN)
9. Lampiran.pdf
Restricted to Registered users only

Download (245kB)

Abstract

The objective of this research is to transform three distinct datasets (product, customer, transaction) into data warehouses utilising Kimball's nine-step method. The application of information systems in the sales industry employs modern information technology to manage big data in an efficient manner, which is of vital importance for strategic decisions. However, sales data frequently exhibits inappropriate formats and structures, thereby complicating analysis. This research improves the presentation of data on transaction datasets by separating metadata such as product_id, quantity, and item_price. This facilitates data integration and improves efficiency. Secondary data obtained from Kaggle's site, covering 44,447 product data lines, 100,001 customer data lines and 852,585 sales transaction data lines with a total of 1,193,024 data lines from 2016 to 2022, was subjected to data transformation using Pentaho Data Integration. The nine-step method proposed by Kimball was employed in this process. The ETL process successfully combines three datasets into a single data warehouse, comprising one fact transaction table and five dimensional tables: one for products, one for customers, one for payments, one for promotions, and one for shipments. This enables more detailed and structured sales analysis. The data transformation process successfully addresses data format and structure issues in transaction datasets by separating product metadata and modifying non-compliant values in relevant columns. Keywords: Data Transformation, Data Warehouse, ETL, Kimball's Nine Step Method, Data Integration, Sales Data Penelitian ini bertujuan untuk mentransformasi tiga dataset terpisah (produk, pelanggan, transaksi) ke dalam data warehouse menggunakan metode sembilan langkah Kimball. Penerapan sistem informasi dalam industri penjualan memanfaatkan teknologi informasi modern untuk mengelola data besar secara efisien, yang sangat penting untuk keputusan strategis. Namun, data penjualan seringkali memiliki format dan struktur yang tidak sesuai, mempersulit analisis. Penelitian ini memperbaiki penyajian data pada dataset transaksi dengan memisahkan metadata seperti product_id, quantity, dan item_price untuk mempermudah integrasi data dan meningkatkan efisiensi. Data sekunder diperoleh dari situs Kaggle, meliputi 44,447 baris data produk, 100,001 baris data pelanggan, dan 852,585 baris data transaksi penjualan, dengan total 1,193,024 baris data dari 2016 hingga 2022. Metode sembilan langkah Kimball diterapkan dalam transformasi data menggunakan Pentaho Data Integration. Proses ETL ini berhasil menggabungkan tiga dataset menjadi satu data warehouse yang terdiri dari satu tabel fact transaction dan lima tabel dimensi dim product, dim customer, dim payment, dim promo, dim shipment, memungkinkan analisis penjualan yang lebih mendalam dan terstruktur. Proses transformasi data berhasil menangani masalah format dan struktur data pada dataset transaksi, dengan memisahkan product metadata serta membersihkan dan mengubah nilai-nilai yang tidak sesuai dalam kolom-kolom yang relevan. Keyword : Transformasi data, Data Warehouse, ETL, Metode Nine Step Kimball, Integrasi Data, Data Penjualan

Item Type: Thesis (S1)
Call Number CD: FIK/SI. 24 102
NIM/NIDN Creators: 41820010029
Uncontrolled Keywords: Transformasi data, Data Warehouse, ETL, Metode Nine Step Kimball, Integrasi Data, Data Penjualan
Subjects: 000 Computer Science, Information and General Works/Ilmu Komputer, Informasi, dan Karya Umum > 000. Computer Science, Information and General Works/Ilmu Komputer, Informasi, dan Karya Umum > 000.01-000.09 Standard Subdivisions of Computer Science, Information and General Works/Subdivisi Standar Dari Ilmu Komputer, Informasi, dan Karya Umum
000 Computer Science, Information and General Works/Ilmu Komputer, Informasi, dan Karya Umum > 000. Computer Science, Information and General Works/Ilmu Komputer, Informasi, dan Karya Umum > 005 Computer Programmming, Programs, Data/Pemprograman Komputer, Program, Data > 005.7 Data in Computer Systems/Data dalam Sistem-sistem Komputer > 005.75 Specific Types of Data Files and Databases/Jenis Spesifik File Data dan Pangakalan Data > 005.758 Distributed Data Files and Databases/File Data Terdistribusi dan Pangakalan Data Berorientasi Objek
600 Technology/Teknologi > 650 Management, Public Relations, Business and Auxiliary Service/Manajemen, Hubungan Masyarakat, Bisnis dan Ilmu yang Berkaitan > 658 General Management/Manajemen Umum > 658.8 Marketing, Management of Distribution/Marketing, Manajemen Distribusi
Divisions: Fakultas Ilmu Komputer > Sistem Informasi
Depositing User: khalimah
Date Deposited: 25 Jul 2024 04:50
Last Modified: 25 Jul 2024 04:50
URI: http://repository.mercubuana.ac.id/id/eprint/89824

Actions (login required)

View Item View Item