Data Warehouse Design With ETL Method (Extract, Transform, And Load) for Company Information Centre

Fana, Wulan Stau; Sovia, Rini; Permana, Randi; Islam, Ataul

doi:10.29099/ijair.v5i2.215

Cited by 4 publications

(7 citation statements)

References 0 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Business Intelligence is a variant or derivative of Data Warehouse that is used to meet the needs of users in accessing information as well as effective data management mechanisms [13]. Business intelligence also defined as a set of methodologies, processes, and technologies to convert transactional data into information that meaningful and useful for organization and business, based on Data Warehouse [14]. The methods and methodologies contained in the Data Warehouse can also be used in Business Intelligence: On-Line Transactional Processing (OLTP), On-Line Analytical Processing (OLAP), multi-dimensional data, Kimball Nine-Step Methodology, and Extraction, Transformation, Loading (ETL).…”

Section: Business Intelligencementioning

confidence: 99%

Business Intelligence Based on Kimball Nine-Steps Methodology for Monitoring the Feasibility of Goods in Market

Pratama,

Raharja

2023

International Journal of Advances in Data and Information Syste

View full text Add to dashboard Cite

Consumer protection is of great concern to the Government of Indonesia through the supervision of goods on the market by the Department of Industry and Trade in each province. The Bali Provincial Office of Industry and Trade has transactional data from various data sources but has not been able to optimize it to support monitoring of goods circulating in the market. This research designs and implements a Data Warehouse-based Business Intelligence system using the Kimball Nine-Steps Methodology and Pentaho BI tools, to facilitate the storage and processing of goods data on the market, and monitor their feasibility. The results of this research show that the system can assist the Bali Province Industry and Trade Office in monitoring the feasibility of goods circulating in the market through the selection process for determining query priorities and query modes, as well as supporting decision-making processes and determining business strategies.

show abstract

Section: Business Intelligencementioning

confidence: 99%

Business Intelligence Based on Kimball Nine-Steps Methodology for Monitoring the Feasibility of Goods in Market

Pratama,

Raharja

2023

International Journal of Advances in Data and Information Syste

View full text Add to dashboard Cite

show abstract

“…The technique can produce reliable results with large and small subsets. ETL test has also been performed by [8] to determine the quality of a data warehouse, ETL test is an important and vital phase during data warehouse testing, this phase affects data quality.…”

Section: Introductionmentioning

confidence: 99%

Development ETL (Extract, Transform and Load) Module in Indonesian Agricultural Commodities OLAP System

Yudhistira,

Sitanggang,

Adrianto

2023

Ilk. J. Ilm.

View full text Add to dashboard Cite

The SOLAP system for Indonesian Agricultural Commodities is a successful development based on previous studies. Agricultural commodity data are managed in a data warehouse with a galactic schema, which has 7 fact tables, namely cut flower horticulture, ornamental plant horticulture, horticulture, food crops, plantation, livestock population, and livestock production, as well as 3 dimensional tables, namely location, time, and commodity. The results of SOLAP operations on the system can be visualized in the form of crosstabs, graphs and maps. The system uses a web platform so that it can be accessed by the public. However, the SOLAP system cannot update data in real time. This study aims to develop a data warehouse for Indonesian Agricultural Commodities SOLAP in real time by creating a scraping system. This study has succeeded in developing a data warehouse in real time on the indonesian agricultural commodity SOLAP system by creating a real time scraping system that is applied to the SOLAP server and has succeeded in making the ETL process run in real time on the SOLAP server and optimizing polygon-based spatial data visualization using the Douglas-Peucker. This study has also carried out functional testing of OLAP features and functions on the Indonesian Agricultural Commodity SOLAP system using the black box testing method. The results of this study provide accurate and real-time data on the SOLAP of Indonesian Agricultural Commodities, with the results of SOLAP feature testing achieving 100 percent pass and the data conformity test results of OLAP function as expected. In addition, the results of this study make it possible to automatically update the data according to a predetermined schedule to provide real-time information.

show abstract

