Understanding user generated telecommunication data provided and extracting insights that helps to understand the performance of the company.
- Introduction
- User Overview or Market Analysis
- User Engagement analysis
- Experience Analytics
- Satisfaction Analysis
- Conclusion and Recommendation
This project is performed to analyse whether Tellco is worth buying and selling. To perform the project the data extracted from a month of aggregated data on xDR is used In this work, data cleaning, transforming, exploration and analysis tasks are performed. Finally, user overview, engagement, experience and satisfaction analytics is done and the Telcco productivity is predicted.Data contain 150001 rows and 55 columns, and null values of 12.72%.Tasks such as null percentage checking, data cleaning, data distribution(skewness) and removing rows with small null values, and filling object columns with mode is performed. 1,495 null rows and 11 null columns are removed, and data reduced to 148506 rows & 44 columns.Null percentage after data cleaning is 0.0%.
Graph a) and b) shows that from the top 3 manufacturers of handset the Apple is leading , and the phone which sold on number one is Huawei B528S-23A . But next to Huawei most of the customers use Apple Handset. Since Apple is highly manufactured and it is also used next to Huawei, the marketing department of Telcco should sell the apple handsets in order to be productive. Therefore, the company will generate a good income from selling the Apple handset.
As it is indicated on graph c) the users are more engaged on Game. To the Maximum 4,518,036 bytes of data volume is used for the gaming purpose. The Correlation of the application are positive, that mean when the usage of the gaming increase the probability of using the other application also increase. This shows that company is profitable in future time. Therefore, the company should emphasis on gaming application.
It is figured out on graph d) Huawei has high TCP Retrans and Apple is the second one. While the total throughput of iApple handset is greater by 21kb when it is compared with Huawei. In addition to this the average TCP trans of Apple is about 60,460 kbps and average TCP trans of Apple is about 16,996.00 kbps. Having this information, I recommend the investor to sell the Apple handset to increase the profit of the telecom.
Most of the user Telcco is more engaged and experienced on using the services. Thus, this shows that the user is satisfied by the Telcco service. The prediction of the developed model on the user satisfaction shows about 83.2% of the user is satisfied.
In this project Telcco data is analysed using the best data engineering practice.The analysis is not made on location of the user.The insights extracted about market analysis, user engagement, experience and satisfaction is very promising that Telcco is best buying and selling company. Therefore, I strongly recommend the investor to buy the Telcco.