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.
|
Text
41819210017 - Rayhan Muhammad Arsyil - 01 Cover.pdf Download (593kB) | Preview |
|
|
Text
41819210017 - Rayhan Muhammad Arsyil - 02 Abstrak.pdf Download (177kB) | Preview |
|
Text
41819210017 - Rayhan Muhammad Arsyil - 03 BAB 1.pdf Restricted to Registered users only Download (378kB) |
||
Text
41819210017 - Rayhan Muhammad Arsyil - 04 BAB 2.pdf Restricted to Registered users only Download (383kB) |
||
Text
41819210017 - Rayhan Muhammad Arsyil - 05 BAB 3.pdf Restricted to Registered users only Download (502kB) |
||
Text
41819210017 - Rayhan Muhammad Arsyil - 06 BAB 4.pdf Restricted to Registered users only Download (1MB) |
||
Text
41819210017 - Rayhan Muhammad Arsyil - 07 BAB 5.pdf Restricted to Registered users only Download (27kB) |
||
Text
41819210017 - Rayhan Muhammad Arsyil - 09 Daftar Pustaka.pdf Restricted to Registered users only Download (362kB) |
||
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 |