Visualization of Sales Danalyser Data in Dashboard Form Google Data Studio
DOI:
https://doi.org/10.56313/jictas.v2i2.270Keywords:
Dasboard, Visualization, Google Data Studio, Sales datalyserAbstract
In the business sector, the use of information technology is used as a means of supporting company performance. Data visualization is the answer to simplifying complex data into a graphical format so that it is easier to understand the business. Managing sales data is an important process that must be carried out by companies. With good data management, companies get more value. This added value includes information supporting decision making, in order to increase the efficiency and effectiveness of company operations. This research uses data on sales of goods obtained from the internet, namely 69 data. The research was carried out with the help of Google Data Studio tools for creating dashboards. The results obtained are that there are several elements that help make it easier to read information, namely scorecard elements, Pie Chart elements, bar chart elements, geographic diagram elements, and table elements. The Scorecard element displays total income, average price of goods, total items sold, and total buyers. In the Pie Chart, the product insight is displayed in percent, the items that sell best are P010. The bar chart element displays total sales for each month, the highest sales were in August 2021. The geographic diagram element displays the distribution of sales to various countries. The table element displays insight information on price cuts or discounts.
References
R. Akbar, M. Silvana, M. H. Hersyah, and M. Jannah, “Implementation of Business Intelligence for Sales Data Management Using Interactive Dashboard Visualization in XYZ Stores,” 2020. doi: 10.1109/ICITSI50517.2020.9264984.
W. Z. J. S. Yangyang Zhang, Chenfan Sun, “Statistics Analysis and Visualization for Big Data of E-commerce Platform Sales Evaluation,” CONVERTER, 2021, doi: 10.17762/converter.136.
J. F. A. Siahaan, D. Sugiarto, and T. Siswanto, “Designing Data Warehouse For Forecast and Data Visualization of Sales Nutrition Products,” Intelmatics, vol. 1, no. 2, 2021, doi: 10.25105/itm.v1i2.5235.
W. Yunus, R. I. Desanti, and W. Wella, “Data Visualization And Sales Prediction of PD. Asia Agung (Ajinomoto) Pontianak in 2019,” IJNMT (International J. New Media Technol., vol. 7, no. 2, 2020, doi: 10.31937/ijnmt.v7i2.1697.
J. Jondri and A. A. Rohmawati, “PELATIHAN VISUALISASI DAN ANALISIS DATA MENGGUNAKAN TABLEAU DI SMKN 3 BANDUNG,” Charity, vol. 4, no. 2, 2021, doi: 10.25124/charity.v4i2.3435.
M. H. Allaymoun, M. Khaled, F. Saleh, and F. Merza, “Data Visualization and Statistical Graphics in big data analysis by Google Data Studio - Sales Case Study.,” 2022. doi: 10.1109/TEMSCONEUROPE54743.2022.9801964.
P. Khadapkar, “How to build a BI dashboard using Google Data Studio and BigQuery | Google Cloud Big Data and Machine Learning Blog | Google Cloud Platform,” Google Cloud Platform, 2017.
L. M. Hudiburgh and D. Garbinsky, “Data Visualization: Bringing Data to Life in an Introductory Statistics Course,” J. Stat. Educ., vol. 28, no. 3, 2020, doi: 10.1080/10691898.2020.1796399.
S. K. Choubey and H. Naman, “A review on use of data science for visualization and prediction of the covid-19 pandemic and early diagnosis of covid-19 using machine learning models,” Stud. Big Data, vol. 80, 2020, doi: 10.1007/978-981-15-8097-0_10.
D. Apriani, M. Aan, and W. E. Saputra, “Data Visualization Using Google Data Studio,” Int. J. Cyber IT Serv. Manag., vol. 2, no. 1, 2022, doi: 10.34306/ijcitsm.v2i1.68.
D. Misnawati, T. Duha, A. R. Sari, G. Al Haddar, and I. H. Kusnadi, “Data Visualization of the Number of Foreign And Domestic Tourist Visits to East Nusa Tenggara Using Google Data Studio,” Infokum, vol. 10, no. 4, 2022.
F. N. Hayati, M. Silfiani, and D. Nurlaily, “PEMANFAATAN GOOGLE DATA STUDIO UNTUK VISUALISASI E-RAPOR SISWA SMAN 2 BALIKPAPAN,” J. Pengabdi. Kpd. Masy. ITK, vol. 2, no. 2, 2021, doi: 10.35718/pikat.v2i2.619.
N. F. Hayati, M. Silfiani, and D. Nurlaily, “Pemanfaatan Google Data Studio Untuk Visualisasi Data Bagi,” J. Pengabdi. Kpd. Masy., vol. 2, no. 2, 2021.
Meredith Hart, “10 Contoh Dasbor Penjualan Yang Akan Membantu Anda Menyiapkannya Sendiri,” blog.hubspot.com, 2023.
H. Sulistiani et al., “Google Spreadsheet Training for Teacher at SMK N 1 Padang Cermin,” J. Eng. Inf. Technol. Community Serv., vol. 1, no. 2, 2022, doi: 10.33365/jeit-cs.v1i2.145.
