Article Per Year (5 Year)
p-Index From 2019 - 2024
0
P-Index
This Author published in this journals
All Journal International Journal of Engineering and Emerging Technology
I Made Adi Bhaskara
Department of Electrical and Computer Engineering, Post Graduate Program, Udayana University
Civil Engineering, Building, Construction & Architecture Computer Science & IT Electrical & Electronics Engineering Mechanical Engineering

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Data Warehouse Implemantation To Support Batik Sales Information Using MOLAP I Made Adi Bhaskara; Luh Gede Putri Suardani; Made Sudarma
International Journal of Engineering and Emerging Technology Vol 3 No 1 (2018): January - June
Publisher : Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Batik product has spread in various regions in Indonesia. Batik companies usually have data that accumulates and accumulates without any follow-up to the data. It is also not supported by well-executed final reports. Therefore it is necessary to build a data warehouse that can be used as a source of information for Batik management related to the trend of the type of batik motif based on the category of goods and marketing area from time to time. One important process that must be done in the operation of data warehouse is the process of copying data from the operational database. Before the operational data goes into the data warehouse, ETL process (extract, transform, load) to the data is done. The process is intended to standardize the data used in the data warehouse. Meanwhile, the scheme designed for the development of data warehouse using Snowflake Schema model. The results showed that batik warehouse data has four dimension tables (Product dimension, Region dimension, Time dimension, and Customer dimension), four sub dimension tables (Category dimension, Sub_Category dimension, Pattern dimension and Gender dimension) and one Fact table, Fact Sales. The extraction process produces dimension tables (Product dimension, Region dimension, Time dimension and Customer dimension) and sub-dimensional tables (Category dimensions, Sub_Category dimensions, Pattern dimensions and Gender dimensions). All monitoring of sales data of batik products is done using cube browser. The information displayed by each dimension can be viewed in more detail with the drill down or roll up process in accordance with the hierarchy rules of each dimension field.
Co-Authors Luh Gede Putri Suardani Made Sudarma