“…Data sebagai sumber utama informasi terkadang memiliki format dan struktur data yang tidak sesuai dengan yang diinginkan [3]. Banyaknya sumber data dalam suatu perusahaan yang berasal dari penggunaan sistem seperti Enterprise Resource Planning (ERP), flat file, aplikasi mobile, sistem berbasis web, hingga spreadsheets (Excel) [4] menjadikan perusahaan mengalami kendala ketika melakukan pengolahan data dalam mendukung pengambilan keputusan manajemen.…”

unclassified

“…• Menghapus kesalahan dan memperbaiki data yang hilang • Memberikan ukuran kepercayaan yang terdokumentasi dalam data • Menangkap data transaksional untuk diamankan • Menyesuaikan data dari berbagai sumber untuk dapat digunakan bersama • Struktur data untuk dapat digunakan oleh tools pengguna akhir Proses ETL memiliki fungsi untuk mengumpulkan data dari sumber data yang berbeda membuatnya menjadi satu kesatuan data yang terintegrasi [4]. Data warehouse adalah sebuah metode didalam desain basis data yang mendukung sistem pengambilan keputusan (DSS) dan sistem informasi eksekutif (EIS).…”

unclassified

See 1 more Smart Citation

Implementasi Extract-Transform-Load (ETL) Data Warehouse Laporan Harian Pool

Andriansyah

2022

JTI

View full text Add to dashboard Cite

- Pool Daily Report (LHP) is a report used by the Operations department and other relevant departments to find out the position, condition, and availability of rental units. In the process, this report is formed by several data sources including from the main system and mobile applications. Differences in data structure and format become the next obstacle faced in the data integration process. The management decision-making process is hampered because the information provided is less relevant, because some of the data is in another database that is different from the database used by the company. The implementation of a data warehouse is one of the efforts to integrate data. Extract-transform-load (ETL) is a method that can be used in a data warehouse to extract, transform, and save data back into the prepared target table. The result of this research is the implementation of the ETL process with a snowflake approach to produce the required dimensions, which are then related to form reports that are in accordance with the wishes of the user. Keywords- data warehouse, ETL, snowflake, pool daily reports. Intisari - Laporan Harian Pool (LHP) merupakan laporan yang digunakan oleh departemen Operation dan departemen terkait lainnya untuk mengetahui posisi, kondisi, dan ketersediaan unit sewa. Dalam prosesnya, laporan ini dibentuk oleh beberapa sumber data diantaranya berasal dari sistem utama dan aplikasi mobile. Perbedaan struktur dan format data menjadi kendala berikutnya yang dihadapi dalam proses integrasi data. Proses pengambilan keputusan manajemen menjadi terhambat karena informasi yang diberikan kurang relevan, dikarenakan sebagian data berada pada basis data lain yang berbeda dengan basis data yang digunakan oleh perusahaan. Penerapan data warehouse menjadi salah satu upaya dalam mengintegrasikan data. Extract-transform-load (ETL) merupakan salah satu metode yang dapat digunakan dalam data warehouse untuk mengekstrak, mentransformasi, dan menyimpan kembali data kedalam tabel target yang telah disiapkan. Hasil dari penelitian ini adalah di implementasikannya proses ETL dengan pendekatan snowflake untuk menghasilkan dimensi-dimensi yang dibutuhkan, untuk selanjutnya di relasikan membentuk pelaporan yang sesuai dengan keinginan pengguna. Kata Kunci— data warehouse, ETL, snowflake, laporan harian pool.

show abstract

Data Warehouse Design With ETL Method (Extract, Transform, And Load) for Company Information Centre

Cited by 4 publications

References 0 publications

Business Intelligence Based on Kimball Nine-Steps Methodology for Monitoring the Feasibility of Goods in Market

Business Intelligence Based on Kimball Nine-Steps Methodology for Monitoring the Feasibility of Goods in Market

Development ETL (Extract, Transform and Load) Module in Indonesian Agricultural Commodities OLAP System

Implementasi Extract-Transform-Load (ETL) Data Warehouse Laporan Harian Pool

Contact Info

Product

Resources

About