PENERAPAN BUSINESS INTELLIGENCE PADA DATA PENJUALAN MENGGUNAKAN METODE SINGLE EXPONENTIAL SMOOTHING (STUDI KASUS: PT. ASDF)

ARSYIL, RAYHAN MUHAMMAD (2023) PENERAPAN BUSINESS INTELLIGENCE PADA DATA PENJUALAN MENGGUNAKAN METODE SINGLE EXPONENTIAL SMOOTHING (STUDI KASUS: PT. ASDF). S1 thesis, Universitas Mercu Buana Bekasi.

[img]
Preview
Text
41819210017 - Rayhan Muhammad Arsyil - 01 Cover.pdf

Download (593kB) | Preview
[img]
Preview
Text
41819210017 - Rayhan Muhammad Arsyil - 02 Abstrak.pdf

Download (177kB) | Preview
[img] Text
41819210017 - Rayhan Muhammad Arsyil - 03 BAB 1.pdf
Restricted to Registered users only

Download (378kB)
[img] Text
41819210017 - Rayhan Muhammad Arsyil - 04 BAB 2.pdf
Restricted to Registered users only

Download (383kB)
[img] Text
41819210017 - Rayhan Muhammad Arsyil - 05 BAB 3.pdf
Restricted to Registered users only

Download (502kB)
[img] Text
41819210017 - Rayhan Muhammad Arsyil - 06 BAB 4.pdf
Restricted to Registered users only

Download (1MB)
[img] Text
41819210017 - Rayhan Muhammad Arsyil - 07 BAB 5.pdf
Restricted to Registered users only

Download (27kB)
[img] Text
41819210017 - Rayhan Muhammad Arsyil - 09 Daftar Pustaka.pdf
Restricted to Registered users only

Download (362kB)
[img] Text
41819210017 - Rayhan Muhammad Arsyil - 10 Lampiran.pdf
Restricted to Registered users only

Download (946kB)

Abstract

PT. ASDF merupakan perusahaan industri dengan fokus memproduksi tepung tapioka dan singkong, yang mana sistem pencatatan penjualan masih dilakukan secara manual. Sehingga penelitian ini dilakukan pembuatan data warehouse dengan metodologi Nine-Steps Kimball dengan menggunakan star schema yang menghasilkan 1 tabel fakta dan 5 tabel dimensi. Pada penelitian ini dilakukan peramalan untuk memperkirakan penentuan produksi tepung untuk 3 bulan ke depan menggunakan model Single Exponential Smoothing dengan akurasi MAPE. Tujuan penelitian ini adalah melakukan visualisasi data perkembangan bisnis dan menampilkan hasil prediksi perencanaan jumlah produksi kategori tepung. Hasil visualisasi menunjukkan bahwa penjualan tepung mengalami peningkatan hingga kuartal akhir tahun. Dari hasil perhitungan peramalan menunjukkan bahwa rata-rata nilai MAPE yaitu 0.15. Hal ini menunjukkan peramalan yang telah dilakukan tidak bisa dijadikan acuan perusahaan dikarenakan hasil akurasi yang rendah serta grafik peramalan dengan data aktual yang tidak seimbang. Kata Kunci: Business Intelligence, Peramalan, Nine Step Kimball, Single Exponential Smoothing PT. ASDF is an industrial company with a focus on producing tapioca and cassava flour, where the sales recording system is still done manually. So this research was carried out to create a data warehouse with Kimball's Nine Steps methodology using a star schema, which resulted in 1 fact table and 5 dimension tables. In this study, forecasting was carried out to estimate the determination of flour production for the next 3 months using the single exponential smoothing model with MAPE accuracy. The purpose of this research is to visualize business development data and display the results of predictions for planning the amount of flour category production. The visualization results show that flour sales have increased until the final quarter of the year. The results of forecasting calculations show that the average MAPE value is 0.15. This shows that the forecasting that has been done cannot be used as a company reference due to low accuracy results and unbalanced forecasting charts with actual data. Keywords: Business Intelligence, Forecasting, Nine Step Kimball, Single Exponential Smoothing

Item Type: Thesis (S1)
Call Number CD: FIK/SI 23 017
NIM/NIDN Creators: 41819210017
Uncontrolled Keywords: Business Intelligence, Peramalan, Nine Step Kimball, Single Exponential Smoothing
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
Divisions: Fakultas Ilmu Komputer > Sistem Informasi
Depositing User: siti maisyaroh
Date Deposited: 03 Oct 2023 06:15
Last Modified: 03 Oct 2023 06:15
URI: http://repository.mercubuana.ac.id/id/eprint/81843

Actions (login required)

View Item View Item