Abstract
Good asset management decisions involve balancing cost, risk and performance requirements. Raw data on maintenance costs (a major contributor to total costs) and for estimating risks associated with asset failure is stored in an organisation’s Enterprise Resource Planning (ERP) system. However as this chapter demonstrates asset data is often erroneous, lacking requisite detail and therefore not fit for decision support. This chapter describes a project to clean data stored in computerised maintenance management systems (CMMS) that form part of ERPs. It looks in detail at the cleaning process, identifying key issues and developing of a set of recommendations for improvement. The major issues identified are to do with poor practice in assigning work to appropriate subsystems and maintainable items, ineffective use of standard text to describe work, inconsistent use of codes describing the type of work, and inability to identify suspensions and actual asset usage hours from the stored data. While focussing on asset data from mobile mining assets, the problems identified are similar in other sectors. Despite these issues, much of the required information is available once the data has been cleaned and forms a resource for the mining industry to assess how asset reliability and costs are changing with the introduction of new developments such as autonomous mobile equipment.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
(2012) Australian Bureau of Statistics: Industry Analysis. http://www.abs.gov.au/ausstats/. Accessed 12/3/2013
Lin S, Goa J, Koronios A (2006) The need for a data quality framework in asset management. In: Proceedings of the 1st Australasian workshop on information quality (AUSIQ), June 22–23
Batini C, Barone D, Federico C, Simone G (2011) A data quality methodology for heterogeneous data. Int J Database Manag Syst 3(1):60–79
Batini C, Cappiello C, Francalanci C, Maurino A (2009) Methodologies for data quality assessment and improvement. ACM Comput Surv 41(3):1–52
Borek A, Woodall P, Oberhofer M, Parlikad A (2011). A classification of data quality assessment methods. In: ICIQ 2011—proceedings of the 16th international conference on information quality
David L (2001) Data quality and business rules in practice. In: Enterprise knowledge management. Academic Press, San Diego
Lee YW (2004) Crafting rules: context-reflective data quality problem solving. J Manag Inf Syst 20(3):93–119
Lee YW, Strong DM (2004) Knowing-why about data processes and data quality. J Manag Inf Syst 20(3):13–39
Maydanchik A (2007) Data quality assessment. Technics Publications, New Jersey
Redman TC (2001) Data quality—the field guide. Digital Press, Oxford
Woodall P, Parlikad AK (2010) A hybrid approach to assessing data quality. In: Proceedings of the 2010 international conference on information quality
Hodkiewicz MR, Kelly P, Sikorska JZ, Gouws L (2006) A framework to assess data quality for reliability variables. World Congress on Engineering Asset Management (WCEAM), Gold Coast
Koronios A, Lin S (2004) Key issues in achieving data quality in Asset Management VETOMAC-3/ACSIM-2004 (Vibration engineering & technology of machinery, Asia-Pacific conference on system integrity & maintenance 2004, December 6–9) New Delhi
Lin S (2008) A data quality framework for engineering asset management. Aust J Mech Eng 5(2):209–219
Haider A (ed) (2013) Information systems for engineering and infrastructure asset management. Springer, Berlin
Improving the Quality of Manually Acquired Data (2009) Applying the theory of planned behaviour to data quality. In: ICOMS 2009, Sydney, Australia
Unsworth K, Adriasola E, Johnston-Billings A, Dmitrieva A, Hodkiewicz M (2011) Goal hierarchy: improving asset data quality by improving motivation. Reliab Eng Syst Safety 96(11):1474–1481
Murphy GD (2009) Building bridges and solving Rubiks Cubes: tribalism in engineering and technical environments. In: ICOMS 2009, Sydney, Australia
Hodkiewicz M, West G, Bartlett N, apsall S (2012) Asset management competency development. In: Lloyd C (ed) International case studies in asset management. ICE, Thomas Telford Press, London
Acknowledgments
The authors wish to thank CRC Mining for funding this project and to Peter Knights, research leader of CRC Mining’s Equipment Management committee for his ongoing support.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
Ho, M., Hodkiewicz, M.R., Pun, C.F., Petchey, J., Li, Z. (2015). Asset Data Quality—A Case Study on Mobile Mining Assets. In: Tse, P., Mathew, J., Wong, K., Lam, R., Ko, C. (eds) Engineering Asset Management - Systems, Professional Practices and Certification. Lecture Notes in Mechanical Engineering. Springer, Cham. https://doi.org/10.1007/978-3-319-09507-3_30
Download citation
DOI: https://doi.org/10.1007/978-3-319-09507-3_30
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-09506-6
Online ISBN: 978-3-319-09507-3
eBook Packages: EngineeringEngineering (R0)