IMPLEMENTASI ETL DATA WAREHOUSE DENGAN KONSEP FITUR METADATA DAN CLEANSING DATA PADA TOKO KUE

Abstract

The rapid development of technology makes the demand for data processing and presentation needs to be better. Udayana cake shop that sells various types of cakes that are self-produced and have several branches spread across Bali. Udayana cake shop has a problem while analyzing the transaction process due to the large amount of data sent from each branch in a month. The results of this analysis process are used for supporting references in making decisions by store management. The exact method of massive data collection used in analyzing the transaction process is the data warehouse technology approach. Data warehouse supports the ability to do queries decision making, the financial situation, product stocks, and services. The development of this data warehouse uses star scheme modeling and the application of data collection there are stages of ETL (extract, transform, and load) to be able to read data from the OLTP (Online Transaction Processing) system. The design of the system uses OLAP (Online Analytical Processing) to design applications that can collect, store, and manipulate multidimensional data for analysis purposes.