Innovation Owner
Mr. PEERANUT CHANGKUM
Student
Details
This project develops an innovation to enhance mobile service quality analysis for the NBTC. By replacing slow Excel processes with Python-based data processing and Power BI dashboards, the system provides faster, more effective, and user-friendly visualization.
Under The National Broadcasting and Telecommunications Commission (NBTC), the Telecommunication Enforcement Bureau collects a lot of data on service quality by monitoring and controlling the quality of telecommunications services, mainly by assessing mobile network infrastructure. The NBTC used Microsoft Excel for data analysis but became ineffective and slow.
We used Python programming for preparation, analysis, and data processing to address this. Raw data was obtained from the Syberiz program in CSV format, processed in Python, and displayed on a dashboard. The dashboard, developed using Power BI, meets NBTC's telecommunications quality standards. It features:
- Maps
- Test results
- Graphical representations
This method enhances the dashboard's appearance and usability and speeds up data processing and visualization compared to Microsoft Excel. This project is primarily designed to help the Telecommunication Enforcement Bureau's operations by making data processing and display for telecommunications quality monitoring faster, more effective, and easier to use.
Objective
The project aims to study NBTC service quality standards, develop technical data analysis systems using Python, design compliant dashboards with Power BI, and improve data storage systems.
- To study methods for monitoring service quality according to the NBTC policy on Telecommunications Service Quality Standards (2022).
- To study Python coding for creating data processing and technical analysis systems.
- To study the use of Power BI for designing dashboards that comply with NBTC policies and announcements.
- To study and develop data storage systems.