Implementation of Business Intelligence In Analyzing Data Using Tableau at PT Global Bintan Permata

Authors

    Guy Ritchie( 1 ) Susanto Hariyanto( 2 )

    (1) Universitas Budhi Dharma
    (2) Universitas Buddhi Dharma

DOI:


https://doi.org/10.32877/bt.v6i1.875

Keywords:


Business Intelligence, Dashboard, Database, Pentaho, Tableau

Abstract

PT Global Bintan Permata is member group Yafindo (Batam, Indonesia) which is engaged in the distribution and import goods consumption and goods consumption throughout Indonesia . one _ business being run is distributing sugar _ throughout modern market and delivery some are via transportation and some are done in a manner independent . The target market namely the big modern market like Alfamart , Alfamidi , Indomarco , Indogrosir , Tiptop, and there is also a small modern market like Totalfruits , Grandlucky , etc. _ Of the many transactions made by the company this company _ This Still Not yet own Dashboard application for monitoring activity operations and transactions . So from it is needed something deep data visualization dashboard shape . Method used to data warehouse design is use method kimball nine-step technology. For the Extract, Transform and Load (ETL) process for data warehouse design using tools in the Pentaho Data Integration application , meanwhile For dashboard visualization is done with use the Tableau Public app . Result of application Tableau Public app is form generated data visualization dashboard reports containing information in form the data visualization it consists of from transaction and marketing data in 2021. Dashboard provides information For know How development sale both product and sales are also developing transactions with customers in 2021 later will become base in taking decisions required by management within PT Global Bintan Permata for help in the process of taking decision.

Downloads

Download data is not yet available.

References

P. Afikah, I. R. Affandi, and F. N. Hasan, “Implementasi Business Intelligence Untuk Menganalisis Data Kasus Virus Corona di Indonesia Menggunakan Platform Tableau,” Pseudocode, vol. 9, no. 1, pp. 25–32, 2022, doi: 10.33369/pseudocode.9.1.25-32.

S. Fitriani and F. N. Hasan, “Sistem Informasi Berbasis Android untuk Meningkatkan Layanan Terhadap Alumni (Studi Kasus: Keluarga Mahasiswa Fakultas Teknik Uhamka),” Pros. Semin. Nas. Teknoka, vol. 5, no. December 2020, pp. 93–100, 2020, doi: 10.22236/teknoka.v5i.360.

R. Gustini and F. N. Hasan, “Perancangan Sistem Aplikasi Monitoring Barang menggunakan Barcode Berbasis Android. (study kasus Toko Chacha cell ITC Cempaka mas),” Pros. Semin. Nas. Teknoka, vol. 5, no. 2502, pp. 87–92, 2020, doi: 10.22236/teknoka.v5i.319.

F. N. Hasan, “Implementasi Sistem Business Intelligence Untuk Data Penelitian di Perguruan Tinggi,” Pros. Semin. Nas. Teknoka, vol. 4, no. 2502, pp. I1–I10, 2019, doi: 10.22236/teknoka.v4i1.3943.

A. Zikri, J. Adrian, A. Soniawan, R. Azim, R. Dinur, and R. Akbar, “Implementasi Business Intelligence untuk Menganalisis Data Persalinan Anak di Klinik Ani Padang dengan Menggunakan Aplikasi Tableau Public,” J. Online Inform., vol. 2, no. 1, p. 20, 2017, doi: 10.15575/join.v2i1.70.

R. Akbar et al., “Implementasi Business Intelligence Untuk Menentukan Tingkat,” J. Ilm. Rekayasa dan Manaj. Sist. Inf., vol. 2, no. 2, pp. 135–138, 2017, [Online]. Available: http://ejournal.uin-suska.ac.id/index.php/RMSI/article/view/3374/2045

S. Pratasik and U. N. Manado, “Perancangan Sistem Business Intelligence Pada Palang Merah Indonesia Daerah Sulawesi Utara Stralen Pratasik Perancangan Sistem Business Intelligence Pada Palang Merah Indonesia Daerah Sulawesi Utara Palang Merah Indonesia ( PMI ) adalah satu-satunya organ,” no. August 2019, 2020.

R. Steven, K., Hariyanto, S., dan Arijanto, “Penerapan Business Intelligence Untuk Menganalisis Data Pada PT. Suryaplas,” J. Algor, vol. Vol.2, no. No.2, pp. 41–50, 2021.

