A conceptual data modelling methodology for asset management data warehousing

In an attempt to turn data management into a profitable enterprise, many businesses are seeking to integrate and centralise their data through data warehousing. A data warehouse then allows businesses to turn data into knowledge, and turn knowledge into tangible profits. One key success factor of a data warehouse lies in its ability to integrate data from multiple sources through a unified data model. Within asset management, several such integrated data models have been proposed, however these individually only cover a limited number of areas within asset management data and are not designed with data warehousing in mind. This paper presents the development process of a novel conceptual data warehousing data model that holistically integrates numerous asset management data areas. The comprehensive ethnographic modelling methodology involves a diverse set of inputs (including data model patterns, standards, information system data models, and business process models) that describes asset management data. The outputs of the process were verified by more than 20 experts in asset management and validated against four case studies.