Indian Telecom Voice Call User Experience & Rating Between June-2017 to Feb-2018

Sangamesh K S

March 14, 2018

Introduction

The dataset is from data.gov.in and can find the dataset here: https://data.gov.in/catalog/voice-call-quality-customer-experience

The data consist of 9 month user rating of 9 popular telecom companies in India. The data collection is between June 2017 to February 2018.

You can see the sample of the data below

##   Month Operator   Rating       Type Year
## 1     6      Jio 3.175126    OutDoor 2017
## 2     6      Jio 3.555710     Indoor 2017
## 3     6      Jio 3.307873 Travelling 2017
## 4     6     Idea 3.952443     Indoor 2017
## 5     6     Idea 3.515842    OutDoor 2017
## 6     6     Idea 4.474982 Travelling 2017

Average rating of Telecom Brands

Now lets find the average rating of all networks

As per the data Jio is leading in rating followed by BSNL and Reliance with the lowest rating

Time Series of Rating

Now lets look at the overall rating of all the companies month wise

We can see the fluctuation in the rating on month on month basis it might be due to customer churn, bad network, customer moving to other location etc.We can see a sudden drop in the rating after December 2017

Overall rating of all brands

The data is been collected in 3 phase. Indoor,Outdoor and Travelling. So lets look at the rating of all the telecom companies.

Conclusion

Jio turns to be a market leader followed by BSNL. We do not see any significant difference between networks but reliance is slightly on a lower side.