TY - GEN
T1 - A Business Intelligence System for Radio Communication Licensing
T2 - 15th International Joint Conference on Computer Science and Software Engineering, JCSSE 2018
AU - Tangsripairoj, Songsri
AU - Natseevatana, Premmanat
N1 - Publisher Copyright:
© 2018 IEEE.
PY - 2018/9/6
Y1 - 2018/9/6
N2 - 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.
AB - 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.
KW - Business intelligence
KW - Data mart
KW - Data warehouse
KW - Olap
KW - Radio communication licensing
UR - https://www.scopus.com/pages/publications/85057736465
U2 - 10.1109/JCSSE.2018.8457358
DO - 10.1109/JCSSE.2018.8457358
M3 - Conference contribution
AN - SCOPUS:85057736465
T3 - Proceeding of 2018 15th International Joint Conference on Computer Science and Software Engineering, JCSSE 2018
BT - Proceeding of 2018 15th International Joint Conference on Computer Science and Software Engineering, JCSSE 2018
A2 - Sawangphol, Wudhichart
A2 - Mitrpanont, Jarernsri
PB - Institute of Electrical and Electronics Engineers Inc.
Y2 - 11 July 2018 through 13 July 2018
ER -