Data warehouse capability maturity model assessment for efficient monitoring process: A case study in National Narcotics Board

Fahmi, A. N. Hidayanto, Solikin, H. S. Indriany, A. Prastya, S. F. Mardiansyah

Research output: Contribution to journalConference articlepeer-review

Abstract

Data Warehouse/Business Intelligence nowadays has become a necessity for every organization. Data analysis supports in making decisions and policies. The problem is the data warehouse management process, both related to ETL, data modelling, and data architecture, which results in the non-optimal and inefficient dashboard that wastes energy, as a data monitoring tool in displaying important information needed by the organization. This research was conducted by providing an assessment to the working group team in the data warehouse section using the Spruit & Sacu Data Warehouse Capability Maturity Model (DWCMM) to measure the maturity of the data warehouse at the National Narcotics Board. The results showed that the DWCMM maturity level is at the repeatable level, from the measurement results it can be seen that the worst DW category is in the Service Processes component so that many improvements need to be made to increase the DWCMM maturity level. As a recommendation, it is necessary to design a virtual integrated DW architecture that has real-time updates, data quality system, automatic synchronization of data modelling, standardization of metadata, realtime ETL monitoring management, closed-loop & BI real-time BI application, and improves the development process and process services in the management of DW/BI at BNN to become more efficient.

Original languageEnglish
Article number012055
JournalIOP Conference Series: Earth and Environmental Science
Volume969
Issue number1
DOIs
Publication statusPublished - 7 Feb 2022
Event10th Engineering International Conference, EIC 2021 - Semarang, Virtual, Indonesia
Duration: 23 Sep 2021 → …

Fingerprint

Dive into the research topics of 'Data warehouse capability maturity model assessment for efficient monitoring process: A case study in National Narcotics Board'. Together they form a unique fingerprint.

Cite this