A Business Intelligence System for Radio Communication Licensing: A Case Study of The National Broadcasting and Telecommunications Commission of Thailand

This paper describes the design and development of the business intelligence system for radio communication licensing textbf(BISRCL) for the Office of the National Broadcasting and Telecommunications Commission of Thailand (NBTC). Data comes from two main sources, which are the Frequency Management System (FMS) and the Automated Spectrum Management System (ASMS). This data is integrated by passing through the Extraction-Transformation-Load (ETL) process and stored in data marts. Online analytical processing (OLAP) techniques are exploited to analyze the data in many different perspectives. Moreover, the BISRCL system provides an interactive dashboard, which is a web application for operational and managerial staff, both in the NBTC central office and regional offices, to support their needs. Besides, various forms of analysis reports can be generated by the system. After the prototype system was developed, it was tested and evaluated by the NBTC officers. The user satisfaction survey results show that by overall the users were satisfied with the BISRCL system at the ‘Good’ level. By comparing the proposed BISRCL system to the existing FMS and ASMS systems, users can access the information they need from the BISRCL system faster, more accurate and more efficient than the existing systems. The ultimate goal of this research project is to provide meaningful and valuable information to the NBTC officers and executives for more effective strategic and operational insights and decisionmaking in radio communication licensing.