Data Warehouse Design For Sales Transactions on CV. Sumber Tirta Anugerah
DOI:
https://doi.org/10.24014/coreit.v8i2.19800Abstract
Many data warehouses are implemented in companies engaged in retail, CV. Sumber Tirta Anugerah is one of the paint product retail companies that has not implemented it yet. As time goes by, the sales transaction data is getting more and more difficult to process because it is still stored in Microsoft Excel. This is a serious problem in utilizing historical data to assist in making a decision. It is difficult to store sales data because the data is quite large and a lot. Based on the above problems, a data warehouse design is needed for sales transaction data. This data warehouse design uses Kimball's nine-steps method and star schema. To perform the ETL process (extract, transform, and load) using Pentaho software. In this data warehouse design, Tableau software is used to visualize the processed data into a graph and dashboard report. The result of this research is a data warehouse design using nine steps and a star schema which gets a transformation response time of 4048 MS.References
I. P. A. E. Pratama and I. G. A. Pradipta, “Data Warehouse Design and Implementation for Sales Prediction at Mekarsari Stores,” J. Teknol. Inform. dan Terap., vol. 2, no. 1, pp. 2–5, 2018.
R. Ferianto, A. Nugroho, and T. Andriyanto, “Data Warehouse Sales Data Management Case Study UD HF Bersaudara,” Semin. Nas. Inov. Teknol., vol. 5, no. 1, pp. 148–153, 2021.
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.
I. P. S. Handika and P. P. Santika, “Implementation of Data Warehouse and Business Intelligence for Sales Data at PT. ABC,” RABIT J. Teknol. dan Sist. Inf. Univrab, vol. 5, no. 2, pp. 76–85, 2020.
I. Putu, W. Prasetia, I. Nyoman, and H. Kurniawan, “ETL (Extract, Transform, Load) Implementation in Sales Data Warehouse Using Pentaho Tools,” TIERS Inf. Technol. J., vol. 2, no. 1, pp. 39–47, 2021.
Maniah and Supono, “Data Warehouse Model Design (Case Study: Post Shop PT. Pos Indonesia),” Competitive, vol. 10, no. 1, pp. 9–16, 2015.
I. P. A. E. Pratama and N. P. N. D. Widhiasih, “Data Warehouse Design For Sales Prediction At Orba Express Using Pentaho,” JUSS (Jurnal Sains dan Sist. Informasi), vol. 3, no. 2, pp. 43–48, 2020, doi: 10.22437/juss.v3i2.8147.
I. R. Marbun and R. Somya, “Data Warehouse Design for Sales Transaction Data Using Snowflake Schema Case Study : Online Market Dataset,” Univ. Kristen Satya Wacana, vol. 5, no. 1, pp. 87–91, 2021.
M. Hasanudin et al., “Material Sales Data Warehouse Model Design using Star Schematic,” Semin. Nas. Inov. Teknol., vol. 2, no. 2019, pp. 34–41, 2019.
R. Riksazany and M. Ayub, “Exploration of Sales Data Warehouse with Tableau,” J. Strateg., vol. 1, no. 2, p. 574, 2019.
E. Triandini, M. S. Rijal, and M. P. Ambara, “Implementation of Star Schema in Development of Data Warehouse Sales of Tour Products,” CSRID (Computer Sci. Res. Its Dev. Journal), vol. 12, no. 1, p. 23, 2021, doi: 10.22303/csrid.12.1.2020.23-33.
M. Akbar and Y. Rahmanto, “Sales Data Warehouse Design Using Nine Step Methodology for Business Intelligence at PT Bangun Mitra Makmur,” J. Inform. dan Rekayasa Perangkat Lunak, vol. 1, no. 2, pp. 137–146, 2020, doi: 10.33365/jatika.v1i2.331.
D. Sugiarto, H. L. H. Warnars, and Winarno, “Sales Data Warehouse Design (Case Study of PT. Subafood Pangan Jaya),” Semin. Nas. Ris. dan Teknol. (SEMNAS RISTEK), pp. 271–276, 2020.
R. Kimball and M. Ross, The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence. 2010.
Downloads
Published
Issue
Section
License
The Authors submitting a manuscript do so on the understanding that if accepted for publication, copyright of the article shall be assigned to CoreIT journal and published by Informatics Engineering Department Universitas Islam Negeri Sultan Syarif Kasim Riau as publisher of the journal.
Authors who publish with this journal agree to the following terms:
Authors automatically transfer the copyright to the journal and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-ShareAlike (CC BY SA) that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
Authors are able to enter into separate permission for non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
