Decision Support System Development for Asset Management

Abstract

This research has two purposes as follows: (1) design and develop a decision support system (DSS) for asset management, and (2) compare the state-of-art business intelligence (BI) tools that are suitable for the organization. Our research is conducted starting from the requirement gathering, data warehouse design, extract-transform-load (ETL) from the operational asset management system, and report generation. Research findings (1) a decision support system for asset management that allows quick access to information in multiple views and reducing the time for summarizing the report of asset. The information outcome can be used as a guideline for future asset management plans. (2) Among the state-of-art business intelligence (BI) tools such as Power-BI, Tableau, Qlik, and ZohoAnalysis, Power-BI has been selected as a design and development tool. Compared to other tools, Power-BI has an easy-to-use interface. It has a feature to prepare the data before creating a report conveniently and is connectable to various types of data.