Search for collections on Universitas Islam Negeri Sultan Syarif Kasim Riau Repository

DATA WAREHOUSE DESIGN FOR SALES TRANSACTION ON CV. SUMBER TIRTA ANUGERAH

MUHAMMAD DWIKY SYAPUTRA, - (2022) DATA WAREHOUSE DESIGN FOR SALES TRANSACTION ON CV. SUMBER TIRTA ANUGERAH. DATA WAREHOUSE DESIGN FOR SALES TRANSACTION ON CV. SUMBER TIRTA ANUGERAH, 8 (2). pp. 88-96. ISSN 2599-3321

[img]
Preview
Text
Muhammad Dwiky Syaputra Repository.pdf

Download (1MB) | Preview
[img] Text
19800

Download (30kB)

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.

Item Type: Article
Subjects: 000 Karya Umum > 004 Pemrosesan Data, Ilmu Komputer, Teknik Informatika
Divisions: Fakultas Sains dan Teknologi > Teknik Informatika
Depositing User: fsains -
Date Deposited: 10 Jan 2023 06:35
Last Modified: 10 Jan 2023 06:35
URI: http://repository.uin-suska.ac.id/id/eprint/64895

Actions (login required)

View Item View Item