Claim Missing Document
Check
Articles

Found 2 Documents
Search
Journal : RJOCS (Riau Journal of Computer Science)

Analisa Visualisasi Data Penjualan dan Tingkat Kepuasan Penjualan Menggunakan Platform Lookerstudio Arfandi, Zirhan; Yanto, Budi; Sabri, Khairul; Aini, Yulfita; Lubis, Adyanata
RJOCS (Riau Journal of Computer Science) Vol. 10 No. 1 (2024): RJOCS (Riau Journal of Computer Science)
Publisher : Fakultas Ilmu Komputer, Universitas Pasir Pengaraian

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.30606/rjocs.v10i1.2402

Abstract

Data management in projects is an important activity in a company because over time the company develops more and more versatile data it has. Growing and highly complex business and supply of goods on a large scale makes data processing difficult. In the current situation, data processing starting from exporting, filtering data, analyzing and visualizing data is still done using Excel files which takes quite a long time, so that management decision making is still not optimal. . The purpose of this research is to provide users with important information and data in real time to speed up the decision-making process. Therefore, the data must be analyzed using the exploratory data analysis (EDA) method. EDA is carried out starting from understanding business objects, with revenue/sales as one of the metrics used to see the company's performance profile and the correlation of other variables. target knife The results of this study indicate that monthly sales comparisons, sales comparisons for each product and composition have the lowest sales generation and customer satisfaction, so that they can be used as material for management evaluation and EDA results can be seen in data visualization applications
Visualisasi BigQuery Data Penjualan Toko Sembako Menggunakan Flatfrom Loker Studio Zai, Feri Irawan; Riki Mustafa, Satria; Aini, Yulfita; Agung Setiawan; Maulana Dwi Sena
RJOCS (Riau Journal of Computer Science) Vol. 10 No. 1 (2024): RJOCS (Riau Journal of Computer Science)
Publisher : Fakultas Ilmu Komputer, Universitas Pasir Pengaraian

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.30606/rjocs.v10i1.2403

Abstract

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