Analysis of ONU Offline, Slow Internet, Frequent Disconnection and Internet Not Working
This module used jQuery and PHP extensively to retrieve data from MySQL server. The database has more than 200,000 dataset from which specific data was fitlered using SQL query language. The data was located for the users that complained about ONU Offline issues during peak hour. Along with it, data from slow internet, frequent internet disconnection and internet not working was also filtered.
The dataset was collected every 5 minutes and the average value for an hour was cached. This data was then parsed into Highcharts.js to provided an updated plot every hour.
This module was prepared during the time when Vianet Communications had large queue of complains lined up and needed automation to help the staff in call center. This module helped the decision-makers to identify the trend and act accordingly to solve the issues.