Perancangan datawarehouse dan teknologi business intelligence untuk analisa penjualan pada perusahaan retail PT. ABC
PT. ABC is one of the retail industries. PT. ABC already has 378 stores spread across Bali, Lombok, and Makassar. Curently PT. ABC has a POS cashier system and warehouse management system to help run its business processes. The problem that often occurs is when the data is more and more, the process of data analysis becomes less optimal because the data is processed very much and to many users who use the system. Thus datawarehouse and business intelligence technology are needed to process data and visualize data into information that can be easily analyzed by stakeholders. Datawarehouse modeling method used in this study is the nine steps kimball method, for ETL process tools are used from Pentaho data integration, and the data visualization process is used power business intelligence tools to be able to display data in graphical form so that stakeholders can analyze data quickly and easily. The application of data warehouses and business intelligence technology can be used and produce information that matches the needs obtained in the analysis of functional requirements. This is evidenced by the results of black box testing that has been received by all stakeholders of PT. ABC.
W. N. Setyo and S. Wardhana, “Implementasi Data Mining Pada Penjualan Produk Di CV Cahaya Setya Menggunakan Algoritma FP-Growth,” PETIR, vol. 12, no. 1, pp. 54–63, Apr. 2019.
E. Triandini, M. S. Rijal, and M. P. Ambara, “Implementasi Star Schema Dalam Pembangunanan Data Warehouse Penjualan Produk Tour,” vol. 12, no. 1, pp. 23–33, Apr. 2020.
A. Dwiputra Wijaya and T. Gantini, “Analisis Forecasting dengan Implementasi Dashboard Business Intelligence Untuk Data Penjualan Pada PT. ‘X,’” Nov. 2019.
L. Setiyani and A. Gintings, “Analisis Kebutuhan Fungsional Sistem Informasi Pengelolaan Skripsi,” Simp. Nas. Ilm. Call Pap. Unindra, vol. 0, no. 0, 2019.
I. G. W. Darma, K. S. Utami, and N. W. S. Aryani, “Data Warehouse Analysis to Support UMKM Decisions using the Nine-step Kimball Method,” Int. J. Eng. Emerg. Technol., vol. 4, no. 1, pp. 65–68, Oct. 2019.
E. K. Suni, “Analisis Dan Perancangan Data Warehouse Untuk Mendukung Keputusan Redaksi Televisi Menggunakan Metode Nine-Step Kimball,” J. Tek. Inform., vol. 11, no. 2, pp. 197–206, Nov. 2018.
D. Sugiarto, H. L. H. S. Warnars, and W. Winarno, “Perancangan Data Warehouse Penjualan (Studi Kasus Pt. Subafood Pangan Jaya),” Semnas Ristek (Seminar Nas. Ris. dan Inov. Teknol. 2020, vol. 4, no. 1, Jan. 2020.
Y. Oslan and D. H. Kristanto, “Proses ETL (Extract Transformation Loading) Data Warehouse Untuk Peningkatan Kinerja Biodata Dalam Menyajikan Profil Mahasiwa Dari Dimensi Asal Sekolah Studi Kasus: Biodata Mahasiswa UKDW,” Res. FAIR UNISRI, vol. 3, no. 1, Jan. 2019.
T. S. Jaya, “Pengujian Aplikasi dengan Metode Blackbox Testing Boundary Value Analysis (Studi Kasus: Kantor Digital Politeknik Negeri Lampung),” J. Inform. Pengemb. IT, vol. 3, no. 2, pp. 45–46, Jan. 2018.
R. T. Yunandar, A. Amir, and K. Rizal, “Perancangan Data Warehouse Untuk Informasi Strategi Studi Kasus Penerimaan Siswa Baru STIE Binaniaga Bogor,” J. Tek. Komput., vol. 6, no. 1, pp. 111–120, Jan. 2020.
V. Novreza, Y. Munarko, and L. Husniah, “Data Warehouse Menggunakan Snowflake Schema Pada Virtual Shop,” J. Repos., vol. 2, no. 1, pp. 67–78, Jan. 2020.
G. Wijaya, “Perancangan Data Warehouse Nilai Mahasiswa Dengan Kimball Nine-Step Methodology,” J. Inform., vol. 4, pp. 1–11, 2017.
R. Akbar, D. Rasyiddah, M. Anrisya, N. F. Julyazti, and S. Syaputri, “Penerapan Aplikasi Power Business Intelligence Dalam Menganalisis Prioritas Pekerjaan di Indonesia,” J. Edukasi dan Penelit. Inform., vol. 4, no. 1, p. 54, Jun. 2018.
Copyright (c) 2020 Rabit : Jurnal Teknologi dan Sistem Informasi Univrab
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Please find the rights and licenses in RABIT : Jurnal Teknologi dan Sistem Informasi Univrab. By submitting the article/manuscript of the article, the author(s) accept this policy.
The non-commercial use of the article will be governed by the Creative Commons Attribution license as currently displayed on Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
2. Author’s Warranties
The author warrants that the article is original, written by stated author(s), has not been published before, contains no unlawful statements, does not infringe the rights of others, is subject to copyright that is vested exclusively in the author and free of any third party rights, and that any necessary written permissions to quote from other sources have been obtained by the author(s).
3. User Rights
RABIT's spirit is to disseminate articles published are as free as possible. Under the Creative Commons license, RABIT permits users to copy, distribute, display, and perform the work for non-commercial purposes only. Users will also need to attribute authors and RABIT on distributing works in the journal.
4. Rights of Authors
Authors retain all their rights to the published works, such as (but not limited to) the following rights;
- Copyright and other proprietary rights relating to the article, such as patent rights,
- The right to use the substance of the article in own future works, including lectures and books,
- The right to reproduce the article for own purposes,
- The right to self-archive the article,
- The right to enter into separate, additional contractual arrangements for the non-exclusive distribution of the article's published version (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal (RABIT : Jurnal Teknologi dan Sistem Informasi Univrab).
If the article was jointly prepared by other authors, any authors submitting the manuscript warrants that he/she has been authorized by all co-authors to be agreed on this copyright and license notice (agreement) on their behalf, and agrees to inform his/her co-authors of the terms of this policy. RABIT will not be held liable for anything that may arise due to the author(s) internal dispute. RABIT will only communicate with the corresponding author.
This agreement entitles the author to no royalties or other fees. To such extent as legally permissible, the author waives his or her right to collect royalties relative to the article in respect of any use of the article by RABIT.
RABIT will publish the article (or have it published) in the journal if the article’s editorial process is successfully completed. RABIT's editors may modify the article to a style of punctuation, spelling, capitalization, referencing and usage that deems appropriate. The author acknowledges that the article may be published so that it will be publicly accessible and such access will be free of charge for the readers as mentioned in point 3.