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

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.