Data Warehouse Kepemilikan MCK Menggunakan Metode Etl Dan Black-Box (Studi Kasus: Kelurahan Nitu, Ntb)

Abstract

Preparation of government policies related to public services and facilities requires population data and its supporting technology. The Government of Bima, West Nusa Tenggara (NTB) has population data related to the ownership of each family in Nitu Village but is constrained by the technology to process these data. This research designs and implements a Data warehouse using the Extraction, Transformation, and Loading (ETL) method with the concept of multi-dimensional data. The system is implemented using Pentaho, then tested using the Black-Box method. The Data warehouse collects data from residents of the Nitu Kelurahan related to MCK ownership, then processed it to produce reports and data visualization. The stages of the research include data collection, identification of data dimensions, design, implementation, and Testing of the Data warehouse, as well as conclusions. The final results of the research show that the Data warehouse that was built helps the government in determining policy strategies and making decisions regarding the provision of MCK facilities for the people of Nitu Village, through reports and data visualization

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

“…Data Warehouse is a structured database that contains a set of subject-oriented, integrated, time-dimensional, and non-variable data, which can be used to assist decision-making processes, data analysis, and data storage from various applications and services, to then be organized using Relational Data Base Management System (RDBMS) [11]. Data Warehouse collects data from various sources, standardizes the format, then processes it for data analysis through data dimensions [12].…”