Applying business intelligence technology for equipment maintenance and repair plan of telecommunications services provider

摘要

The purpose of this study was to apply business intelligence (BI) technology for planning of equipment maintenance and repair. Multidimensional data model was designed as a star schema for multidimensional analysis, ad hoc analytics and online analytical processing. Moreover, data mining technique was utilized to figure out association rules of cause of difficulty and time of difficulty. This research applied Oracle Business Intelligence and Weka 3.6 as research tools to analyze the data of Maintenance Department of CAT Telecom Public Company Limited in Thailand from the past four years during 2013–2016 including 131,456 records. The findings revealed that applying BI to the organization was beneficial to executives since it provided various aspects of data which could be used for more appropriate and faster decision making and strategic planning.