R. Akbar, R. Darman, F. Marizka, J. Namora, and N. Ardewati, “Implementasi Business Intelligence Menentukan Daerah Rawan Gempa Bumi di Indonesia dengan Fitur Geolokasi,” J. Edukasi dan Penelit. Inform., vol. 4, no. 1, p. 30, 2018, doi: 10.26418/jp.v4i1.25518.

D. Saepuloh, “Visualisasi Data Covid 19 Provinsi DKI Menggunakan Tableau,” J. Ris. Jakarta, vol. 13, no. 2, pp. 55–64, 2020, doi: 10.37439/jurnaldrd.v13i2.37.

R. Riksazany and M. Ayub, “Eksplorasi Data Warehouse Penjualan dengan Tableau,” J. Strateg., vol. 1, no. November, p. 574, 2019, [Online]. Available: https://www.tableau.com/products

E. Marvaro and R. Sefina Samosir, “Penerapan Business Intelligence dan Visualisasi Informasi di CV. Mitra Makmur Dengan Menggunakan Dashboard Tableau,” KALBISCIENTIA J. Sains dan Teknol., vol. 8, no. 2, pp. 37–46, 2021, doi: 10.53008/kalbiscientia.v8i2.197.

F. N. Hasan and M. Dwijayanti, “Analisis Sentimen Ulasan Pelanggan Terhadap Layanan Grab Indonesia Menggunakan Multinominal Naïve Bayes Classifier,” J. Linguist. Komputasional, vol. 4, no. 2, pp. 52–58, 2021, doi: https://doi.org/10.26418/jlk.v4i2.61.

D. Fernando, “Visualisasi Data Menggunakan Google Data Studio,” J. Pengabdi. Masy., vol. 2, no. 1, pp. 71–77, 2018, [Online]. Available: https://e-jurnal.lppmunsera.org/index.php/snartisi/article/view/808

D. F. Saputra, “Visualisasi Data Di Sistem Manajemen Perpustakaan,” J. Perpust. Pertan., vol. 26, no. 2, p. 82, 2018, doi: 10.21082/jpp.v26n2.2017.p82-86.

R. Wijaya and B. Pudjoatmodjo, “Penerapan Extraction-Transformation-Loading (ETL) Dalam Data Warehouse (Studi Kasus : Departemen Pertanian),” J. Nas. Pendidik. Tek. Inform., vol. 5, no. 2, p. 61, 2016, doi: 10.23887/janapati.v5i2.9855.

G. A. Udayana, I. M. Y. Mahendra, I. K. A. Sukawirasa, G. D. Dimastawan Saputra, and I. B. M. Mahendra, “Implementasi Data Warehouse Dan Penerapannya Pada PHI-Minimart Dengan Menggunakan Tools Pentaho dan Power BI,” JELIKU (Jurnal Elektron. Ilmu Komput. Udayana), vol. 10, no. 1, p. 163, 2021, doi: 10.24843/jlk.2021.v10.i01.p19.

D. Subuh and W. Yasman, “Implementasi Data Warehouse Dan Penerapannya Pada Toko Magnifique Clothes Dengan Menggunakan Tools Pentaho,” Semin. Nas. Inov. dan Apl. Teknol. di Ind., pp. 29–36, 2019.

G. D. Sonia, “EVALUASI KRITERIA ADOPSI BUSINESS INTELLIGENCE BERBASIS SaaS CLOUD COMPUTING DENGAN MENGUNAKAN METODE FUZZY AHP,” ICT Learn., vol. 3, no. 2, pp. 23–52, 2017, [Online]. Available: http://jurnal.upmk.ac.id/index.php/ictlearning/article/view/460%0Ahttp://jurnal.upmk.ac.id/index.php/ictlearning/article/download/460/316

G. Wijaya, “Perancangan Data Warehouse Nilai Mahasiswa dengan Kimball Nine-Step Methodology,” J. Inform., vol. 4, no. 1, pp. 1-11, 2017.

Downloads

Published

2023-08-25

How to Cite

[1]
Guy Ritchie and S. Hariyanto, “Implementation of Business Intelligence In Analyzing Data Using Tableau at PT Global Bintan Permata”, bit-Tech, vol. 6, no. 1, pp. 40–50, Aug. 2023.

Issue

Section

Articles
DOI : https://doi.org/10.32877/bt.v6i1.875
Abstract views: 594 / PDF downloads: 467