Data Warehouse Design For Sales Transactions on CV. Sumber Tirta Anugerah

Muhammad Dwiky Syaputra, Alwis Nazir, Siska Kurnia Gusti, Suwanto Sanjaya, Fadhilah Syafria

Abstract


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. 

Full Text:

PDF

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.




DOI: http://dx.doi.org/10.24014/coreit.v8i2.19800

Refbacks

  • There are currently no refbacks.


Bookmark and Share


Creative Commons License  site stats  
Jurnal CoreIT by http://ejournal.uin-suska.ac.id/index.php/coreit/ is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.