Visualisasi BigQuery Data Penjualan Toko Sembako Menggunakan Flatfrom Loker Studio
DOI:
https://doi.org/10.30606/rjocs.v10i1.2403Keywords:
Data Penjualan Sembako, Lokerstudio, Biq Query, Visualisasi DataAbstract
In today's digital era, grocery stores often use the Loker Studio and BigQuery platforms to analyze their sales data. In this study, we analyzed data on grocery store sales using this platform. First of all, we collect sales data from grocery stores that use the Loker Studio platform. This data includes information such as sales dates, products sold, prices, sales quantities, and more. We then transfer this data to BigQuery, a powerful database and data analytics platform. Next, we perform the data analysis steps using BigQuery. We use queries to analyze sales trends, find bestselling products, identify customer buying patterns, and evaluate grocery store performance over time. In addition, we also conduct customer segmentation analysis to understand their preferences and buying habits. The results of this data analysis provide valuable insights to grocery stores. By looking at sales trends, grocery stores can identify popular products and increase their stock. Analyzing customer purchasing patterns helps grocery stores optimize marketing strategies and target promotional campaigns more effectively. In addition, customer segmentation analysis enables grocery stores to provide more personalized and relevant services to their customers. By using the Loker Studio and BigQuery platforms, grocery stores can easily collect, manage and analyze their sales data. This helps them in taking better decisions and improving their business performance
Downloads
References
] Reichenbach, A., Bringmann, A., Reader, E. E., Pournaras, C. J., Rungger-Brändle, E., Riva, C. E., Hardarson, S. H., Stefansson, E., Yard, W. N., Newman, E. A., & Holmes, D. (2019). No 主観的健康感を中心とした在宅高齢者における 健康関連指標に関する共分散構造分析Title. Progress in Retinal and Eye Research, 561(3), S2–S3.
] Muhammad Haekal, T., Hasanuddin, & Pratama, S. (2021). Aplikasi Penjualan Berbasis Web Di Toko Sembako Indung Mayang Martapura. Sistem Informasi Dan Teknologi Informasi Universitas Islam Kalimantan, 1–10.
] Husin, N. (2020). Sistem Pemesanan Grosir Sembako berbasis Web pada Toko Indra Jakarta Timur. Jurnal Esensi Infokom : Jurnal Esensi Sistem Informasi Dan Sistem Komputer, 4(1), 19–24. https://doi.org/10.55886/infokom.v4i1.316
] Student, M. T., Kumar, R. R., Omments, R. E. C., Prajapati, A., Blockchain, T.-A., Ml, A. I., Randive, P. S. N., Chaudhari, S., Barde, S., Devices, E., Mittal, S., Schmidt, M. W. M., Id, S. N. A., PREISER, W. F. E., OSTROFF, E., Choudhary, R., Bit-cell, M., In, S. S., Fullfillment, P., … Fellowship, W. (2021). No 主観的健康感を中心とした在宅高齢者における 健康関連指標に関する共分散構造分析Title. Frontiers in Neuroscience, 14(1), 1–13.
] B. Yanto, W. Eka Putra, and F. Erwis, “Visualization of Covid-19 Data in Indonesia in 2022 through the Google Data Studio Dashboard,” J. Ict Apl. Syst., vol. 2, no. 1, pp. 29–34, 2023, doi: 10.56313/jictas.v2i1.237.
] B. Yanto, A. Sudaryanto, and Hasri Ainun Pratiwi, “Data Visualization Analysis of Waste Production Volume in Every District of Tangerang Regency in 2021 Using Looker Studio and Big Query Platforms,” J. Ict Apl. Syst., vol. 2, no. 1, pp. 35–40, 2023, doi: 10.56313/jictas.v2i1.239.
] Purnama, A. (2020). Pengaruh Harga Dan Kualitas Pelayanan Terhadap Kepuasan Pelanggan Pada Pt. Hokindo Perkasa. Value : Jurnal Manajemen Dan Akuntansi, 15(1), 81–89. https://doi.org/10.32534/jv.v15i1.1021
] Fitri, M., Jamalludin, J., & WM Vermila, C. (2019). Analisis Kepuasan Konsumen Terhadap Produk Sembako Pada Minimarket Juan Di Kecamatan Benai Kabupaten Kuantan Singingi. Optima, 3(1). https://doi.org/10.33366/optima.v3i1.1251
] Fernando, D. (2018). Visualisasi Data Menggunakan Google Data Studio. Jurnal Pengabdian Masyarakat, 2(1), 71–77. https://e-jurnal.lppmunsera.org/index.php/snartisi/article/view/808
] Haryanto, B., & Gata, G. (2019). Sistem informasi penjualan dan pembelian sembako pada toko masa genae berbasis object oriented. Jurnal Sistem Informasi Penjualan, 2(1), 144–150. https://jom.fti.budiluhur.ac.id/index.php/IDEALIS/article/view/1377/684
] Manihuruk, W. H., Kevin Perdana, & Heliyanto. (2020). Sistem Informasi Penjualan Sembako Berbasis Website Pada Ud. Bintan Jaya. Jurnal Bangkit Indonesia, 9(1), 118–125. https://doi.org/10.52771/bangkitindonesia.v9i1.142
] Mahayana, I. P. G. B., Suarjaya, I. M. A. D., & Putri, G. A. A. (2022). Rancang Bangun Sistem Informasi Toko Sembako Berbasis Android Dengan Studi Kasus Toko Raja Sosis. JITTER-Jurnal Ilmiah Teknologi Dan Komputer, 3(2).
] Sudarnaya, K., Nurjiasih, L. Y., Mahandika, M. B., & Guritna4, K. D. (2022). Analisis Umkm Toko Sembako Jans77. Ruang Cendekia : Jurnal Pengabdian Kepada Masyarakat, 1(1), 39–43. https://jurnal.arkainstitute.co.id/index.php/ruang-cendekia/article/view/16
